$1$ Chapter $5$: Applying Excel

$2$

$3$ Data

$4$ Unit sales

$\backslash$table$[[45,000,$units$],[$$$70,$per unit$],[$$$55,$per unit$],[$$$340,000,]]$

$5$ Selling price per unit

$6$ Variable expenses per unit

$7$ Fixed expenses

$\backslash$table$[[,],[45,000,$units$],[$$$70,$per unit$],[$$$55,$per unit$],[$$$340,000,],[,]]$

Enter a formula into each of the gray cells below. Be sure to format the cells appropriatey. For example, if the cell has a dollar

$9$

amount in it$,$ then the cell should be formatted for dollars.

$10$ Review Problem: CVP Relationships

$11$

Review Problem: CVP Relationships

$12$ Compute the CM ratio and variable expense ratio

$13$ Selling price per unit

$14$ Variable expenses per unit $$ per unit

$15$ Contribution margin per unit per unit

$16$

per unit

$17$ CM ratio

$18$

$19$

$20$ Compute the break$-$even

$21$ Break$-$even in unit sales

$$

Break$-$even in dollar sales

$\backslash$table$[[$