7 Acct. 111, ABC Excel Problem X Inc. manufactures two products, A1 and B2. March production and estimated overhead costs (by activity) for these two products was as follows: Product Units 60 350 B2 NMF Total Estimated Activity Cost Driver Overhead Material handling # of requisitions $36,000 Machine setups # of setups $28,000 Quality inspectior # of inspections $25,000 $89,000 The cost driver volume for each product was as follows: Cost Driver A1 B2 Total # of requisitions 380 650 1.030 # of setups 210 L 350 560 # of inspections 200 425 625 Instructions: (a) Determine the overhead rate for each activity. Activit cell reference cell reference cell reference Expected Estimated of Cost Overhead d er cell reference cell reference cell reference cell reference cell reference cell reference Activity- Overhead Rates formula formula formula M (b) Assign the manufacturing overhead costs for April to the two products using activity-based costing. 41 42 Cost Driver cell reference ABC Overhead Product A1 Product B2 Total Overhead Rate Use Cost U se Cost Cost Assigned cell reference loell reference formula oell reference formula formula ABC excel 2) 24 Cost Driver # of requisitions # of setups # of inspections A1 380 210 200 B 2 650 350 425 Total 1030 560 625 Instructions (a) Determine the overhead rate for each activity. Activite cell reference cell reference cell reference Expected Estimated of Cost Overhead per cell referencel cell reference cell referencel cell reference cell referencel cell reference Activity Overhead Rates formula formula formula (b) Assign the manufacturing overhead costs for April to the two products using activity-based costing. Use Cost Use ABC Overhead Product A1 Product B2 Total Overhead Cost Driver Rate Cost Cost Assigned cell reference cell reference cell reference formula cell reference formula formula cell reference cell reference cell reference formula I cell reference Formula formula cell reference cell reference Joell reference formula cell reference formula formula Total costs Formula formula formula Units produced cell reference cell reference Overhead cost per unit formula formula