Please solve using excel and include formulas, Thank you!

Chapter 7: Apolvina Excel Data Manufacturing overhead Selling and administrative overhead $500,000 $300,000 Manufacturing overhead Selling and administrative overhead Total activity Assembling Processing Units Orders 50% 35% 10% 1.000 250 orders Supporting Customers 5% 25% 100 customers Other 10% 20% 45% OfficeMart orders: 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 cells marked with a ? below Review Problem: Activity-Based Costing Perform the first stage allocations Other Total Manufacturing overhead Selling and administrative overhead Total cost Assembling Processing Units Orders ? ? ? ? ? ? Supporting Customers ? ? ? ? ? ? ? ? ? Compute the activity rates Activity Cost Pools Assembling units Processing orders Supporting customers Total Cost ? ? ? Talal Activity ? units 7 orders ? customers Activity Rale ? per unit ? per order ? per customer ABC Cost Compute the overhead cost attributable to the OfficeMart orders Activity Cost Pools Activity Rate Assembling units ? per unit Processing orders ? per order Supporting customers ? per customer Activity ? units ? orders ? customer ? ? ? Determine the customer margin for the OfficeMart orders under Activity-Based Costing Sales ? Casts: 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 ? units Manufacturing overhead per unit ? per unit ? Sales Costs Direct materials Direct labor Manufacturing overhead Traditional costing product margin