Question 2 for assignment 2

You are thinking of opening a Broadway play, I Love You, Youre Mediocre, Now Get Better! It will cost $5 million to develop the show. There are 8 shows per week, and you project the show will run for 100 weeks. It costs $1000 to open the theatre each night. Each ticket sells for $50, and you can earn an average of $1.50 profit per ticket holder from concessions. The theater holds 800, and you expect 80% of the seats full.

Please answer the following parts to this question. PLEASE ANSWER USING EXCEL. Please show all calculations and formulas.

Part A) Given your other assumptions, how many weeks will the play have to run for you to earn a 100% return on the plays development cost?

Part B) Given your other assumptions, how does an increase in the percentage of seats full affect profit?

Part C) Given your other assumptions, determine how a joint change in the average ticket price and number of weeks the play runs influences profit.

Part D) Use Excels Formula Auditing tools to show which cells in the spreadsheet are directly affected by the percentage of seats full.

Please make sure you indicate which cells on the spreadsheet represent your responses for parts A-C.