Question: Im using excel and I have a product. What u should know is that there are three variables for the product, each having a different

Im using excel and I have a product. What u should know is that there are three variables for the product, each having a different weight of importance. And I can upgrade each variable and it will cost (the cost depends on how much I upgrade it) thats why I took three points for each variables upgrade/cost to know the cost per unit upgrade, I took the three points to find the lowest cost per unit upgrade for each variable. And as you know each variable has a different weight of importance. Also I have limited funding. What i want in excel is a calculator that has all the data regarding the wieght of importance for each varaible, the cost per unit increase graph. i want it to find the optimal point to what varaibles to upgrade and to what extent based on the limited funding. I input funding it inputs what should i upgrade for each variable and to what extent, and there should be a funding graph to see the relationship between funding and overall product score to know how much should I finance.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!