JPL, Inc. 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. Here are some tips for using Excel: Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: +(plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and/ (forward slash to divide). For example, if you entered =B4+B5 in a blank cell, the formula would add the values from those cells and output the result. Given the following information complete a CVP analysis for JPL, Inc.: Unit sales Selling price per unit Variable expenses per unit Fixed expenses Required: 11,200 units $75 per unit $45 per unit $210,000 Use the data to answer the following. (Use cells A4 to C7 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. Selling price per unit Variable expenses per unit Contribution margin per unit per unit per unit per unit CM ratio Variable expense ratio 2. Compute the break-even sales. Break-even in unit sales Break-even in dollar sales 3. Compute the margin of safety. Margin of safety in dollars 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 units