Top executive officers of Franklin Company, a merchandising firm, are preparing the next year’s budget. The...
Top executive officers of Franklin 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 | $ | 1,600,000 | |
| Cost of goods sold | 1,120,000 | ||
| Gross profit | 480,000 | ||
| Selling & administrative expenses | 240,000 | ||
| Net income | $ | 240,000 | |
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 $80,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:
-
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 $344,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?
Homework Answers
a
| Particulars | Amount ($) |
| Desired Net Income | 276,000 |
| Add: | |
| Selling and admin expenses | |
| Fixed | 80,000 |
| Variable (0.1 x) | 178,000 |
| COGS (0.7 x) | 1,246,000 |
| Equals | |
| Sales (x) | 1,780,000 |
| x=0.7x+0.1x+80,000+276,000 |
| x=1,780,000 |
b
| Particulars | Amount ($) |
| Sales | 1,600,000 |
| Less: COGS (68%) | 1,088,000 |
| Gross Profit | 512,000 |
| Less: Desired Net Income | 276,000 |
| Desired Selling and Admin Expenses | 236,000 |
| Current Selling and Admin Expenses | 240,000 |
| Required cut in Selling and Admin Expenses | 4,000 |
c
| Particulars | Amount ($) |
| Sales (115%) | 1,840,000 |
| Less: COGS (70%) | 1,288,000 |
| Gross Profit | 552,000 |
| Selling and admin expenses | 344,000 |
| Net Income | 208,000 |
| Company's Desired Income | 276,000 |
| Deficit | 68,000 |
| No, company shall not be able to achieve its goals. |
Add Answer to:
Top executive officers of Franklin Company, a merchandising
firm, are preparing the next year’s budget. The...
Top executive officers of Baird Company, a merchandising firm, are preparing the next year’s budget. The...
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...
Top executive officers of Thornton Company, a merchandising firm, are preparing the next year's budget. The...
Top executive officers of Thornton 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 $1,800,000 1,260,000 540,000 254,000 Cost of goods sold Gross profit Selling & administrative expenses $ 286,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 $74,000. The president has announced...
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year's budget. The...
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $1,600,000 1,120,000 480,000 190,000 $ 290,000 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 $30.000. The president has...
Top executive officers of Vernon Company, a merchandising firm, are preparing the next year's budget. The...
Top executive officers of Vernon Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $1,600,000 1,200,000 400,000 240,000 $ 160,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 $80,000. The president has...
Top executive officers of Jordan Company, a merchandising firm, are preparing the next year's budget. The...
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...
Top executive officers of Zachary Company, a merchandising firm, are preparing the next year's budget. The...
Top executive officers of Zachary Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $2,500,000 1,875,000 625,000 327,000 $ 298,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 $77,000. The president has...
Top executive officers of Stuart Company, a merchandising firm, are preparing the next year's budget. The...
Top executive officers of Stuart Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement Sales revenue Cost of goods sold Gross profit Selling administra Net income Current Year $2,400,000 1,680,000 720,000 319.000 $ 401,000 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 $79,000. The president has announced that...
Top executive officers of Fanning Company, a merchandising firm, are preparing the next year's budget. The controller h...
Top executive officers of Fanning Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $2,200,000 1,650,000 550,000 298,000 $ 252,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 $78,000. The president has...
Top executive officers of Campbell Company, a merchandising firm, are preparing the next year's budget. The...
Top executive officers of Campbell Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $1,600,000 1,120,000 480,000 232,000 $ 248,000 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 $72,000. The president has...
How do I calculate the Reduction in selling and administrative expenses? Top executive officers of Tildon...
How do I calculate the
Reduction in selling and administrative expenses?
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $1,600,000 1,120,000 480,000 190,000 $ 290,000 Cost of goods sold is usually 70 percent of sales revenue, and selling and administrative expenses are usually 10 percent...
Top executive officers of Thornton 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 $1,800,000 1,260,000 540,000 254,000 Cost of goods sold Gross profit Selling & administrative expenses $ 286,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 $74,000. The president has announced...
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $1,600,000 1,120,000 480,000 190,000 $ 290,000 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 $30.000. The president has...
Top executive officers of Vernon Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $1,600,000 1,200,000 400,000 240,000 $ 160,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 $80,000. The president has...
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...
Top executive officers of Zachary Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $2,500,000 1,875,000 625,000 327,000 $ 298,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 $77,000. The president has...
Top executive officers of Stuart Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement Sales revenue Cost of goods sold Gross profit Selling administra Net income Current Year $2,400,000 1,680,000 720,000 319.000 $ 401,000 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 $79,000. The president has announced that...
Top executive officers of Fanning Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $2,200,000 1,650,000 550,000 298,000 $ 252,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 $78,000. The president has...
Top executive officers of Campbell Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $1,600,000 1,120,000 480,000 232,000 $ 248,000 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 $72,000. The president has...
How do I calculate the
Reduction in selling and administrative expenses?
Top executive officers of Tildon Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement. Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income Current Year $1,600,000 1,120,000 480,000 190,000 $ 290,000 Cost of goods sold is usually 70 percent of sales revenue, and selling and administrative expenses are usually 10 percent...
Most questions answered within 3 hours.
-
(Expected rate of return and risk) Carter Inc. is evaluating a
security. Calculate the investment’s expected...
asked 2 hours ago -
What specific indicators can point to lack of progress for
African Americans in American society?
asked 3 hours ago -
1-The Electrons in a beam are moving at 2.7×108 m/s in an
electric field of 15000...
asked 3 hours ago -
A gas tank is a vertical cylinder. It has a radius of 1m, a
height of...
asked 4 hours ago -
Accent Software faces the following conditions. All of these
support Accent’s use of a market-penetration pricing...
asked 4 hours ago -
A mathematically inclined friend emails you the following
instructions: "Meet me in the cafeteria the first...
asked 5 hours ago -
A monopoly sells in two countries . The demand curves in the two
countries are p1...
asked 6 hours ago -
A .15kg rubber ball is bounced off a wall. Before hitting the
wall, the ball moves...
asked 6 hours ago -
A manufacturing company preparing to build a new plant is
considering three potential locations for it....
asked 6 hours ago -
B. If compound Y has approximately the same values of solubility
in toluene as compound X,...
asked 7 hours ago -
Oscar Inc. has inventory in Japan valued at 39,051,000 Yen one
year ago. One year ago...
asked 7 hours ago -
If Canada suffered from "fundamental disequilibrium," and its
government choose not to devalue its currency, a...
asked 7 hours ago