Break-Even Sales Under Present and Proposed Conditions Portmann Company, operating at full capacity, sold 1,000,000 units at a price of $188 per unit during the current year. Its Income statement is as follows: Sales Cost of goods sold Gross profit Expenses: Selling expenses $188,000,000 ($18,000,000) $90,000,000 $15,000,000 Administrative expenses 16,300,000 Total expenses (31,300,000) $58,700,000 Operating income The division of costs between variable and fixed is as follows: Variable Fixed 70% 30% Cost of goods sold Selling expenses Administrative 75% 25% 50% 50% expenses Management is considering a plant expansion program for the following year that will permit an increase of $13,160,000 in yearly sales. The expansion will increase fixed costs by $3,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 $58,700,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 8. Based on the data given, would you recommend accepting the proposal? 8. Based on the data given, would you recommend accepting the proposal? a. In favor of the proposal because of the reduction in break-even point. b. In favor of the proposal because of the possibility of increasing income from operations. c. In favor of the proposal because of the increase in break-even point. d. Reject the proposal because if future sales remain at the current level, the income from operations will increase. e. Reject the proposal because the sales necessary to maintain the current income from operations would be below the current year sales. Choose the correct answer. b Feedback Check My Work 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
