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 22. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) A 1 Chapter 7: Applying Excel 23 B 4 Data Manufacturing overhead $ 500,000 5 in 60 Selling and administrative overhead $ 300,000 D 6 7 8 Manufacturing overhead 9 Selling and administrative overhead Total activity 10 Assembling Processing Units Orders Supporting Customers Other 50% 35% 5% 10% 10% 45% 25% 20% 1,000 250 100 units orders customers 11 12 OfficeMart orders: 13 Customers 1 customer 14 Orders 22 orders 15 Number of filing cabinets ordered in total 80 units 16 Selling price $ 595 17 Direct materials $ 180 18 Direct labor $ 50 19