Assignment Case 2B Mendel Paper Company

Week 1 assignment
Managerial Accounting
BUS 630

Week 1 assignment
1. From all original estimates given, prepare estimated contribution margins by product line for the next fiscal quarter. Also, show the contribution margins per unit.
Product Line
Sales Volume
Price
Variable Cost
Contribution
Margin/Unit
Ratio
Comp. Paper
30,000
$14.00
$6.00
$8.00
57%
$8.00*30,000 = $240,000 CM
Napkins
120,000
$ 7.00
$4.50
$2.50
36%
$2.50*120,000 = $300,000 CM
Place Mats
45,000
$12.00
$3.60
$8.40
70%
$8.40 * 45,000 = $378,000 CM
Poster Board
80,000
$ 8.50
$2.50
$6.00
71%
$6.00 * 80,000 = $480,000 CM
Total
275,000

Sales Proportions
CM/Product
Weighed CM
Computer Paper
11% *
$8.00 =
$0.88
Napkins
44% *
$2.50 =
$1.10
Place Mats
16% *
$8.40 =
$1.34
Poster Board
29% *
$6.00 =
$1.74
Total
100%

$5.06 weighted CM

Total Fixed Costs = $420,000+$118,000 = 538,000
Total Units = $538,000/$5.06 = 106,324 Break Even

Product Lines
Sales Mix %
Total Units
# of Products
Unit CM
CM
Comp. Papers
11%
106,324
11,696
$8.00
$93,568
Napkins
44%
106,325
46,783
$2.50
$116,956
Place Mats
16%
106324
17,012
$8.40
$142,899
Poster Board
29%
106324
30,834
$6.00
$185,003

2. Prepare contribution margins as in part (1) with all revisions included.
Product Line
Sales Volume
Price
Variable Cost
Contribution
Margin/Unit
Ratio
Comp. Paper
35,000
$14.00
$7.00
$7.00
50%
Napkins
120,000
$ 7.00
$4.50
$2.50
36%
Place Mats
45,000
$12.00
$4.00
$8.00
67%
Poster Board
80,000
$ 8.50
$2.50
$6.00
71%
Total
280,000

Sales Proportions
CM/Product
Weighed CM
Computer Paper
13% *
$7.00 =
$0.91
Napkins
44% *
$2.50 =
$1.10
Place Mats
16% *
$8.00 =
$1.28
Poster Board
29% *
$6.00 =
$1.74
Total
100%

$5.03 weighted CM

$538,000/$5.03 = $106,958 Break Even

3. For the original estimates, compute each of the following:
(a) Break-even point for the given sales mix.
Total Costs / Weighted CM
$538,000/$5.06 = 106,324 Break Even
(b) Margin of safety for the estimated sales volume.
275,000 – 106,324 =