Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you Chapter 7: Applying Excel B C D Data Manufacturing overhead Selling and administrative overhead $500,000 $300,000 10% 25% Assembling Processing Supporting Units Orders Customers Other 3 Manufacturing overhead 50% 35% 5% 10% Seling and administrative overhead 45% 20% - Total activity 1,000 250 100 units orders customers 12 13 OfficeMart orders: 24 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 colis marked with a ? below 22 Review Problem: Activity-Based Costing 23 24 Perform the first stage allocations Assembling Processing Supporting 25 Units Orders Customers Other Total 26 Manufacturing overhead 7 ? 2 2 27 Seling and administrative overhead ? ? ? ? 28 Total cost ? 2 ? ? 2 29 30 Compute the activity rates 31 Activity Cost Pools Total Cost Total Activity Activity Rate 32 Assembling units 2 ? units ? per unit 33 Processing orders ? 7 orders 7 per order 34 Supporting customers ? ? customers ? per customer 35 36 Compute the overhead cost attributable to the Office Mart orders 37 Activity Cost Pools Activity Rate Activity ABC Cost 38 Assembling units ? perunt ? units ? 39 Processing orders ? por order ? orders 40 Supporting customers ? por customer ? customer 41 ? 7 Chapter 7 Form 19 AutoSave 5 Insert Home Draw Page Layout Formulas Data Review Arial 10 A A Paste BIU Open recovered workbooks? Your recent changes were saved. Do you want to co Al fx Chapter 7: Applying Excel A C D 46 42 Determine the customer margin for the OfficeMart orders under Activity-Based Costing 43 Sales 2 44 Costs: 45 Direct materials ? Direct labor ? 47 Unit-related overhead ? 48 Order-related overhead ? 49 Customer-related overhead ? 2 50 Customer margin ? 51 52 Determine the product margin for the Office Mart orders under a traditional cost system 53 Manufacturing overhead 2 54 Total activity ? units 55 Manufacturing overhead per unit ? per unit 56 57 Sales ? 58 Costs: 59 Direct materials ? 60 Direct labor ? 61 Manufacturing overhead 2 2 62 Traditional costing product margin 2 63 64 65 66 67 68 69 70 71 72 73