In: Accounting
Spencer Kars provides shuttle service between four hotels near a
medical center and an international airport. Spencer Kars uses two
10-passenger vans to offer 12 round trips per day. A recent month’s
activity in the form of a cost-volume-profit income statement is
shown below.
Fare revenues ( 1,500 fares) | $ 34,500 | |||
Variable costs | ||||
Fuel | $ 5,603 | |||
Tolls and parking | 3,446 | |||
Maintenance | 956 | 10,005 | ||
Contribution margin | 24,495 | |||
Fixed costs | ||||
Salaries | 13,100 | |||
Depreciation | 1,500 | |||
Insurance | 1,517 | 16,117 | ||
Net income |
$ 8,378 |
A. Calculate the break-even point in dollars.
B. Calculate the break-even point in number of fares. (Round answer to 0 decimal places, e.g. 5,275.)
C. Without calculations, determine the contribution margin at the break-even point.
Fare revenues ( 1,500 fares) | 34500 | |
Variable costs | ||
Fuel | 5603 | |
Tolls and parking | 3,446 | |
Maintenance | 956 | 10,005 |
Contribution margin | 24,495 | |
Fixed costs | ||
Salaries | 13,100 | |
Depreciation | 1,500 | |
Insurance | 1,517 | 16,117 |
Net income | 8,378 | |
Requirement A | ||
CM Ratio = Contribution Margin/ Revenue X100 | ||
CM Ratio = 24,495/34,500 X100 | ||
=71% | ||
Break even point in dollars = Fixed Cost/ CM Ratio | ||
= 16,117/71% | ||
= 22,700 | ||
Requirement B | ||
Contribution per fare = Contribution margin / # of fares | ||
=24,495/1500 = 16.33 | ||
Break-even point in number of fares | ||
= Fixed cost / Contribution per fare | ||
= 16,117/16.33 | ||
= 987 fares |
Requirement C. Contribution margin at the break even point is fixed costs i.e., $16,117