Question

In: Accounting

Problem 5-29 (Algo) Changes in Cost Structure; Break-Even Analysis; Operating Leverage; Margin of Safety [LO5-4, LO5-5,...

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.

Solutions

Expert Solution

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 !


Related Solutions

Problem 5-29 (Algo) Changes in Cost Structure; Break-Even Analysis; Operating Leverage; Margin of Safety [LO5-4, LO5-5,...
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 (48,000 units × $23 per unit) $ 1,104,000 Variable expenses 772,800 Contribution margin 331,200 Fixed expenses 264,960 Net operating income $ 66,240 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...
Problem 5-29 (Algo) Changes in Cost Structure; Break-Even Analysis; Operating Leverage; Margin of Safety [LO5-4, LO5-5,...
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 (48,000 units × $23 per unit) $ 1,104,000 Variable expenses 772,800 Contribution margin 331,200 Fixed expenses 264,960 Net operating income $ 66,240 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...
Problem 5-29 Changes in Cost Structure; Break-Even Analysis; Operating Leverage; Margin of Safety [LO5-4, LO5-5, LO5-7,...
Problem 5-29 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 (43,000 units × $25 per unit) $ 1,075,000 Variable expenses 752,500 Contribution margin 322,500 Fixed expenses 258,000 Net operating income $ 64,500 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...
Problem 5-29 Changes in Cost Structure; Break-Even Analysis; Operating Leverage; Margin of Safety [LO5-4, LO5-5, LO5-7,...
Problem 5-29 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 (43,000 units × $23 per unit) $ 989,000 Variable expenses 692,300 Contribution margin 296,700 Fixed expenses 237,360 Net operating income $ 59,340 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...
Problem 5-29 Changes in Cost Structure; Break-Even Analysis; Operating Leverage; Margin of Safety [LO5-4, LO5-5, LO5-7,...
Problem 5-29 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 (49,000 units × $27 per unit) $ 1,323,000 Variable expenses 926,100 Contribution margin 396,900 Fixed expenses 317,520 Net operating income $ 79,380 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...
Problem 5-29 Changes in Cost Structure; Break-Even Analysis; Operating Leverage; Margin of Safety [LO5-4, LO5-5, LO5-7,...
Problem 5-29 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 (15,000 units × $30 per unit) $ 450,000 Variable expenses 315,000 Contribution margin 135,000 Fixed expenses 90,000 Net operating income $ 45,000 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...
Problem 5-22 (Algo) CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5,...
Problem 5-22 (Algo) CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,100 units × $20 per unit) $ 262,000 Variable expenses 157,200 Contribution margin 104,800 Fixed expenses 116,800 Net operating loss $ (12,000 ) Required: 1....
Problem 5-20 (Algo) CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6,...
Problem 5-20 (Algo) CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6, LO5-8] Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 54,000 of these balls, with the following results: Sales (54,000 balls) $...
Case 5-32 (Algo) Cost Structure; Break-Even and Target Profit Analysis [LO5-4, LO5-5, LO5-6] Pittman Company is...
Case 5-32 (Algo) Cost Structure; Break-Even and Target Profit Analysis [LO5-4, LO5-5, LO5-6] Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales force of its own; rather, it relies completely on independent sales agents to market its products. These agents are paid a sales commission of 15% for all items sold. Barbara Cheney, Pittman’s controller, has just prepared the company’s budgeted income statement for next year as follows: Pittman Company Budgeted Income Statement...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6]...
Problem 5-22 CVP Applications; Contribution Margin Ratio; Break-Even Analysis; Cost Structure [LO5-1, LO5-3, LO5-4, LO5-5, LO5-6] Due to erratic sales of its sole product—a high-capacity battery for laptop computers—PEM, Inc., has been experiencing financial difficulty for some time. The company’s contribution format income statement for the most recent month is given below:    Sales (13,500 units × $20 per unit) $ 270,000 Variable expenses 162,000 Contribution margin 108,000 Fixed expenses 120,000 Net operating loss $ (12,000 ) Required: 1. Compute...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT