$2$ Required information To complete this activity, you will need to have Excel installed on your computer. This exercise requires you to work in Excel and answer questions in Connect. You will read a brief scenario and then download an Excel file that you will need to complete the requirements in Parts $1$ through $5$ of this exercise. In Part $6,$ your instructor may require you to upload your completed workbook. Some of the requirements include brief video tutorials on using Excel functions. After viewing the tutorials, you will then use what you learned to work directly in Excel to answer the required questions in Connect. $[$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: The company considers all of its manufacturing overhead costs $(\backslash (\backslash$$ $1,346,250\backslash ))$ to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor$-$hours. Cary's production manager has suggested replacing the company's current cost system with an activity$-$based costing system that assigns all of the company's manufacturing overhead costs to four activity cost pools as follows $($the company does not have any organization$-$sustaining costs or unused capacity costs$)$: Cary's production manager has suggested replacing the company's current cost system with an activity$-$based costing system that assigns all of the company's manufacturing overhead costs to four activity cost pools as follows $($the company does not have any organization$-$sustaining costs or unused capacity costs$)$:Manufacturing Overhead

The production manager also provided the following additional information with respect to the company's two products:

Use the Excel workbook titled "ExcelAnalytics$\_$ComparingTraditionalandActivityBasedProductCosting$\_$Template" to complete requirements $2$ a $.$ and $2$ b $.$

$2$a$.$ Navigate to the "Activity Based Approach." tab of the Excel workbook. Within the Activity Rates section of this tab, create formulas that calculate the activity rates in cells G$5,$ G$10,$ G$15,$ and G$20.$

$2$b$.$ On the table below, enter the activity rate for each of the four activities as calculated by the formulas you created in requirement $2$a$.$

Note: Round your answers to $\backslash (\backslash$mathbf$\{2\}\backslash )$ decimal places.