2-please help with all parts

Renata Company has four departments: Materials, Personnel, Manufacturing, and Packaging. Information follows. Department Materials Personnel Manufacturing Packaging Total Employees 34 17 68 51 170 Square Feet Asset Values 41,250 $ 11,550 8,250 3,080 90, 750 46,200 24,750 16,170 165,000 $ 77,000 The four departments share the following indirect expenses for supervision, utilities, and insurance according to their allocation bases. Indirect Expense Supervision Utilities Insurance Total Cost Allocation Base $ 84,200 Number of employees 67,000 square feet occupied 31,000 Asset values $ 182,200 Allocate each of the three indirect expenses to the four departments. Allocation Base Cost to be Allocated Allocated Cost Supervision expenses Department Materials Percent of Allocation Base Numerator Denominator % of Total Personnel Manufacturing Packaging Totals Utilities Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Total Department Materials Personnel Manufacturing Packaging Totals Insurance Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Total Department Materials Personnel Manufacturing Packaging Totals