Required: 1. 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,760 units.) 2. 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. Gaming Table Cost Data Contribution. Income Statements What If Sensitivity Required 1 Required 2 Analysis Per Unit 2022 Fixed costs (per year) $ 74,400 $ 2023 74,400 Selling price $ 75 Variable cost 35 Planned production Planned sales volume 2,760 units 2,760 units 3,020 units 3,020 units Complete this question by entering your answers in the tabs below. Gaming Table Cost Data Contribution Income Statements What If Sensitivity Required 1 Required 2 Analysis 2022 2023 Amount Percent Amount Percent Change Notes Sales $ 207,000 100.00 % $ 226,500 100.00 % $ Variable costs 96,600 46.67 105,700 46.67 19,500 9,100 Total contribution margin $ 110,400 53.33 % $ 120,800 53.33 % $ 10,400 53.33% is the contribution margin ratio Fixed costs 74,400 74,400 0 Operating profit $ 36,000 $ 46,400 S 10,400 10,400 0.5333 x 19,500 Gaming Table Cost Data Contribution Income Statements What If Sentitivity Analysis Required 1 Required 2 Variable Cost Selling Price Operating Units Sold per Unit Fixed Costs per Unit Profit 1,860 $ 30 $ 74,400 $ 75 $ 9,300 1,860 35 74,400 75 0 1,860 40 40 74,400 1,860 45 74,400 775 -9300 -18600 Gaming Table Cost Data Contribution Income Statements What If Sensitivity Analysis Required 1 Required 2 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,760 units.) (Input your answer as a percentage rounded to 2 decimal places (i.e., 0.1567 = 15.67%).) DOL % Complete this question by entering your answers in the tabs below. Gaming Table Cost Data Contribution Income Statements What If Sensitivity Required 1 Required 2 Analysis Using the spreadsheet you created, compute the new operating profit assuming a 10% decrease in demand. Operating profit Show less A