Question

The Badgers are a pro sports team. The teams sells three different type of tickets: Deluxe,...

The Badgers are a pro sports team. The teams sells three different type of tickets: Deluxe, Lower level and upper level. Information from the prior year is as follows: (TIP- Revenue Variances)

BUDGET:

Contribution Margin

      Number of

          Per seat

           Seats

deluxe

$          100

           2,000

lower level

               50

           6,000

upper level

               20

           8,000

ACTUAL:

Contribution Margin

      Number of

          Per seat

           Seats

deluxe

$          110

           2,200

lower level

               50

           6,200

upper level

               20

           8,400

Total Market Size

Budget

        40,000

Actual

        50,000

Required:

  1. Calculate the Sales Volume Variance for each product.
  2. Calculate the Sales Quantity Variance for each product.
  3. Calculate the Market Share Variance in terms of contribution margin.
  4. Calculate the Market Size Variance in terms of contribution margin.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a. Sales Volume Variance"

Sales Volume Variance =(Actual Units-Budgeted units)*Budgeted Contribution per unit

Delux : (2200-2000)*$100=$20,000.... Favorable

Lower Level : (6200-6000)*$50=$10,000.....Favorable

Upper Level : (8400-8000)*$20=$8,000.....Favorable

b Sales Quantity Variance:

Sales Quantity Variance :

Total Budgeted Sales( units)=2000+6000+8000=16000

Proportion of Delux =2000/16000=0.125

Proportion of Lower Level =6000/16000=0.375

Proportion of Upper Level=8000/16000=0.5

Total Actual sales=2200+6200+8400=16800

UNIT SALES AT STANDARD MIX:

Delux : 0.125*16800=2100

Lower Level : 0.375*16800=6300

Upper Level : 0.5*16800=8400

Sales Quantity Variance =(Budgeted SalesQuantity -Unit sales Quantity at standard Mix)* Budgeted Unit Contribution

Delux : (2000-2100)*$100=$10,000 Favorable

Lower Level : (6000-6300)*$50=$15,000..Favorable

Upper Level : (8000-8400)$20=$8,000.Favorable

Market Size Variance :

Budgeted Sales =16000 units

Budgeted Market Size=40000

Budgeted market share =16000/40000=0.4

Budgeted unit Contribution =(2000*$100+6000*$50+8000*$20)/16000=$41.25

Market Size Variance =(Actual Market Size-Budgeted Market Size)*Market Share*Budgeted unit contribution

Market Size Variance =(50000-40000)*0.4*41.25=$165,000 Favorable

Market Share Variance =(Actual Market Share-Budgeted Market Share)*Actual Market Size* Budgeted unit contribution

Actual Sales =2200+6200+8400=16800

Actual Market size =50000

Actual Market Share =16800/50000=0.336

Market Share Variance =(0.336-0.4)*50000*$41.25=$132,000 Unfavorable

Add a comment
Know the answer?
Add Answer to:
The Badgers are a pro sports team. The teams sells three different type of tickets: Deluxe,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • What is the correct answer? 100% Sparrow Company sells three different products that are similar, but...

    What is the correct answer? 100% Sparrow Company sells three different products that are similar, but are differentiated by various product features. Budgeted sales by product and in total for the coming year are shown below: Product Standard Deluxe Premium Total Percentage of total sales 48% 20% 32% Sales $240,000 $100,000 $160,000 $500,000 Less: variable costs 72,000 80,000 88,000 240,000 Contribution margin $168,000 $ 20,000 $ 72,000 $260,000 Less: fixed expenses $233,600 Net operating income $ 26,400 If the actual...

  • Elsworth Inc. manufactures and sells two fruit drinks: Kostor and Limba. Budgeted and actual results for...

    Elsworth Inc. manufactures and sells two fruit drinks: Kostor and Limba. Budgeted and actual results for 2017 are as follows: (Click the icon to view the budgeted and actual results.) Read the requirements Requirement 1. Compute the total sales volume variance, the total sales-mix variance, and the total sales-quantity variance (Calculate all variances in terms of contribution margin.) Show results for each product in your computations, Begin by completing the following table to determine the budgeted contribution margin per unit,...

  • Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop...

    Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop vacs vary in terms of quality and features, all are good sellers. Tanek is currently operating at full capacity with limited machine time. Sales and production information relevant to each model follows. Product Economy Standard Deluxe Selling price $35 $58 $115 Variable costs and expenses $18 $23 $53 Machine hours required 0.5 0.8 1.6 Calculate contribution margin per unit. Product Economy Standard Deluxe Contribution...

  • Paquindo Co. has two products: X and Y. The firm had the following budget and operating...

    Paquindo Co. has two products: X and Y. The firm had the following budget and operating results for the period just ended. The budgeted total industry sales for both products was 324,800 units and the actual industry sales was 350,000. Master Budget Product X Product Y Total Sales $324,800 $426,300 $751,100 Variable costs 194,880 213,150 408,030 Contribution margin 129,920 213,150 $343,070 Fixed costs 162,000 130,000 292,000 Operating income ($32,080) $83,150 $51,070 Selling price per unit $160 $70 Operating Results Product...

  • 1) Paquindo Co. has two products: X and Y. The firm had the following budget and...

    1) Paquindo Co. has two products: X and Y. The firm had the following budget and operating results for the period just ended. The budgeted total industry sales for both products was 324,800 units and the actual industry sales was 350,000. Master Budget Product X Product Y Total Sales $324,800 $426,300 $751,100 Variable costs 194,880 213,150 408,030 Contribution margin 129,920 213,150 $343,070 Fixed costs 162,000 130,000 292,000 Operating income ($32,080) $83,150 $51,070 Selling price per unit $160 $70 Operating Results...

  • Bazinga Ltd. makes 2 products, Aces and Bells.  Data for the most recent year is as follows:...

    Bazinga Ltd. makes 2 products, Aces and Bells.  Data for the most recent year is as follows: Budget Data Product Selling price per unit Variable cost per unit CM per unit Sales volume in units Sales mix (based on units) Total Contribution Margin Aces 10.00               2.00             8.00        123,000 61.50%                           984,000 Bells              15.00             10.00             5.00          77,000 38.50%                           385,000        200,000                        1,369,000 Actual Data Product Selling price per unit Variable cost per unit CM per unit Sales volume in units Sales mix (based on...

  • Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop vacs...

    Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop vacs vary in terms of quality and features, all are good sellers. Tanek is currently operating at full capacity with limited machine time. Sales and production information relevant to each model follows. Product Standard Deluxe Economy $38 Selling price Variable costs and expenses Machine hours required $63 $25 0.8 $125 $58 $20 0.5 1.6 Calculate contribution margin per unit. Product Standard Economy Deluxe Contribution...

  • Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop...

    Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop vacs vary in terms of quality and features, all are good sellers. Tanek is currently operating at full capacity with limited machine time. Sales and production information relevant to each model follows. Selling price Variable costs and expenses Machine hours required Economy $36 $19 0.5 Product Standard $60 $24 0.8 Deluxe $120 $56 1.6 Calculate contribution margin per unit. Product Standard Economy Deluxe Contribution...

  • Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop...

    Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop vacs vary in terms of quality and features, all are good sellers. Tanek is currently operating at full capacity with limited machine time. Sales and production information relevant to each model follows. Product Economy Standard Deluxe $72 $144 $23 $29 $66 0.8 1.6 Selling price Variable costs and expenses Machine hours required $43 0.5 Calculate contribution margin per unit. Product Standard Economy Deluxe Contribution...

  • Problem 19-4A Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although...

    Problem 19-4A Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop vacs vary in terms of quality and features, all are good sellers. Tanek is currently operating at full capacity with limited machine time. Sales and production information relevant to each model follows. Problem 19-4A Tanek Industries manufactures and sells three different models of wet-dry shop vacuum cleaners. Although the shop vacs vary in terms of quality and features, all are good sellers....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT