In: Accounting
A Manufacturing Company Whose Total Factory Overhead Cost Fluctuate Considerably From Year ... Question: A manufacturing company whose total factory overhead cost fluctuate considerably from year to yea... A manufacturing company whose total factory overhead cost fluctuate considerably from year to year according to increases and decreases in the number of direct labor-hours worked in the factory. Total factory overhead costs at high and low levels of activity for recent years are Low: 52800, High: 70,400, Total factory overhead cost $279,380 Low, and $316,340 High. The factory overhead costs above consist of indirect materials, rent, and maintenance. The company has analyzed these costs at the 52,800-hour level of activity as: indirect materials (variable) $89,760, rent (fixed) 138,000, maintenance (mixed) 51,620, total factory overhead cost: $279,380. Estimate how much of the $316,340 factory overhead cost at the high level of activity consist of maintenance cost. First determine how much of $316,340 consist of indirect materials and rent. Maintenance cost at high level of activity is Using the high-low method estimate a cost formula for maintenance (round the variable cost per DLH to 2 decimal places) High level of activity, low level of activity, change, variable cost element fixed cost element Y=------+--------x What total factory overhead cost would you expect the company to incur at an operating level of 58,080 direct labor-hours?
| Variable | Fixed | Mixed | |||||
| Activity level(hour) | Factory overhead | Indirect Materials | Rent | Maintenance | |||
| 52800 | $279,380 | $89,760 | $138,000 | $51,620 | |||
| 70400 | $316,340 | ||||||
| Indirect material at 70400 hours | $ 119,680 | (89760/52800)*70400) | |||||
| Rent at 70400 hours level | $138,000 | ||||||
| Maintenance cost at70400 level | $58,660 | (316340-119680-138000) | |||||
| Total Factory overhead at 70400 | $ 316,340 | ||||||
| Maintenance cost at high level | $58,660 | ||||||
| Maintenance cost at low level | $51,620 | ||||||
| Y=a+bX | |||||||
| Y2=High Level | |||||||
| Y1=Low level | |||||||
| Y2=a+bX2 | |||||||
| Y1=a+bX1 | |||||||
| (Y2-Y1)=b(X2-X1) | |||||||
| b=(Y2-Y1)/(X2-X1) | |||||||
| In this case, | |||||||
| b=(Y2-Y1)/(X2-X1) | |||||||
| b=(58660-51620)/(70400-52800) | |||||||
| b= | 0.40 | ||||||
| Y2=a+bX2 | |||||||
| 58660=a+0.4*70400 | |||||||
| a=58660-(0.4*70400) | 30500 | ||||||
| The Required Formula for Maintenance cost: | |||||||
| Y=30500+0.4X | |||||||
| Y=Maintenance cost | |||||||
| X=activity level | |||||||
| At operating level58080 hours; | |||||||
| Maintenance cost=30500+0.4*58080 | $ 53,732 | ||||||
| Variable indirect material | $ 98,736 | (89760/52800)*58080 | |||||
| Rent | $138,000 | ||||||
| Total factory overhead cost | $ 290,468 | ||||||