Exercise 22-5 Departmental expense allocations LO P2 Cast 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 bages used to allocate them follow. Indirect Expense Allocation has Supervision $ 84,200 Wamber of employees Dentities 57.000 Square feet occupied Insurance 31.000 Value of assets in use Total $152. 200 Departmental data for the company's recent reporting period follow. Department Teployees Square feet Rret Values Materials 41.250 $11.550 Personnel 12 3.250 9.000 Manufacturing 63 90, 750 46,200 Packaging 51 24,950 16, 190 Total 165,000 $7,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 t. 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 ? Use this information to allocate each of the three indirect expenses across the four departments Supervision expenses location Base Cost to be Percent of Allocation Base Allocated Cost Allocated Department Number of employees Numerator Denominator of Total Materials 34 os 84.200 Personnel 17 0 Manufacturing 0 0 Packaging 0 0 Totals 0 $ 84,200 Cost to be Utilities Allocation Base Percent of Allocation Base Allocated Cost Allocated Department Square feet occupied Numerator Denominato % of Total Materials OF $ 87.000 Personnel 0 Manufacturing 0 0 Packaging 0 Totals 0 $ 87.000 Cost to be Insurance Allocation Base Percent of Allocation Base Allocated Cost Allocated Department Value of assets in use Numerator Denominator of Total Materials OT 5 31,000 Personnel Manufacturing Packaging OD Use this information to allocate each of the three indirect expenses across the four departments Aloed cost Mlocated Parco Allolian B Number of employees Numerator Denominato % of Total 34 os 17 0 84.200 Department Materials Personnel Manufacturing Packaging Totals 0 0 0 0 84.200 0 $ Utilities Cost to be Allocated Allocated Cost Department Materials Allocation Base Percent of Allocation Base Square feet occupied Numerator Denominatof % of Total 0 $ 67.000 0 Personnel 0 0 0 Manufacturing Packaging Totals 0 $ 87,000 Cost to be Allocated Allocated Cost Insurance Allocation Base Percent of Allocation Base Value of assets in use Numerator Denominato % of Total O $ Department Materials Personnel 31.000 0 0 Manufacturing Packaging Totals Ooo 0 $ $ 31,000 Required 2 > 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 0 Manufacturing 0 Packaging Totals $ o$ 0
