Question

In: Accounting

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 expected cost of goods sold as the current quarter’s ending inventory. This year’s ending inventory is $22,000. Next year’s ending inventory is budgeted to be $23,000.

Required

Prepare an inventory purchases budget using the sales manager’s estimate.

Prepare an inventory purchases budget using the marketing consultant’s estimate. Complete this question by entering your answers in the tabs below.

Required A

Required B

Prepare an inventory purchases budget using the sales manager’s estimate. (Round your final answers to nearest whole dollar amount.)

First Quarter Second Quarter Third Quarter Fourth Quarter
Sales $384,000 $315,000 $282,000 $483,000
Total inventory needed 0 0 0 0
Required purchases $0 $0 $0 $0

Prepare an inventory purchases budget using the marketing consultant’s estimate. (Round your final answers to nearest whole dollar amount.)

First Quarter Second Quarter Third Quarter Fourth Quarter
Sales $525,000 $458,000 $412,000 $648,000
Total inventory needed 0 0 0 0
Required purchases $0 $0 $0 $0

Solutions

Expert Solution

Inventory Purchase Budget - Sales Manager's Estimate
First Quarter Second Quarter Third Quarter Fourth Quarter
Sales                   384,000                       315,000                     282,000                       483,000
Budgeted Cost of Goods Sold - 65% of Sales                   249,600                       204,750                     183,300                       313,950
Add: Desired Ending Inventory                     30,713                          27,495                       47,093                         23,000
Total Inventory Needed                   280,313                       232,245                     230,393                       336,950
Less: Beginning Inventory                   (22,000)                       (30,713)                     (27,495)                       (47,093)
Required Purchases                   258,313                       201,532                     202,898                       289,857
Inventory Purchase Budget - Marketing Consultant's Estimate
First Quarter Second Quarter Third Quarter Fourth Quarter
Sales                   525,000                       458,000                     412,000                       648,000
Budgeted Cost of Goods Sold - 65% of Sales                   341,250                       297,700                     267,800                       421,200
Add: Desired Ending Inventory                     44,655                          40,170                       63,180                         23,000
Total Inventory Needed                   385,905                       337,870                     330,980                       444,200
Less: Beginning Inventory                   (22,000)                       (44,655)                     (40,170)                       (63,180)
Required Purchases                   363,905                       293,215                     290,810                       381,020

Related Solutions

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...
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
ADVERTISEMENT