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 Expenum CORE Alion Supervision $ 84,200 Number of employees Utilities 67,000 square feet coupled Tasurance 31,000 Value of anneta in un Total 5182,200 Departmental data for the company's recent reporting period follow Department Materials Personnel Manufacturing Packaging Total Toployees 30 12 68 51 170 que es 41,250 8,250 90.750 20.750 165,000 At Value $11,550 3.00 46,200 16,170 977,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, Complete this question by entering your answers in the tabs below. Required 1 Required 2 Use this information to allocate each of the three indirect expenses across the four departments Supervision expenses Allocation Base Percent of Allocations Cost to be Allocated Allocated out Department Numerator Denominator of Total Materials YOU MY GIR Required 1 Required 2 Use this information to allocate each of the three indirect expenses across the four departments. Supervision expenses Allocation Base Percent of Allocation Bone Cost to be Allocated Allocated Coat Department Numerator Denominator % of Total Materials Personnel Manufacturing Packaging Totals Utilities Allocation Base Parcent of Allocation Base Cost to be Allocated Allocated Cou Department Numerator Denominator of Total Materials Personnel Manufacturing Packaging Totals Allocation Bano Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Total Insurance Department Materials Personnel Manufacturing Packaging Totals 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 Olilities Insurance Total Materials Personnel Manufacturing Packaging Totals