Conditional Fo Font Formatting Alignment Number Styl 62 A B C D E F Chapter 7: Applying Excel G H Data Manufacturing overhead $500,000 Selling and administrative overhead $300,000 Assembling Processing Supporting Units Orders Customers Other Manufacturing overhead 50% 35% 5% 10% Selling and administrative overhead 10% 45% 25% 20% Total activity 1,000 250 100 units orders customers OfficeMart orders: Customers 1 customer Orders 4 orders Number of filing cabinets ordered in total 80 units Selling price $595 Direct materials $180 Direct labor $50 Enter a formula into each of the cells marked with a ? below Review Problem: Activity-Based Costing 4 Perform the first stage allocations Assembling Processing Supporting Orders Customers Other Total 15 Units $ 250,000 $ $ 25,000 $ 50,000 $ 500,000 6 Manufacturing overhead 175,000 75,000 60,000 300,000 7 Selling and administrative overhead 30,000 135,000 18 Total cost $ 280,000 $ 310,000 $ 100,000 $110,000 $ 800,000 19 Chapter 7 Form Ready Accessibility: Good to goD62 X A B C D E 0 Compute the activity rates F G H 31 Activity Cost Pools Total Cost Total Activity 32 Assembling units Activity Rate $280,000 1,000 units $280 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 Compute the overhead cost attributable to the OfficeMart orders 37 Activity Cost Pools Activity Rate Activity ABC Cost 38 Assembling units $280 per unit 160 units $44,800 39 Processing orders $1,240 per order 4 orders $4,960 40 Supporting customers $1,000 per customer 1 customer $1,000 41 42 Determine the customer margin for the OfficeMart orders under Activity-Based Costing 43 Sales $ 95,200 44 Costs: 45 Direct materials $ 28,800 46 Direct labor 8,000 47 Unit-related overhead 44,800 48 Order-related overhead 4,960 49 Customer-related overhead 1,000 87,560 50 Customer margin $ 7,640 51 52 Determine the product margin for the OfficeMart orders under a traditional cost system 53 Manufacturing overhead $500,000 54 Total activity 1,000 units 55 Manufacturing overhead per unit $500 per unit 56 $ 95,200 57 Sales 58 Costs: Direct materials 28,800 59 8,000 60 Direct labor Chapter 7 Form\fChapter 7: (Algo) Applying Excel: Exercise (Part 2 of 2) 2. Assume that OfficeMart places orders more frequently, but everything else remains the same. On your worksheet increase the number of orders from 4 to 22. (Prior to completing this requirement, change all worksheet figures back to their original amounts.) A B C- D E 1 Chapter 7: Applying Excel 2 3 Data 4 Manufacturing overhead $ 500,000 5 Selling and administrative overhead $ 300,000 6 Assembling Processing Supporting Other Units Orders Customers 8 |Manufacturing overhead 50% 35% 5% 10% 9 Selling and administrative overhead 10% 45% 25% 20 10 100 Total activity 1,000 250 11 units orders customers 12 13 OfficeMart orders 14 Customers 1 customer Chapter V excel sh..xIsx DELL) Search ILLOCZBRequired information 13 OfficeMart orders: 14 Customers 1 customer 15 Orders 22 orders 16 Number of filing cabinets ordered in total 80 units 17 Selling price $ 595 18 Direct materials $ 180 19 Direct labor $ 50 (a) What is the customer margin under activity-based costing when the number of orders increases to 22? (Enter a amount.) Customer margin under activity-based costing CP Required information (b) What is the product margin under the traditional costing system when the number of orders increases to 22? (Enter a loss as a negative amount.) Product margin under the traditional costing system (c) Which of the following statements are true? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) If a customer orders more frequently, but orders the same total number of units over the course of a year, the customer margin under activity based costing will decrease. Isx Chapter V excel sh...xIsx Q Search DELL