Woh Che Co. has four departments: Materials. Personnel, Manufacturingand 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 $ 89,Bee Number of employees utilities 55,Bee Square feet occupied Insurance 25.000 value of assets in use Total $163,000 Departmental data for the company's recent reporting period follow Department Materials Personnel Manufacturing Packaging Total Employees 40 8 64 48 160 Square Feet Ge, 7,500 67,500 15.ee 150,00 Asset Values $ 9,750 1,300 33,00 20.150 $65,000 ces 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: Required 2 Use this information to allocate each of the three indirect expenses across the four departments Supervision expenses Allocation Base Percent Allocation Base Cost to be Allocated Allocated Cost Department Number of employees Numerator Denomina of Total Materials 401 40 180 2500 5 83,000 Personnel & 0 Manufacturing 04 Packaging 48 100 Totals 160 383.000 Utilities Allocation Base Percent of Allocaban is Cost to be Allocated Allocated Cost Department Numerator Denominator of Total Materials Personnel Manufacturing Packaging Totals Insurance Allocation Base Percent Alone Cost to be Allocated Allocated Cost Department Numerator Denominato all Materials 0 Personnel Manufacturing 0 Packaging 0 0 Totals 0 Required 2 > 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 Supervision utilities Insurance Total Cost Allocation Base 83, eee Namber of employees 65,000 square feet occupied 25,00 Value of assets in use 3163.000 Departmental data for the company's recent reporting period follow. Department Materials Personel Manutucturing Packaging Total Employees 20 8 64 48 168 Square Feet Gec 7,500 67.5ee 15.000 150,000 Asset Values $ 9.750 1.300 33, Bee 20,150 $65.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 Required 2 Prepare a summary table that reports the indirect expenses assigned to each of the four departments. Supervision Utilities Insurance Total Materials S 0 Personnel 0 Manufacturing Packaging Totals 3 $ Os OS