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$ 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. You should also identify the break$-$even point, profit area and the loss

area on the chart. Please add a legend to the chart.

Please create the CVP graph $/$ chart on "Template" tab under CVP graph table.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$ 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. You should also identify the break$-$even point, profit area and the loss

area on the chart. Please add a legend to the chart.

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