Required:

Using the data from $2022$ in Gaming Table Cost Data, create an Excel spreadsheet to provide a sensitivity analysis of the effect $0$ operating profit of potential changes in demand for HFI Incorporated, ranging from a $20$ percent decrease to a $20$ percent increase Use Contribution Income Statements and What$-$If Sensitivity Analysis as a guide. Assume that two$-$thirds of fixed costs are manufacturing related; the remaining one$-$third are selling$-$related. The variable manufacturing cost per unit is $$30,$ while the variabl selling cost per unit is $$5.($Hint: Calculate the DOL for $2022$ at a sales volume of $2,880$ units.$)$

Using the spreadsheet you created, compute the new operating profit assuming a $10\%$ decrease in demand.

Complete this question by entering your answers in the tabs below.

$\backslash$table$[[\backslash$table$[[$Gaming Table$],[$Cost Data$]],\backslash$table$[[$Contribution$],[$Income$],[$Statements$]],\backslash$table$[[$What If$],[$Sensitivity$],[$Analysis$]]]]$

Using the data from $2022$ in Gaming Table Cost Data, create an Excel spreadsheet to provide a sensitivity analysis of the effect on operating profit of potential changes in demand for HFI Incorporated, ranging from a $20$ percent decrease to a $20$ percent increase. Use Contribution Income Statements and What$-$If Sensitivity Analysis as a guide. Assume that two$-$thirds of fixed costs are manufacturing related; the remaining one$-$third are selling$-$related. The variable manufacturing cost per unit is $$30,$ while the variable selling cost per unit is $$5.($Hint: Calculate the DOL for $2022$ at a sales volume of $2,880$ units.$)($Input your answer as a percentage rounded to $2$ decimal places $($i$.$e$.,0\mathrm{.}1567=15\mathrm{.}67\%).)$

Show less $$

$\backslash$table$[[DOL,\%$