6 points D References Required: 1. Using the 20X1 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 $30, while the variable selling cost per unit is $5. (Hint: Calculate the DOL for 20X1 at a sales volume of 3,060 units.) 2. Use the Contribution Income Statements and What-If Sensitivity Analysis tabs as a guide, compute the new operating profit assuming a 10% decrease in demand. 3. Use the Goal Seek tool within Excel to determine which sales price would allow HFI to earn $100,000 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. Contbuum What If Gaming Table: income | Sensitivity ~ Required 1 Required2 | Required 3 : Statements @ Analysis Sales 100.00/%| $ 252,?'5(.'!'l 100.00 $ 23,250 Variable costs 46.67 117,950! 46.67 10,850 Total contribution margin 134.800! 53.33|% $ 12,400 53.33% is the contribution margin ratio Fixed costs ) 86,400 Operating profit 12,400 = 0.5333 x 23,250 6 points. References Required: 1. Using the 20X1 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 $30, while the variable selling cost per unit is $5. (Hint: Calculate the DOL for 20X1 at a sales volume of 3,060 units.) 2. Use the Contribution Income Statements and What-If Sensitivity Analysis tabs as a guide, compute the new operating profit assuming a 10% decrease in demand. 3. Use the Goal Seek tool within Excel to determine which sales price would allow HFI to earn $100,000 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. Contribution = What If Income : Sensitivity : Required 1 Required 2 Required 3 Statements : Analysis Gaming Table Cost Data 2460 30 86400 75} $ 10,800 2,160 35 86,400 75 0 2,160, 40 86,400 75 -10800 2,160 45 86,400 75| -21600 Return to question Required: 1. Using the 20X1 data in the Gaming Table Cost Data tab, create an Excel spreadsheet to provide a sensitivity analysis of the effect 6 on operating profit of potential changes in demand for HFI Incorporated, ranging from a 20 percent decrease to a 20 percent points 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 20X1 at a sales volume of 3,060 units.) 2. Use the Contribution Income Statements and What-If Sensitivity Analysis tabs as a guide, compute the new operating profit assuming a 10% decrease in demand. 3. Use the Goal Seek tool within Excel to determine which sales price would allow HFI to earn $100,000 operating profit, assuming that all the other cost information is the same as in Gaming Table Cost Data. o Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. . Contribution What If Gaming Mable: Income Sensitivity Required 1 Required 2 Required 3 Cost Data . Statements Analysis Use the Contribution Income Statements and What-If Sensitivity Analysis tabs as a guide, compute the new operating profit assuming a 10% decrease in demand