SBS_Lab6_Step4 - Click OK Add the values for your first...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Creating a Scenario Summary Lab 6, Step 4 A. Name the cells that will be used in the Scenario Summary. To use the labels you have already created in the Income Statement, select the two columns from the Income Statement: In the Formula Tab in the Defined Names Group, select “Create from Selection”. Select the Left column as your name: Click OK. When you click on the right hand cell, notice that the cell is now named: Continue and name all of the cells in your Income Statement. B. Define Scenarios From the Data Tab, select What-If Analysis and then select Scenario Manager:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The Scenario Manager Dialog Box opens. Click Add to begin defining your scenarios. Provide a name in the first textbox: Now select the cells that will change. You can select multiple cells by holding down the Control (Ctrl) key as you make your selections. Or you may type a comma after you select each variable. Select Number of Children (B6), Teacher Cost (B8), Supplies (B10), and Tuition (B13):
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click OK. Add the values for your first Scenario: Click OK. Add your second Scenario with the same Changing Cells: Click OK and then add the Changing values: Click OK and then add your final scenario. Name it High and add the values: To Test your Scenario, click “Show.” Your Income Statement will now contain the values you specified: Change your values back to the original assumptions: Number of children: 7 Teacher Cost: 26,000 Supplies: 75 Tuition: 50 C. Create a Scenario Summary to display the scenarios you have created. Click Summary in the Scenario dialog box: Select Scenario Summary and then choose the Result Cells: Total Expenses (B31), Total Revenue (B32), Net Income (B33): Click OK. Your Scenario Summary will be created on a new sheet: D. Move this sheet to the end of the workbook....
View Full Document

This note was uploaded on 08/27/2011 for the course BUSSINESS BIS155 taught by Professor Foster during the Winter '11 term at DeVry Federal Way.

Page1 / 7

SBS_Lab6_Step4 - Click OK Add the values for your first...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online