Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Top executive officers of Baird Company, a merchandising firm, are preparing the next years budget. The controller has provided everyone with the current years projected

Top executive officers of Baird 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 

Sales revenue $ 2,300,000 

Cost of goods sold 1,725,000

Gross profit 575,000 

Selling & administrative expenses 304,000 

Net income $ 271,000 

Cost of goods sold is usually 75 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $74,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. Using Excel prepare a pro forma income statement. What percentage increase in sales would enable the company to reach its goal? 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 2 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. The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expenses to $347,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?

Step by Step Solution

3.40 Rating (150 Votes )

There are 3 Steps involved in it

Step: 1

current year income statement Sales 2300000 less cost of good sold 1725000 gross profit 57500... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

13th Edition

978-0073379616, 73379611, 978-0697789938

More Books

Students also viewed these Accounting questions

Question

Explain the operation of the dividends received deduction.

Answered: 1 week ago