May Acme Labs has four separate labs: chemical, blo, mechanical and electrical. The four labs all share the support functions of Admin, Utilities and insurance. Acme spreads the cost of these three departments to the labs based on the allocation below. Allocation base Expenses Administralve expense 104,950 number of employees Utilities 72,600 square feet per lab Insurance 36,000 value of assets in use. 213,550 Square feet Department Employees Chem Lab Bio Lab Mechanical Lab Electrical Lab Totals INSTRUCTIONS: Enter numbers in blue cells Enter formulas in the yellow cells Enter your narrative analysis in the green cells 10,000 55,500 29,800 18,500 113,800 Asset values 47,950 88,250 31,500 98,500 266,200 % allocation base Cost Allocation Base #employees W ww Administrative Expenses Department Chem Labs Bio Lab Mechanical Lab Electrical Lab Totals Problem 1 Problem 2 Problem 3 Ready Merge & Center B57 Ax B Cost Allocation Base % allocation base Sqaure feet occupied Utilities Department Chem Lab Bio Lab Mechanical Lab Electrical Lab Totals Insurance Allocation Base % allocation base Cost Department Value of Assets in use Chem Lab A MATRAMARILLA S MAKSAA OMANIKANISA LARANIWAKAN MONAS Bio Lab AMAT MALAYALAM MA AMAN ANG KATAWA KANI SA LARAWAKIANA NA MAMA Mechanical Lab RAMAI L ALANGAN KATA KATIKA MAKAN Electrical Lab Totals Utilities Insurance Total Summary Admin Chem Lab Bio Lab Mechanical Lab ALLA AURAMAAN LAMA MARAMING Electrical Lab Totals MMA MA MA MAILL MAL AMAN KARANGAN E