Integrated Excel: Preparing a CVP Analysis

JPL$,$ Incorporated has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations.

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

$```$

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.

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

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

$3.$ Compute the margin of safety.

$4.$ Compute the degree of operating leverage.

Navigation:

$1.$ Use the Open Excel in New Tab button to launch this question.

$2.$ When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Given the following information complete a CVP analysis for JPL$,$ Incorporated:

Required:

Use the data to answer the following.

$($Use cells $\backslash (\backslash$mathrm$\{$A$4\}\backslash )$ to $\backslash (\backslash$mathrm$\{$C$7\}\backslash )$ from the given information to complete this question. All answers should be input and displayed as positive values.$)$

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

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

$3.$ Compute the margin of safety.

$4.$ Compute the degree of operating leverage.