In: Accounting
Lindstrom Company produces two fountain pen models. Information about its products follows:
| Product A | Product B | ||||
| Sales revenue | $ | 120,000 | $ | 125,000 | |
| Less: Variable costs | 60,000 | 66,000 | |||
| Contribution margin | $ | 60,000 | $ | 59,000 | |
| Total units sold | 7,000 | 7,000 | |||
Lindstrom’s fixed costs total $84,500.
Required:
1. Determine Lindstrom’s weighted-average unit
contribution margin and weighted-average contribution margin ratio.
(Round your weighted-average CM to 2 decimal places and
your CM ratio to 1 decimal place (i.e. .123 should be entered as
12.3%)).
2. Calculate Lindstrom’s break-even point in units
and in sales revenue. (Round your "Sales Revenue" answer to
2 decimal places and "Sales Units" answer to the nearest whole
number.)
3. Calculate the number of units that Lindstrom
must sell to earn a $120,000 profit. (Round your
answer to the nearest whole
number.)
4. Calculate Lindstrom’s margin of safety and
margin of safety as a percentage of sales if it sells 11,000 total
pens. (Round your margin of safety in units to the nearest
whole number and your percentage of sales answer to 2 decimal
places (i.e. .1234 should be entered as 12.34%))
| Solution: | |||||
| 1. | Weighted-average unit contribution margin =$8.5 per unit | ||||
| Weighted-average contribution margin ratio =48.6% | |||||
| Working Notes: | |||||
| Weighted-average unit contribution margin =Total contribution margin of all products/Total units for all products | |||||
| =119,000/14,000 | |||||
| =$8.5 per unit | |||||
| Weighted-average contribution margin ratio =Total contribution margin of all products/Total SALES for all products | |||||
| =119,000/245,000 | |||||
| =0.48571428 | |||||
| =48.57% | |||||
| =48.6% | |||||
| Notes: | i | II | III=I+II | ||
| Product A | Product B | Total | |||
| Sales revenue | 120,000 | 125,000 | 245,000 | a | |
| Less: Variable costs | 60,000 | 66,000 | 126,000 | b | |
| Contribution margin | 60,000 | 59,000 | 119,000 | c=a-b | |
| Total units sold | 7,000 | 7,000 | 14,000 | d | |
| 2. | Break-even point in units =9,941 units | ||||
| Break-even point in sales revenue =$173,970.59 | |||||
| Working Notes: | |||||
| Breakeven point = Fixed cost /unit contribution margin | |||||
| =$84,500/$8.50 | $8.50 unit contribution margin used from 1. | ||||
| =9,941.176 | |||||
| =9,941 units | |||||
| Break-even point in sales revenue = Fixed cost /Contribution margin ratio | |||||
| =$84,500/0.48571428 | |||||
| =$173,970.5903 | contribution margin ratio = 0.48571428 from 1. | ||||
| =$173,970.59 | |||||
| 3. | Number of units that Lindstrom must sell to earn a $120,000 profit = 24,059units | ||||
| Working Notes: | |||||
| Target units=(Total fixed cost + target profit) / Unit Contribution Margin | |||||
| = (84,500 + 120,000)/8.50 | |||||
| = 204,500/8.50 | |||||
| =24,058.823 | |||||
| =24,059 units | nearest whole no. | ||||
| 4. | Margin of safety = 1,059 units | ||||
| margin of safety as a percentage of sales=9.63% | |||||
| Working Notes: | |||||
| Margin of safety units= Actual or budgeted sales - Break even sales | |||||
| =11,000 -9,941.176 | |||||
| =1,058.824 | |||||
| =1,059 | nearest whole no. | ||||
| Margin of safety as a percentage of sales=Margin of safety in units/Total sales units | |||||
| = 1,058.824/11,000 | |||||
| =0.096256727 | |||||
| =0.0963 | |||||
| =9.63% | |||||
| Please feel free to ask if anything about above solution in comment section of the question. | |||||