Chapter $6$: Applying Excel

Data

Unit sales

Selling price per unit

Variable expenses per unit

Fixed expenses

B

C

D

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

Enter a formula into each of the cells marked with a $?$ below

Review Problem: CVP Relationships

Compute the CM ratio and variable expense ratio

Selling price per unit

Variable expenses per unit

$\begin{array}{cc}?p& ?\\ ?p& ?\\ ?& ?\end{array}$

Contribution margin per unit

CM ratio

Variable expense ratio

Compute the break$-$even

Break$-$even in unit sales

Break$-$even in dollar sales

Compute the margin of safety

Margin of safety in dollars

Margin of safety percentage

$27$

$28$ Compute the degree of operating leverage

$29$

$30$

$31$

$32$

$33$

$34$

$35$

$36$

$37$

Degree of operating leverage

Chapter $6$ Form