Microsoft Office Tutorials and References
In Depth Information
Making the Case with Scenario Manager
I want to create three scenarios using the following sets of values for the
three changing cells:
Most Likely Case where the Sales_Growth percentage is 5%, COGS is
20%, and Expenses is 28%
Best Case where the Sales_Growth percentage is 8%, COGS is 18%, and
Expenses is 20%
Worst Case where the Sales_Growth percentage is 2%, COGS is 25%, and
Expenses is 35%
To create the first scenario, I click the Add button in the Scenario Manager
dialog box to open the Add Scenario dialog box, enter Most Likely Case in
the Scenario Name box, and then click OK. (Remember that the three cells
currently selected in the worksheet, H3, H4, and H6, are already listed in the
Changing Cells text box of this dialog box.)
Excel then displays the Scenario Values dialog box where I accept the
following values already entered in each of the three text boxes (from the Sales
Forecast 2014 table), Sales_Growth, COGS, and Expenses, before clicking its
Add button:
0.05 in the Sales_Growth text box
0.2 in COGS text box
0.28 in the Expenses text box
Always assign range names as described in Chapter 6 to your changing cells
before you begin creating the various scenarios that use them. That way,
Excel always displays the cells’ range names rather than their addresses in the
Scenario Values dialog box.
After clicking the Add button, Excel redisplays the Add Scenario dialog box
where I enter Best Case in the Scenario Name box and the following values in
the Scenario Values dialog box:
0.08 in the Sales_Growth text box
0.18 in the COGS text box
0.20 in the Expenses text box
After making these changes, I click the Add button again. Doing this opens
the Add Scenario dialog box where I enter Worst Case as the scenario name
and the following scenario values:
Search JabSto ::




Custom Search