Open the Excel file and go to the Template tab.

1. Using Goal Seek:

a. Calculate the unit sales required to break even.

b. Calculate the unit sales required to attain a target profit of $25,000. What would be the companys margin of safety (in dollars) at this level of sales?

c. Calculate the selling price per unit required to attain net operating income of $30,000.

d. Calculate the variable expense per unit required to attain net operating income of $30,000.

e. Calculate the unit sales required to attain a margin of safety of $75,000.

2. Using Solver:

a. Calculate the unit sales required to attain a margin of safety percentage of 15%.

b. Restore the original values in your Excel file. Calculate the unit sales required to attain a profit margin of 8%.

c. Restore the original values in your Excel file. Calculate the selling price per unit required to attain a profit margin of 10%.

d. Restore the original values in your Excel file. Calculate the variable expense per unit required to attain a profit margin of 6%.

Please enter the answers for part 1 and 2