Required information Alternate Lab $9\mathrm{.}6$ Excel$-$On Your Own: Performing Sensitivity Analysis with Excel's Scenario Manager $[$The following information applies to the questions displayed below.$]$ Decision$-$Making Context Big Green Egg is one of the world's largest producers and international distributors of the highest$-$quality ceramic cooking system. The company produces and sells a variety of sizes of its ceramic grill online and through various retail outlets. In this lab, you will perform sensitivity analysis for operating income at Big Green Egg to determine how changes in units sold, sales price, and direct costs are likely to affect operating income. Required: Use Excel's Scenario Manager to perform sensitivity analyses for operating income at Big Green Egg based on data contained in Excel file Alt Lab $9\mathrm{.}6$ Data.xlsx$.$ Examine the following three scenarios: $1.5$ percent decrease in sales of large, XL $,$ and $2$ XL grills as well as a $5$ percent increase in sales of medium, minimax, small, and mini grills. $2.$ A $\backslash (\backslash$$ $50\backslash )$ increase in the price of all grills. $3.5$ percent decrease in labor hours for all products and a $2$ percent increase in direct materials costs. To complete this lab $,$ follow the steps in Lab $9\mathrm{.}6.$ Master the Data Use the Alt Lab $9\mathrm{.}6$ Data xlsx dataset. Perform the Analysis Alternate Labs $-$ On Your Own don't have step$-$by$-$step instruction. Apply your experience from the original lab. If needed, reference the text or eBook for instructions and steps from the original lab. Alternate Lab $9\mathrm{.}6($Algo$)$ Excel: Assessment Questions Answer the following questions based on the details provided. Answer is complete but not entirely correct$\mathrm{.}1.$ What is the cost of direct labor per hour for the medium sized Big Green Egg? Note: Round your answer to $2$ decimal places$\mathrm{.}2.$ Which of the proposed changes has the most significant impact on total budgeted operating income?Proposed changes in sales price$3.$ What is the total budgeted operating income after you have considered the possible $\backslash (5\backslash \%\backslash )$ decrease in labor hours for all products and a $2\backslash \%$ increase in direct materials costs? Note: Round your answer to $2$ decimal places.

Please use the excel sheet and creat three scenario manager.