solve using cell/sum functions: example: =B6-B4

J18 x fx G H K B D E F 1 Chapter 7: Applying Excel 2 3 Data 4 Manufacturing overhead $500,000 5 Soling and administrative overhead $300,000 6 Assembling Processing Supporting 7 Links 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 orders customers 12 13 OfficeMart Orders 14 Customers 1 customer 15 Orders 4 orders 16 Number of fing cabinets ordered in total 80 units 17 Selling price $595 18 Direct materials $180 19 Drect labor $50 20 21 Enter a formule into each of the cells marked with a ' below 22 Review Problem: Activity Based Coating 23 24 Perform the first stage allocations Assembling Processing Supporting 25 Units Orders Customers Other Total 7 26 Manufacturing overhead ? ? ? ? 27 Seling and administrative overhead 2 ? ? ? ? 28 Total cost 7 ? ? ? 2 29 30 Compute the activity rates 31 Activity Coat Pools Total Cost Total Activity Activity Rate 32 Assembing unts 7 ? units 7 per unit 33 Processing orders 2 ? orders 7 per order 34 Supporting customers 7 7 customers 7 per customer 35 36 Compute the overhead cost attributable to the Omce Marf orders 37 Activity Cost Pools Activity Rate Activity ABC Cost 38 Assembling units 7 per unit 7 ? units 7 39 Processing orders 7 orden 7 per order 40 Supporting customers ? per customer 7 customer 7 41 42 Determine the customer margin for the Omee Marf orders under Activity-Based Costing ? 44 Couts 45 Direct materials ? 46 Drect labor ? 47 Unit related overhead 2 48 Orderrested overhead 2 Chapter 7 Form + Paste BIU a. Av Merge & Center $ %) Condition Formatti 4 G H 1 1 K L J18 X fx B D E F 22 Review Problem: Activity-Based Costing 23 24 Perform the first stage allocations Assembling Processing Supporting 25 Units Orders Customers Other Total 25 Manufacturing overhead 2 ? ? ? 27 Seling and administrative overhead 7 ? ? ? 28 Total cost ? 2 7 7 7 29 30 Compute the activity rates 31 Activity Cost Pools Total Cost Total Act Acowy Rate 32 Assembing units ? ? units 7 per unit ? 33 Processing orders ? onders 7 per order 34 Supporting customers 7 ? customers 7 per customer 35 36 Compute the overhead cost attributable to the Omice Martorders 37 Activity Cost Pools Activity Rate Activy ABC Cost ? per unit 38 Assembling units 2 ? units 7 per order onden 7 39 Processing orders 7 per customer 40 Supporting customers 2 7 customer 41 42 Determine the customer margin for the OceMart orders under Activity-Based Costing ? 43 Sales 44 Costs 45 ? Direct materiais 46 Direct labor 2 47 ? Untreated overhead 48 Order related overhead 7 ? 49 Customer related overhead So Customer margin 51 52 Determine the product margin for the Omice Martorders under traditional cost system ? 53 Manufacturing overhead 54 Total activity ? units 7 per unit 55 Manufacturing overhead perunt 7 57 Sales 58 Couts 7 Direct materials 7 60 Direct labor ? 61 Manufacturing overhead 62 Traditional costing product margin 60 2 67