Required information 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: Number of units produced and sold Selling price per unit Direct materials per unit Direct labor cost per unit Direct labor-hours per unit Standard 20,000 $ 150 $ 40 $ 30 1.50 Advanced 10,000 $ 200 $ 60 S 30 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 brief tutorial on Charts in Excel Activity Measure Assemble and pack Machining Order processing Setups Activity Measure Direct labor hours Machine-hours Number of customer orders Setup hours Manufacturing Overhead $ 292,500 440,000 256,250 357,500 $1,346,250 The production manager also provided the following additional information with respect to the company's two products: Standard 1.0 400 2 Advanced 2.0 Machine-houro per unit Average customer order size (in units) Number of setups per customer order Number of setup hours per setup 50 1 3 hala 2a. Go to the tab titled "Activity Based Approach." Within the Activity Rates section of this tab, create formulas that calculate the activity rates in cells G5, G10, G15, and G20. 2b. What is the activity rate for each of the four activities? (Round your answers to 2 decimal places.) Activity Rate Activity Cost Pool Assemble and pack Machining Order processing Setups per direct labor-hour per machine-hour per customer order per setup hour Complete this question by entering your answers in the tabs below. Req 3A Req 3B Reg 3C What formulas correctly calculate the cost assignments from the Order Processing and Setups activities to the Advanced model? Order Processing -C3C6/ G15 =C3+C6'615 =C3-C6'G15 -C3/C6'G15 Setups -03-C6"CB'G20 =(C3+C6)*CB*G20 -C3/C6*C8-G20 -C3/C6 C8'G20 Req 3B > Complete this question by entering your answers in the tabs below. Req 3A Req 3B Reg 3C How much overhead cost is assigned from each of the four activities to the Standard and Advanced models? Standard Model Advanced Model Assemble and pack Machining Order processing Setups Complete this question by entring your answers in the tabs below. Reg 3A Req 3B Req 30 What is the product margin for the Standard model? The Advanced model? Standard Model Advanced Model Product margin Complete this question by entering your answers in the tabs below. Req 4B Req 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 CS.) Which of the following statements is true with respect to the chart? The Assemble and Pack cost allocation percentages match the overhead cost allocation percentages using the plantwide approach The Machining cost allocation percentages match the overhead cost allocation percentages using the plantwide approach The Order Processing cost allocation percentages match the overhead cost allocation percentages using the plantwido approach The Setups cost allocation porcentages match the overhead cost allocation percentages using the plantwide approach Complete this question by entering your answers in the tabs below. Reg SB Req 5D Based on your completed bar chart, which model is overcosted using the plantwide approach? Which model is underco The plantwide approach The plantwide approach the Standard model the Advanced model Required information 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: Number of units produced and sold Selling price per unit Direct materials per unit Direct labor cost per unit Direct labor-hours per unit Standard 20,000 $ 150 $ 40 $ 30 1.50 Advanced 10,000 $ 200 $ 60 S 30 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 brief tutorial on Charts in Excel Activity Measure Assemble and pack Machining Order processing Setups Activity Measure Direct labor hours Machine-hours Number of customer orders Setup hours Manufacturing Overhead $ 292,500 440,000 256,250 357,500 $1,346,250 The production manager also provided the following additional information with respect to the company's two products: Standard 1.0 400 2 Advanced 2.0 Machine-houro per unit Average customer order size (in units) Number of setups per customer order Number of setup hours per setup 50 1 3 hala 2a. Go to the tab titled "Activity Based Approach." Within the Activity Rates section of this tab, create formulas that calculate the activity rates in cells G5, G10, G15, and G20. 2b. What is the activity rate for each of the four activities? (Round your answers to 2 decimal places.) Activity Rate Activity Cost Pool Assemble and pack Machining Order processing Setups per direct labor-hour per machine-hour per customer order per setup hour Complete this question by entering your answers in the tabs below. Req 3A Req 3B Reg 3C What formulas correctly calculate the cost assignments from the Order Processing and Setups activities to the Advanced model? Order Processing -C3C6/ G15 =C3+C6'615 =C3-C6'G15 -C3/C6'G15 Setups -03-C6"CB'G20 =(C3+C6)*CB*G20 -C3/C6*C8-G20 -C3/C6 C8'G20 Req 3B > Complete this question by entering your answers in the tabs below. Req 3A Req 3B Reg 3C How much overhead cost is assigned from each of the four activities to the Standard and Advanced models? Standard Model Advanced Model Assemble and pack Machining Order processing Setups Complete this question by entring your answers in the tabs below. Reg 3A Req 3B Req 30 What is the product margin for the Standard model? The Advanced model? Standard Model Advanced Model Product margin Complete this question by entering your answers in the tabs below. Req 4B Req 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 CS.) Which of the following statements is true with respect to the chart? The Assemble and Pack cost allocation percentages match the overhead cost allocation percentages using the plantwide approach The Machining cost allocation percentages match the overhead cost allocation percentages using the plantwide approach The Order Processing cost allocation percentages match the overhead cost allocation percentages using the plantwido approach The Setups cost allocation porcentages match the overhead cost allocation percentages using the plantwide approach Complete this question by entering your answers in the tabs below. Reg SB Req 5D Based on your completed bar chart, which model is overcosted using the plantwide approach? Which model is underco The plantwide approach The plantwide approach the Standard model the Advanced model