please assist with the formulas and cell references (EX. =A123/A456 or =B123)

9 X Inc. manufactures two products, A1 and B2 March production and estimated overhead costs (by activity) for these two products was as follows: 10 12 Product A1 B2 Units 60 350 13 14 15 16 17 18 19 Activity Material handling Machine setups Quality inspections Cost Driver of requisitions of schups of inspections Total Estimated Overhead $36,000 $28,000 $25,000 $89,000 20 21 22 23 24 25 The cost driver volume for each product was as follows: Cost Driver AI of requisitions 380 650 # of setups 210 350 of inspections 200 425 Total 1,030 560 625 Instructions: (a) Determine the overhead rate for each activity 27 28 29 30 31 32 33 34 Expected Use of Cost Drivers De Activity Activity based Overhead Estimated Overhead $36.000 $28.000 $25.000 Activity Material handling Machine setups Quality inspections 1010 560 625 formula formula formala 30 37 38 39 40 (b) Assign the manufacturing overhead costs for April to the two products using activity-based costing Total Overhead Cost Assigned Use ABC Overhead Rate cell reference cell reference cell reference Cost Driver of requisitions # of setups # of inspections Total costs Units produced Overhead cost per unit Product Al Use Cost 380 formula 210 formula 200 formula formula cell reference formula Product B2 Cost 650 formula 350 formula 425 formula formula cell reference formula formala formula formula 44 45 48 49 50