In: Accounting
Problem 5-29 (Algo) Changes in Cost Structure; Break-Even Analysis; Operating Leverage; Margin of Safety [LO5-4, LO5-5, LO5-7, LO5-8]
Morton Company’s contribution format income statement for last
month is given below:
Sales (47,000 units × $22 per unit) | $ | 1,034,000 | |
Variable expenses | 723,800 | ||
Contribution margin | 310,200 | ||
Fixed expenses | 248,160 | ||
Net operating income | $ | 62,040 | |
The industry in which Morton Company operates is quite sensitive to cyclical movements in the economy. Thus, profits vary considerably from year to year according to general economic conditions. The company has a large amount of unused capacity and is studying ways of improving profits.
Required:
1. New equipment has come onto the market that would allow Morton Company to automate a portion of its operations. Variable expenses would be reduced by $6.60 per unit. However, fixed expenses would increase to a total of $558,360 each month. Prepare two contribution format income statements, one showing present operations and one showing how operations would appear if the new equipment is purchased.
2. Refer to the income statements in (1). For the present operations and the proposed new operations, compute (a) the degree of operating leverage, (b) the break-even point in dollar sales, and (c) the margin of safety in dollars and the margin of safety percentage.
3. Refer again to the data in (1). As a manager, what factor would be paramount in your mind in deciding whether to purchase the new equipment? (Assume that enough funds are available to make the purchase.)
4. Refer to the original data. Rather than purchase new equipment, the marketing manager argues that the company’s marketing strategy should be changed. Rather than pay sales commissions, which are currently included in variable expenses, the company would pay salespersons fixed salaries and would invest heavily in advertising. The marketing manager claims this new approach would increase unit sales by 30% without any change in selling price; the company’s new monthly fixed expenses would be $396,022; and its net operating income would increase by 20%. Compute the company's break-even point in dollar sales under the new marketing strategy.
Requirement-1:
Before purchasing the equipment | |
Particulars | Amount |
Sales | 1,034,000 |
Less: Variable expenses | (723,800) |
Contribution | 310,200 |
Less: Fixed cost | (248,160) |
Profit | 62,040 |
If the equipment is purchased | |
Particulars | Amount |
Sales | 1,034,000 |
Less: Variable expenses (723,800/47,000= 15.40 15.40 - 6.60 = 8.80 47,000*8.80 = 413,600) |
(413,600) |
Contribution | 620,400 |
Less: Fixed cost | (558,360) |
Profit | 62,040 |
Requirement-2:
Particulars | Present operations | Proposed new operations |
a) Degree of operating leverage | 5 | 10 |
(Contribution/EBIT) | (310,200/62,040) | (620,400/62,040) |
b) Break even point in sales | 827,200 | 930,600 |
(Fixed cost/P V ratio) | (248,160/30%) | (558,360/60%) |
P V ratio = contribution/sales *100 | ( P V ratio = 310,200/1,034,000*100 = 30% ) | ( P V ratio = 620,400/1,034,000*100 = 60% ) |
c) Margin of safety | 206,800 | 103,400 |
(Total sales - Break even sales) | (1,034,000-827,200) | (1,034,000-930,600) |
Margin of safety percentage | 20% | 10% |
( Margin of safety/sales)*100 | (206,800/1,034,000)*100 | (103,400/1,034,000)*100 |
Requirement-3:
The factor that would be paramount in our mind in deciding whether to purchase the new equipment is Cyclical movements in the economy itself. It is an external factor. It cannot be controlled easily. All the other factors are internal to the business.
Requirement-4:
As per the new marketing strategy,
Sales in units = 47,000*130/100
= 61,100
Therefore, Sales = 61,100 * 22
= $ 1,344,200
Profit (62,040*120/100) |
74,448 |
Add : Fixed cost | 396,022 |
Contribution | 470,470 |
P V ratio = Contribution/Sales*100
= (470,470/1,344,200)*100
= 35%
Break even point in sales = Fixed cost/P V ratio
= 396,022/35%
= $ 1,131,491
Please rate positively if htis helped you,
All the best !