5 10 points 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,500 Number of employees Utilities 50,000 square feet occupied Insurance 22.500 Value of assets in use Total $155.ee Black Paint References Departmental data for the company's recent reporting period follow. Department Employees Square Feet Asset Values Materials 27 25,000 5 6,600 Personnel 9 5,600 1,200 Manufacturing 63 37,800 Packaging 15,600 15.000 Total 150 109,00 560,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, Use this information to allocate each of the three indirect expenses across the four departments. 10 points eBook Hint Print Supervision expenses Department Materials Personnel Manufacturing Packaging Totals Ulities Department Materials Personnel Manufacturing Packaging Totals References Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Number of employees Numerator Denominator % of Total 27 27 0 S 14,850 91 9 0 4,950 63 63 0 0 51 51 0 150 0 Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Square foot occupied Numerator Denominator % of Total 250,000 250.000 0 $ 12.500 5,000 5.000 0 2,500 55.000 0 0 15.000 15.000 0 325.000 0 Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Value of assets in use Numerator Denominator % of Total S 6.000 $ 6.000 0 2.250 1,200 1,200 0 450 37.800 37.800 0 0 15,000 15.000 0 60.000 ol 55.000 Insurance Department Materials Personnel Manufacturing Packaging Totals 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. 10 points Complete this question by entering your answers in the tabs below. eBook Required 1 Required 2 Prepare a summary table that reports the indirect expenses assigned to each of the four departments. References 0 Supervision Utilities Insurance Total Materials $ 4,950 $ 4,950 Personnel Manufacturing 0 Packaging 0 Totals $ 4,950 $ 0 $ 0 $ 4.950