Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Solver
I have a spreadsheet where I am running different financial scenarios to see
how they impact returns. I also want to be able to say for each scenario what price I would have to charge for my product to get the base case return. What would be the best way to get Excel to solve for the price that the product would be sold for and then output it into a predetermined cell? Thanks! |
#2
|
|||
|
|||
The Solver function can probably do it if you set your limits and costs, then
choose how you want it to calculate. It's been a while, but I wrote one to change the formula for ice cream based on least cost while maintaining the right amount of fat solids, non-fat solids, and other critical items while varying the use of powdered milk (with each posible fat content and cost) fresh milk (with each posibility and associated cost), cream, butter, etc. Solver is powerfull, but you need to plan the variables carefully. "Scott" wrote: I have a spreadsheet where I am running different financial scenarios to see how they impact returns. I also want to be able to say for each scenario what price I would have to charge for my product to get the base case return. What would be the best way to get Excel to solve for the price that the product would be sold for and then output it into a predetermined cell? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with Solver | Excel Discussion (Misc queries) | |||
Solver | Excel Discussion (Misc queries) | |||
Using Solver with VBA | Excel Discussion (Misc queries) | |||
Using solver with function with multiple outputs | Excel Worksheet Functions | |||
Solver Problems | Excel Worksheet Functions |