The Chapter 7 Form worksheet is to be used to create your own worksheet version of the Review Problem for Activity Based Costing found in the text (include a link of the problem). Chapter 7: Applying Excel: Exercise (Part 2 of 2) (Algo) 2. Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the number of orders from 4 to 23. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) 1 Chapter 7: Applying Excel 2 3 Data Manufacturing overhead A B C D E 4 $ 500,000 5 Selling and administrative overhead $ 300,000 6 Manufacturing overhead 7 8 9 Selling and administrative overhead Assembling Processing Supporting Other Units Orders Customers 50% 35% 5% 10% 10% 45% 25% 20% 10 Total activity 1,000 250 100 11 12 units orders customers 13 OfficeMart orders: 14 Customers 15 Orders 16 Number of filing cabinets ordered in total 17 Selling price 18 Direct materials 19 Direct labor 1 customer 23 orders 80 units $ 595 180 $ 50