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 lower right to return to Connect. 1 2 Given the following information complete a CVP analysis for JPL, Incorporated: 3 8 9 Required: 10 Use the data to answer the following. 11 12 (Use cells A4 to C7 from the given information to complete this question. All answers should be input and displayed as positive values.) 13 14 1. Compute the CM ratio and variable expense ratio. 15 Selling price per unit 16 Variable expenses per unit per unit 17 Contribution margin per unit per unit 18 19 CM ratio 20 Variable expense ratio 21 22 2. Compute the break-even sales. 23 Break-even in unit sales per unit 24 Break-even in dollar sales 25 26 3. Compute the margin of safety. 27 Margin of safety in dollars 28 Margin of safety percentage 29 30 4. Compute the degree of operating leverage. 31 Sales 32 Variable expenses 33 Contribution margin 34 Fixed expenses 35 Net operating income 36 37 Degree of operating leverage 38 39