Cost accounting
Josh_95
showexcelfile.xlsxCase 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 |
