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 3,000 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 2023 Fixed costs (per year) Selling price Variable cost Planned production $ 84,000 $ 84,000 75 35 3,000 units 3,300 units Planned sales volume 3,000 units 3,300 units Gaming Table Cost Data Contribution Income Statements What If Sensitivity Required 1 Required 2 Analysis 2022 2023 Amount Percent Amount Percent Change Notes Sales 225,000 100.00% $ 247,500 100.00% $ 22,500 Variable costs 105,000 46.67 115,500 46.67 Total contribution margin $ 120,000 53.33 % $ 132,000 53.33 % S 10,500 12,000 53.33% is the contribution margin Fixed costs 84,000 84,000 Operating profit $ 36,000 $ 48,000 0 S 12,000 12,000 0.5333 22,500 Complete this question by entering your answers in the tabs below. Gaming Table Cost Data Contribution Income Statements What If Sensitivity Analysis Required 1 Required 2 Variable Cost Units Sold per Unit Fixed Costs Selling Price per Unit Operating Profit 2,100 $ 30 $ 84,000 $ 75 S 10,500 2,100 35 84,000 75 0 2,100 40 84,000 75 -10500 2,100 45 84,000 75 -21000 < Contribution Income Statements Required 1 > 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 3,000 units.) (Input your answer as a percentage rounded to 2 decimal places (i.e., 0.1567 = 15.67%).) DOL % < What If Sensitivity Analysis Required 2 > Complete this question by entering your answers in the tabs below. Gaming Table Income Contribution What If Sensitivity Required 1 Required 2 Analysis Cost Data Statements Using the spreadsheet you created, compute the new operating profit assuming a 10% decrease in demand. Operating profit < Required 1 Required 2 Show less