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 | ||||