Your Data Table will look something like this. STEP 4: Create Scenarios and a Scenario Summary
Adair wants to look at three scenarios. Be sure to save each scenario with a unique name, and place the name of the scenario on the sheet, so that when the scenario changes, the name on the sheet changes to match the scenario.
Scenario Teacher Salary Supplies Number Tuition 1. Economy 15,000 25 15 35 2. Midrange 26,000 60 8 50 3. High 38,000 100 6 100
She wants to see the Net Income that would be achieved in each Scenario and compare this to her original assumptions.
A. Name the cells that will be used in the Scenario. B. Create the three Scenarios. C. Create a Scenario Summary. D. Move the Scenario Summary to the end of the workbook.
STEP 5: Create a Documentation Sheet and Provide a Recommendation
A. Add a documentation sheet to the beginning of the workbook. Include Author, date Created, Last Modified, and Contents sections.
B. Provide a recommendation to Adair.