(Solution) - Contribution Income Statements Using Excel Sensitivity Analysis -(2025 Original AI-Free Solution)

Discipline:

Type of Paper:

Academic Level: Undergrad. (yrs 3-4)

Paper Format: APA

Pages: 5 Words: 1375

Download Solution ($11.00) Write My Paper Afresh

Buy For $11.00

Paper Details

Contribution Income Statements Using Excel; Sensitivity Analysis; Goal Seek

Required
1. Using the data 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. Use Exhibits 9.2 and 9.6 as a guide.
2. Use the Goal Seek tool within Excel to determine which sales price would allow HFI to earn $100,000 operating profit, assuming that all the other cost information is the same as in Exhibit 9.1. Use Exhibit 9.5 as a guide.