fill in question marks provide formulas please

Data Manufacturing overhead Selling and administrative overhead Other $500,000 $300.000 Assembling Units 50% 10% 1.000 Manufacturing overhead Selling and administrative overhead Total activity Processing Orders 35% 45% 250 Orders Supporting Customers 5% 25% 100 customers 10% 20% units Office Martorders: Customers Orders Number of filing cabinets ordered in total Selling price Direct materials Direct labor 1 customer 4 orders 80 units $595 $180 $50 Enter a formula into each of the cels marked with e? below Review Problem: Activity-Based Costing Perform the first stage allocations Assembling Units Manufacturing overhead ? Selling and administrative overhead 7 Total cost ? Other Total Processing Orders ? 2 2 Supporting Customers ? ? ? ? ? ? Compute the activity rates Actiwty Cost Pools Total Cos! Total Activity Activity Rate Assembling units ? ? units ? per unit Processing orders ? ? orders ? per order Supporting customers ? ? customers ? per customer Compute the overhead cost attributable to the Office Martorders Activity Cost Pools Activity Rate Activity ABC Cost Assembling units 7 per unit 7 units Processing orders 7 per order 7 orders 2 Supporting customers ? per customer ? customer 7 Determine the customer margin for the Office Marf orders under Activity-Based Costing Sales ? Costs: Direct materials ? Direct labor ? Unit-related overhead 7 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 ? units Manufacturing overhead per unit 7 per unit Sales ? Costs: Direct materials ? Direct labor 7 Manufacturing overhead ? Traditional costing product margin