Set up the following cell entries in Excel:

a$)(20$ points$)$ Use appropriate formulae in Excel to calculate Breakeven $($units$)$ and

Breakeven in dollars $($$$).$ Do not use Goal Seek. Be sure to use cell references in your

formulae; do not embed constants into your formulae. You may add other cells to your

Excel spreadsheet beyond those shown above.

b$)(15$ points$)$ Use Goal Seek to compute the number of units required to achieve a profit of

$$200.$ Adjust the model and$/$or parameters from part a as necessary. Be sure to put your

model for part b on a separate tab or in a separate workbook. Hint: You will almost

certainly need to add other cells to your Excel spreadsheet beyond those shown above $($or

added in part a$).$

c$)(15$ points$)$ Using Goal Seek, what should the selling price per unit be in order to realize a

"Breakeven in dollars $($$$)"$ amount of $$200?$ Use your model from part a$.$ Be sure to put

your solution $($and model$)$ for part c in a separate workbook. Hint: You should be able to

do this using only the cells shown above $($and any you added for part a$).$