please answer section D with formulas. TIA

Manufacturing overhead 5 Selling and administrative overhead $500,000 $300,000 Assembling Processing Supporting Units Orders Customers Other 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 a) Perform the first stage allocations Assembling Processing Supporting 25 Units Orders Customers Other Total 26 Manufacturing overhead 250,000 175,000 25,000 50.000 $ 500.000 27 Selling and administrative overhead 30.000 135,000 75.000 60,000 300.000 28 Total cost $ 280,000 $ 310,000 $ 100.000 $ 110,000 $ 800,000 29 30 b) Compute the activity rates 280 1240 1000 31 Activity Cost Pools Total Cost Total Activity Activity Rate 32 Assembling units $ 280,000 1,000 units $500 per unit 33 Processing orders $ 310,000 250 orders $1,240 per order 34 Supporting customers $ 100,000 100 customers $1,000 per customer 35 36 c) Compute the overhead cost attributable to the Office Mart orders 37 Activity Cost Pools Activity Rate Activity ABC Cost 38 Assembling units $500 per unit 595 units $297,500 39 Processing orders $1,240 per order 80 orders $99,200 40 Supporting customers $34 per customer 4 customer $136 41 42 ) Determine the customer margin for the Office Mart orders under Activity-Based Costing Di 43 Sales ? 44 Costs: 45 Direct materials ? 46 Direct labor ? 47 Unit-related overhead ? 48 Order-related overhead ? 49 Customer-related overhead 50 Customer margin ? 51 ? Manufacturing overhead 5 Selling and administrative overhead $500,000 $300,000 Assembling Processing Supporting Units Orders Customers Other 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 a) Perform the first stage allocations Assembling Processing Supporting 25 Units Orders Customers Other Total 26 Manufacturing overhead 250,000 175,000 25,000 50.000 $ 500.000 27 Selling and administrative overhead 30.000 135,000 75.000 60,000 300.000 28 Total cost $ 280,000 $ 310,000 $ 100.000 $ 110,000 $ 800,000 29 30 b) Compute the activity rates 280 1240 1000 31 Activity Cost Pools Total Cost Total Activity Activity Rate 32 Assembling units $ 280,000 1,000 units $500 per unit 33 Processing orders $ 310,000 250 orders $1,240 per order 34 Supporting customers $ 100,000 100 customers $1,000 per customer 35 36 c) Compute the overhead cost attributable to the Office Mart orders 37 Activity Cost Pools Activity Rate Activity ABC Cost 38 Assembling units $500 per unit 595 units $297,500 39 Processing orders $1,240 per order 80 orders $99,200 40 Supporting customers $34 per customer 4 customer $136 41 42 ) Determine the customer margin for the Office Mart orders under Activity-Based Costing Di 43 Sales ? 44 Costs: 45 Direct materials ? 46 Direct labor ? 47 Unit-related overhead ? 48 Order-related overhead ? 49 Customer-related overhead 50 Customer margin ? 51