Help Save & Exit Submit Chapter #5-In-Class Assignment 1 po Sepped References Saved 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 "-85" into a blank cell, the formula would output the value from cell 85. 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 84-85 in a blank cell, the formula would add the values from those cells and output the result 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 Open Excel in new tab News Translate YouTube https 201 Saved Search (Option Q Formulas Data IMPORTANT: Answer grading policy B Accessibility tab summary: Fina B in complete a CVP analysis for IP For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an sign. 2. Reference cells, instead of entering values. Example: B3+C3 11,200 unit $75 per $45 per $210,000 OK ollowing given information, as well as A15 to 837 to complete this question. All fed as positive values.) presented in rows 9 to 14. A table for student prese MMcGraw Hill Check Answers Check My Work Legend Graded celt: Leave blank if ow needed. Scratchoad: Use as a non-go workspace le expense ratio per unit per unit per unit Excel McGraw Hill Excel Question - Saved Search (Option + Q) File Home Insert Draw Formulas Data Review View Help v Calibri A1 AJ 11 B~ Av Xfx Accessibility tab summary: Financial information for JPL incorporated, is p B C D 1 2 Given the following information complete a CVP analysis for JPL, Inc.: 3 34 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 8 9 Required: 11,200 units $75 per unit $45 per unit $210,000 E F 10 Use the data to answer the following. 11 (Use cells A4 to C7 from the given information, as well as A15 to B37 to complete this question. All 12 answers should be input and displayed as positive values.) 13 14 1. Compute the CM ratio and variable expense ratio. 16 15 Selling price per unit 17 Contribution margin per unit 18 per unit Variable expenses per unit per unit per unit 19 CM ratio 20 Variable expense ratio 21 22 23 2. Compute the break-even sales. Break-even in unit sales 24 Break-even in dollar sales 25 Graded Worksheet Calculation Mode: Automatic Workbenk C units File Home Insert Draw Formulas Data Review View Help Calibri A1 BA X Accessibility tab summary: Financial information for JPL incorpor 9 B C D E F 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 40 41 Students: The scratchpad area is for you to do any additional work you need to solve this question or 42 Nothing in this area will be graded, but it will be submitted with your assignment 43 44 45 46 47 48 49 50 5 Graded Worksheet + Calculation Mode Auto esc F1 1 @2 2 ab Q lock A * 20 " #3 3 54 $ 4 % 85 " W E R T S D F .