Using the reciprocal method spreadsheet (shown in Exhibit), show the costs allocated to production for Steamco Corporation. Use the data in Problem 11-49.
In Problem 11-49, Steamco Corporation is reviewing its operations to see what additional energy-saving projects it might adopt. The company's manufacturing plant generates its own electricity using a process capturing steam from its production processes. A summary of the use of service departments by other service departments as well as by the two producing departments at the plant follows:

Direct costs (in thousands) in the various departments follow:
Department Direct costs
Steam Generation (S1) . . . . . . . . . . . . . . . . . . . . . . . . . . . $ 210
Electric Generating:
Fixed costs (S2) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90
Variable costs (S3) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240
Equipment Maintenance (S4) . . . . . . . . . . . . . . . . . . . . . . 144
Production
Alpha (P1). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,800
Beta (P2) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,320
Steamco currently allocates costs of service departments to production departments using the step method. The local power company indicates that it would charge $480,000 per year for the electricity that Steamco now generates internally. Management rejected switching to the power company on the grounds that its rates would cost more than the $330,000 ($90,000 + $240,000) cost of the present, company-owned,system.

Services Used by Steam Fixed Variable Equipment Service DepartmentGeneration Costs Costs Maintenance Alpha Beta -00.10 0.50 -0-00.40 Electric Generating Fixed costs Variable costs 0.10 0.30 0.50 0.05 0.55 0.30 -00.50 0.15 . . . 0.10 0 Equipment Maintenance 0.20 0.10 0.05