Any Help would be SO nice!!!

Step method support department rankings are based on the proportion of the total payroll dollars, where the support department with the most payroll dollars is ranked \#1. 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