1 compute the CM Arobo and variable expense ratio. \begin{tabular}{|c|c|c|} \hline Selline price per unit & & pef unit \\ \hline Varbble expewses per unit & \multirow{2}{*}{r} & pet unit \\ \hline Cortribution margin per unit & & per unit \\ \hline & \multirow{4}{*}{r} & \\ \hline CMratio & & \\ \hline Warable exponse ratio & & z \\ \hline & & \\ \hline \end{tabular} 22 2. Compute the break-eved ales. 22232.Computethebreak-eve Ereak-even in unit sales 24 Erohieverin dofter wates 26 3. Combute the marrin of sulety. 27 Margin of sadety in dolars 28 Marcin of sefety pencentape 30 e. Compute the dectee ct operating leverage. 31 Sales 32 Variable expenses 13 Contribution marein 36 fived expenis: 35 Net aperating iocome = A Groded Worksheet 4. Compute the degree of operating leverage. Sales Variable expenses 33 Contribution margin Fixed expenses Net operating income Degree of operating leverage 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: 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 fower fight to return to Connect. Given the following information complete a CVP analysis for JPL, Incorporated: \begin{tabular}{l|r|l|} \hline Unit sales & 11,200 & units \\ \hline Selling price per unit & $75 & per unit \\ \hline Variable expenses per unit & $45 & per unit \\ \hline Fixed expenses & $210,000 & \\ \hline \end{tabular} Use the data to answer the following. (Use cells A4 to Cl from the eiven information to complete this question. All answers should be input and displayed as posittive values.)