1. Using the data from 2019 in Exhibit 9.1, create an Excel spreadsheet to provide a sensitivity analysis of the effect on operating profit of potential changes in demand for HFI Inc., raging from a 20 percent decrease to 20 percent increase. Use Exhibits 9.2 and 9.6 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 2019 at a sales volume of 2,400 units. How does this figure help you interpret your sensitivity analysis results?)

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

3. Use the Goal Seek tool within Excel to determine the sales price per unit that would allow HFI to earn an operating profit of $100,000, assuming that all the other cost information is the same as in Exhibit 9.1. Use Exhibit 9.5 as a guide.