Support department cost allocation$-$reciprocal services method

Temple Lights, Inc. produces Hanukkah menorahs in its Cutting and Molding departments. The Maintenance and Security departments support the production of the menorahs. Costs from the Maintenance Department are allocated based on machine hours, and costs from the Security Department are allocated based on asset value. Information about each department is provided in the following table:

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Open spreadsheet

Determine the total cost of each production department after allocating all support department costs to the production departments using the reciprocal services method.