C D 1 Unit 3 Application Assignment 2 Chapter 5: Applying Excel 4 Data 5 Unit sales 6 Selling price per unit 7 Variable expenses per unit 8 Fixed expenses 20,000 units 560 per unit $45 per unit $240,000 Enter a formula into each of the cells marked with a ? below. Be sure to format the cells appropriatey. For example, if the cell has a dollar amount in it, then the cell should be 10 formatted for dollars. 11 12 Review Problem: CVP Relationships 14 Compute the CM ratio 15 Selling price per unit 16 Variable expenses per unit 17 Contribution margin per unit $60 per unit $45 per unit per unit 19 CM ratio ? units 21 Compute the break-even 22 Break even in unit sales 23 Break-even in dollar sales 24 25 Compute the margin of safety 26 Margin of safety in dollars 27 Margin of safety percentage Chapter 5 Form