In: Accounting
Exercise 11-33 Cost Allocation: Reciprocal Method (LO 11-4)
University Printers has two service departments (Maintenance and Personnel) and two operating departments (Printing and Developing). Management has decided to allocate maintenance costs on the basis of machine-hours in each department and personnel costs on the basis of labor-hours worked by the employees in each.
The following data appear in the company records for the current period:
| Maintenance | Personnel | Printing | Developing | |||||||||
| Machine-hours | ? | 455 | 455 | 2,590 | ||||||||
| Labor-hours | 315 | ? | 294 | 1,491 | ||||||||
| Department direct costs | $ | 11,000 | $ | 23,000 | $ | 25,000 | $ | 23,000 | ||||
Required:
Allocate the service department costs using the reciprocal method. (Matrix algebra is not required because there are only two service departments.) (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations.)
| The key to using the reciprocal method is to keep reallocating the two service department (maintenance and personnel) costs until the service departments reach a zero balance. | ||||
| Machine hour percentages--Allocation of Maintenance Costs | ||||
| 455 + 455 + 2,590 = 3,500 total machine hrs | ||||
| Personnel | ||||
| 455 / 3,500 = 13% | ||||
| Printing | ||||
| 455 / 3,500 = 13% | ||||
| Developing | ||||
| 2,590 / 3,500 = 74% | ||||
| Labor hr. percentages--Allocation of Personnel costs | ||||
| 315 + 294 + 1,491 = 2,100 total labor hrs. | ||||
| Maintenance | ||||
| 315 / 2,100 = 15% | ||||
| Printing | ||||
| 294 / 2,100 = 14% | ||||
| Developing | ||||
| 1,491 / 2,100 = 71% | ||||
| Service | ||||
| Maintenance | Personnel | Printing | Developing | |
| Costs before allocation | 11000 | 23000 | 25000 | 23000 |
| Allocate maintenance costs | -11000 | 1430 | 1430 | 8140 |
| (11000X13%) | (11000X13%) | (11000X74%) | ||
| 0 | 24430 | |||
| Allocate personnel costs | 3664.5 | -24430 | 3420.2 | 17345.3 |
| (24430X15%) | (24430X14%) | (24430X71%) | ||
| Allocate maintenance costs | -3664.5 | 476.39 | 476.39 | 2711.73 |
| (3664.5X13%) | (3664.5X13%) | (3664.5X74%) | ||
| Allocate personnel costs | 71.46 | -476.39 | 66.69 | 338.24 |
| (476.39X15%) | (476.39X14%) | (476.39X71%) | ||
| Allocate maintenance costs | -71.46 | 9.29 | 9.29 | 52.88 |
| (71.46X13%) | (71.46X13%) | (71.46X74%) | ||
| Allocate personnel costs | 1.39 | -9.29 | 1.3006 | 6.5959 |
| (9.29X15%) | (9.29X14%) | (9.29X71%) | ||
| Allocate maintenance costs | -1.39 | 0 | 0 | 1.39 |
| Total costs | 0.00 | 0.00 | 30403.87 | 51596.13 |