Applying ExcelData Unit sales 10,000 unitsSelling price per unit $70 per unitVariable expenses per unit $42 per unitFixed expenses $140,000Enter a formula into each of the questions below. If your formulas are correct, you should get the correct answers to the following questions. Show your work and formulas.(a) What is the break-even in dollar sales?Break-even in dollar (b) What is the margin of safety percentage?Margin of safety percentage (c) What is the degree of operating leverage? (Round your answer to 2 decimal places.)Degree of operating leverage 3. 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%Percentage increase in the operating income 4. Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area looks like thisData Unit sales 12,000 unitsSelling price per unit $70 per unitVarable expenses per unit $42 per unitFixed expenses $140,000(a) What is the net operating income? (Negative amount should be indicated by a minus sign.)Net operating income (loss) (b) By what percentage did the net operating income increase?Percentage increase in net operating income %

Please see solution below

Explanation:

a. Break even in dollar sales

= [ Fixed cost / Contribution margin ] × Selling price per unit

Fixed cost = $140,000

Selling price per unit = $70

Variable expenses per unit = $42

BEP in dollars = [$140,000 / $70 - $42] × $70

= $350,000

b. Margin of safety percentage

= [ Current sales level - Break even point / Current sales level ] × 100

Current sales level = 10,000 units

Break even point = Fixed cost / Contribution margin

= $140,000 / $70 - $42

= 5,000 units

Margin of safety = [10,000 - 5,0000/10,000 ] × 100

= 50%

C. Degree of operating leverage.

= Contribution margin / Net operating income

Contribution margin = $70 - $42 = $28

Net operating income

Sales ($70 × 10,000)

$700,000

Less Variable cost ($42 × 10,000)

$420,000

Contribution margin

$280,000

Less Fixed cost

$140,000

Net operating income

$140,000

Degree of operating leverage = $280,000 / $140,000

= 20%

D. Percentage in net income

Sales ($70 × 12,000)

$840,000

Less variable cost

$420,000

Contribution margin

$420,000

Less fixed cost

$140,000

Net operating income

$280,000

Percentage change in net income

= [$140,000 / $280,000] × 100

= 50%

apex verified answer < 3

: : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : d. choose to : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : : :

i really hope this < 3 < 3 < 3