Chapter 4 Q3

Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for all departments in the hospital for the forthcoming quarter are presented in the table below:

	Service Departments									Operating Departments
	Housekeeping Services			Food Services			Administrative Services			Laboratory			Radiology			General Hospital			Total
Variable costs	$	0		$	210,860		$	175,840		$	269,100		$	338,800		$	83,000		$	1,077,600
Fixed costs		104,000			124,200			107,180			179,300			249,700			452,300			1,216,680
Total cost	$	104,000		$	335,060		$	283,020		$	448,400		$	588,500		$	535,300		$	2,294,280
Meals served								2,500			5,400			2,700			78,200			88,800
Percentage of peak-period needsFood Services								2.50	%		4.10	%		3.30	%		90.10	%		100	%
Square feet of space		6,700			18,100			9,900			15,100			9,200			125,000			184,000
Files processed											22,500			15,500			42,000			80,000
Percentage of peak-period needsAdministrative Services											40	%		30	%		30	%		100	%

The costs of the service departments are allocated by the step-down method using the allocation bases and in the order shown in the following table:

Service Department	Costs Incurred	Allocation Bases
Housekeeping Services	Fixed	Square feet of space
Food Services	Variable	Meals served
	Fixed	Peak-period needsFood Services
Administrative Services	Variable	Files processed
	Fixed	Peak-period needsAdministrative Services

All billing in the hospital is done through Laboratory, Radiology, or General Hospital. The hospitals administrator wants the costs of the three service departments allocated to these three billing centers.

Required:

Using the step-down method, prepare the cost allocation desired by the hospital administrator. Include under each billing center the direct costs of the center, as well as the costs allocated from the service departments. (Please enter allocations from a department as negative and allocations to a department as positive. The line should add across to zero. Do not round intermediate calculations. Round your answers to the nearest dollar amount.)

	Housekeeping Services	Food Services	Administrative Services		Laboratory	Radiology	General Hospital
Variable costs
Food services allocation
Administrative services allocation
Total variable costs	$0	$0	$0		$0	$0	$0
Fixed costs
Housekeeping services allocation
Food services allocation
Administrative services allocation
Total fixed costs	$0	$0	$0		$0	$0	$0
Total overhead costs	$0	$0	$0		$0	$0	$0