Required:

$1.$ Using the $20$X$1$ data in the Gaming Table Cost Data tab, 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 $\backslash (\backslash$$ $30\backslash ),$ while the variable selling cost per unit is $\backslash (\backslash$$ $5\backslash ).($Hint: Calculate the DOL for $\backslash (20\backslash$times $1\backslash )$ at a sales volume of $3,480$ units.$)$

$2.$ Use the Contribution Income Statements and What$-$If Sensitivity Analysis tabs as a guide, compute the new operating profit assuming a $10\backslash \%$ decrease in demand.

$3.$ Use the Goal Seek tool within Excel to determine which sales price would allow HFI to earn $\backslash (\backslash$$ $100,000\backslash )$ operating profit, assuming that all the other cost information is the same as in Gaming Table Cost Data.

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

$1.$ Using the $20$X$1$ data in the Gaming Table Cost Data tab, 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 $\backslash (\backslash$$ $30\backslash ),$ while the variable selling cost per unit is $\backslash (\backslash$$ $5\backslash ).($Hint: Calculate the DOL for $20$X$1$ at a sales volume of $3,480$ units.$)$

$2.$ Use the Contribution Income Statements and What$-$If Sensitivity Analysis tabs as a guide, compute the new operating profit assuming a $10\backslash \%$ decrease in demand.

$3.$ Use the Goal Seek tool within Excel to determine which sales price would allow HFI to earn $\backslash (\backslash$$ $100,000\backslash )$ operating profit, assuming that all the other cost information is the same as in Gaming Table Cost Data.

Complete this question by entering your answers in the tabs below. $1.$ Using the $20$X$1$ data in the Gaming Table Cost Data tab, 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 $\backslash (\backslash$$ $30\backslash ),$ while the variable selling cost per unit is $\backslash (\backslash$$ $5\backslash ).($Hint: Calculate the DOL for $\backslash (20\backslash$times $1\backslash )$ at a sales volume of $3,480$ units.$)$

$2.$ Use the Contribution Income Statements and What$-$If Sensitivity Analysis tabs as a guide, compute the new operating profit assuming a $10\backslash \%$ decrease in demand.

$3.$ Use the Goal Seek tool within Excel to determine which sales price would allow HFI to earn $\backslash (\backslash$$ $100,000\backslash )$ operating profit, assuming that all the other cost information is the same as in Gaming Table Cost Data.

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

$1.$ Using the $20$X$1$ data in the Gaming Table Cost Data tab, 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 $\backslash (\backslash$$ $30\backslash ),$ while the variable selling cost per unit is $\backslash$$$5.($Hint: Calculate the DOL for $20$X$1$ at a sales volume of $3,480$ units.$)$

$2.$ Use the Contribution Income Statements and What$-$If Sensitivity Analysis tabs as a guide, compute the new operating profit assuming a $10\backslash \%$ decrease in demand.

$3.$ Use the Goal Seek tool within Excel to determine which sales price would allow HFI to earn $\backslash (\backslash$$ $100,000\backslash )$ operating profit, assuming that all the other cost information is the same as in Gaming Table Cost Data.

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

Using the $20$X$1$ data in the Gaming Table Cost Data tab, 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 $\backslash (\backslash$$ $30\backslash ),$ while the variable selling cost per unit is $\backslash (\backslash$$ $5\backslash ).($Hint: Calculate the DOL for $\backslash (20\backslash$times $1\backslash )$ at a sales volume of $3,480$ units.$)$ Note: Input your answer as a percentage rounded to $2$ decimal places $($i$.$e$.,\backslash (0\mathrm{.}1567=15\mathrm{.}67\backslash \%\backslash )).$ Required:

$1.$ Using the $20$X$1$ data in the Gaming Table Cost Data tab, create an Excel spreadsheet to p