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, Bee Number of employees Utilities s5,eee square feet occupied Insurance 25, wee value of assets in use Total $ 163,080 Departmental date for the company's recent reporting period follow. Department Employees Square Feet Asset Values Materials Personnel 48 $ 9,758 7, 580 1,380 Manufacturing 67, 58 33, 380 Packaging 28, 158 Total 158, 08 $65, 080 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. supervision expended Allocation Base Percent of Allocation Base Cost to be Allocated| Allocated Cost Department Numerator| Denominain % of Total 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 Insurance Allocation Base Percent of Allocation Base Cost to be Allocated | Allocated Coat Department Numerator Denominator % of Total Materials Personne Manufacturing Packaging Totals 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, 080 Number of employees Utilities 55, Bed square feet occupied Insurance 25, 080 Value of assets in use Total $163, 080 Departmental date for the company's recent reporting period follow. Department Employees Square Feet Asset Values Materials 48 $ 9,750 Personnel 7,580 1, 380 Manufacturing 64 67 , 580 33,880 Packaging 48 15, 080 28, 158 Total 168 158, 080 $65,080 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. Supervleion| Utilities Insurance Total Materials Personnel Manufacturing Packaging Totals >
