Renata Company has four departments: Materials, Personnel, Manufacturing, and Packaging. Information follows. Employees 27 9 Department Materials Personnel Manufacturing Packaging Total Square Feet 25,000 5,000 55,000 15,000 100,000 Asset Values $6,000 1,200 37,800 15,000 $60,000 63 51 150 The four departments share the following indirect expenses for supervision, utilities, and insurance according to thei 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 Required: Allocate each of the three indirect expenses to the four departments. (Use cells A5 to 017 from the given information to complete this question.) Allocation Base Allocated Cost Percent of Allocation Cost to be Allocated % of Total Allocation Base Cost to be Allocated Allocated Cost % of Total Supervision expenses Department Materials Personnel Manufacturing Packaging Totals Utilities Department Materials Personnel Manufacturing Packaging Totals Insurance Department Materials Personnel Manufacturing Packaging Totals Allocation Base Cost to be Allocated Allocated Cost % of Total