7(b) What is the product margin under the traditional costing system when the number of orders increases to 16? (Enter a loss as a negative amount.)

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