Question

In: Accounting

3. Sales mix and CVP Analysis: Goalie’s Ball, Inc. produces and sells two different types of...

3. Sales mix and CVP Analysis: Goalie’s Ball, Inc. produces and sells two different types of soccer goals: basic and premium. Monthly information regarding the two types of goals are shown below:

Basic

Premium

Total

Sales

$

1,080,000

$720,000

$1,800,000

Variable costs

$315,400

$294,100

$609,500

Fixed expenses are $517,250 per month in total for the company.

  1. Determine the sales mix for the two products
  2. Determine the contribution margin ratio for each of the two products (round your decimal answer to four decimal places, i.e. 0.3149322 = 0.3149 = 31.49%)
  3. Calculate the weighted average contribution margin (WACM) ratio (round your decimal answer to four decimal places, i.e. 0.3149322 = 0.3149 = 31.49%)
  4. Calculate Goalie’s Ball’s break-even point in dollars. Round to the nearest cent (i.e. two decimal places)
  5. The manager of Goalie’s Ball is considering a shift in sales mix, increasing sales of basic goals to 65% and decreasing sales of premium goals to 35%. How would this affect the break-even point in dollars? Briefly explain your answer.

Solutions

Expert Solution

Part-1

Computation of Sales Mix
Basic Premium Total
Sales 1080000 720000 1800000
Sales Mix 0.6 0.4
(1080000/1800000) (720000/1800000)

Part-2

Computation of Contribution margin Ratio
Basic Premium Total
Sales (a) 1080000 720000 1800000
Less: Variable cost 315400 294100 609500
Contribution ( C) 764600 425900 1190500
CM Ratio(c/a) 70.80% 59.15% 66.14%

Part-3

-Computation of Weighted Average Contribution ratio
Basic Premium Total
Sales (a) 1080000 720000 1800000
Contribution ( C) 764600 425900 1190500
Sales Mix 0.6 0.4
Weighted Average Contribution 458760 170360 629120
Weighted Average Contribution margin Ratio:- 629120/1800000=34.95%
d) Commputation BEP in Dollar
BEP= Fixed Cost/ Weighted CM Ratio
517250/34.95%= $1479924
BEP for Basic= $1479924X60%=$887954
BEP for Premium= $1479924X40%=$591970
e:-Computation of Weighted Avergae Contribution ratio
Basic Premium Total
Contribution ( C) 764600 425900 1190500
Sales Mix (d) 0.65 0.35
Weighted Averge Contribution
(cXd)
496990 149065 646055
Weighted Average Contribution margin Ratio:- 646055/1800000=35.89%
Commputation BEP in Dollar
BEP= Fixed Cost/ Weighted CM Ratio
517250/35.89%= $1441209

Related Solutions

3. Sales mix and CVP Analysis:   Goalie’s Ball, Inc. produces and sells three different types of...
3. Sales mix and CVP Analysis:   Goalie’s Ball, Inc. produces and sells three different types of soccer balls: basic, deluxe, and pro. Monthly information regarding the three types of balls are shown below: Basic Deluxe Pro Sales volume (Units) 5,500 4,000 500 Price per unit $20.00 $35.00 $60.00 VC per unit $8.00 $19.00 $32.00 Total Fixed Costs (FC): $108,500 Determine the sales mix percentage (%) for the three products. Determine the contribution margin (CM) per unit for each of the...
CVP Analysis and Sales Mix (Multiple Products). Sierra Books Incorporated produces two different products with the...
CVP Analysis and Sales Mix (Multiple Products). Sierra Books Incorporated produces two different products with the following monthly data (this is the base case). Text Lecture Notes Total Selling price per unit $100 $12 Variable cost per unit $60 $3 Expected unit sales 21,000 14,000 35,000 Sales mix 60 percent 40 percent 100 percent Fixed costs $750,000 Assume the sales mix remains the same at all levels of sales except for requirement i. Required: Round to the nearest unit of...
3-21 Breakeven analysis; multiproduct CVP analysis (LO 1, 5) Kitchenware, Inc., sells two types of water...
3-21 Breakeven analysis; multiproduct CVP analysis (LO 1, 5) Kitchenware, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $15 and are sold for $30. Glass pitchers cost $24 and are sold for $45. All other costs are fixed at $982,800 per year. Current sales plans call for 14,000 plastic pitchers and 42,000 glass pitchers to be sold in the coming year. Required a. How many pitchers of each type must be sold to...
Part II - Effect of Sales Mix on CVP Analysis ** Round all answers to two...
Part II - Effect of Sales Mix on CVP Analysis ** Round all answers to two decimal places.** Also can you please how work so i can understand Fat Cat Furniture store sells two types of products; cat beds and scratching posts. Over the past year Fat at sold 6,000 cat beds and 4,000 scratching posts, the sales mix of 6,000 beds to 4,000 posts creates a percentage of 60% for the cat beds and 40% for the scratching posts....
ABC and CVP Analysis: Multiple Products Good Scent, Inc., produces two colognes: Rose and Violet. Of...
ABC and CVP Analysis: Multiple Products Good Scent, Inc., produces two colognes: Rose and Violet. Of the two, Rose is more popular. Data concerning the two products follow: Rose Violet Expected sales (in cases) 50,000 10,000 Selling price per case $100 $80 Direct labor hours 36,000 6,000 Machine hours 10,000 3,000 Receiving orders 50 25 Packing orders 100 50 Material cost per case $50 $43 Direct labor cost per case $10 $7 The company uses a conventional costing system and...
ABC and CVP Analysis: Multiple Products Good Scent, Inc., produces two colognes: Rose and Violet. Of...
ABC and CVP Analysis: Multiple Products Good Scent, Inc., produces two colognes: Rose and Violet. Of the two, Rose is more popular. Data concerning the two products follow: Rose Violet Expected sales (in cases) 50,000 10,000 Selling price per case $100 $80 Direct labor hours 36,000 6,000 Machine hours 10,000 3,000 Receiving orders 50 25 Packing orders 100 50 Material cost per case $50 $43 Direct labor cost per case $10 $7 The company uses a conventional costing system and...
ABC and CVP Analysis: Multiple Products Good Scent, Inc., produces two colognes: Rose and Violet. Of...
ABC and CVP Analysis: Multiple Products Good Scent, Inc., produces two colognes: Rose and Violet. Of the two, Rose is more popular. Data concerning the two products follow: Rose Violet Expected sales (in cases) 50,000 10,000 Selling price per case $100 $80 Direct labor hours 36,000 6,000 Machine hours 10,000 3,000 Receiving orders 50 25 Packing orders 100 50 Material cost per case $50 $43 Direct labor cost per case $10 $7 The company uses a conventional costing system and...
CVP Analysis; Break-even point (2pts): Diagram, Inc., produces and sells a single product whose selling price...
CVP Analysis; Break-even point (2pts): Diagram, Inc., produces and sells a single product whose selling price is $240.00 per unit and whose variable expense is $72.00 per unit. The company's fixed expense is $372,960 per month. Determine the monthly break-even in: a)     unit sales volume b)     total dollar sales CVP Analysis; Target Profit (2pts): L. Gott Corporation produces and sells a single product. Data concerning that product appear below: Selling price per unit $ 230.00 Variable expense per unit $...
Multiple-Product Analysis, Changes in Sales Mix, Sales to Earn Target Operating Income Basu Company produces two...
Multiple-Product Analysis, Changes in Sales Mix, Sales to Earn Target Operating Income Basu Company produces two types of sleds for playing in the snow: basic sled and aerosled. The projected income for the coming year, segmented by product line, follows: Basic Sled Aerosled Total Sales $3,000,000 $2,400,000 $5,400,000 Total variable cost 1,000,000 1,000,000 2,000,000 Contribution margin $2,000,000 $1,400,000 $3,400,000 Direct fixed cost 778,000 650,000 1,428,000 Product margin $1,222,000 $750,000 $1,972,000 Common fixed cost 198,900 Operating income $1,773,100 The selling prices...
Bramble Corp. sells two types of computer hard drives. The sales mix is 30% (Q-Drive) and...
Bramble Corp. sells two types of computer hard drives. The sales mix is 30% (Q-Drive) and 70% (Q-Drive Plus). Q-Drive has variable costs per unit of $ 150 and a selling price of $ 210. Q-Drive Plus has variable costs per unit of $ 165 and a selling price of $ 255. Bramble’s fixed costs are $ 729000. How many units of Q-Drive would be sold at the break-even point? 9000. 6300. 2700. 3645.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT