PLEASE USE PROPER CELL REFERENCES AND FORMULAS!!!!!!! IF THIS ANSWER DOES NOT SHOW THE AMOUNT ALONG WITH THE FORMULA, AUTOMATIC THUMBS DOWN THIS IS THE 5th TIME IVE ASKED FOR THIS NOW

PLEASE MAKE SURE CEL REFERENCE AND FORMULA IS CORRECT!!!!!!!

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 Activity Material handling Machine setups Quality inspections Cost Driver of requisitions # of setups of inspections Total Estimated Overhead $36,000 $28.000 $25,000 $89.000 19 20 21 22 23 24 25 The cost driver volume for each product was as follows: Cost Driver B2 of requisitions 380 650 of setups 210 350 of inspections 200 425 Total 1,030 560 625 27 Instructions: (a) Determine the overhead rate for each activity 29 30 31 32 33 Activity based Overhead Activity Material handling Machine setups Quality inspections Estimated Overhead $36.000 $28.000 $25.000 Expected Use of Cost Drivers Der Activity 1.030 560 625 formula formula formula 36 37 38 (b) Assign the manufacturing overhead costs for April to the two products using activity-based costing Total Overhead Cost Assigned 40 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 formala formula Product A1 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 44 45 48 49 50