Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at
Question:
Break-Even Sales Under Present and Proposed Conditions
Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $186 per unit during the current year. Its income statement is as follows:
Sales | $186,000,000 | ||
Cost of goods sold | (98,000,000) | ||
Gross profit | $88,000,000 | ||
Expenses: | |||
Selling expenses | $14,000,000 | ||
Administrative expenses | 13,800,000 | ||
Total expenses | (27,800,000) | ||
Operating income | $60,200,000 |
The division of costs between variable and fixed is as follows:
Variable | Fixed | |||
Cost of goods sold | 70% | 30% | ||
Selling expenses | 75% | 25% | ||
Administrative expenses | 50% | 50% |
Management is considering a plant expansion program for the following year that will permit an increase of $9,300,000 in yearly sales. The expansion will increase fixed costs by $4,000,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 $60,200,000 of operating income that was earned in the current year. ______units
6. Determine the maximum operating income possible with the expanded plant. $______
7. If the proposal is accepted and sales remain at the current level, what will the operating income or loss be for the following year? $______ Income
1. Multiply the percentages for fixed and variable costs by each cost.
2. a. Divide the total variable costs by number of units.
2. b. Sales price per unit minus variable costs per unit equals contribution margin per unit.
3. Fixed costs divided by unit contribution margin equals break-even point.
4. Fixed costs under the proposed program divided by contribution margin equals new break-even point.
5. (Fixed costs + Target profit) divided by unit contribution margin equals sales units.
6. Determine the increase in units by dividing the sales increase by the price per unit. Add the additional revenue and additional fixed costs when calculating:
Sales minus fixed and variable costs equals income from operations.
7. Subtract the additional fixed costs from the operating income.