Question

In: Accounting

The Greensboro Performing Arts Center (GPAC) has a total capacity of 7,800 seats: 2,100 center seats,...

The Greensboro Performing Arts Center (GPAC) has a total capacity of 7,800 seats: 2,100 center seats, 2,600 side seats, and 3,100 balcony seats. The budgeted and actual tickets sold for a Broadway musical show are as follows:

Percentage Occupied
Ticket Price Budgeted Seats Actual Seats
Center $ 80 90 % 95 %
Side 70 80 85
Balcony 60 85 75

The actual ticket prices were the same as those budgeted. Once a show has been booked, the total cost does not vary with the total attendance.

Required:

Compute the following for the show:

1. The budgeted and actual sales mix percentages for different types of seats.

2. The budgeted average contribution margin per seat. Assume the ticket price is also the contribution margin.

3-a. The total sales mix variance.

3-b. The total sales quantity variance.

4. The total sales volume variance.

Requirement 1

The budgeted and actual sales mix percentages for different types of seats. (Round your answers to 4 decimal places. (i.e. .123456 = 12.3456%))

Budgeted Sales Mix Actual Sales Mix
Center % %
Side % %
Balcony %

%

The budgeted average contribution margin per seat. Assume the ticket price is also the contribution margin. (Round your answer to 2 decimal places.)

Requirement 2
What is the Budgeted average contribution margin per seat
  

The total sales mix variance. (Round your answers to the nearest whole dollar amount.)

Requirement 3A
Sales Mix Variance
Center
Side
Balcony
Total

Requirement 3B

he total sales quantity variance. (Round your answers to the nearest whole dollar amount.)

Sales Quantity Variance
Center
Side
Balcony
Total

Requirement 4

The total sales volume variance.

Sales Volume Variance
Center
Side
Balcony
Total

Solutions

Expert Solution

Requirement 1
The budgeted and actual sales mix percentages for different types of seats. (Round your answers to 4 decimal places. (i.e. .123456 = 12.3456%))
Capacity (seats) Budgeted Seats Budgeted Sales Mix Actual Seats Actual Sales Mix
Center 2100 1890 28.6147% 1995 30.5513%
Side 2600 2080 31.4913% 2210 33.8438%
Balcony 3100 2635 39.8940% 2325 35.6049%
Total 7800 6605 6530
Requirement 2
The budgeted average contribution margin per seat. Assume the ticket price is also the contribution margin. (Round your answer to 2 decimal places.)
What is the Budgeted average contribution margin per seat
Budgeted Avg. Contribution margin per seat = (Budgeted Sales x Ticket Price) / Total No. of Seats
Budgeted Avg. Contribution margin per seat  = ((1890*$80) + (2080*$70) + (2635*$60)) / 7800 $                                               58.32
3) The total sales mix variance. (Round your answers to the nearest whole dollar amount.)
Requirement 3A
Total Sales mix Variance = (Actual Quantity sold - Total Actual Quantity sold in Standard mix) x  Contribution per seat
A B C (A - B ) x C
Actual Seats Total Actual Quantity sold in Standard mix =6530 x Budgeted Sales Mix Contribution per seat Sales Mix Variance
Center 1995 1868.54 $       80.00 $            10,117 F
Side 2210 2056.38 $       70.00 $            10,753 F
Balcony 2325 2605.08 $       60.00 $          (16,805) U
Total 6530 $                          6,530.00 $              4,065 F
Requirement 3B
The total sales quantity variance. (Round your answers to the nearest whole dollar amount.)
Total Sales Quantity Variance = (Actual Sales Volume in Standard mix - Budgeted Sales) *Contribution per seat
A B C (A - B ) x C
Total Actual Quantity sold in Standard mix =6530 x Budgeted Sales Mix Budgeted Seats Contribution per seat Sales Quantity Variance
Center 1868.54 1890 $       80.00 $            (1,717) U
Side 2056.38 2080 $       70.00 $            (1,653) U
Balcony 2605.08 2635 $       60.00 $            (1,795) U
Total 6530.00 6605.00 $            (5,165) U
Requirement 4
Total Sales Volume Variance = (Actual Sales - Budgeted Sales) * Contribution Per Seat A B C (A - B ) x C
Actual Sales Budgeted Sales Contribution per seat Sales Volume Variance
Center 1995 1890 $       80.00 $         8,400.00 F
Side 2210 2080 $       70.00 $         9,100.00 F
Balcony 2325 2635 $       60.00 $     (18,600.00) U
Total 6530.00 6605.00 $       (1,100.00) U



Related Solutions

The Greensboro Performing Arts Center (GPAC) has a total capacity of 8,600 seats: 2,400 center seats,...
The Greensboro Performing Arts Center (GPAC) has a total capacity of 8,600 seats: 2,400 center seats, 2,900 side seats, and 3,300 balcony seats. The budgeted and actual tickets sold for a Broadway musical show are as follows: Percentage Occupied Ticket Price Budgeted Seats Actual Seats Center $ 85 90 % 95 % Side 75 80 85 Balcony 65 85 75 The actual ticket prices were the same as those budgeted. Once a show has been booked, the total cost does...
The Greensboro Performing Arts Center (GPAC) has a total capacity of 8,400 seats: 2,400 center seats,...
The Greensboro Performing Arts Center (GPAC) has a total capacity of 8,400 seats: 2,400 center seats, 2,900 side seats, and 3,100 balcony seats. The budgeted and actual tickets sold for a Broadway musical show are as follows: Percentage Occupied Ticket Price Budgeted Seats Actual Seats Center $ 110 90 % 95 % Side 100 80 85 Balcony 90 85 75 The actual ticket prices were the same as those budgeted. Once a show has been booked, the total cost does...
The Greensboro Performing Arts Center (GPAC) has a total capacity of 8,900 seats: 2,500 center seats,...
The Greensboro Performing Arts Center (GPAC) has a total capacity of 8,900 seats: 2,500 center seats, 3,000 side seats, and 3,400 balcony seats. The budgeted and actual tickets sold for a Broadway musical show are as follows: Percentage Occupied Ticket Price Budgeted Seats Actual Seats Center $ 85 90 % 95 %   Side 75 80 85   Balcony 65 85 75 The actual ticket prices are the same as those budgeted. Once a show has been booked, the total cost does...
Please include explanations The Greensboro Performing Arts Center (GPAC) has a total capacity of 7,600 seats:...
Please include explanations The Greensboro Performing Arts Center (GPAC) has a total capacity of 7,600 seats: 2,000 center seats, 2,500 side seats, and 3,100 balcony seats. The budgeted and actual tickets sold for a Broadway musical show are as follows: Percentage Occupied Ticket Price Budgeted Seats Actual Seats Center $ 90 90 % 95 %   Side 80 80 85   Balcony 70 85 75 The actual ticket prices are the same as those budgeted. Once a show has been booked, the...
Sky High Seats manufactures seats for airplanes. The company has the capacity to produce 100,000 seats...
Sky High Seats manufactures seats for airplanes. The company has the capacity to produce 100,000 seats per year, but currently produces and sells 75,000 seats per year. The following information relates to the current production of the product: Regular selling price per unit $400 Variable costs per unit: Manufacturing $220 Marketing and administrative $50 Total fixed costs: Manufacturing $1,500,000 Marketing and administrative $1,000,000 If a special sales order is accepted for 7,000 seats at a price of $350 per unit,...
Comfort Cloud manufactures seats for airplanes. The company has the capacity to produce? 100,000 seats per?...
Comfort Cloud manufactures seats for airplanes. The company has the capacity to produce? 100,000 seats per? year, but currently produces and sells? 75,000 seats per year. The following information relates to current? production: Sales price per unit $ 410 Variable costs per? unit: Manufacturing $ 250 Marketing and administrative $ 90 Total fixed? costs: Manufacturing $ 750,000 Marketing and administrative $ 200,000 If a special sales order is accepted for 3,000 seats at a price of $ 350 per? unit,...
XYZ manufactures seats for helicopters. The company has the capacity to produce 100,000 seats per year,...
XYZ manufactures seats for helicopters. The company has the capacity to produce 100,000 seats per year, but is currently produces and sells 75,000 seats per year. Selling price per unit $ 200 Variable costs per unit: Manufacturing $ 110 Operating $ 25 Fixed costs: Manufacturing $ 375,000 Operating $ 100,000 If a special sales order is accepted for 2,500 seats at a price of $ 160 per unit, fixed costs increase by $ 2,500, and variable marketing and administrative costs...
Macro-Hydropower. A dam has a height of 220 meters. Total generating capacity for the power plant...
Macro-Hydropower. A dam has a height of 220 meters. Total generating capacity for the power plant at the dam is about 1 GW (1 million kW). Assume an effective head of 215 meters and generating efficiency of 90%. At maximum capacity, what flow is required through the dam’s turbines to generate its power? If the dam operates at 60% of capacity on average, how much energy does it produce in a year? Express your answer in watts (e.g., W, kW,...
2. A bomb calorimeter and its contents has a total heat capacity of 17.2 kJ/°C. When...
2. A bomb calorimeter and its contents has a total heat capacity of 17.2 kJ/°C. When 5.00 grams of liquid ethanol, C2H6O (l), is completely combusted in the presence of excess oxygen gas, the calorimeter and its contents increases in temperature by 8.66°C. a) Write a balanced chemical equation for the complete combustion of one mole of liquid ethanol at 25°C. b) Determine the enthalpy of combustion (∆H°comb) of liquid ethanol at 25°C in units of kJ/mol. c) Incomplete combustion...
3. Excess capacity adjustments Water and Power Co. (W&P) currently has $540,000 in total assets and...
3. Excess capacity adjustments Water and Power Co. (W&P) currently has $540,000 in total assets and sales of $1,550,000. Half of W&P’s total assets come from net fixed assets, and the rest are current assets. The firm expects sales to grow by 22% in the next year. According to the AFN equation, the amount of additional assets required to support this level of sales is $_________ . W&P was using its fixed assets at only 93% of capacity last year....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT