Chapter 5: Applying Excel: Exercise (Part 2 of 2) 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 9. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) 1 Chapter 5: Applying Excel A B C D E 2 3 Data 4 Manufacturing overhead 500,000 5 Selling and administrative overhead i $ 300,000 6 Assembling 7 Processing Supporting Other Units Orders Customers B Manufacturing overhead 50% 35% 5% 10% 9 Selling and administrative overhead 10% 45% 25% 20% 10 Total activity 1,000 250 100 units orders customers 11 + -12 OfficeMart orders: 13 Customers 1 customer 14 Orders orders 15 Number of fling cabinets ordered in total 30 units 16 Selling price $ 595 17 Direct materials $ 150 18 Direct labor 50 19 (6) What is the customer margin under activity-based costing when the number of orders increases to 9" (Enter a loss as a negative amount)