Question

Top executive officers of Jordan Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Current Year $2,100,000 1,470,000 630,000 286,000 Sales revenue Cost of goods sold Gross profit Selling & administrative expenses $ 344,000 Net income Cost of goods sold is usually 70 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $76,000. The president has announced that the company's goal is to increase net income by 15 percent. Required The following items are independent of each other. a. Prepare a pro forma income statement. What percentage increase in sales would enable thee company to reach its goal? b. The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 1 percent. Prepare a pro forma income statement still assuming the President's goal to increase net income by 15 percent. Calculate the required reduction in selling & administrative expenses to achieve the budgeted net income. c. The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $349,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales. Prepare a pro forma income statement. Will the company reach its goal?

Answer 1

Answer
a)
Projected Income Statement
Sales (W/Note-1)	$     23,58,000
Less: COGS = 70% of Sales	$     16,50,600
Gross Profit	$       7,07,400
Less: Sales and administrative expense (76000+ 10% of Sales)	$       3,11,300
Net Income	$       3,96,100
b)
		Sales revenue	$     21,00,000
Less: Cost of goods sold = (1470000 x 98%)	$     14,40,600
Gross profit	$       6,59,400
Selling & administrative expenses (difference)	$       2,63,800
Net income	$       3,95,600
c)
		Sales revenue ($2100000*1.15)	$     24,15,000
Less: Cost of goods sold ( 70% of sales)	$     16,90,500
Gross profit	$       7,24,500
Selling & administrative expenses (difference)	$       3,49,000
Net income	$       3,75,500
Yes, Company reach its goal .
W/Note-1Computation of Projected Sales
Projected Net Income ( $344000X1.15)	$       3,95,600
Let assume Sales be X
Sales	X
Cost of Goods Sold	0.70X
Selling & Administrative expense	0.10X+76000
Total Expected Cost	0.7*0.1*76000
Net Income = Sales-COGS-Selling & Admin Expense
395600= X-(0.70X+0.10X+76000)
395600=X-0.80X-76000
471600=0.20X
X=$2358000
Hence Projected Sales will be $2358000
Please Like ( positive Rating )