Question

In: Accounting

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 expected cost of goods sold as the current quarter’s ending inventory. This year’s ending inventory is $31,000. Next year’s ending inventory is budgeted to be $32,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 $389,000 $315,000 $280,000 $471,000
Cost of goods sold
Less: Desired ending inventory
Total inventory needed 0 0 0 0
Required purchases $0 $0 $0 $0
Complete this question by entering your answers in the tabs below.

Required A

Required B

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 $516,000 $457,000 $406,000 $649,000
Total inventory needed 0 0 0 0
Required purchases $0 $0 $0 $0

Solutions

Expert Solution


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