3 Data Master is a computer software consulting company. Its three major functional areas are computer...

Transcribed Image Text:

3 Data Master is a computer software consulting company. Its three major functional areas are computer programming, information systems consulting, and software training. Cynthia Moore, a pricing analyst in the Accounting Department, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Moore is considering three different methods of allocating overhead costs-the direct method, the step method, and the reciprocal method. Moore assembled the following data on overhead from its two service departments, the Information Systems Department and the Facilities Department. eBook Service Departments User Departments Info Systems Computer Facilities Program Consult $ 50,000 $ 25,000 400 $75,000 1,100 400,000 600 600,000 Training Total $110,000 $ 85,000 $ 345,000 900 3,000 800,000 2,000,000 Budgeted Overhead Info Systems (hours) Facilities (Square feet) 200,000 Information systems are allocated on the basis of hours of computer usage; facilities are allocated on the basis of floor space. Required: Allocate the service department costs to the user departments using the step method. Allocate Information Systems first and round to the nearest whole dollar. Provide total user department costs. 3 Data Master is a computer software consulting company. Its three major functional areas are computer programming, information systems consulting, and software training. Cynthia Moore, a pricing analyst in the Accounting Department, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Moore is considering three different methods of allocating overhead costs-the direct method, the step method, and the reciprocal method. Moore assembled the following data on overhead from its two service departments, the Information Systems Department and the Facilities Department. eBook Service Departments User Departments Info Systems Computer Facilities Program Consult $ 50,000 $ 25,000 400 $75,000 1,100 400,000 600 600,000 Training Total $110,000 $ 85,000 $ 345,000 900 3,000 800,000 2,000,000 Budgeted Overhead Info Systems (hours) Facilities (Square feet) 200,000 Information systems are allocated on the basis of hours of computer usage; facilities are allocated on the basis of floor space. Required: Allocate the service department costs to the user departments using the step method. Allocate Information Systems first and round to the nearest whole dollar. Provide total user department costs.