I having hard time understand what to do and where to start?

The budgeted data:

Basic hospital has twelve producing departments and four supporting departments. The budgeted data here pertain to these sixteen departments, and the allocation statistics table below identifies the allocation bases used to distribute the costs of each supporting department. ALLOCATION STATISTICS TABLE Dept. Statistic General Admin Payroll dollars Total Assets Maintenance 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) 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 |$X Producing Dept. A Producing Dept. B Direct Method Step Method Difference | $ Y $Y - $X $A $ B $A - $B Producing Dept. L $L $M $ L - $M Totals Sum Sum Sum 4. If the hospital is currently using the direct method, do you think (based on the differences you see) that they should switch to the sequential method? Write up your recommendation to the management of Basic Hospital in 250 words or less. 5. Combine Table 1, Table 2, Table 3, and your recommendation into a single PDF and upload the PDF to complete the assignment. Be sure to reference the grading rubric and thoroughly review your work prior to submission. A B 1 2 3 D E F G H . I J K L M N O Q R General Admin Maintenance Housekeeping Cafeteria Emergency Room Labor and Delivery Surgery Intensive Care Radiology General Med/S Opthamology Psychiatry Long-term Care Physical Therap Palliative Care Coronary Care $ 753,547 $ 548,687 $ 654,853 $ 996,452 $ 512,475 $ 624,239 $ 179,612 $ 125,132 $ 428,129 $ 415,091 $ 450,316 $ 358,314 $ 546,974 $ 104,291 $ 267,706 $ 184,130 $ 542,568 $ 227,927 $ 456,852 $ 525,458 $ 1,024,950 $ 1,248,478 $ 359,224 $ 250,264 $ 856,258 $ 830,182 $ 900,632 $ 716,628 $ 1,093,948 $ 208,582 $ 535,412 $ 368,260 $ 807,052 $ 398,312 $ 393,907 $ 435,127 $ 703,617 $ 850,583 $ 181,217 $ 237,380 $ 849,170 $ 793,965 $ 724,377 $ 547,952 $ 1,041,184 $ 206,694 $ 492,682 $ 268,154 7,452 2,816 13,082 3,050 5,662 3,983 1,448 1,581 8,715 4,000 716 4,795 5 3 8 9 11 13 5 4 10 10 10 9 12 3 7 5 Direct Overhead Payroll dollars Total Assets Patient Days Employees 4 5 6 7 7 8 Basic hospital has twelve producing departments and four supporting departments. The budgeted data here pertain to these sixteen departments, and the allocation statistics table below identifies the allocation bases used to distribute the costs of each supporting department. ALLOCATION STATISTICS TABLE Dept. Statistic General Admin Payroll dollars Total Assets Maintenance 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) 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 |$X Producing Dept. A Producing Dept. B Direct Method Step Method Difference | $ Y $Y - $X $A $ B $A - $B Producing Dept. L $L $M $ L - $M Totals Sum Sum Sum 4. If the hospital is currently using the direct method, do you think (based on the differences you see) that they should switch to the sequential method? Write up your recommendation to the management of Basic Hospital in 250 words or less. 5. Combine Table 1, Table 2, Table 3, and your recommendation into a single PDF and upload the PDF to complete the assignment. Be sure to reference the grading rubric and thoroughly review your work prior to submission. A B 1 2 3 D E F G H . I J K L M N O Q R General Admin Maintenance Housekeeping Cafeteria Emergency Room Labor and Delivery Surgery Intensive Care Radiology General Med/S Opthamology Psychiatry Long-term Care Physical Therap Palliative Care Coronary Care $ 753,547 $ 548,687 $ 654,853 $ 996,452 $ 512,475 $ 624,239 $ 179,612 $ 125,132 $ 428,129 $ 415,091 $ 450,316 $ 358,314 $ 546,974 $ 104,291 $ 267,706 $ 184,130 $ 542,568 $ 227,927 $ 456,852 $ 525,458 $ 1,024,950 $ 1,248,478 $ 359,224 $ 250,264 $ 856,258 $ 830,182 $ 900,632 $ 716,628 $ 1,093,948 $ 208,582 $ 535,412 $ 368,260 $ 807,052 $ 398,312 $ 393,907 $ 435,127 $ 703,617 $ 850,583 $ 181,217 $ 237,380 $ 849,170 $ 793,965 $ 724,377 $ 547,952 $ 1,041,184 $ 206,694 $ 492,682 $ 268,154 7,452 2,816 13,082 3,050 5,662 3,983 1,448 1,581 8,715 4,000 716 4,795 5 3 8 9 11 13 5 4 10 10 10 9 12 3 7 5 Direct Overhead Payroll dollars Total Assets Patient Days Employees 4 5 6 7 7 8