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 Selling price per unit 11,200 units $ 75 per unit $ 45 per unit Variable expenses per unit $ 210,000 Fixed expenses 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. AL A ACCESSIDnity tab summary.colysis for incorporated is presented to. A stateme B C D E 1 2 Given the following information complete a CVP analysis for JPL, Incorporated: 3 4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 11,200 units $75 per unit $45 per unit $210,000 8 9 G H Required: 10 Use the data to answer the following. 11 (Use cells A4 to C7 from the given information to complete this question. All answers should be input and displayed as 12 positive values.) 13 14 1. Compute the CM ratio and variable expense ratio. 16 15 Selling price per unit 17 Contribution margin per unit per unit Variable expenses per unit 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 24 Break-even in dollar sales 25 26 3. Compute the margin of safety. 1 Graded Worksheet Calculation Mode: Automatic Workbook Statistics units + B 13 14 1. Compute the CM ratio and variable expense ratio. 15 Selling price per unit 16 Variable expenses per unit 17 Contribution margin per unit 18 19 CM ratio 20 Variable expense ratio 21 22 2. Compute the break-even sales. 23 Break-even in unit sales 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 and = Graded Worksheet + Calculation Mode: Automatic Workbook Statistics per unit per unit per unit units D E H +