Producing Departments
Emergency Room	Labor and Delivery	Surgery	Intensive Care Unit	Radiology	General Med/Surg	Opthamology	Psychiatry	Long-term Care
$ 512,475	$ 624,239	$179,612	$ 125,132	$ 428,129	$ 415,091	$ 450,316	$ 358,314	$ 546,974
$ 1,024,950	$ 1,248,478	$359,224	$ 250,264	$ 856,258	$ 830,182	$ 900,632	$ 716,628	$ 1,093,948
$ 703,617	$ 850,583	$181,217	$ 237,380	$ 849,170	$ 793,965	$ 724,377	$ 547,952	$ 1,041,184
7,452	2,816	13,082	3,050	5,662	3,983	1,448	1,581	8,715
11	13	5	4	10	10	10	9	12
Supporting Departments							Supporting Departments
	General Admin	Maintenance	Housekeeping	Cafeteria			Dept	Basis of Allocation
Direct Overhead	$ 753,547	$548,687	$ 654,853	$ 996,452			General Admin	Payroll Dollars
Payroll dollars	$ 542,568	$227,927	$ 456,852	$ 525,458			Maintenance	Total Assets
Total Assets	$ 807,052	$398,312	$ 393,907	$ 435,127			Housekeeping	Patient Days
Patient Days	-	-	-	-			Cafeteria	# of employees
Employees	5	3	8	9

Basic hospital has twelve producing departments and four supporting departments. The budgeted data here pertain to these sixteen departments, and the allocation statistics tabl below identifies the allocation bases used to distribute the costs of each supporting department. ALLOCATION STATISTICS TABLE Dept. Statistic General Admin Payroll dollars Maintenance Total Assets Housekeeping Patient Days Cafeteria # of employees Step method support department rankings are based on the proportion of the department's statistic that is used up by other support departments. Required: 1. Create a table (Table 1) showing the allocation of supporting departments to producing departments using the direct method. See example 7.3 from the textbook for guidance on preparing the allocation schedule. 2. Create a table (Table 2) showing the allocation of supporting departments to producing departments using the sequential method. (See example 7.4 for guidance) Basic hospital has twelve producing departments and four supporting departments. The budgeted data here pertain to these sixteen departments, and the allocation statistics tabl below identifies the allocation bases used to distribute the costs of each supporting department. ALLOCATION STATISTICS TABLE Dept. Statistic General Admin Payroll dollars Maintenance Total Assets Housekeeping Patient Days Cafeteria # of employees Step method support department rankings are based on the proportion of the department's statistic that is used up by other support departments. Required: 1. Create a table (Table 1) showing the allocation of supporting departments to producing departments using the direct method. See example 7.3 from the textbook for guidance on preparing the allocation schedule. 2. Create a table (Table 2) showing the allocation of supporting departments to producing departments using the sequential method. (See example 7.4 for guidance)