Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

It will cost $3 million to develop the show. There are eight performances per week (on Saturday there is a matinee) and we expect the

It will cost $3 million to develop the show. There are eight performances per week (on Saturday there is a matinee) and we expect the show to run for 52 weeks. It costs $800 to open up the theatre each day. Tickets sell for $75.00 each and we earn an average of $5.50 profit for every ticket sold from concessions. The theater holds 1200 seats and we expect somewhere between 75% and 85% of the seats to be sold for each performance.

a. Set up a spreadsheet model to compute the total profit for the entire run of the musical and total profit for each performance. Note: the % of seats sold is an uncertain variable.

b. Use a one-way table to show the sensitivity of profit (entire run) to the percentage of full seats use values of 70, 75, 80, 85, and 90%. Graph the results of your table.

c. Use a two-way table to show the sensitivity of profit (entire run) to the average ticket price and the number of weeks the play runs. Use values of $55, 60, 65, 70, 75, and 80 for ticket prices and values of 40, 50, 60, and 70 for the number of weeks.

PLZ POST EXCEL FORMULAS

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

Accounting For Non-Accountants

Authors: David Horner

10th Edition

0749472812, 978-0749472818

More Books

Students also viewed these Accounting questions