Question: Please show me how to use a data table with the information above Q1. You are investing in a new play. You are given the

 Please show me how to use a data table with the

Please show me how to use a data table with the information above

Q1. You are investing in a new play. You are given the following information about the play: 1. The fixed cost of opening the play is $5 million. 2. The average ticket price is $100. 3. The theatre seats 2000 people, and there are 365 performances per year. 4. Variable cost of operating each performance is $1000. 5. In order to know the profitability of the play, you also need to know how many years you want to run the play, currently you are planning for 3 years, but the number is expected to change. 6. The current occupancy rate is 80% per performance, this number is expected to change. Use a data table to determine how the total profit generated by the play varies as the length of the play run varies between 1 and 5 years, and the average occupancy rate varies between 70% and 90% (hint: profit = total revenue - fixed cost - total variable cost )

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!