please pay attention to the cell refrences and formulas. i need EACH CELL REFERENCE AND FORMULA FILLED IN PLEASE. please make answer clear and zoom in if needed...if all correct i will give THUMBS UP

X Ine, manufactures two products, Al und B2. March production and estimated overhead cons by activity) for these two products was as follows Product A1 60 10 11 12 13 Units 332 350 14 15 Activity Material handling Machine store Quality inspections Cost Driver of requisitions of setups of inspections 18 Total Estimated Overhead $36.000 $28.000 $25,000 $89.000 19 20 21 22 23 24 25 20 27 28 20 30 The cost driver volume for each product was as follows Cost Driver A1 B12 of requisitions 380 650 N of setups 210 350 of inspections 200 425 Total 1.030 360 625 Instructiews (a) Determine the overhead rate for cach activity Expected Use Estimated of Cost Drivers Obechead Der Activity cell reference cell reference cell reference cell reference cell reference cell reference Activity-based Overhead Rates formula formula formula Activity cell reference cell reference cell reference 35 37 38 39 (b) Assign the manufacturing overhead costs for April to the two products using activity-based costing, ARC Overhead Rate cell reference cell reference cell reference Cost Driver cell reference cell reference cell reference Total costs Units produced Overhead cost per unit Product AI Use Cost cell reference formula cell reference formula cell reference formula formula cell reference formula Product B2 Use cell reference cell reference formula cell reference formal formula cell reference for 44 Total Overhead Cost Assigned formula formula formula formula 45