2
Accounting 212
CVP Project Data
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 commission of 15% of selling price for all items sold.
Karen, Pittman’s controller just prepared the company’s budgeted income statement for next year. The statement follows:
PITTMAN COMPANY
BUDGETED INCOME STATEMENT
FOR THE YEAR ENDED DECEMBER 31, 2017
SALES
$16,000,000
MANUFACTURING COSTS:
VARIABLE
$7,200,000
FIXED
2,340,000
9,540,000
GROSS MARGIN
6,460,000
SELLING & ADMIN COSTS:
COMMISSION TO AGENTS
2,400,000
FIXED MARKETING COSTS
120,000*
FIXED ADMIN COSTS
1,800,000
4,320,000
NET OPERATING INCOME
2,140,000
*All depreciation on storage facilities.
As Karen handed the statement to Mitt Romney, Pittman’s president, she commented, “ I used the agents’ 15% commission rate in completing the statement. But we’ve just learned that the agents refuse to handle selling our product next year unless we increase the commission rate to 20%.”
Mitt replied “How can they possibly defend a 20% commission rate? And I say it’s time we fire those guys and get our own sales force.”
Karen said “We can hire our own sales staff and pay them 7.5% commission, along with a small salary. Of course, we would have to handle all promotion costs too. We figure our fixed costs would increase by $2,500,000 per year.”
The breakdown of the $2,500,000 cost figure is as follows:
Salaries:
Sales manager $ 100,000
Salespersons 700,000
Travel and Entertainment 400,000
Advertising 1,300,000
Total $2,500,000
Required:
Compute Pittman’s break-even point in sales dollars for next year assuming:
that the agents commission rate remains unchanged at 15%
that the agents commission rate is increased to 20%
that the company employs its own sales force
ALL CALCULATIONS, INCLUDING ANY FINANCIAL STATEMENTS, IN THE WRITTEN PORTI Cost ON OF YOUR PROJECT MUST BE DONE ON A SPREADSHEET!!
2