O’Brian’s Department Stores allocates the costs of the Personnel and Payroll departments to three retail sales departments, Housewares, Clothing and Furniture. In addition to providing services to the operating departments, Personnel and Payroll provide services to each other. O’Brian’s allocates Personnel Department cost on the basis of the number of employees and Payroll Department costs on the basis of gross payroll. Cost and allocation for June is as follows:
Personnel Payroll Housewares Clothing Furniture
Direct dept. cost $6900 $3200 $12200 $20000 $15750
Number of employees 5 3 8 15 4
Gross payroll $6000 $3300 $11200 $17400 $8100
1. Determine the percentage of total Personnel Department services that was provided to the Payroll Department.
2. Determine the percentage of total Payroll Department services that was provided to the Personnel Department.
3. Prepare a schedule showing Personnel Department and Payroll Department cost allocations to the operating departments, assuming O’Brian’s uses the step method. (round calculations to nearest dollar.