Basic hospital has twelve producing departments and four supporting departments. The budgeted data bers \pm pertain to these sixteen departments, and the allocation statistics table below identifies the allocatich buses used to distribute the costs of each supporting department. "Step method support deportment rankings are baved on the proportion of the total poroll dollars, where the support departinent with the most parroll dallars is ranked of. Required 1. Create a table (Table 1) showing the alocation of supporting departments to producing departments using the direct thethod. See example 7.3 from the textbook for guidance on prepuring 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 coemparison of the fwo slocation methods. Table 3 should be a summary table, It should huve columns for total amounts allocated for each method. It should also have a column for the difference between the two methods. Fows should exist for each producing departinent. For Example: 4. If the hospital is currently using the direct method, do you thins (based on the dfferences you see) that ther should switch to the sequeotial method? Write up your recommendation to the management of Back Hospital in 250 words or less. 5. Combine Table 1. Table 2. Table 3, and your recommendation into a single POF and upload the PDF to complete the assenment, Be sure to reference the srading rubric and thorouthly review your wark priar to submision. Basic hospital has twelve producing departments and four supporting departments. The budgeted data bers \pm pertain to these sixteen departments, and the allocation statistics table below identifies the allocatich buses used to distribute the costs of each supporting department. "Step method support deportment rankings are baved on the proportion of the total poroll dollars, where the support departinent with the most parroll dallars is ranked of. Required 1. Create a table (Table 1) showing the alocation of supporting departments to producing departments using the direct thethod. See example 7.3 from the textbook for guidance on prepuring 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 coemparison of the fwo slocation methods. Table 3 should be a summary table, It should huve columns for total amounts allocated for each method. It should also have a column for the difference between the two methods. Fows should exist for each producing departinent. For Example: 4. If the hospital is currently using the direct method, do you thins (based on the dfferences you see) that ther should switch to the sequeotial method? Write up your recommendation to the management of Back Hospital in 250 words or less. 5. Combine Table 1. Table 2. Table 3, and your recommendation into a single POF and upload the PDF to complete the assenment, Be sure to reference the srading rubric and thorouthly review your wark priar to submision. Basic hospital has twelve producing departments and four supporting departments. The budgeted data bers \pm pertain to these sixteen departments, and the allocation statistics table below identifies the allocatich buses used to distribute the costs of each supporting department. "Step method support deportment rankings are baved on the proportion of the total poroll dollars, where the support departinent with the most parroll dallars is ranked of. Required 1. Create a table (Table 1) showing the alocation of supporting departments to producing departments using the direct thethod. See example 7.3 from the textbook for guidance on prepuring 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 coemparison of the fwo slocation methods. Table 3 should be a summary table, It should huve columns for total amounts allocated for each method. It should also have a column for the difference between the two methods. Fows should exist for each producing departinent. For Example: 4. If the hospital is currently using the direct method, do you thins (based on the dfferences you see) that ther should switch to the sequeotial method? Write up your recommendation to the management of Back Hospital in 250 words or less. 5. Combine Table 1. Table 2. Table 3, and your recommendation into a single POF and upload the PDF to complete the assenment, Be sure to reference the srading rubric and thorouthly review your wark priar to submision. Basic hospital has twelve producing departments and four supporting departments. The budgeted data bers \pm pertain to these sixteen departments, and the allocation statistics table below identifies the allocatich buses used to distribute the costs of each supporting department. "Step method support deportment rankings are baved on the proportion of the total poroll dollars, where the support departinent with the most parroll dallars is ranked of. Required 1. Create a table (Table 1) showing the alocation of supporting departments to producing departments using the direct thethod. See example 7.3 from the textbook for guidance on prepuring 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 coemparison of the fwo slocation methods. Table 3 should be a summary table, It should huve columns for total amounts allocated for each method. It should also have a column for the difference between the two methods. Fows should exist for each producing departinent. For Example: 4. If the hospital is currently using the direct method, do you thins (based on the dfferences you see) that ther should switch to the sequeotial method? Write up your recommendation to the management of Back Hospital in 250 words or less. 5. Combine Table 1. Table 2. Table 3, and your recommendation into a single POF and upload the PDF to complete the assenment, Be sure to reference the srading rubric and thorouthly review your wark priar to submision