Data Performance, a computer software consulting company, hasthree major functional areas: computer programming, informationsystems consulting, and software training. Carol Bingham, a pricinganalyst, has been asked to develop total costs for the functionalareas. These costs will be used as a guide in pricing a newcontract. In computing these costs, Carol is considering threedifferent methods of the departmental allocation approach toallocate overhead costs: the direct method, the step method, andthe reciprocal method. She assembled the following data from thetwo service departments, information systems and facilities:
(Round percentage calculations to 4 decimal places(e.g., 33.3333%). For all requirements, Do not round yourintermediate calculations. Round your final answers to nearestwhole dollar amount.)
| Service Departments Production Departments |
| Information Systems | Facilities | Computer Programming | Information System Consulting | Software Training | Total |
| Budgeted overhead (base) | $90,000 | $32,000 | $170,000 | $193,000 | $134,000 | $619,000 |
| Information System (computer hours) | | 1,000 | 500 | 1,000 | 2,500 | 5,000 |
| Facilities (square feet) | 200 | | 600 | 600 | 600 | 2,000 |
Required:
1. Using computer usage time as the allocation base for theinformation systems department and square feet of floor space asthe application base for the facilities department, apply overheadfrom these service departments to the production departments, usingthese three methods:
a. Direct method.
b. Step method (both for the information systems departmentgoing first and for the facilities department going first).
c. Reciprocal method.
This is how the answer is supposed to be set up:
| | Programming | Consulting | Training | Total |
| a. | Direct Method | ? | ? | ? | ? |
| b (1) | Step method (information systems goes first) | ? | ? | ? | ? |
| b (2) | Step method (facilities goes first) | ? | ? | ? | ? |
| c. | Reciprocal method | ? | ? | ? | ? |
