Open the template file called breakeven using Microsoft Excel. Examine the formulas in the file to understand the relationships between the variables (such as sales price per unit, manufacturing cost per unit, and fixed monthly expenses) and the outputs (such as breakeven point and revenue at break-even point). Run at least three different scenarios, changing the inputs as desired and noting the outputs. Write a short paper to summarize the results, including screen shots of the three scenarios and your opinions on sensitivity analysis in general and in this example.

  LO.1