Required Information Excel Analytics 05-01 (Static) Comparing Traditional and Activity-Based Product Costing (ROI) (LOS-1, 5- 3,5-4,5-5) [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 Advanced 20,000 10,000 $ 150 $ 200 $ 40 $ 60 $ 20 S 30 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 Excel Analytics 05-01 (Static) Part 2 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 Cost Pool Activity Rate per direct labor-hour Assemble and pack Machining Order processing Setups per machine-hour persu hour