Question
In: Accounting
Executive officers of Stuart Company are wrestling with their budget for the next year. The following...
Executive officers of Stuart Company are wrestling with their budget for the next year. The following are two different sales estimates provided by two difference sources.
| Source of Estimate | First Quarter | Second Quarter | Third Quarter | Fourth Quarter | ||||||||
| Sales manager | $ | 381,000 | $ | 306,000 | $ | 287,000 | $ | 486,000 | ||||
| Marketing consultant | 511,000 | 457,000 | 417,000 | 648,000 | ||||||||
Stuart’s past experience indicates that cost of goods sold is about 65 percent of sales revenue. The company tries to maintain 10 percent of the next quarter’s expected cost of goods sold as the current quarter’s ending inventory. This year’s ending inventory is $24,000. Next year’s ending inventory is budgeted to be $25,000.
Required
-
Prepare an inventory purchases budget using the sales manager’s estimate.
-
Prepare an inventory purchases budget using the marketing consultant’s estimate.
Prepare an inventory purchases budget using the sales manager’s estimate. (Round your final answers to nearest whole dollar amount.)
|
Prepare an inventory purchases budget using the marketing consultant’s estimate. (Round your final answers to nearest whole dollar amount.)
|
Solutions
Expert Solution
Purchase Budget (Sales Manager Estimate)
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Sales | $ 381,000 | $ 306,000 | $ 287,000 | $ 486,000 |
| Cost of Goods Sold (60%) | $ 228,600 | $ 183,600 | $ 172,200 | $ 291,600 |
| Add : Desired Inventory | $ 18,360 | $ 17,220 | $ 29,160 | $ 25,000 |
| Total inventory needed | $ 246,960 | $ 200,820 | $ 201,360 | $ 316,600 |
| Less Beginning Inventory | $ 24,000 | $ 18,360 | $ 17,220 | $ 29,160 |
| Required Purchases | $ 222,960 | $ 182,460 | $ 184,140 | $ 287,440 |
Desired Ending Inventory = 10% of next quarter's cost of goods sold
i.e.
1st Quarter = $183600 x 10%, 2nd Quarter = $172200 x 10% and 3rd
Quarter = $291600 x 10%
Purchase Budget (Marketing Consultant Estimate)
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Sales | $ 511,000 | $ 457,000 | $ 417,000 | $ 648,000 |
| Cost of Goods Sold (60%) | $ 306,600 | $ 274,200 | $ 250,200 | $ 388,800 |
| Add : Desired Inventory | $ 27,420 | $ 25,020 | $ 38,880 | $ 25,000 |
| Total inventory needed | $ 334,020 | $ 299,220 | $ 289,080 | $ 413,800 |
| Less Beginning Inventory | $ 24,000 | $ 27,420 | $ 25,020 | $ 38,880 |
| Required Purchases | $ 310,020 | $ 271,800 | $ 264,060 | $ 374,920 |
Desired Ending Inventory = 10% of next quarter's cost of goods
sold i.e.
1st Quarter = $274200 x 10%, 2nd Quarter = $250200 x 10% and 3rd
Quarter = $388800 x 10%
ekkarill92 answered 1 year agoRelated Solutions
Executive officers of Solomon Company are wrestling with their budget for the next year. The following...
Executive officers of Solomon Company are wrestling with their
budget for the next year. The following are two different sales
estimates provided by two difference sources:
Source of Estimate
First Quarter
Second Quarter
Third Quarter
Fourth Quarter
Sales manager
$
384,000
$
315,000
$
282,000
$
483,000
Marketing consultant
525,000
458,000
412,000
648,000
Solomon’s past experience indicates that cost of goods sold is
about 65 percent of sales revenue. The company tries to maintain 15
percent of the next quarter’s...
Executive officers of Benson Company are wrestling with their budget for the next year. The following...
Executive officers of Benson Company are wrestling with their
budget for the next year. The following are two different sales
estimates provided by two difference sources:
Source of Estimate
First Quarter
Second Quarter
Third Quarter
Fourth Quarter
Sales manager
$
389,000
$
315,000
$
280,000
$
471,000
Marketing consultant
516,000
457,000
406,000
649,000
Benson’s past experience indicates that cost of goods sold is
about 55 percent of sales revenue. The company tries to maintain 15
percent of the next quarter’s...
Executive officers of Jordan Company are wrestling with their budget for the next year. The following...
Executive officers of Jordan Company are wrestling with their
budget for the next year. The following are two different sales
estimates provided by two difference sources:
Source of Estimate
First Quarter
Second Quarter
Third Quarter
Fourth Quarter
Sales manager
$
377,000
$
316,000
$
275,000
$
482,000
Marketing consultant
511,000
456,000
402,000
658,000
Jordan’s past experience indicates that cost of goods sold is
about 55 percent of sales revenue. The company tries to maintain 10
percent of the next quarter’s...
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 Preston Company, a merchandising firm, are preparing the next year’s budget. The...
Top executive officers of Preston 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 $ 3,200,000 Cost of goods sold 2,240,000
Gross profit 960,000 Selling & admin. expenses 380,000 Net
income $ 580,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 $60,000. The president...
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...
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.
Current Year
Sales revenue
$
1,600,000
Cost of goods sold
1,120,000
Gross profit
480,000
Selling & administrative
expenses
190,000
Net income
$
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...
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
$
1,600,000
Cost of goods sold
1,120,000
Gross profit
480,000
Selling & administrative
expenses
190,000
Net income
$
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 announced...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What role does nucleation and kinetics in general have for making a single crystal silicon wafer?...
- Lesley is the purchasing manager for an organic food restaurant with a banquet room. She needs...
- *this is for sociology class and i chose psychology because there were no option for sociology...
- QUESTION THREE Sally has decided to go into business to make and sell organic, home-made playdough...
- What is the pricing strategy of the heinz ketup and justify why the company is using...
- Holly Springs, Inc. contracted with Coldwater Corporation to have constructed a custom-made lathe. The machine was...
- You have just learned that you will have three students with disabilities in your classroom. List...
ADVERTISEMENT