I need help with this number. I would prefer an excel file with the answers please.

Business Intelligence using Excel

Off$-$Broadway Musical

You are thinking of opening a musical, 'Hurray! It's Fall Time Again!$\text{'}$ It will cost $$5$ million to develop $($that is$,$

onetime set$-$up cost$)$ the show. There are $7$ shows per week $($one show per day Monday through Friday and two

shows on Saturday$),$ and you project the show will run for $52$ weeks $(1$ year$).$ It costs $$4,800$ to open the theatre

each day $($not per show$).$ A ticket sells for $$50,$ and you earn an average of $$3$ profit per ticket holder from

concessions $($for light snacks and beverages such as wine, cheese, etc.$).$ The theatre holds $1,000$ people, and you

expect $65\%$ of the seats to be full at every show.

Using the description above, build the model $($annual income statement$)$ for this musical $($e$.$g$.,$ income statement$)$

$($Hint: consult the spreadsheet we used in class as a basic template$).$

Use a separate income statement $($copy and paste the model from #$1),$ how many weeks will the play have to run for

you to make a breakeven?

Use a separate income statement $($copy and paste the model from #$1),$ how does an increase in the percentage of seats

full affect profit? Past historic data shows that the percentage of seats full tends to change from $40\%$ to $100\%$ with

the increment of $10\%.$

Use a separate income statement $($copy and paste the model from #$1),$ determine how a joint change in the average

ticket price and percentage of seats full influence profit. Historically, the ticket price tends to vary from $$35\mathrm{.}00$ to

$$65\mathrm{.}00$ with the increment of $$5\mathrm{.}00$ and the percentage of seats full tends to change from $40\%$ to $100\%$ with the

increment of $10\%.$