Topic 39: Demostration of using scenario Manager in Excel 2003

[seema]

However it allows you to change multiple cells in order to see changes (not just one as is the case with Goal Seek). One of the advantages of scenarios is that they are kept for later reference and can be printed in summary form.

Scenario Manager - An Example
Look at the illustration below. We will use it to illustrate the Scenario Manager.

It shows a sheet that is calculating yearly payments on specific items this year and details expected percentage increase in these costs. You may be interested in knowing how the figures are effected if we make a range of assumptions about how each item might increase.

The cell E3 contain the formula =C3*D3%
The cell E4 contain the formula =C4*D4%
The cell E5 contain the formula =C5*D5%
The cell E6 contain the formula =C6*D6%
The cell E7 contain the formula =SUM(E3:E6)
The cell C7 contain the formula =SUM(C3:C6)

Similar Threads:

• Topic 34: Changing and Customizing the Excel 2003 Sytles
• Topic 33: Discover the Amazing Power of Excel 2003 Data Analysis Tools!
• Topic 2: Start Exploring Microsoft Excel 2003

[seema]

We are going to create scenarios for the following situations:

• Staff Low - 2.5%
• Staff Low, Energy High - 2.5%, 35%
• Once the above data and formulas have been created, select the changing cells, D3:D6.
• From the Tools menu, click Scenarios.
• If no previous scenarios have been created you will see the following dialog box.
  
  

[seema]

• Click on the Add ****on and the Add Scenario dialog box is displayed.
  
  
• Enter a name for the scenario you are about to create. In this case enter the name Staff Low into the Scenario name text box and then click on the OK ****on. The Scenario Values dialog box will be displayed as illustrated below.

[seema]

• The percentage rise in staff costs are located in cell D4 and we need to change the contents of this cell. In the dialog box enter a low value, i.e. 2.5 in the text box, next to $D$4.
• Click on the OK ****on and you will be returned to the main Scenario Manager dialog box, as illustrated below.
• 
  
  

[seema]

• Next we will add a second scenario where staff cost increases are low, but energy costs increases are high. Click on the Add ****on and enter the name for the next scenario, in this case Staff Low Energy High.
• Click on the OK ****on, and change the two cells as below. In the $D$4 text box, enter 2.5. In the $D$5 text box, enter 35.
• 
  
  
• Click on the OK ****on.
• You will be returned to the main Scenario Manager dialog box. You can go on adding different scenarios in the way outlined above. In this case we will content ourselves with just these two scenarios.