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 upgradecost 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
