Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started