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
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
1. A. Estimate the VARIABLE predetermined overhead rate using the high-low method. Using the high-low method, what does the y-intercept ‘mean’ in this case?
B. Using your answer from 1 above (using BOTH the VPDOH and the y-intercept), compute the breakeven point in terms of total # of mountain dew lamps that need to be sold to break even. Assume that the price per Mountain Dew Lamp is $20/mountain dew lamp and that capacity is NOT an issue.
C. Calculate the # of mountain dew lamps that must be sold in order to achieve a goal operating income of $10,000 (and still use your answer from part 1 above);
A. Variable predetermined overhead rate: $5 per direct labor hour
Working:
| 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
| 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.
B. 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
C. Number of lamps to be sold = (Fixed costs + Desired profit)/Contribution margin per unit = ($1900 + $10000)/$14 = $11900/$14 = 850 lamps