Extra credit 2

points Shipped Reterences Excel SIM: CVP Analysis _' Determine the break-even point. Compute the margin of safety and explain Its significance. 3' Compute the degree of operating leverage at a particular level of sales and explain how it can be used to predict changes in net operating income N CVF AnalySIs ~ Excel 1 E INSERT PAGE LAYOUT VIEW HOME FORMULAS DATA REVIEW Sign In\" D\" a F HE @QEW . b. A - Alignment Number Conditional Formal as can Cells Editing _ Formatting' Table' Styles' v ' Paste - \\'f B I Clipboard '3 Funl I'- Styles A A] v 5 > '4' fr Given the following information complete a CV? analysis v A B C D E Given the following information complete a analysis for JPL, Inc: ' Unit sales 11,200 units \\omunmhwuiw NNNN~......... hww~cwm~qmmtha 25 26 27 28 29 3 D 3 l 32 33 34 35 36 37 38 Selling price per unit Variable expenses per unit Fixed expenses Use the data to answer the following. Selling price per unit Variable expenses per unit Contribution margin per unit CM ratio Variable expense ratio 2. Compute the break-even point Break-even inunil sates 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 l. Compute the CM ratio and variable expense ratio $75 per unit $45 per unit $210,000 per unit per unit per unit units