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 $ 34,300 Number of employees Utilities 68,000 square feet occupied Insurance 31,508 value of assets in use Total $183,500 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,500 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 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 Base Numerator Denominato % of Total Supervision expenses Department Materials Personnel Manufacturing Packaging Totals Utilities Department Materials Personnel Manufacturing Packaging Totals Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Total Allocation Base Cost to be Allocated Allocated Cost Porcent of Allocation Base Numerator Denominator of Total Insurance Department Materials Personnel Manufacturing Packaging Totals 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 Totals