PLEASE USE CELL REFERENCES AND FORMULAS. PLEASE FILL OUT CLEARLY AND IN ORDER.

BE SURE TO PAY ATTENTION OF WHICH CELL IS WHICH. HAD RO SCRO DOWN SO IT STARTS AT 9 ON THE TOP. if all correct will give THUMBS UP

9 X Inc. manufactures to products, AI and B2 March production and estimated overhead costs (by activity) for these two products was as follows: 10 12 13 Product R2 Units 60 350 14 15 16 Activity Cost Driver Material handling w of requisitions Machine setups w of suns Quality inspections of inspections Total Estimated Overhead $36,000 $28.000 $25,000 $89,000 18 19 21 22 24 The cost driver volume for cach product was as follows Cost Driver A1 B2 W of requisitions 380 650 of setups 210 350 of inspections 200 425 Total 1,030 560 625 2 20 27 20 Instructions (a) Determine the overhead rate for each activity 30 31 Activity 0 0 Expected Use Activity based Estimated of Cost Drivers Overhead Overhead Der Activity Rates cell reference cell reference formula cell reference cell reference formula cell reference cell reference formula 35 38 Units (b) Assign the manufacturing overhead costs for April to the two products using activity based costing 40 45 Total Overhead Cost Ansigned ABC Overhead Rate cell reference cell reference cell reference 43 Cost Driver cell reference cell reference cell reference Total costs Units produced Overhead cost per unit Product AI Cost cell reference formula cell reference formula cell reference formula formula cell reference Product B2 Uwe Cost cell reference cell reference formula cell reference formula formula cell reference formula formula formula formula 44 45 43