The Tulsa PAC is going to open a new musical, "The Importance of being in Love!" 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 theater each day. Tickets sell for $75.00 each and we earn an average of $0.50 profit per ticket holder from concessions. The theater holds 1200 seats and we expect somewhere between 75 and 85% of the seats to be full.
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 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, 6A0, and 70 for the number of weeks.