1 Chapter 7: Applying Excel 2 3 Data 4 Manufacturing overhead 5 Selling and administrative overhead $500,000 $300,000 6 Assembling Processing Supporting Other 7 Units Orders Customers 8 Manufacturing overhead 50% 35% 5% 10% 9 Selling and administrative overhead 10% 45% 25% 20% 10 Total activity 1,000 250 100 11 units orders customers 12 13 OfficeMart orders: 14 Customers 1 customer 15 Orders 4 orders 16 Number of filing cabinets ordered in total 80 units 17 Selling price $595 18 Direct materials $180 19 Direct labor $50 20 21 Enter a formula into each of the cells marked with a ? below 22 Review Problem: Activity-Based Costing 23 24 Perform the first stage allocations Other Total