Exercise 09-5 Departmental expense allocations LO P2 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 $ 84,000 Number of employees Utilities 65,000 square feet occupied Insurance 30,000 Value of assets in use Total $179,000 Departmental data for the company's recent reporting period follow. Department Materials Personnel Manufacturing Packaging Total Employees 27 9 60 54 150 Square Feet 58,000 7,250 65,250 14,500 145,000 Asset Values $ 7,500 1,500 48,750 17,250 $75,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 Required 1 Required 2 Use this information to allocate each of the three indirect expenses across the four departments. Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Numerator Denominator % of Total Supervision expenses Department Materials Personnel Manufacturing Packaging Totals Utilities Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Department Numerator Denominator % of Total Materials Personnel Manufacturing Packaging Totals Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Insurance Department Materials Numerator Denominator % of Total Personnel Manufacturing Packaging Totals