Exercise 24-5 (Static) Departmental expense allocations LO P2 Renata Company has four departments: Materials, Personnel, Manufacturing, and Packaging. Information follows. Department Square Feet Asset Values Employees Materials 27 25,000 Personnel 9 5,000 Manufacturing Packaging 63 55,000 $ 6,000 1,200 37,800 51 15,000 15,000 Total 150 100,000 $ 60,000 Return to question The four departments share the following indirect expenses for supervision, utilities, and insurance according to their allocation bases. Indirect Expense Supervision Cost Allocation Base $ 82,500 Number of employees Utilities Insurance. Total 50,000 Square feet occupied 22,500 Asset values $ 155,000 Allocate each of the three indirect expenses to the four departments. Answer is not complete. Supervision expenses Department Allocation Base Number of employees Numerator Percent of Allocation Base Denominator Cost to be Allocated Allocated Cost % of Total < Prev 2 of 5 Next > Allocate each of the three indirect expenses to the four departments. Answer is not complete. Supervision expenses Allocation Base Percent of Allocation Base Cost to be Allocated Allocated Cost Department Number of employees Numerator Denominator % of Total Materials Personnel Manufacturing Packaging Totals 27 18 0 $ 82,500 90 6 * 0 82,500 63 63 0 82,500 0+ 51 51 0 82,500 150) 0 $ 82,500 Allocation Base Cost to be Allocated Allocated Cost Utilities Department Materials Personnel Manufacturing Packaging Totals Insurance Department Materials Percent of Allocation Base Numerator Denominator % of Total 0 0 0 0 0 0 Allocation Base Numerator Percent of Allocation Base Cost to be Allocated Allocated Cost Denominator % of Total 0 < Prev 2 of 5 Next >