Cost accounting

profileJosh_95
showexcelfile.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