In: Accounting
X Company’s chief accountant has accumulated the following annual estimated production and service department cost.
Service Departments
Employee Relation. $35000
Storeroom 42000
Maintenance 48000
Production Departments
Mixing 47350
Baking 57650
To allocate service department costs to production departments the relevant cost drivers are:
Employee Relations – Number of Employees
Storeroom – Material requisitions
Maintenance – Maintenance hours
Budgeted values:
Department. No. of emp. Material requisition. maintenance hours machine hours
Employee Relation 1000 400 400
Storeroom 500 700 1800
Maintenance 2500 1000 700
Mixing 4000 3000 8000 4000
Baking 3000 1000 2000 5000
Required:
a. Use the direct method and allocate service department costs.
b. Assume production department costs are allocated to products based on machine hours, calculate the overhead rate for the production departments.
Ans 1. Direct Allocation of Service department costs | ||||||||
X Company | Service Departments | Production Departments | ||||||
Departments | Employee Relations | Store room | Maintenance | Mixing | Baking | Total | ||
a | Total Departmental costs | 35,000 | 42,000 | 48,000 | 47,350 | 57,650 | 230,000 | |
No of Employees for Allocating Employee Realtions dept cost | 4,000 | 3,000 | 7,000 | |||||
b | Employee Realtions cost allocated to Prodn Dept Employees @$5/employee ($35000/7000)= | (35,000) | 20,000 | 15,000 | ||||
No of Material Requisitions for Storeroom cost allocation | 3,000 | 1,000 | 4,000 | |||||
c | Storeroom cost allocated to Prodn. depts @$10.5 per Material reqn ($42,000/4000) | (42,000) | 31,500 | 10,500 | ||||
No of Maintenance Hrs to allocate Maintenance dept costs | 8,000 | 2,000 | 10,000 | |||||
d | Maintenance Dept costs allocated to Prodn dept @$4.8/Maintenance Hrs($48,000/10000)= | (48,000) | 38,400 | 9,600 | ||||
e | Total Costs pf Production depratments with allocated service dept costs=a+b+c+d | - | - | - | 137,250 | 92,750 | 230,000 | Ans a. |
f | Machine Hrs for allocation of Production dept costs | 4,000 | 5,000 | |||||
g | Production dept cost per Machine Hr=e/f= | $ 34.31 | $ 18.55 | Ans b. |