answer in excel show formulas and explain please

2. Calculate the ABC costs for each product on a per-box basis. 3. What do these results tell you about activity-based meetinn c D 2. Calculate the ABC costs for each productes a perbes basis Answer Question 2 here and show support clow. Base Information (Exhibit) Ornaments Boxes Zauner Ornaments Calculations of ABC Costs Small Large Specialty 420.000 300,000 100,000 35.000 50.000 100,000 z Activity Base noted within the case Estimated MORS noted within the case) Activity Rate Estimated base noted within different exhibit) Small Large Specialty NDIV/0! & 5 Production Scheduling 6 Machine Setup 1. Tquipment Depreciation 18 Plan Depreciation Quality Inspection 20 Packing 21 Plant Administration 22 23 24 Exhibit Exhibit Exhibit) Exhibit Exhibit ht Exhib so Lante Speciales 20 29 30 31 12 SAP Production Scheduling Machines que Decision Plant Depreciation Quality Inspection Packing Punt Administration Antivity produced SOLIS Check 14 35 36 37 Total AEC Ces 2. Calculate the ABC costs for each product on a per-box basis. 3. What do these results tell you about activity-based meetinn c D 2. Calculate the ABC costs for each productes a perbes basis Answer Question 2 here and show support clow. Base Information (Exhibit) Ornaments Boxes Zauner Ornaments Calculations of ABC Costs Small Large Specialty 420.000 300,000 100,000 35.000 50.000 100,000 z Activity Base noted within the case Estimated MORS noted within the case) Activity Rate Estimated base noted within different exhibit) Small Large Specialty NDIV/0! & 5 Production Scheduling 6 Machine Setup 1. Tquipment Depreciation 18 Plan Depreciation Quality Inspection 20 Packing 21 Plant Administration 22 23 24 Exhibit Exhibit Exhibit) Exhibit Exhibit ht Exhib so Lante Speciales 20 29 30 31 12 SAP Production Scheduling Machines que Decision Plant Depreciation Quality Inspection Packing Punt Administration Antivity produced SOLIS Check 14 35 36 37 Total AEC Ces