Given the following data, what formulas would one use to complete a spreadsheet that shows the related CVP Analysis computations? Thanks!

Course Documents-MA \ D Study Guide for Test-2-, ?D Chapter 5 CVP Excel x \. x ox?0.32041458693813785 1527375348486 Caibri Blu- .2.?. Alignment Number Cordboral Formetas. Cell Cells Editing Formatting TableStyles Styies - A1 | i | X ? | Given the following information complete a CVP analysis 1 Given the following information complete a CVlanalysis 2 for JPL, Inc 4 Unit sales 11,200 units Selling price per unit 6 Variable expenses per unit $75 per unit 45 per unit Fixed expenses $210,000 9 Use the data to answer the following. 11 1. Compute the CM ratio and variable expense ratio 2 Selling price per unit 1 Variable expenses per unit 14 Contribution margin per unit per unit per unit per unit 16 CM ratio 17 Varlable expense ratio 19 2. Compute the break-even paint 20 Break-even in unit sales 21 Break-even in dollar sales units 23 3.Compute the margin of s n doll Sheeti eBook & Resources