80.2K

Verified Solution

Link Copied!

in excel equation pls!

Excel McGraw Hill Excel Question - Saved File Home Insert Draw Formulas Data Review View Calibri B Currency 815 fx A B C D E G H 1 2 Given the following information complete a CVP analysis for JPL, Inc.: 3 4 Unit sales 11,200 units 5 Selling price per unit 6 Variable expenses per unit $75 per unit $45 per unit $210,000 7 Fixed expenses B 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 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. A Graded Worksheet Catering Automatic Sunny Search (Alt+Q) Help + Editing McGraw Hill Excel Question - Saved Home Insert Draw Calibri B15 V X fx A 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 40 41 Students: The scratchpad area is for you to do any additional work you need to solve 42 Nothing in this area will be graded, but it will be submitted with your assignment. 12 Excel File Formulas 11 V B Data Review Vie B A C D units

Answer & Explanation Solved by verified expert

See Answer