In: Accounting
a college produces and sells two types of delivery for accounting classes, Daytime Delivery & Online Delivery. The company records show the following monthly data relating to these two programs:
Daytime |
Online |
|||||
Selling Price per Course |
$350 |
$ 330 |
||||
Variable Costs |
$300 |
$ 100 |
||||
Expected Monthly Sales |
600 |
200 |
||||
Total Monthly Fixed Cost (Common to Both) |
$30,000 |
|||||
Determine the sales mix based on Sales units as a % (or decimal)
Daytime _________ Online __________
(a) Determine the weighted-average contribution margin ratio.
(b) Determine the monthly sales in $ to break even.
(c) Determine how the number of registrations of each type of program are sold at the breakeven point.
Round to a whole unit.
______________Daytime
________________Online
Sales Mix | |||||
Day Time | Online | Total | |||
Expected Monthly sales | 600 | 200 | 800 | ||
Sales Mix | 75% | 25% | 100% | ||
(600/800) X 100 | (200/800) X 100 | ||||
Weighted average contribution Margin Ratio | |||||
Day Time | Online | Total | |||
A | Sales Price Per Course | 350 | 330 | ||
B | Variable Expenses | 300 | 100 | ||
C=A-B | Contribution Margin per unit | 50 | 230 | ||
D=(C/A) X 100 | Contribution Margin ratio | 14% | 70% | ||
E | Expected Monthly sales | 600 | 200 | 800 | |
F | Sales Mix | 75% | 25% | ||
G=E X F | 11% | 17% | |||
Weighted average contribution Margin Ratio | 28% | ||||
(11%+17%) | |||||
Break Even Sales in Dollars(Break Even Point) | |||||
Tota Fixed Cost | 30000 | ||||
Weighted average contribution Margin Ratio | 28% | ||||
Break Even Sales in Dollars | 106615 | ||||
(Total Fixed Cost/Weighted average Contribution Margin Ratio) | |||||
Breakdown of the break-even sales revenue: | |||||
(B-E point x Sales revenue Mix) | |||||
Day Time (106615 x 75%) | 79,961 | ||||
Online (106615 x 25%) | 26,654 | ||||
Total | 106,615 | ||||