General Admin Maintenance Housekeeping Cafeteria Emergency Room Labor and Deliver Surgery Intensive Care Radiology General Med/Opthamology Psychiatry Long-term Care Physical Therap Palliative Care Coronary Care Direct Overhead $ 753,547 $ 548,687 $ 654,853 $ Payroll dollars $ 542,568 $ 227,927 $ 456,852 $ 996,452 $ 525,458 $ 512,475 $ 624,239 $ 179,612 $ 1,024,950 $ 1,248,478 $ 359,224 $ Total Assets $ 807,052 $ 358,312 5 393,907 5 435,127 $ 703.617 $ 850,583 $ 181,217 $ Patient Days 7,452 2,816 13,082 125,132 $ 250,254 $ 237,380 $ 3,050 428,129 $ 856,258 $ 849,170 $ 5,662 Employees 11 13 5 10 415,091 $ 830,182 $ 793.965 $ 3,983 10 450,316 $ 900,632 $ 724,377 $ 358,314 $ 716,628 $ 547,952 $ 1,448 1,581 546,974 $ 1,093,948 $ 1,041,184 $ 8,715 10 9 12 104,291 $ 208,582 $ 206,694 $ 4,000 3 267,706 $ 184.130 535,412 $ 368,260 492,682 $ 268.154 716 4,795 7 5 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. General Admin Maintenance Housekeeping Cafeteria Statistic Payroll dollars Total Assets Patient Days # 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) 3. Create a table (Table 3) showing the comparison of the two allocation methods. Table 3 should be a summary table. It should have columns for total amounts allocated for each method. It should also have a column for the difference between the two methods. Rows should exist for each producing department. For Example: Table Title Direct Method Step Method Producing Dept. A $X SY Difference SY-SX Producing Dept. B $A $B $A-$B Producing Dept. L $L SM $L-$M Totals Sum Sum Sum