Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Marketing And Export Management

Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr

8th Edition

9781292016924

Students also viewed these Economics questions