Woh Che Co has four departments: Materials, Personnel Manufacturing, and Packaging in a recent month, the four departments Incurred three shered indirect expenses. The amounts of these indirect expenses and the bases used to allocate them follow. Indirect Expense Cost Allocation Base Supervision $ 84,308 Number of employees Utilities 68,000 square feet occupied Insurance 31,500 Value of assets in use Total $183,800 Departmental data for the company's recent reporting period follow, Department Materials Personnel Manufacturing Packaging Total Employees 36 9 72 63 180 Square Feet 52,500 17,506 78,750 26,250 175,000 Asset Values $11,700 3,90 47,580 14,820 $78,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 fout departments Allocation Base Cost to be Allocated Allocated Cost Persent of Allocations Numerator Denominator of Total Supervision expenses Department Materials Personnel Manufacturing Packaging Total Allocation Base Whilities Department Persent Allocation at Numerator Denominato of Total Cost to be Allocated Allocated Cost Personnel Maructuring Packaging Allocation Base Persent. Allcoast Numero of Total Cost to be located Alated Cout Insurance Department Materials Personne Manufacturing Packaging To 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 Supervision Utilities Insurance Total Cost Allocation Base $ 84,300 Number of employees 63,000 square feet occupied 31,5ee Value of assets in use $183,800 Departmental data for the company's recent reporting period follow, Department Materials Personnel Manufacturing Packaging Total Employees 36 9 72 63 180 Square Feet 52,500 17,500 78,750 26,250 175,000 Asset Values $11,700 3,900 47,580 14020 $78,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 Prepare a summary table that reports the indirect expenses assigned to each of the four departments Supervision Utilities Insurance Total Materials Personnel Manufacturing Packaging Total