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 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 5 60 $ 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 castles that collow Click here for a a brief tutorial on Charts in Excel en to the section called "Product Margin Analysis. Create formulas (within cells vitu cast pool to each product. Al c D E B Background Information Standard Number of units produced and sold 20,000 Direct labor-hours per unit 1.50 Machine-hours per unit 1 Average customer order size 400 Number of setups per customer order 1 Number of setup hours per setup 1 Advanced 10,000 1.50 2 50 1 3 F G Activity Rates Assemble and Pack: Manufacturing overhead cost(a) 5 292,500 Direct labor-hours (b) 45,000 Activity rate (a) (b) Machining Manufacturing overhead cost (a) $440,000 Machine-hours (b) 40,000 Activity rate (a) + (b) Product Margin Analysis Standard Advanced $ $ Total $ Order Processing Manufacturing overhead cost(a) Number of customer orders (b) Activity rate (a) (b) $ 256,250 250 USUS 1 2 Sales 3 Costs: Direct materials 5 Direct labor 16 Assemble and pack 17 Machining 18 Order processing 19 Setups 20 Total cost 21 Product margin Setups Manufacturing overhead cost (a)5357,500 Setup hours (b) Activity rate (a) * b) 650 Complete this question by entering your answers in the tabs below. Req Req 3B Reg 30 What formulas correctly calculate the cost assignments from the Order Processing and Setups activities to the Advanced model2 Order Processing =C3C6/G15 =C3+C6'G15 =C3-C6"G15 -C3/C6"G15 Setups =C3 C6 C8*G20 =(C3+C6)*C8'G20 -C3/C6 C8-G20 -C3/C6 C89620 Reg 38 > Reg 3A Reg 58 Req 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 Sotups Reg 3C >