| Solution: | |||||
| 1) | |||||
| Calculation of Weighted Average Contribution margin per unit: | |||||
| Smasher | Basher | Dinker | Total | ||
| Units sold (Given) | 2000 | 3200 | 3200 | 8400 | |
| Contribution Margin | $86,500 | $98,500 | $81,800 | $266,800 | |
| Contribution margin per unit (Contribution Margin/Units sold) | 43.25000 | 30.78125 | 25.56250 | $31.76 | |
| ($86500/2000) | ($98500/3200) | ($81800/3200) | ($266800/8400) | ||
| Sales mix Ratio (Sales units/Total Sales units) | 0.238095238 | 0.380952381 | 0.380952381 | 1 | |
| (2000/8400) | (3200/8400) | (3200/8400) | (8400/8400) | ||
| Weighted average contribution Margin (Contribution margin per unit * Sales mix ratio) | 10.29761905 | 11.72619048 | 9.738095238 | $31.76 | |
| Weighted average contribution margin = $31.76 per unit | |||||
| 2) | |||||
| Calculation of Break even point in units: | |||||
| Break even points in units = Fixed Cost/ Weighted average contribution margin | |||||
| $141900/$31.76 | |||||
| 4467.88 | |||||
| Break even points in Units = 4468 units | |||||
| 3) | |||||
| Calculation of Weighted average margin ratio : | |||||
| Smasher | Basher | Dinker | Total | ||
| Contribution Margin | $86,500 | $98,500 | $81,800 | $266,800 | |
| Sales | $160,300 | $168,100 | $117,400 | $445,800 | |
| Contribution Margin Ratio (Contribution Margin/Sales*100) | 53.96132252 | 58.59607377 | 69.67632027 | 59.84746523 | |
| ($86500/160800*100) | ($98500/168100*100) | ($81800/117400*100) | ($266800/445800*100) | ||
| Sales Mix (Calculated in Part 1) | 0.238095238 | 0.380952381 | 0.380952381 | 1 | |
| Weighted Average Contribution Margin Ratio (Contribution Margin ratio *Sales Mix) | 12.84793393 | 22.32231382 | 26.5433601 | 59.84746523 | |
| Weighted Average Contribution Margin ratio = 59.85% | |||||
| 4) | |||||
| Calculation of Level of sales (in Dollars) to earn a profit of $135,900: | |||||
| Level of sales = (Common Fixed Cost+Required profit)/Weighted average contribution ratio | |||||
| ($141900+$135900)/59.85% | |||||
| $277800/59.85% | |||||
| 464160.401 | |||||
| Level of Sales = $464160 | |||||
| 5) | |||||
| Total Sales calculated | $464,160 | ||||
| Smasher | Basher | Dinker | Total | ||
| Sales Mix (Calculated in Part 1) | 0.238095238 | 0.380952381 | 0.380952381 | 1 | |
| Sales (In dollars) (Total Sales *Sales Mix) | $110,514 | $176,823 | $176,823 | $464,160 | |
| (464160*0.238095238) | (464160*0.380952381) | (464160*0.380952381) | |||
| Sales (In dollars) | $110,514 | $176,823 | $176,823 | $464,160 | |
Problem 4-14 Culver Tennis Racquet Co. produces and sells three models: Units sold Sales Less variable...
Sheffield Co., a manufacturer of rain barrels, had the
following data for 2016.
Sales
5,000
units
Sales price
$130
per unit
Variable costs
$52
per unit
Fixed costs
$347,100
What is the contribution margin ratio? (Round
answer to 0 decimal places, e.g. 5,275.)
Contribution margin ratio
%
LINK TO TEXT
LINK TO TEXT
LINK TO TEXT
What is the break-even point in dollars? (Round
intermediate calculation and final answers to 0 decimal places,
e.g. 5,275.)
Break-even point
$
LINK TO...
Question 3 Rossi Incorporated makes track suits that sell for coming year. 70 each. Actual sales are $1,036,000. Management estimates that fixed costs will total $233,100 and variable costs will be $49 per unit this Calculate the break even point n sales dollars using the contribution margin ratio places, e.g. 125.) Round contribution margin ratio to 4 decimal places, eg. 15.2964% and final answer to 0 decimal Break-even point in dollars LINK TO TEXT Calculate the margin of safety in...
Lindstrom Company produces two fountain pen models. Information about its products follows: Sales revenue Less: Variable costs Contribution margin Total units sold Product A $ 165,000 72,600 $ 92,400 5,000 Product B $215,000 60,200 $154,800 5,000 Lindstrom’s fixed costs total $87,500. Required: 1. Determine Lindstrom's weighted-average unit contribution margin and weighted-average contribution margin ratio. 2. Calculate Lindstrom's break-even point in units and in sales revenue. 3. Calculate the number of units that Lindstrom must sell to earn a $130,000 profit....
Question 5 Hoopz Incorporated makes basketball nets. Its sales mix and contribution margin information per unit are as follows Sales Mix Bryant 12 % James 49 % Jordan 39 % Contribution Margin $92 $73 $55 It has fixed costs of $2,389,100. Determine the weighted-average unit contribution margin. (Round answers to 2 decimal places, e.g. 15.25.) Weighted-average unit contribution margin $ LINK TO TEXT Determine the total number of units that the company must produce to break even Total number of...
Hoopz Incorporated makes basketball nets. Its sales mix and contribution margin information per unit are as follows: Sales Mix Contribution Margin Bryant 9% $89 James 50% $70 Jordan 41 % $56 It has fixed costs of $2,203,398. Determine the weighted average unit contribution margin. (Round answers to 2 decimal places, e.g. 15.25.) Weighted average unit contribution margins LINK TO TEXT Determine the total number of units that the company must produce to break even. Total number of units LINK TO...
Bridgeport Co., a manufacturer of rain barrels, had the
following data for 2016.
Sales
3,300
units
Sales price
$100
per unit
Variable costs
$37
per unit
Fixed costs
$172,557
(a)
Your answer is correct.
What is the contribution margin ratio? (Round answer to
0 decimal places, e.g. 5,275.)
Contribution margin ratio
%
Click if you would like to
Show Work for this question:
Open Show Work
SHOW SOLUTION
LINK TO TEXT
LINK TO TEXT
LINK TO TEXT
Attempts: 1 of...
Waterways Continuing Problem-6 (Part 1)
The vice-president of sales and marketing, Madison Tremblay, is
trying to plan for the coming year in terms of production needs to
meet the forecasted sales. The board of directors is very
supportive of any initiatives that will lead to increased profits
for the company in the upcoming year.
Waterways markets a simple water controller and timer that it mass
produces. During 2016, the company sold 332,500 units at an average
selling price of $8...
Rossi Incorporated makes track suits that sell for $50 each. Actual sales are $642,500. Management estimates that fixed costs will total $205,600 and variable costs will be $30 per unit this coming year. Calculate the break-even point in sales dollars using the contribution margin ratio. (Round contribution margin ratio to 4 decimal places, e.g. 15.2964% and final answer to 0 decimal places, e.g. 125.) Break-even point in dollars $ Calculate the margin of safety in dollars and the margin of...
Question, Fill in the
blanks
Thank you, I really appreciate it!
Waterways Continuing Problem-6 (Part 1) The vice-president of sales and marketing, Madison Tremblay, is trying to plan for the coming year in terms of production needs to meet the forecasted sales. The board of directors is very supportive of any initiatives that will lead to increased profits for the company in the upcoming year. Waterways markets a simple water controller and timer that it mass produces. During 2016, the...
Do It! Review 19-2 Snow Cap Springs produces and sells water filtration systems for homeowners. Information regarding its three models is shown below Basic 627 $254 $198 Basic Plus Premium Total Units sold Selling price Variable cost 242 $396 $290 231 1,100 $798 $418 The company's total fixed costs to produce the filtration systems are $148,544 Determine the sales mix as a function of units sold for the three products. (Round answers to 0 decimal places, e.g. 12.) Basic Basic...