CASE 3–33 Cost Structure; Break-Even and Target Profit Analysis [ LO 3-4 , LO 3-
ID: 2531091 • Letter: C
Question
CASE 3–33 Cost Structure; Break-Even and Target Profit Analysis [LO 3-4, LO 3-5, LO 3-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. The statement follows:
As Barbara handed the statement to Karl Vecci, Pittman’s president, she commented, “I went ahead and used the agents’ 15% commission rate in completing these statements, but we’ve just learned that they refuse to handle our products next year unless we increase the commission rate to 20%.”
“That’s the last straw,” Karl replied angrily. “Those agents have been demanding more and more, and this time they’ve gone too far. How can they possibly defend a 20% commission rate?”
“They claim that after paying for advertising, travel, and the other costs of promotion, there’s nothing left over for profit,” replied Barbara.
“I say it’s just plain robbery,” retorted Karl. “And I also say it’s time we dumped those guys and got our own sales force. Can you get your people to work up some cost figures for us to look at?”
Page 116
“We’ve already worked them up,” said Barbara. “Several companies we know about pay a 7.5% commission to their own salespeople, along with a small salary. Of course, we would have to handle all promotion costs, too. We figure our fixed expenses would increase by $2,400,000 per year, but that would be more than offset by the $3,200,000 (20% × $16,000,000) that we would avoid on agents’ commissions.”
The breakdown of the $2,400,000 cost follows:
“Super,” replied Karl. “And I noticed that the $2,400,000 is just what we’re paying the agents under the old 15% commission rate.”
“It’s even better than that,” explained Barbara. “We can actually save $75,000 a year because that’s what we’re having to pay the auditing firm now to check out the agents’ reports. So our overall administrative expenses would be less.”
“Pull all of these numbers together and we’ll show them to the executive committee tomorrow,” said Karl. “With the approval of the committee, we can move on the matter immediately.”
Required:
1.
Compute Pittman Company’s break-even point in dollar sales for next year assuming:
a.
The agents’ commission rate remains unchanged at 15%.
b.
The agents’ commission rate is increased to 20%.
c.
The company employs its own sales force.
2.
Assume that Pittman Company decides to continue selling through agents and pays the 20% commission rate. Determine the volume of sales that would be required to generate the same net income as contained in the budgeted income statement for next year.
3.
Determine the volume of sales at which net income would be equal regardless of whether Pitt-man Company sells through agents (at a 20% commission rate) or employs its own sales force.
4.
Compute the degree of operating leverage that the company would expect to have on December 31 at the end of next year assuming:
a.
The agents’ commission rate remains unchanged at 15%.
b.
The agents’ commission rate is increased to 20%.
c.
The company employs its own sales force.
Use income before income taxes in your operating leverage computation.
5.
Based on the data in requirements 1–4 above, make a recommendation as to whether the company should continue to use sales agents (at a 20% commission rate) or employ its own sales force. Give reasons for your answer.
1.
Compute Pittman Company’s break-even point in dollar sales for next year assuming:
a.
The agents’ commission rate remains unchanged at 15%.
b.
The agents’ commission rate is increased to 20%.
c.
The company employs its own sales force.
2.
Assume that Pittman Company decides to continue selling through agents and pays the 20% commission rate. Determine the volume of sales that would be required to generate the same net income as contained in the budgeted income statement for next year.
3.
Determine the volume of sales at which net income would be equal regardless of whether Pitt-man Company sells through agents (at a 20% commission rate) or employs its own sales force.
4.
Compute the degree of operating leverage that the company would expect to have on December 31 at the end of next year assuming:
a.
The agents’ commission rate remains unchanged at 15%.
b.
The agents’ commission rate is increased to 20%.
c.
The company employs its own sales force.
Use income before income taxes in your operating leverage computation.
5.
Based on the data in requirements 1–4 above, make a recommendation as to whether the company should continue to use sales agents (at a 20% commission rate) or employ its own sales force. Give reasons for your answer.
Pittman Company Budgeted Income Statement For the Year Ended December 31 $16,000,000 Manufacturing expenses: $7,200,000 2,340,000 9,540,000 6,460,000 Selling and administrative expenses: 2,400,000 1,20,000* 1,800,000 Flxed administrative expenses 4,320,000 2,140,000 540,000 1,600,000 480,000 $1,120,000 Net Income .. Primartly depreclation on storage facilitles.Explanation / Answer
1). Calculation of breakeven point:
a). When agent commission rate is at 15%:
Total Fixed cost = 2,340,000+120,000+1,800,000+540,000 = 4,800,000
Contribution required for breakeven = 4,800,000
Contribution as per budgeted = 16,000,000 - 7,200,000 - 2,400,000 = 6,400,000
% of contribution = 6,400,000 / 16,000,000 = 40%
Breakeven sales = 4,800,000 / 40% = $12,000,000
b). Agents commission rate is 20%
New Contribution as per budgeted = 16,000,000 - 7,200,000 - 3,200,000(20% of sales) = 5,600,000
% of contribution = 5,600,000 / 16,000,000 = 35%
Contribution required for breakeven = 4,800,000
Breakeven sales = 4,800,000 / 35% = $ 13,714,285.71
c). Company Employs its own sales force:
Sales 16,000,000
Less: Variable mfr cost 7,200,000
Contribution 8,800,000
Less Fixed Cost
Salaries to sales staff 2,400,000
Overhead 2,340,000
Marketing 120,000
Administrative 1,725,000
Interest Expense 540,000
Profit 1,675,000
Contribution % = 55%
Total fixed costs = 2,400,000 + 2340000 + 120000+1725000 + 540000 = 7,125,000
Breakeven sales = 7125000 / 55% = $12,954,545
2). Profit before taxes as per budgeted = $1,600,000
Contribution margin % = 35% if sales commission at 20%
Contribution required = Total fixed costs + Budgeted profit = 4,800,000 + 1,600,000 = $6,400,000
Sales = 6,400,000 / 35% = $18,285,714
3). Sales at which net income at own sales force and at 20% commission is equal :
Let sales be x:
Net profit at 20% commission = 0.35x - 4,800,000
Net profit at own sales force = x - 0.45x - 2,400,000 - 4,725,000 = 0.55x - 7,125,000
Equating both the equations:
0.35x - 4800000 = 0.55x - 7125000
0.20x = 2325000
x = $11,625,000 i.e sales
4). Operating Leverage = Contribution / EBIT
a) If commission at 15% = 6400000 / 1600000 = 4
b). If commission at 20% = 5600000 / 800000 = 7
c). IF own sales force = 8800000 / 1675000 = 5.25
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.