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