Next, add 4 other scenarios (70%, 80%, 90% and 100%).įinally, your Scenario Manager should be consistent with the picture below: Enter the corresponding value 0.6 and click on OK again.Ħ. Type a name (60% highest), select cell C4 (% sold for the highest price) for the Changing cells and click on OK.ĥ. On the Data tab, in the Forecast group, click What-If Analysis.Ĥ. However, what-if analysis enables you to easily compare the results of different scenarios. Note: You can simply type in a different percentage into cell C4 to see the corresponding result of a scenario in cell D10. You can use the Scenario Manager to create these scenarios. Create Different Scenariosīut what if you sell 70% for the highest price? And what if you sell 80% for the highest price? Or 90%, or even 100%? Each different percentage is a different scenario. If you sell 60% for the highest price, cell D10 calculates a total profit of 60 * $50 + 40 * $20 = $3800.
