Woh Che Co. has four departments: materials, personnel, manufacturing, and packaging. In a recent month, the four departments incurred three shared indirect expenses. The amounts of these indirect expenses and the basess used to allocate them follow. Indirect Expense Allocation Base 84,400 Number of employees 69,000 Square feet occupied 32,000 Value of assets in use Cost Supervision Utilities Insurance $185,400 Total Departmental data for the company's recent reporting period follow. ETTT Square Feet 64,750 9,250 92,500 18,500 185,000 Employees 38 19 Department Materials Asset Values 7,900 4,740 45,820 20,540 $79,000 Personnel Manufacturing Packaging 76 57 190 Total 1. Use this information to allocate each of the three indirect expenses across the four departments. 2. Prepare a summary table that reports the indirect expenses assigned to each of the four departments. Required 2 Required 1 Use this information to allocate each of the three indirect expenses across the four departments. Supervision Cost to be Allocated Percent of Allocation Base Allocated Cost Allocation Base expenses Number of employees Department Numerator Denominator % of Total Materials 38 38 0 Personnel 19 19 0 76 Manufacturing 76 0 0 Packaging 57 57 0 0 Totals 190 0 Cost to be Allocated Utilities Allocated Cost Allocation Base Percent of Allocation Base Department Square feet occupied Numerator Denominator % of Total 64,750 64,750 Materials 0 Personnel 9,250 9,250 0 92,500 92,500 Manufacturing 0 0 Packaging 18,500 18,500 0 0 185,000 0 Totals Cost to be Percent of Allocation Base Insurance Allocation Base Allocated Cost Allocated Numerator Department Denominator % of Total Materials 0 Personnel 0 Manufacturing 0 0 Packaging 0 0 00 Totals Required 1 Required 2 Prepare a summary table that reports the indirect expernses assigned to Supervision Utilities Total Insurance $ 0 Materials Personnel 0 Manufacturing 0 Packaging 0 $ 0$ $ 0 0 0 Totals