Chapter : Applying Excel
Data
Unit sales
tableunits$per unit$per unit$
Selling price per unit
Variable expenses per unit
Fixed expenses
tableunits$per unit$per unit$
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
amount in it then the cell should be formatted for dollars.
Review Problem: CVP Relationships
Review Problem: CVP Relationships
Compute the CM ratio and variable expense ratio
Selling price per unit
Variable expenses per unit per unit
Contribution margin per unit per unit
per unit
CM ratio
Compute the breakeven
Breakeven in unit sales
Breakeven in dollar sales
table
