You are thinking of opening a Broadway play, I Love You, You’re 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 theater each night. Tickets sell for $50.00, and you earn an average of $1.50 profit per ticket holder from concessions. The theater holds 800, and you expect 80% of the seats to be full. Given your other assumptions, how many weeks will the play have to run for you to earn a 100% return on the play’s development cost? Given your other assumptions, how does an increase in the percentage of seats full affect profit? Given your other assumptions, determine how a joint change in the average ticket price and number of weeks the play runs influence profit. Use Excel’s Formula Auditing tools to show which cells in the spreadsheet are directly affected by the percentage of seats full.
You are thinking of opening a Broadway play, I Love You, You’re 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 theater each night. Tickets sell for $50.00, and you earn an average of $1.50 profit per ticket holder from concessions. The theater holds 800, and you expect 80% of the seats to be full. Given your other assumptions, how many weeks will the play have to run for you to earn a 100% return on the play’s development cost? Given your other assumptions, how does an increase in the percentage of seats full affect profit? Given your other assumptions, determine how a joint change in the average ticket price and number of weeks the play runs influence profit. Use Excel’s Formula Auditing tools to show which cells in the spreadsheet are directly affected by the percentage of seats full.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
You are thinking of opening a Broadway play, I Love You, You’re 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 theater each night. Tickets sell for $50.00, and you earn an average of $1.50 profit per ticket holder from concessions. The theater holds 800, and you expect 80% of the seats to be full.
- Given your other assumptions, how many weeks will the play have to run for you to earn a 100% return on the play’s development cost?
- Given your other assumptions, how does an increase in the percentage of seats full affect profit?
- Given your other assumptions, determine how a joint change in the average ticket price and number of weeks the play runs influence profit.
- Use Excel’s Formula Auditing tools to show which cells in the spreadsheet are directly affected by the percentage of seats full.
please use screenshots to explain why and how !!! Thank youuuu
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Step 1: Given information
VIEWStep 2: Calculate profit for 100 weeks as follows
VIEWStep 3: 1. Number of weeks the play have to run are as follows
VIEWStep 4: 2. Effect of increase in the percentage of seats full affect profit
VIEWStep 5: 3. Effect of joint change in average ticket price and number of weeks the play runs influence profit
VIEWStep 6: 4. The effect of percentage full is as follows
VIEWSolution
VIEW
Trending now
This is a popular solution!
Step by step
Solved in 7 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education