alred) Homework (ch 24) Saved Help Exercise 24-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 $ 82,580 Number of employees Utilities 50,000 square feet occupied Insurance 22,500 Value of assets in use Total $155,000 Departmental data for the company's recent reporting period follow. Department Employees Square Feet Asset Values Materials 27 25,000 $ 6,000 Personnel 9 5,000 1,200 Manufacturing 63 55,000 37,800 Packaging 51 15,000 15,000 Total 150 100,000 $60,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. Help Save & Eal 3 Required: Required 2 Chec Use this information to allocate each of the three indirect expenses across the four departments. 4 points Allocation Base Number of employees Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Total 27 150 18.00% 9 150 6.00% ello 0 0 0 Hint 0 Allocation Base Percent of Allocation Base Numerator Denominator % of Total Cost to be Allocated Allocated Coat Print 0 Supervision expenses Department Materials Personnel Manufacturing Packaging Totals Utilities Department Materials Personnel Manufacturing Packaging Totals Insurance Department Materials Personnel Manufacturing Packaging Totals 0 References 0 0 0 Allocation Base Percent of Allocation Base Numerator Denominator % of Total Cost to be Allocated Allocated cost 0 0 0 0 0 0 Required 2 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 0 Personnel 0 0 Manufacturing Packaging Totals 0 $ 0 $ 0 $ 0 $ 0