In: Accounting
Calculating and Using Dual Charging Rates The expected costs for the Maintenance Department of Stazler, Inc., for the coming year include: Fixed costs (salaries, tools): $72,960 per year Variable costs (supplies): $1.4 per maintenance hour The Assembly and Packaging departments expect to use maintenance hours relatively evenly throughout the year. The Fabricating Department typically uses more maintenance hours in the month of November. Estimated usage in hours for the year and for the peak month is as follows: Yearly hours Monthly Peak Hours Assembly Department 4,900 270 Fabricating Department 6,900 1,485 Packaging Department 11,000 945 Total maintenance hours 22,800 2,700 Actual usage for the year by: Assembly Department 3,250 Fabricating Department 7,000 Packaging Department 10,200 Total maintenance hours 20,450 Required: 1. Calculate a variable rate for the Maintenance Department. Round your answer to the nearest cent. $ per maintenance hour Calculate the allocated fixed cost for each using department based on its budgeted peak month usage in maintenance hours. Round your answers to the nearest dollar. Department Peak Number of Hours Allocated Fixed Cost Assembly $ Fabricating Packaging Total $ 2. Use the two rates to assign the costs of the Maintenance Department to the user departments based on actual usage. Calculate the total amount charged for maintenance for the year. Round your answers to the nearest dollar. Assembly $ Fabricating Packaging Total $ 3. What if the Assembly Department used 3,300 maintenance hours in the year? How much would have been charged out to the three departments? Round your answers to the nearest dollar. Assembly $ Fabricating Packaging Total $
1 | Variable rate for the maintenance department=Variable cost (supplies)=$1.4 per maintenance hour | |||||||||
Allocation of fixed cost: | ||||||||||
Department | Peak hours |
Percentage of total peak hours |
Budgeted Fixed cost |
Allocated Fixed cost |
||||||
Assembly | 270 | 10% | 72960 | 7296 | ||||||
Fabricating | 1485 | 55% | 72960 | 40128 | ||||||
Packaging | 945 | 35% | 72960 | 25536 | ||||||
Total | 2700 | 72960 | ||||||||
2 | Department | Actual Hours | Variable rate | Variable cost |
Allocated Fixed cost |
Total | ||||
Assembly | 3250 | 1.40 | 4550 | 7296 | 11846 | |||||
Fabricating | 7000 | 1.40 | 9800 | 40128 | 49928 | |||||
Packaging | 10200 | 1.40 | 14280 | 25536 | 39816 | |||||
Total | 20450 | 72960 | 101590 | |||||||
Total amount charged=$ 101590 | ||||||||||
3 | If 3300 hours used in Assembly, | |||||||||
Department | Actual Hours | Variable rate | Variable cost |
Allocated Fixed cost |
Total | |||||
Assembly | 3300 | 1.40 | 4620 | 7296 | 11916 | |||||
Fabricating | 7000 | 1.40 | 9800 | 40128 | 49928 | |||||
Packaging | 10200 | 1.40 | 14280 | 25536 | 39816 | |||||
Total | 20500 | 72960 | 101660 | |||||||
Total amount charged=$ 101660 | ||||||||||