Contribution Format Income StatementOpen the Excel file and go to the "Template" tab.

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

company's 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.$

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$