In: Accounting
CVP Analysis | |||
Data | |||
Unit sales | 20,000 | units | |
Selling price per unit | $60 | per unit | |
Variable expenses per unit | $45 | per unit | |
Fixed expenses | $240,000 | ||
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 | ? | per unit | |
Variable expenses per unit | ? | per unit | |
Contribution margin per unit | ? | per unit | |
CM ratio | ? | ||
Variable expense ratio | ? | ||
Compute the break-even | |||
Break-even in unit sales | ? | units | |
Break-even in dollar sales | ? | ||
Compute the margin of safety | |||
Margin of safety in dollars | ? | ||
Margin of safety percentage | ? | ||
Compute the degree of operating leverage | |||
Sales | ? | ||
Variable expenses | ? | ||
Contribution margin | ? | ||
Fixed expenses | ? | ||
Net operating income | ? | ||
Degree of operating leverage | ? | ||
Particulars | Amount | ||||
Unit sales | 20000 | ||||
Selling price(PU) | 60 | ||||
Variable cost per unit | 45 | ||||
Fixed cost | 240000 | ||||
Particulars | Amount | Remarks | |||
Selling price per unit(SP) | 60 | ||||
Variable cost per unit(VC) | 45 | ||||
Contribution margin per unit(CM) | 15 | ||||
Contribution margin ratio(CM/SP*100)(P/V ratio) | 0.25 | ||||
Variable cost ratio(VC/SP) | 0.75 | ||||
Break Even sales( units) | 16000 | ||||
Break Even sales( $) | 960000 | ||||
Margin of safety(units)(Sales-BES) | 4000 | (20000-16000) | |||
Margin of safety($)(Sales-BES) | 240000 | (20000*60-960000) | |||
Computation of Operating Leverage | |||||
Particulars | Units | Amount per unit | Amount | ||
a | Sales | 20000 | 60 | 1200000 | |
b | Variable expenses | 20000 | 45 | 900000 | |
c | Contribution margin | 15 | 300000 | ||
d | Fixed Expenses | 240000 | |||
e | Net operating income | 60000 | |||
f | Operating Leverage(c/e) | 5 Times | |||
Break even sales( in units) = Fixed cost/Contribution per unit | |||||
Break even sales( in $) = Fixed cost/P/V ratio | |||||
Margin of safety=Sales- Break even sales | |||||
Operating Leverage=Contribution/Net operating income(EBIT) | |||||
Variable cost ratio=Variable cost/sales | |||||
Contribution margin ratio=Contribution per unit/Sale value per unit |