This was the only information that I received for this question.

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,820 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 Analysis Required 1 Required 2 Per Unit 2022 2023 $ 76,800 $ 76,800 75 Fixed costs (per year) Selling price Variable cost Planned production 35 2,820 units 2,820 units 3,090 units 3,090 units Planned sales volume 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 2022 2023 Amount Percent Amount Percent Sales $ 100.00 % $ 100.00 % Variable costs Change Notes 20,250 9,450 $ 10,800 53.33% is the contribution margin ratio 46.67 211,500 98,700 112,800 76,800 46.67 231,750 108,150 123,600 76,800 Total contribution margin $ 53.33% $ 53.33% Fixed costs 0 Operating profit 36,000 $ 46,800 $ 10,800 10,800 = 0.5333 x 20,250 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 Selling Price Operating Profit Units Sold per Unit Fixed Costs per Unit 1,920 $ 30 $ 76,800 $ 75 $ 9,600 1,920 35 75 0 76,800 76,800 1,920 40 75 -9600 1,920 45 76,800 75 -19200 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 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,820 units.) (Input your answer as a percentage rounded to 2 decimal places (i.e., 0.1567 = 15.67%).) Show less A DOL % 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 Using the spreadsheet you created, compute the new operating profit assuming a 10% decrease in demand. Operating profit