In: Accounting
Break-Even Sales Under Present and Proposed Conditions
Darby Company, operating at full capacity, sold 154,100 units at a price of $105 per unit during the current year. Its income statement is as follows:
| Sales | $16,180,500 | ||
| Cost of goods sold | 5,740,000 | ||
| Gross profit | $10,440,500 | ||
| Expenses: | |||
| Selling expenses | $2,870,000 | ||
| Administrative expenses | 1,715,000 | ||
| Total expenses | 4,585,000 | ||
| Income from operations | $5,855,500 |
The division of costs between variable and fixed is as follows:
| Variable | Fixed | |||
| Cost of goods sold | 60% | 40% | ||
| Selling expenses | 50% | 50% | ||
| Administrative expenses | 30% | 70% | ||
Management is considering a plant expansion program for the following year that will permit an increase of $1,260,000 in yearly sales. The expansion will increase fixed costs by $168,000, but will not affect the relationship between sales and variable costs.
Required:
1. Determine the total variable costs and the total fixed costs for the current year.
| Total variable costs | $ |
| Total fixed costs | $ |
2. Determine (a) the unit variable cost and (b) the unit contribution margin for the current year.
| Unit variable cost | $ |
| Unit contribution margin | $ |
3. Compute the break-even sales (units) for the
current year.
units
4. Compute the break-even sales (units) under
the proposed program for the following year.
units
5. Determine the amount of sales (units) that
would be necessary under the proposed program to realize the
$5,855,500 of income from operations that was earned in the current
year.
units
6. Determine the maximum income from operations
possible with the expanded plant.
$
7. If the proposal is accepted and sales remain
at the current level, what will the income or loss from operations
be for the following year?
$
8. Based on the data given, would you recommend accepting the proposal?
Choose the correct answer.
Ques 1
| Variable | Fixed | Total | |
| Cost of goods sold(60%/40%) | 3,444,000 | 2,296,000 | 5,740,000 |
| Selling expenses(50%/50%) | 1,435,000 | 1,435,000 | 2,870,000 |
| Administrative (30%/70%) | 514,500 | 1,200,500 | 1,715,000 |
| Total | 5,393,500 | 4,931,500 | 10,325,000 |
Ques 2
| Unit variable cost | $ |
| Total variable costs | 5,393,500 |
| Total units | 154,100 |
| Variable cost ($ per unit) | 35.00 |
| Unit Contribution margin | $ |
| Sales price | 105.00 |
| Variable cost ($ per unit) | 35.00 |
| Contribution margin per unit | 70.00 |
Ques 3
| Breakeven point (Units) = Fixed costs / contribution per unit | ||
| Fixed costs | 4,931,500 | |
| Contribution per unit | 70.00 | |
| Breakeven point (Units) | 70,450 | |
Ques 4
| Fixed costs (W-1) | 5,099,500 |
| Contribution per unit | 70.00 |
| Breakeven point (Units) | 72,850 |
| (W-1) | |
| Existing fixed costs | 4,931,500 |
| Increase in fixed costs | 168,000 |
| Revised fixed costs | 5,099,500 |
Ques 5
| Formula: (Fixed costs + target profit) / contribution per unit | |||
| Fixed costs | 5,099,500 | ||
| Add: Target profit | 5,855,500 | ||
| Contribution per unit | 70.00 | ||
| Target Units sold | 156,500 | ||
Ques 6
| Contribution margin | 11,627,000 | |
| Less: Total fixed costs | 5,099,500 | |
| Maximum income | 6,527,500 | |
| (W-1) | ||
| Revised total sales | 17,440,500 | |
| ($5,637,600+ $1,260,000) | ||
| Contribution to sales ratio* | 67% | |
| Revised contribution margin | 11,627,000 | |
| *($70 contribution per unit 105 sales price) | ||
Ques 7
| Sales | 16,180,500 | |
| Variable costs | 5,393,500 | |
| Contribution margin | 10,787,000 | |
| Fixed costs | 5,099,500 | |
| Net income | 5,687,500 |
Ques 8
| accepted because there is a possibility to increasing income from operations |