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 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 deductions).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.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 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!