In: Accounting
Nova Company’s total overhead cost at various levels of activity are presented below:
Month | Machine- Hours |
Total Overhead Cost |
||
April | 49,000 | $ | 205,220 | |
May | 39,000 | $ | 179,420 | |
June | 59,000 | $ | 231,020 | |
July | 69,000 | $ | 256,820 | |
Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 39,000 machine-hour level of activity is:
Utilities (variable) | $ | 58,500 | ||
Supervisory salaries (fixed) | 64,000 | |||
Maintenance (mixed) | 56,920 | |||
Total overhead cost | $ | 179,420 | ||
Nova Company’s management wants to break down the maintenance cost into its variable and fixed cost elements.
Required:
1. Estimate how much of the $256,820 of overhead cost in July was maintenance cost. (Hint: To do this, it may be helpful to first determine how much of the $256,820 consisted of utilities and supervisory salaries. Think about the behavior of variable and fixed costs!) (Do not round intermediate calculations.)
2. Using the high-low method, estimate a cost formula for maintenance. (Do not round your intermediate calculations. Round the "Variable cost per machine-hours" to 2 decimal places.)
Machine Hours | Maintenance Cost | |
High activity level | ||
Low activity level | ||
Change | $ | |
Variable cost element | per mH | |
Fixed cost element |
Y= a + bX
3. Express the company’s total overhead cost in the linear equation form Y = a + bX. (Do not round your intermediate calculations. Round the "Variable cost per machine-hours" to 2 decimal places.)
Variable cost per | ||
Machine-Hour | Fixed Cost | |
Utilities cost | ||
Supervisory salaries cost | ||
Maintenance cost | ||
Total overhead cost | $ | $ |
y= a +bX
4. What total overhead cost would you expect to be incurred at an activity level of 44,000 machine-hours? (Do not round intermediate calculations.)
1) | Utilities | (58500/39000)*69000= | 103500 | ||||
Supervisory Salaries | 64,000 | ||||||
Maintenance (balancing figure) | 89,320 | ||||||
Total overhead cost | 256,820 | ||||||
2) | Estimating formula for maintenance cot | ||||||
MH's | cost | ||||||
high | 69,000 | 89,320 | |||||
low | -39,000 | -56,920 | |||||
Difference | 30,000 | 32,400 | |||||
Variable cost per unit = 32400/30000 | |||||||
1.08 | |||||||
Fixed cost = 89320 - 69000*1.08 | |||||||
14800 | |||||||
Cost formula | |||||||
Y= | 14,800 | + | 1.08 | X | |||
3) | Companys total overhead cost | ||||||
Variable | Fixed | ||||||
Utilities | 1.5 | ||||||
Supervisory salaries | 64,000 | ||||||
Maintenance cost | 1.08 | 14,800 | |||||
total | 2.58 | 78800 | |||||
cost formula | |||||||
Y= | 78,800 | + | 2.58 | X | |||
4) | total overhead cost | ||||||
Y= | 78,800 | + | 2.58 | X | |||
so | |||||||
fixed cost | 78,800 | ||||||
Variable cost (44000*2.58) | 113520 | ||||||
total overhead cost | 192,320 | answer | |||||