In: Accounting
A traveling production of Grease performs each year. The average show sells 1,500 tickets at $65 per ticket. There are 100 shows each year. The show has a cast of
35, each earning an average of $340 per show. The cast is paid only after each show. The other variable expense is program printing costs of $6 per guest. Annual fixed expenses total $1,072,400.
| 
 1.  | 
 Compute revenue and variable expenses for each show.  | 
| 
 2.  | 
 Use the income statement equation approach to compute the number of shows needed annually to break even.  | 
| 
 3.  | 
 Use the shortcut unit contribution margin approach to compute the number of shows needed annually to earn a profit of $10,111,200 Is this goal realistic? Give your reason.  | 
| 
 4.  | 
PrepareGrease's contribution margin income statement for 100 shows each year. Report only two categories of expenses: variable and fixed. | 
Requirement 1. Compute revenue and variable expenses for each show.
| 
 The revenue for each show is $  | 
 .  | 
| 
 The variable expenses for each show are $  | 
 .  | 
Requirement 2. Use the income statement equation approach to compute the number of shows needed annually to break even.
Begin by determining the basic income statement equation.
| 
 -  | 
 -  | 
 =  | 
 Operating income  | 
Using the basic income statement equation you determined above, solve for the number of shows to breakeven.
| 
 The number of shows needed annually to break even is  | 
 .  | 
Requirement 3. Use the shortcut unit contribution margin approach to compute the number of shows needed annually to earn a profit of
$10,111,200 Is this goal realistic? Give your reason.
Begin by selecting the formula.
| 
 (  | 
 +  | 
 ) /  | 
 =  | 
 Target # of shows  | 
Using the equation you determined above, solve for the target number of shows.
| 
 The number of shows needed annually to earn a profit of $10,111,200 is  | 
 .  | 
The profit goal of $10,111,200 is ▼ (unrealistic, realistic) since Grease currently performs 100 shows a year.
Requirement 4. Prepare Grease's contribution margin income statement for 100 shows each year. Report only two categories of expenses: variable and fixed.
| 
 Grease  | 
||||
| 
 Contribution Margin Income Statement  | 
||||
| 
 Year Ended December 31  | 
||||
Solution – 1:
Computation of revenue:
Number of tickets sold = 1500
Average price per ticket = $65
Total revenue for a show = 1500*$65 = $97,500
Computation of variable cost:
Payment to Cast (35 casts paid @$340 per show) = $11,900
Program printing cost (1500 * $6) = $9,000
Total Variable cost = $11,900 + $9,000 = $20,900
Solution- 2:
Annual Fixed Expenses = $1,072,400
Contribution margin (per show) = Sales Price – Variable cost
= $97,500 - $20,900
= $76,600
Number of shows required to reach at break-even= Fixed Expenses / Contribution per show
= $1,072,400 / $76,600
= 14
Hence 14 shows are required in a year to reach at break-even point.
Solution 3:
Annual Fixed Expenses = $1,072,400
Profits required = $10,111,200
Contribution margin per show = $76,600
Number of shows required to earn desired profit = (Fixed Cost + Desired profit) / Contribution per show
= ($1,072,400 + $10,111,200) / $76,600
= 146
Hence 146 shows are required in a year to earn profit of $10,111,200. Looking at current number of 100 shows in n year, this goal does not seem realistic for short term. An increase of 46% in number of shows require Travelling Production to re-look at its schedule, strategy and resources and see if it is possible.
Solution 4: