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 Expanse Cost Allocation Base Supervision $183,100 Number of employers 56.000 square feet occupied 25,500 Value of assets in use 3164,600 Utilities Insurance Total Departmental data for the company's recent reporting period follow. Employees Deportent Materials Personnel Manufacturing Packaging Total 68 51 170 Square Feet 32,000 16.000 38,000 24,000 160,000 Asset Values $13,200 1.980 34,90 15,340 566,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. Subervision expenses Allocation Base Percent of Allocation Base Cont to tie Allocated Allocated Cont Department Numerator Denominator % of Total Materials Porsonnel Manufacturing Packaging Totals Utilities Allocation Base Percent of Allocation Bane Cost to be Allocated Allocated Cost Department Numerator Denominato % of Total Motorals Personnel Manufacturing Packaging Totals Totals Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Bass Numerator Denominator % of Total Utilities Department Materials Personnel Manufacturing Packaging Totals Insurance Allocation Base Cost to be Allocated Allocated Cost Percent of Allocation Base Numerator Denominator % of Total Department Matenals Personnel Manufacturing Packaging Totals Red 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 Manufacturing Packaging Totals Required 1