In: Accounting
Sawaya Co., Ltd., of Japan is a manufacturing company whose total factory overhead costs 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 given below: Level of Activity Low High Direct labor-hours 45,600 60,800 Total factory overhead costs $ 234,300 $ 257,100 The factory overhead costs above consist of indirect materials, rent, and maintenance. The company has analyzed these costs at the 45,600-hour level of activity as follows: Indirect materials (variable) $ 59,280 Rent (fixed) 139,000 Maintenance (mixed) 36,020 Total factory overhead costs $ 234,300 To have data available for planning, the company wants to break down the maintenance cost into its variable and fixed cost elements. Required:
1. Estimate how much of the $257,100 factory overhead cost at the high level of activity consists of maintenance cost. (Hint: To do this, it may be helpful to first determine how much of the $257,100 consists of indirect materials and rent. 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 intermediate calculations. Round "Variable cost element" to 2 decimal places.)
3. What total factory overhead costs would you expect the company to incur at an operating level of 50,160 direct labor-hours? (Do not round intermediate calculations.)
| Indirect material per DLH: | ||||||
| Total Indirest material | 59280 | |||||
| Divide: Total DLH | 45600 | |||||
| Indirect material per DLH: | 1.3 | |||||
| Req 1. | ||||||
| Miantennance cost: | ||||||
| Total OH at 60800 DLH activity | 257100 | |||||
| Less: Indirect material (60800 DLH @1.30) | 79040 | |||||
| Less: Rent expense | 139000 | |||||
| Maintenance expense | 39060 | |||||
| Req 2. | ||||||
| Maintenance | DLH | |||||
| Cost | ||||||
| High activity | 39060 | 60800 | ||||
| Low activity | 36020 | 45600 | ||||
| Change | 3040 | 15200 | ||||
| Maintenance variable cost per DLH = Change in cost / Change in DLH | ||||||
| 3040 /15200 = 0.20 per DLH | ||||||
| Total Maintenance cost at 60800 DLh | 39060 | |||||
| Less: Variable cost (60800*0.20) | 12160 | |||||
| Fixed Maintenance cost | 26900 | |||||
| Maintenance cost function, C (X) = 26900+0.20X | ||||||
| Req 3. | ||||||
| Total Overheads at 50160 DLH: | ||||||
| Indirect material (50160*1.30) | 65208 | |||||
| Rent expense | 139000 | |||||
| Maintenance Cost (26900+0.20*50160) | 36932 | |||||
| Total Overheads at 50160 DLH: | 241140 | |||||