Exercise 9-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 Supervision83,580 Number of employees Utilities Insurance Total Cost Allocation Base 6e,ee0 Square feet occupied 27,588 Value of assets in use $171,800 Departmental data for the company's recent reporting period follow Employees Square FeetAsset Values Materials Personnel Manufacturing Packaging Total 2e 18 40 3e 1ee 48,880 10,800 120,808 30,800 2e0,000 $14,800 1,480 35,ee0 19,600 $70,880 Chap20.6.pdf Chap19.6 (1) pdf $79,680 18e 288,800 Total 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. upervision expenses ation Base Cost to be Allocated Allocated Cost Allocation Base Numerator | Denominato 20 10 % of Total Number of employees Department 20 Manufacturing Packaging 30 100 Totals Next Prevf Chap196 (1).pof Chap20.6.pdf Utilities Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Numerator! Denominato % of Total | Department Materials Personnel Manufacturing Packaging Totals nsurance Department Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Numeratori Denominato 96 of Total Materials Personnel Manufacturing Packaging Totals Required 2> Prey ll Next 1 of 1 Ch 09 Ex 9-5 Saved Hel Required 1 Required 2 Prepare a summary table that reports the indirect expenses assigned to each of the four departments... 20 points Supervision Utilities Insurance Total eBook Hint Ask Print 01$ 01$ Totals Graw