Allocating costs Acme Labs has four separate labs: chemical, bio, mechanicaland electrical. The four lats all share the support functions of Admin, Utilities and insurance. Acne spreads the cost of these three departments to the labs based on the alocation below. May Allocation base Expenses number of Administrave expense 104,950 employees square feet Utilities 72,600 per lab value of assets Insurance 36,000 in use. 213,550 Department Employees Square feet Asset values Chern Lab 20 10.000 47,950 Bio Lab 99 55,500 89,250 Mechanical Lab 19 29,800 31,500 Electrical Lab 28 18,500 98,500 Totals 166 113,800 266, 200 INSTRUCTIONS: Enter numbers in blue cells Enter formulas In the yellow cells Enter your narrative analysis in the green cells Administrative Expen Allocation B. % allocation Cost Department # employees Chem Lab Blo Lab Mechanical Lab Electrical Lab Totals Allocation B. % allocatlont Cost Sqaure feet occupled Utilities Department Chem Lab Blo Lab Mechanical Lab Electrical Lab Totals Allocation B. % allocation Cost Value of Assets In use Insurance Department Chem Lab Bio Lab Mechanical Lab Electrical Lab Totals Admin Utilities Insurance Total Summary Chem Lab Blo Lab Mechanical Lab Electrical Lab Totals