$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 $$43,000.$

c$.$ What would be the company$$s margin of safety $($in dollars$)$ when the target profit is $ $43,000?$

$2.$ Using Solver:

a$.$ Calculate the unit sales required to attain a margin of safety percentage of $20\%.$

b$.$ Restore the original values in your Excel file. Calculate the unit sales required to attain a profit margin of $5\%\mathrm{.}9$ Contribution Format Income Statement