Question: 12. Create three scenarios as follows (DO NOT COPY THIS TABLE INTO YOUR EXCEL FILE, YOU HAVE TO USE THE SCENARIO MANAGER. THIS TABLE IS

12. Create three scenarios as follows (DO NOT COPY THIS TABLE INTO YOUR EXCEL FILE, YOU HAVE TO USE THE SCENARIO MANAGER. THIS TABLE IS ONLY FOR REFERENCE. ENTER THE VALUES BELOW INTO YOUR 3 SCENARIOS). Be sure to add the total revenue, total expenses, and net income as RESULTS CELLS, no input values required: Scenarios Input Cells Status Quo Maximum Minimum Classes Classes Participants Per Week 150 250 100 Average Class Price $12 $20 $10 Classes 10 20 8 Average Instructor Cost per Class $80 $100 Advertising $200 $400 $100 Results Cells Status Quo Maximum Minimum Classes Classes Total Revenue Total Expenses Scenario manager will calculate this part for you after you enter these as results cells. Net Income a) Use the Curl key to select and name the five input cells, then create each of the three scenarios with the values shown above. Enter appropriate text for the comments. b) In the scenario manager, create a scenario summary report of the three scenarios. Make sure you display the total revenue, total expenses, and net income under each scenario. As you can see, Shelley needs to seriously rethink her business model. Only the Maximum Classes scenario generates a profit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
