Chapter 7: Applying Excel Data Manufacturing overhead Selling and administrative overhead $500,000 $300,000 Assembling Processing Supporting Units CustomersOther Manufacturing overhead Selling and administrative overhead Total activity 50% 10% 1,000 units 35% 5% 25% 100 customers 10% 250 orders OfficeMart orders Customers customer 4 orders 80 units ders Number of filing cabinets ordered in total Selling price Direct materials Direct labor $595 $180 $50 Enter a formula into each of the cells marked with a? below Review Problem: Activity-Based Costing Perform the first stage allocations Assembling ProcessingSupporting Customers Units Other Total Manufacturing overhead Selling and administrative overhead Total cost Compute the activity rates Activity Cost Pools Total Cost Total Activity ? units Activity Rate ? per unit ? per order bling units Processing orders Supporting customers orders ? customers per customer Compute the overhead cost attributable to the OfficeMart orders Activity Cost Pools Activity Rate Activity ABC CostI ? per unit ? per order ? per customer ? units ? orders ? customer bling units Processing orders Supporting customers Determine the customer margin for the OfficeMart orders under Activity-Based Costing Sales Costs l Direct materials Direct labor Unit-related overhead Order-related overhead Customer-related overhead Customer margin Determine the product margin for the OfficeMart orders under a traditional cost system Manufacturing overhead Total activity Manufacturing overhead per unit ? units ? per unit Sales Costs: Direct materials Direct labor Manufacturing overhead Traditional costng product marin