In: Accounting
Glover Company makes three products in a single facility with the following information:
A |
B |
C |
|
Selling Price per unit |
$85.00 |
$97.00 |
$91.00 |
Direct Materials |
16.00 |
11.00 |
14.00 |
Direct Labor |
19.00 |
17.00 |
20.00 |
Variable Manufacturing |
3.0 |
2.5 |
4.0 |
Fixed Manufacturing |
22.00 |
24.00 |
30.00 |
Variable Selling Cost |
3.00 |
2.50 |
1.90 |
Mixing Minutes / Unit |
4.0 |
2.5 |
3.0 |
Monthly demand (units) |
1,500 |
2,000 |
500 |
**The company only has 10,500 minutes available per month to mix these products**
Calculate the contribution margin per unit
How much of each of these products should be produced to maximized net operating income, and what would the total contribution margin equal?
A | B | C | ||
Sales | A | 85.00 | 97.00 | 91.00 |
Variable costs | ||||
Direct materials | 16.00 | 11.00 | 14.00 | |
Direct Labor | 19.00 | 17.00 | 20.00 | |
Variable Manufacturing | 3.00 | 2.50 | 4.00 | |
Variable selling costs | 3.00 | 2.50 | 1.90 | |
Total Variable cost | B | 41.00 | 33.00 | 39.90 |
Contribution Margin per unit | C=A-B | 44.00 | 64.00 | 51.10 |
Mixing minutes per unit | D | 4.00 | 2.50 | 3.00 |
Contribution Margin per minute | E=C/D | 11.00 | 25.60 | 17.03 |
Ranking | III | I | II | |
(based on Contribution Margin per minute) | ||||
Monthly Demand (Units) | F | 1,500 | 2,000 | 500 |
Hours Required | G=FXD | 6,000 | 5,000 | 1,500 |
Hours allocated based on ranking | H | 4,000 | 5,000 | 1,500 |
Maximum available minutes per month is 10500 minutes | ||||
Units to be production to maximise net operating income | I =H/D | 1,000 | 2,000 | 500 |
Comtribution | J =I X C | 44,000 | 128,000 | 25,550 |
Total Contribution Margin | 197,550 |