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 one thing is that each variable has deductions to paint the picture, the more you are off consumer prefrances the lower your score is the bottom line is to maximise the product's score with limited funding i have the data for the deductionsI 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.what should i do Maybe its an optimization problem or soemthing? I woudl really appreciate your help
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
