Open 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 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$ on Answers Tab

CVP graph $/$ chart:

a$.$ Complete the CVP graph table.

b$.$ Prepare a CVP graph $/$ chart using Excel. Your final product should have a chart

title, vertical axis title and a horizontal axis title. Be sure to use the correct format $($do

not google as what you find on the internet is likely not the correct content$/$format that

you learned in Chapter $3$ of this class$)1\mathrm{.}0"-$ Single $"$

Bullets & Lists

Please create the CVP graph $/$ chart on "Template" tab under CVP graph table.

Instructions on how to use Goal Seek and Solver as well as how to create the

chart are on the first three tabs of the Excel file "Donaldson Company".