Given the following information complete a CVP analysis for JPL$,$ Inc.:

Unit sales $11,200$ units

Selling price per unit $$75$ per unit

Variable expenses per unit $$45$ per unit

Fixed expenses $$210,000$

Required:

Use the data to answer the following.

$($Use cells A$4$ to C$7$ from the given information, as well as A$15$ to B$37$ to complete this question. All answers should be input and displayed as positive values.$)$

$1.$ Compute the CM ratio and variable expense ratio.

Selling price per unit $$75$ per unit

Variable expenses per unit $45$ per unit

Contribution margin per unit $$30$ per unit

CM ratio $40\%$

Variable expense ratio $60\%$

$2.$ Compute the break$-$even sales.

Break$-$even in unit sales $7,000$ units

Break$-$even in dollar sales $$525,000$

$3.$ Compute the margin of safety.

Margin of safety in dollars $$315,000$

Margin of safety percentage

$4.$ Compute the degree of operating leverage.

Sales

Variable expenses

Contribution margin

Fixed expenses

Net operating income

Degree of operating leverage

if possible use Excel functions to asnewr the questions