In: Accounting
Midlands Inc. had a bad year in 2019. For the first time in its history, it operated at a loss. The company’s income statement showed the following results from selling 75,000 units of product: net sales $1,500,000; total costs and expenses $1,620,000; and net loss $120,000. Costs and expenses consisted of the following.
Total | Variable | Fixed | |
Cost of Goods Sold | $962,000 | $451,000 | $511,000 |
Selling Expenses | 510,000 | 91,000 | 419,000 |
Administrative Expenses | 148,000 | 58,000 | 90,000 |
$1,620,000 | $600,000 | $1,020,000 |
Management is considering the following independent alternatives
for 2020.
1.Increase unit selling price 25% with no change in costs and
expenses.
2.Change the compensation of salespersons from fixed annual salaries totaling $205,000 to total salaries of $35,025 plus a 5% commission on net sales.
3.Purchase new high-tech factory machinery that will change the proportion between variable and fixed cost of goods sold to 50:50.
(a) Compute the break-even point in dollars for 2019. (Round contribution margin ratio to 4 decimal places e.g. 0.2512 and final answer to 0 decimal places, e.g. 2,510.)
(b) Compute the break-even point in dollars under
each of the alternative courses of action for 2020.
(Round contribution margin ratio to 3 decimal places
e.g. 0.251 and final answers to 0 decimal places, e.g.
2,510.)
Break-even point | |
1) increase selling price | $ |
2) change compensation | $ |
3) purchase machinery | $ |
total | per unit | ||||||
Sales | 1,500,000 | 20 | |||||
less :variable expense | |||||||
cost of goods sold | 451,000 | 6.013333 | |||||
selling expense | 91,000 | 1.213333 | |||||
administrative expense | 58,000 | 0.773333 | |||||
total variable expense | 600,000 | 8 | |||||
contribution margin | 900,000 | 12 | |||||
contribution margin = contribution/sales | |||||||
900,000/1,500,000 | |||||||
0.6 | |||||||
a) | Break even point (dollars) = total fixed cost/contribution margin ratio | ||||||
1020000/60% | |||||||
2040000 | answer | ||||||
b) | |||||||
1) | increase selling price 25% | ||||||
Selling price per unit (20*125%)= | 25 | ||||||
less variable cost per unit | 8 | ||||||
contribution margin per unit | 17 | ||||||
Break even point = 1,020,000/17*25 | |||||||
1500000 | answer | ||||||
2) | Change compensation | ||||||
selling price per unit | 20 | ||||||
variable cost per unit | 8 | ||||||
5% commission on sales (20*5%) | 1 | 9 | |||||
Contribution margin per unit | 11 | ||||||
Fixed cost | |||||||
total fixed cost | 1,020,000 | ||||||
less:Reduced | -205,000 | ||||||
add:Salaries | 35,025 | ||||||
new fixed cost | 850,025 | ||||||
BEP(dollars) = 850025/11*20 | |||||||
1545500 | answer | ||||||
3) | Variable | Fixed | |||||
cost of goods sold | 481,000 | 481,000 | |||||
Selling expense | 91,000 | 419,000 | |||||
Administrative expense | 58,000 | 90,000 | |||||
total | 630,000 | 990,000 | |||||
contribution = 1,500,000-630000 | |||||||
870,000 | |||||||
contribution margin ratio =870000/1500000 | |||||||
58.0000% | |||||||
Break even = | 990000/58% | ||||||
1706897 | answer | ||||||
Alternative 1 | |||||||