In: Accounting
Abbott Lamp Corporation manufactures Mountain Dew Lamps. Abbott Lamp Corporation has the following historical cost behavior data:
Year |
Total Direct Labor Hours |
Total Utilities |
Total Indirct Labor |
Total Indirct Materials |
Total Mixed OH costs |
2014 |
100 |
$125 |
$400 |
$175 |
$700 |
2015 |
150 |
$175 |
$550 |
$225 |
$950 |
2016 |
200 |
$225 |
$700 |
$275 |
$1,200 |
2017 |
350 |
$375 |
$1,150 |
$425 |
$1,950 |
Other 2018 estimated information is as follows:
Rent on production facility $100
Factory supervisor salary $100
Depreciation on factory equipment $200
Rent on corporate headquarters $300
Corporate HQ salaries $1,000
Total $1,700
Abbott Lamp also estimates the following with regard to direct materials and direct labor:
Direct Materials:
1 mountain can/mountain dew lamp @ $2/mountain dew can;
.25 pieces of paper/mountain dew lamp @$4/piece of paper;
Direct Labor
.2 dlh/mountain dew lamp @ $10/dlh
Variable predetermined overhead rate: ($1950-$700)/(350dlh-100dlh) | |||||||
$1250/250=$5.00dlh | |||||||
$1950-($5.00dlh)*(350dlh) | |||||||
$1950-$1750= $200 | |||||||
Now, this predicts that for every dlh we incur, utilities will increase by $5.00. |
Total Direct Labor Hours | Total Mixed OH Costs | |
High activity level | 350 | $ 1,950 |
Low activity level | 100 | $ 700 |
Change | 250 | $ 1,250 |
Variable cost per unit = $1250/250 = $5
Fixed cost (at high level) = $1950 - (350 x $5) = $1950 - $1750 = $200
Fixed cost (at low level) = $700 - (100 x $5) = $700 - $500 = $200
Variable predetermined overhead rate: $5 per direct labor hour
Fixed overhead | 200 |
Rent on production facility | 100 |
Factory supervisor salary | 100 |
Depreciation on factory equipment | 200 |
Rent on corporate headquarters | 300 |
Corporate HQ salaries | 1000 |
Total fixed costs $ | 1900 |
y-intercept: $1900
The y-intercept means the total fixed costs.
Break-even point (units) = Fixed costs/Contribution per unit
Sales price per unit | 20 | |
Variable costs: | ||
Direct materials | ||
1 mountain can | 2 | |
0.25 pieces of paper (0.25 x $4) | 1 | |
Direct labor (0.2 x $10) | 2 | |
Variable overhead (0.2 x $5) | 1 | |
Total variable costs | 6 | |
Contribution margin per unit $ | 14 |
Break-even point = $1900/$14 = 135.71 = 136 lamps