In: Accounting
Department: Budget Costs:
(S1) Human resources $80,000
(S2) Plant security $56,000
(S3) Maintenance $63,000
Department: Direct overhead:
(P1) Fabricating $280,000
(P2) Finishing $340,000
Rose allocates support department costs using the following activity drivers: Human Resources (number of employees), Plant Security (direct labor hours), and Maintenance (machine hours). Assume a service department does not provide services to itself. Budgeted 2020 support department driver consumption (by department) is as follows:
Driver: (S1) (S2) (S3) (P1) (P2) total
Number of employees= 0 20 20 90 70 200
direct labor hours= 400 0 1,200 3,200 3,200 8,000
Machine hours= 0 102 0 612 306 1,020
Use the direct method to calculate the total overhead for each production department. Round to 4 decimal places (e.g. $1.0000).
Allocation base | |||||
Cost driver base | Total cost | Fabricating | Finishing | Total | Cost per cost driver |
No. of employees for HR | $ 80,000 | 70 | 200 | 270 | $ 296.2963 |
Direct labor hours for plant security | $ 56,000 | 3200 | 8000 | 11200 | $ 5 |
Machine hours for maintenance | $ 63,000 | 306 | 1020 | 1326 | $ 47.5113 |
Department | ||
Particulars | Fabricating | Finishing |
Allocation of HR cost of $80,000 | $ 20,740.7410 | $ 59,259.2600 |
Allocation of Plant security cost of $56,000 | $ 16,000 | $ 40,000 |
Allocation of HR cost of $63,000 | $ 14,538.4578 | $ 48,461.5260 |
For any clarification, please comment. Kindly Up Vote!