pls include excel sheet with the formulas shown

You are thinking of opening a musical, 'Hurray! It's Fall Time Again!' 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. 1. 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). 2. 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? 3. 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%. 4. 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.00 to $65.00 with the increment of $5.00 and the percentage of seats full tends to change from 40% to 100% with the increment of 10%