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 bases used to allocate them follow. Indirect Expense Cost Allocation Base Supervision $ 82,780 Number of employees Utilities 52,000 square feet occupied Insurance 23,500 Value of assets in use Total $158,280 Departmental data for the company's recent reporting period follow. Department Employees Square Feet Asset Values Materials 26 30,000 $ 9,300 Personnel 13 12,000 2,480 Manufacturing 52 66,000 37,820 Packaging 39 12,080 12,400 Totat 138 120,000 $62,000 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 1 Required 2 Use this information to allocate each of the three indirect expenses across the four departments. Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Bane Numerator Denominator % of Total 0 Supervision expenses Department Materials Personnel Manufacturing Packaging Totals 0 0 0 0 0 0 Utilities Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Numerator Denominator % of Total 0 Department Materials Personnel Manufacturing Packaging 0 0 0 0 0 Totals 0 Insurance Allocation Base Cost to be Allocated Allocated Coat Percent of Allocation Base Numerator Denominator % of Total Department Materials Personnel 0 0 0 Manufacturing Packaging Totals 0 0 0 0 Required 2 > 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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Prepare a summary table that reports the Indirect expenses assigned to each of the four departments. Supervision Utilities Insurance Total Materials $ 0 Personnel 0 Manufacturing Packaging Totals 0 0 $ 0 $ 0 $ 0 $ 0 Required 1 Required 2