A

B

C

D

E

F

G

C$7.$ A statement for requiremer

$2$ Given the following information complete a CVP analysis for JPL$,$ Incorporated:

$3$

$\backslash$table$[[$Unit sales,$11,200,$units$],[$Selling price per unit,$$75,$per unit$],[$Variable expenses per unit,$$45,$per unit$],[$Fixed expenses,$$210,000,]]$

$8$

$9$ Required:

$10$ Use the data to answer the following.

$11$

$12($Use cells A$4$ to $C7$ from the given information to complete this question. All answers should be input and displayed as positive values.$)$

$13$

$141.$ Compute the CM ratio and variable expense ratio.

$15$ Selling price per unit

$16$ Variable expenses per unit

per unit

$17$ Contribution margin per unit per unit

$8q,$ per unit

$19$

$0$

Variable expense ratio

$2$

$2.$ Compute the break$-$even sales.

$3$ Break$-$even in unit sales

$4$ Break$-$even in dollar sales

$63.$ Compute the margin of safety.

Margin of safety in dollars

Graded Worksheet