Cost accounting
Josh_95showexcelfile.xlsx
Case Exhibit 1
Exhibit 1. Summary of the Contract With Mosesian Center for the Arts Black Box Theater | ||||
Service | Fee | Hours per show | ||
Hall rental per week, including practices and performance | $1,000 | |||
One-time ticket set-up fee | $30 | |||
Technical support and lighting (4-hour minimum) | $30 | per hour | 1.5 | * |
Sound techinician (4-hour minimum) | $30 | per hour | 1.5 | ** |
House management | $60 | per show | ||
Facility fees | $2 | per ticket | ||
Ticket convenience charges | $3 | per ticket | ||
*SETU would have to pay a minimum of 4 hours ($120) even if SETU does not use 4 hours of technical support and lighting. | ||||
**SETU would have to pay minimum of 4 hours ($120) even if SETU does not use 4 hours of sound technician. | ||||
Case Exhibit 3
Exhibit 3. Assumptions for Estimating Ticket Sales and Receipts | ||
Estimated number of shows | 4 | |
Price per ticket - adult | $25 | including $5 in fees |
Price per ticket - student and senior | $22 | including $5 in fees |
Estimated percentage of adult ticket | 70% | |
Estimated percentage of student and senior ticket | 30% | |
Maximum capacity | 90 | seats |
Average occupancy per show | 50% |
Exhibit TN1
Color Scheme for Exhibit TN1 | |||||||||
Data Entry | |||||||||
For cells in this color, find the numerical information in the case and enter the correct number. | |||||||||
Calculations | |||||||||
For cells in this color, calculate the answer based on information found in other colored cells. | |||||||||
Assumptions | |||||||||
Ticket sales assumptions | |||||||||
Estimated number of shows | |||||||||
Price per ticket - adult | |||||||||
Price per ticket - student and senior | |||||||||
Estimated percentage of adult ticket | |||||||||
Estimated percentage of student and senior ticket | |||||||||
Maximum capacity | |||||||||
Average occupancy per show | |||||||||
Variable costs assumptions | |||||||||
Facility fees | |||||||||
Ticket convenience charges | |||||||||
Step costs assumptions | |||||||||
Technical support and lighting (4-hour minimum) | per hour | ||||||||
Number of technical support hours per show | |||||||||
Sound technician (4-hour minimum) | per hour | ||||||||
Number of sound technician hours per show | |||||||||
House management | per show | ||||||||
Budgeted Statement Based on Four Shows | |||||||||
SETU (Stage Ensemble Theater Unit, Inc.) | |||||||||
Kamala at the Mosesian Center for the Arts Black Box Theater - March 31, April 1, and April 2, 2017 | |||||||||
RECEIPTS | Budget | Actual | EXPENDITURE | Budget | Actual | ||||
Total Variable Costs | |||||||||
Black Box Theater, including adults, students, and seniors | |||||||||
TOTAL ESTIMATED TICKET RECEIPTS | Total Contribution Margin | ||||||||
Cash donation | Step Costs: From Solution to Question 2b | ||||||||
In-kind food donation | Technical support and lighting (4-hour minimum) | ||||||||
Cash and In-Kind Food Donations Total | Sound technician (4-hour minimum) | ||||||||
TOTAL BUDGETED RECEIPTS | House management | ||||||||
Total Step Costs | |||||||||
Fixed Costs: | |||||||||
Hall rental per week, including practices and performance | |||||||||
One-time ticket set-up fee | |||||||||
Rental for rehearsal | |||||||||
Stage decoration and transportation of décor | |||||||||
Additional light and sound | |||||||||
Brochures and printing | |||||||||
Publcity for various ads, interviews, Facebook ads, etc. | |||||||||
Make-up | |||||||||
Food during performances and rehearsals | |||||||||
Copyright payment | |||||||||
Other | |||||||||
Total step and fixed costs | |||||||||
Operating Income Before Donations | |||||||||
NET OPERATING INCOME ESTIMATED | |||||||||
Solution 2a-b
Appendix TN2. Solutions for Questions 2a and 2b | |||||||
Service | From Case Exhibit 1 | ||||||
Fixed Costs assumptions | |||||||
Hall rental per week, including practices and performance | Get information from Case Exhibit 1 (use formulas, do not retype amounts) | ||||||
One-time ticket set-up fee | |||||||
Get information from Case Exhibit 3 (use formulas, do not retype amounts) | |||||||
Step costs assumptions | hrs per show | ||||||
Technical support and lighting (4-hour minimum) | per hour | * | Use information on this sheet to prepare a formula to compute this amount | ||||
Sound techinician (4-hour minimum) | per hour | ** | |||||
House management | per show | Get information from the text of the case (you'll need to type these amounts) | |||||
Variable costs assumptions | |||||||
Facility fees | per ticket | ||||||
Ticket convenience charges | per ticket | ||||||
Ticket sales assumptions | From Case Exhibit 3 | ||||||
Estimated number of shows | 4 | ||||||
Price per ticket - adult | |||||||
Price per ticket - student and senior | |||||||
Estimated percentage of adult ticket | |||||||
Estimated percentage of student and senior ticket | |||||||
Maximum capacity | seats | ||||||
Average occupancy per show | |||||||
Budget | Calculated based on information provided in Case Exhibits 1 and 3 | ||||||
Ticket sales - adult | 0 | ||||||
Ticket sales - student and senior | 0 | ||||||
Total number of tickets | 0 | ||||||
Receipts | |||||||
Ticket receipts - adult | - 0 | ||||||
Ticket receipts - student and senior | - 0 | ||||||
Total Receipts | $0 | ||||||
Expenditures | |||||||
Variable costs | |||||||
Facility fees | - 0 | ||||||
Ticket convenience charges | - 0 | ||||||
Total Variable Costs | $0 | ||||||
Contribution margin | $0 | Total Receipts - Total Variable Costs | |||||
Step costs | |||||||
Technical support and lighting (4-hour minimum) | 0 | From Case Exhibit 1 ($30 per hour × 1.5 hours per show × 4 shows) | |||||
Sound technician (4-hour minimum) | 0 | Use the formula in the cell above to help you determine the formula for this cell | |||||
House management | 0 | ||||||
Fixed costs | From Case Descriptions | ||||||
Hall rental per week, including practices and performance | $0 | ||||||
One-time ticket set-up fee | $0 | ||||||
Rental for rehearsal | |||||||
Stage decoration and transportation of décor | 0 | ||||||
Additional light and sound | |||||||
Brochures and printing | |||||||
Publcity for various ads, interviews, Facebook ads, etc. | |||||||
Make-up | 0 | ||||||
Food during performances and rehearsals | |||||||
Copyright payment | |||||||
Other | |||||||
Total step and fixed costs | $0 | ||||||
Operating Income Before Donations | $0 | Contribution Margin - Total Step and Fixed Costs | |||||
Cash and in-kind donation | |||||||
Cash donation | |||||||
Food in-kind donation | |||||||
Total donations | $0 | ||||||
Net operating income | $0 | Operating income before donations + Total donations | |||||
Calculate breakeven | |||||||
Average price per ticket | ERROR:#DIV/0! | ||||||
Average variable cost per ticket | ERROR:#DIV/0! | ||||||
Average contribution margin | ERROR:#DIV/0! | ||||||
Number of tickets needed to break even | ERROR:#DIV/0! | ||||||
Ticket receipts needed to break even | ERROR:#DIV/0! | ||||||
Average number of tickets needed to break even per show | ERROR:#DIV/0! | ||||||
Break-even occupancy | ERROR:#DIV/0! |
Solution 2c
Solution 2d
Solution 2e
Solutions 2f
Enter your explanation for Question 2f here. As you type the text lines will scroll upward. | |
Solutions 3a-3c
Appendix TN6. Solution to Question 3a | ||||||||
Contract costs with Black Box Theater | ||||||||
Fixed Costs assumptions | ||||||||
Hall rental per week, including practices and performance | ||||||||
One-time ticket set-up fee | Get information from Case Exhibit 1 (use formulas, do not retype amounts) | |||||||
Step costs | Get information from Case Exhibit 3 (use formulas, do not retype amounts) | |||||||
Technical support and lighting (4-hour minimum) | per hour | hour per show* | ||||||
Sound techinician (4-hour minimum) | per hour | hour per show* | Use information on this sheet to prepare a formula to compute this amount | |||||
House management | per show | |||||||
Get information from the text of the case (you'll need to type these amounts) | ||||||||
Variable costs | ||||||||
Facility fees | per ticket | |||||||
Ticket convenience charges | per ticket | |||||||
Hidden costs | ||||||||
Transporting stage décor furniture | ||||||||
Bookkeeping for production | ||||||||
Marketing on social media service | ||||||||
Graphic design for Kamala poster | ||||||||
Rental cost of furniture | ||||||||
Stage decoration service | ||||||||
Total Hidden Costs | $0 | <--3a solution | ||||||
Appendix TN7. Solution to Question 3b | ||||||||
Estimated number of shows | ||||||||
Price per ticket - adult | ||||||||
Price per ticket - student and senior | ||||||||
Estimated percentage of adult ticket | ||||||||
Estimated percentage of student and senior ticket | ||||||||
Maximum capacity | seats | |||||||
Average occupancy per performance | ||||||||
Budget | ||||||||
Ticket sales - adult | ||||||||
Ticket sales - student and senior | ||||||||
Total number of tickets | 0 | |||||||
Receipts | ||||||||
Ticket receipts - adult | ||||||||
Ticket receipts - student and senior | ||||||||
Total Receipts | $0 | |||||||
Expenditures | ||||||||
Variable costs | ||||||||
Facility fees | ||||||||
Ticket convenience charges | ||||||||
Total Variable Costs | $0 | |||||||
Contribution margin | $0 | |||||||
Step costs | ||||||||
Technical support and lighting (4-hour minimum) | ||||||||
Sound techinicial (4-hour minimum) | ||||||||
House management | ||||||||
Fixed costs | ||||||||
Hall rental per week, including practices and performance | ||||||||
One-time ticket set-up fee | ||||||||
Rental for rehearsal | ||||||||
Stage decoration and transportation of décor | ||||||||
Additional light and sound | ||||||||
Brochures and printing | ||||||||
Publcity for various ads, interviews, Facebook ads, etc. | ||||||||
Make-up | ||||||||
Food during performances and rehearsals | ||||||||
Copyright payment | ||||||||
Other | ||||||||
Hidden Costs | ||||||||
Total step and fixed costs | $0 | |||||||
Operating Income Before Donations | $0 | |||||||
Cash and in-kind donation | ||||||||
cash donation | ||||||||
Food in-kind donation | ||||||||
Total donations | $0 | |||||||
Net operating income | $0 | |||||||
Appendix TN8. Solution to Question 3c | ||||||||
Number of shows | ||||||||
Calculate breakeven without donation | 4 | 3 | ||||||
Average price per ticket | ||||||||
Average variable cost per ticket | ||||||||
Average contribution margin | ||||||||
Number of tickets needed to break even | ||||||||
Ticket receipts needed to break even | ||||||||
Average number of tickets needed to break even per show | ||||||||
Break-even occupancy | ||||||||
Calculate breakeven with donation | ||||||||
Number of tickets needed to break even | ||||||||
Ticket receipts needed to break even | ||||||||
Average number of tickets needed to break even per show | ||||||||
Break-even occupancy |