Need Help with 4B

X AutoSave ( Off) @ = ExcelAnalytics_Comparing TraditionalandActivityBasedProductCosting_Template - Protected View -... Search garlan wong GW File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share @ PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing F10 Activity rate (a) + (b) B C D E G H K Background Information Activity Rates IN Standard Advanced Assemble and Pack: Number of units produced and sold 20,000 10,000 Manufacturing overhead cost (a) $ 292,500 Direct labor-hours per unit 1.50 1.50 Direct labor-hours (b) 45,000 Machine-hours per unit 2 Activity rate (a) : (b) Average customer order size 400 50 Number of setups per customer order 1 Machining: 8 Number of setup hours per setup Manufacturing overhead cost (a) $ 440,000 9 Machine-hours (b) 40,000 10 Product Margin Analysis Activity rate (a) : (b) 11 Standard Advanced Total 12 Sales $ Order Processing: 13 Costs: Manufacturing overhead cost (a) $ 256,250 Direct materials Number of customer orders (b) 250 Direct labor Activity rate (a) : (b) 16 Assemble and pack 17 Machining Setups: 18 Order processing Manufacturing overhead cost (a) $ 357,500 19 Setups Setup hours (b) 650 20 Total cost Activity rate (a) : (b) 21 Product margin 22 23 24 25 26 27 28 29 30 31 Charts Plantwide Approach Activity-Based Approach Activity-Based Cost Analysis Cost Allocation Compa ... + Ready 130%A B C D E F G H K M Activity Standard Advanced Total Assemble and pack 0% 3 Machining 0% Order processing 0% 5 Setups 0% 6 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Charts | Plantwide Approach Activity-Based Approach Activity-Based Cost Analysis Cost Allocation Compa ... + Ready 170%Standard Advanced Total Plantwide approach: Total overhead cost allocated $ Activity-based approach: Total overhead cost allocated S 42 K Plantwide Approach Activity-Based Approach Activity-Based Cost Analysis Cost Allocation Comparison +A B D G H Background Information Plantwide Overhead Rate Standard Advanced Manufacturing overhead cost (a) $ 1,346,250 3 Number of units produced and sold 20,000 10,000 Direct labor hours (b) Selling price per unit 150 $ 200 Plantwide overhead rate (a) + (b) Direct materials per unit 40 60 Direct labor cost per unit 30 $ 30 Direct labor-hours per unit 1.50 1.50 8 9 Gross Margin Analysis 10 Standard Advanced Total 11 Sales 12 Cost of goods sold: 13 Direct materials 14 Direct labor 15 Manufacturing overhead 16 Cost of goods sold 17 Gross margin 18 19 20 21 22 23 24 25 26 28 29 30 31 32 33 34 35 ac Charts Plantwide Approach Activity-Based Approach | Activity-Based Cost Analysis Cost Allocation Compa ... + Read[The following information applies to the questions displayed below.] Cary Company manufactures two models of industrial components-a Standard model and an Advanced Model. It has provided the following information with respect to these two products: Standard Advanced Number of units produced and sold 20,060 10, 000 Selling price per unit 150 206 Direct materials per unit 40 60 Direct labor cost per unit 30 30 Direct labor-hours per unit 1.50 1.50 The company considers all of its manufacturing overhead costs ($1,346,250) to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor-hours. Click here to download the Excel template, which you will use to answer the questions that follow. Click here for a a brief tutorial on Charts in Excel. 4a. Go to the tab titled "Activity-Based Cost Analysis". Create formulas in cells B2 through C5 that compute the percent of each activity's total cost that is allocated to each product. (Hint: If you complete this step correctly, the percentages shown in column D will total 100%.) 4b. What percent of each of the four activities is allocated to the Standard model? The Advanced model? 4c. Using Charts, create a 100% stacked bar chart that shows the percent of each activity's total cost that is allocated to each product. (Hint: This chart should refer to the percentages that you computed in cells B2 through C5.) (Your instructor may require you to upload this file in Part 6). Which of the following statements is true with respect to the chart? Complete this question by entering your answers in the tabs below. Req 48 Req 4C What percent of each of the four activities is allocated to the Standard model? The Advanced model? Standard Advanced Model Mode Assemble and pack % Machining Order processing % Setups