Question: D E F G . 1 K L A B 1 Festival 2 3 Expected Crowd 6000 people 4 5 Average Concessions-Food Expenditure 16.00 per

D E F G . 1 K L A B 1 Festival 2 3 Expected Crowd

D E F G . 1 K L A B 1 Festival 2 3 Expected Crowd 6000 people 4 5 Average Concessions-Food Expenditure 16.00 per person 6 Average Concessions-Alcohol Sales (Beer/win. $ 22.00 per person 7 Fixed Cost $ 16,000.00 8 9 Ticket Price $ 25.00 per person 10 11 REVENUE FROM TICKETS $ 150,000.00 12 CONCESSION SALES-Food $ 96,000.00 13 CONCESSION SALES- Alcohol -Beer/Wine $ 132,000.00 14 PROFIT PERCENTAGE from Sales/food/Alcoho 30240000% 15 16 Festival PROFIT 28640000% 17 18 19 20 21 22 14 23 24 Festival Bali Swimsuits Booking Determine Customer Value Grades Example + + 100% b. For the Festival model, you developed above, define and run some scenarios using the Scenario Manager to evaluate profitability. Use the following scenarios below and rename the Scenario summary tab to Festival Profit. Scenario Summary for Music Festival Current Values Perfect Weather-Best Average Weather Realistic Rain and Cloudy Pessimistic Changing Cells: Expected crowd Food Beer/Wine Ticket Price Result Cells: Festival Profit 6000 15.00 $ 20.00 $ 25.00 $ 7500 22.00 $ 25.00 $ 30.00 $ 6200 16.00 $ 22.00 S 25.00 $ 4000 12.00 15.00 20.00 $ $ 272,000.00 $ 446,000.00 $ 296,480.00 $ 134,400.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

please post formulas Tell me ANO IESU. MPTS Excel Assignment Module 9 Attempt 1 Home Insert Draw Page Layout Formulas Data Review View X Times New Roman 12 AA General Dante an ====== S% 9 Condon...

USING LEVEL-UTILIZATION STRATEGY, FILL OUT EXCEL SPREADSHEET Use the following monthly forecast to create your aggregate plans: 2021 Forecast: Month Demand 1 5689 2 6094 3 12592 4 6458 5 6 10246...

Congratulations, on being appointed as the director of the North Carolina Open Singles Badminton Championships. You have been researching probable revenues and costs so that you can make a budget....

Congratulations, on being appointed as the director of the North Carolina Open Singles Badminton Championships. You have been researching probable revenues and costs so that you can prepare a budget....

2 Tue Sep 14 9:35 AM Excel File Edit View Insert Format Tools Data Window Help AutoSave A @ O... Chapter #5 - Problems - ACC 318 - FS21(2) Q OFF Home Insert Draw Page Layout Formulas Data Review View...

Please use the bolded information to determine the solution. The Pictures represent the amounts needed. Updated Scenario: Many customers have been asking for more hypoallergenic products, so in...

hi I need answers to those questions as soon as possible thank you File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments @ A & Cut Garamond 12 III NO ab Wrap Text General...

AutoSave O Off) Copy of Copy of Students v Search (Alt+Q) A Natalia N X File Home Insert Page Layout Formulas Data Review View Help Comments Share A44 X V Equipment A B C D E F G J K L M N O P...

Course Syllabus, Calendar, Cal X M10: Comprehensive Master BI X Dashboard X + C slcc.instructure.com/courses/729683/assignments/9368459 * a Update : To demonstrate your understanding of the master...

complete only page 1 of the tax form and ecplain the adjustments C-Corporation Tax Return Instructions Purpose: The purpose of this tax return assignment is to apply the tax rules you have learned in...

Eastland Company and Westside Company are competing businesses. Both began operations 6 years ago and are quite similar in most respects. The current balance sheet data for the two companies are...

Give the products of the following reactions. Indicate whether each reaction is an oxidation or a reduction: a. b. c. d. e. f. g. h. i. j. k. l. m. n. o. p. q. r. Na2Cr207 H2SOA CH3CH2CH2CH2CH2OH...

( 3 points ) A homeowner obtained a mortgage 5 years ago for $ 4 0 0 , 0 0 0 at 1 2 percent amortized over 2 0 years. Mortgage rates have dropped, so that a new 1 5 - year loan can be obtained at 1 0...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...