Chapter $5$: Applying Excel: Exercise $($Part $2$ of $2)($Algo$)$

Change all of the numbers in the data area of your worksheet so that it looks like this:

If your formulas are correct, you should get the correct answers to the following questions.

$($a$)$ What is the break$-$even in dollar sales?

$($b$)$ What is the margin of safety percentage?

$($c$)$ What is the degree of operating leverage?

Note: Round your answer to $2$ decimal places.

Using the degree of operating leverage and without changing anything in your worksheet, calculate the

percentage change in net operating income if unit sales increase by $20\%.$

Confirm your calculations in Requirement $3$ above by increasing the unit sales in your worksheet by $20\%$ so that the Data area looks like this:

$($a$)$ What is net operating income?

Note: Negative amount should be indicated by a minus sign.