need done in 8 hrs

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 Assumptions area:

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:

Repeat the process and name all of the cells in your Income Statement as you did in the steps above:

• Tuition per Day • Food Expenses • Supplies per Year

• Teacher Cost • Insurance • Maintenance • Administrative & Advertising • Est. Taxes • Total Revenue • Total Expenses • Net Income (Make sure to also label the net income)

B. Define Scenarios From the Data tab, click What-If Analysis, and then select Scenario Manager:

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):

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:

Click Close to exit the Scenario Manager.

Change your values back to the original assumptions:

C. Create a Scenario Summary to display the scenarios you have created. Go back to

the Data tab, click What-If Analysis, and then select Scenario Manager:

Click Summary in the Scenario dialog box:

Select Scenario Summary and then choose the Result Cells: Total Revenue (B31), Total Expenses (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.