2 Homework Saved Help Save & Exit Exercise 22-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 $ 83,200 Number of employees Utilities 57,eee square feet occupied Insurance 26,800 Value of assets in use Total $166, 2ee Departmental data for the company's recent reporting perlod follow. Department Employees Square Feet Asset Values Materials 45 42,5ee $ 6,7ee Personnel 9 8,500 2,680 Manufacturing 81 102,eee 36,189 Packaging 45 17,000 21,440 Total 180 170,eee $67, eee 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, Activate Wind Go to Settings to Saved Help Homework Save & Exi 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 Denominator % of Total Supervision expenses Department Materials Personnel Manufacturing Packaging Totals Utilities Department Materials Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Total Personnel Manufacturing Packaging Totals Allocation Base Percent of Allocation Base Numerator Denominator % of Total Cost to be Allocated Allocated Cost Insurance Department Materials Personnel Activate W Go to Setting Saved Help Save & EX 22 Homework Allocation Base Cost to be Allocated Allocated Cost Manufacturing Packaging Totals Utilities Department Materials Personnel Manufacturing Packaging Percent of Allocation Base Numerator Denominator % of Total Totals Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Total Insurance Department Materials Personnel Manufacturing Packaging Totals (Required 1 Required 2 > Activate anth Sath Packaging Total 45 180 17,800 170, eee 21,440 $67, eee 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 Totals