SHOW CELL REFERENCES

Acct. 111, ABC Excel Problem X Inc. manufactures two products, Al and B2. March production and estimated overhead costs (by activity) for these two products was as follows: Product Units Al 60 B2 350 15 Total Estimated 16 Activity Cost Driver Overhead Material handling # of requisitions $36,000 18 Machine setups # of setups $28,000 19 Quality inspections # of inspections $25,000 20 $89,000 22 The cost driver volume for each product was as follows: 23 Cost Driver Al B2 Total 24 # of requisitions 380 650 1,030 25 # of setups 210 350 560 26 # of inspections 200 425 625 27 28 Instructions: 29 (a) Determine the overhead rate for each activity. ASTHE WATSON 30 31 Expected Use Activity-based 32 Estimated of Cost Drivers Overhead 33 Activity Overhead per Activity Rates 34 cell reference cell reference cell reference formula 35 cell reference cell reference cell reference formula 36 cell reference cell reference cell reference formula 37 38 (b) Assign the manufacturing overhead costs for April to the two products using activity-based costing. 39 ABC Overhead Product Al Product B2 Total Overhead Cost Driver Rate Use Cost Use Cost Cost Assigned cell reference cell reference cell reference ormula cell reference ormula ormula cell reference cell reference cell reference formula cell reference formula formula 44 cell reference cell reference cell reference ormula cell reference formula formula 45 Total costs formula formula formula 46 Units produced cell reference cell reference 47 Overhead cost per unit formula formula