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,400 units.) (Input your answer as a percentage rounded to 2 decimal places (i.e., 0.1567 = 15.67%).)

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.

Calculate DOL for 2022.

Using the spreadsheet you created, compute the new operating profit assuming a 10% decrease in demand.

It is not accepting 3.56 as the DOL and also is not accepting 17400 as the operating costs with the 10% decrease. Please help.

Assessment Tool iFrame to (por your/ Selling price Variable cost Planned production Planned sales volume Per Unit 75 35 2022 69,000 2,400 units 2,400 units 2023 $ 69,000 2,600 units 2,600 units Sales Variable costs Total contribution margin Fixed costs Operating profit $ $ Amount 2022 180,000 84,000 96,000 60,000 36,000 Percent 100.00 % $ 46.67 53.33 % $ Amount 2023 195,000 91,000 104,000 60,000 44,000 Percent 100.00 % 46.67 53.33 % $ $ $ Change Notes 15,000 7,000 8,000 53.33% is the contribution margin ratio 0 8,000 $8,000 = 0.5333 $15,000 Units Sold Variable Cost per Unit 1,500 $ 1,500 1,500 1,500 30 35 40 45 Fixed Costs $ 69,000 69,000 69,000 69,000 Selling Price per Unit $ 75 75 75 75 Operating Profit $ 7,500 0 -7,500 -15,000