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