Question

In September 2016, the management of Rye Company assembles the following data in preparation of budgeted merchandise purchases for the months of October and November.

1. Expected Sales
October $1,500,000
November 2,100,000
December 2,700,000
2. Cost of goods sold is expected to be 70% of sales.
3. Desired ending merchandise inventory is 20% of the next month's cost of goods sold.
4. The beginning inventory at October 1 will be the desired amount.


Compute the budgeted merchandise purchases for October and November.

RYE COMPANY Merchandise Purchases Budget For the Months of October and November, 2016 October November Less ▼

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

RYE Company
Merchandise Purchases Budget
Particulars October November
Cost of Goods Sold (70% of sales) $10,50,000 $14,70,000
Add: Desired ending inventory (20% of next month's Cost of goods sold) $2,94,000 $3,78,000
Total goods required for Production $13,44,000 $18,48,000
Less: Opening Inventory $2,10,000 $2,94,000
Budgeted Merchandise Purchase $11,34,000 $15,54,000

Excel Poo-2 - Microsoft Excel 2. General - - Home Insert Page Layout - 7 X File Formulas Dala Review View Insert Function Mor

Add a comment
Know the answer?
Add Answer to:
In September 2016, the management of Rye Company assembles the following data in preparation of budgeted...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • In September 2016, the management of Rye Company assembles the following data in preparation of budgeted...

    In September 2016, the management of Rye Company assembles the following data in preparation of budgeted merchandise purchases for the months of October and November. 1) Expected Sales a) October $1,500,000 b) November 2,100,000 c) December 2,700,000 2) Cost of goods sold is expected to be 70% of sales 3) Desired ending merchandise inventory is 20% of the next month's cost of goods sold. 4) The beginning inventory at october 1 will be the desired amount. INSTRUCCIONS Compute the budgeted...

  • In May 2020, the budget committee of Johnson Stores assembles the following data in preparation of...

    In May 2020, the budget committee of Johnson Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. Expected sales: June $501,000, July $607, 400 2. Cost of goods sold is expected to be 75% of sales. 3. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. 4. The beginning inventory at June 1 will be the desired amount. -Compute the budgeted merchandise purchases for June: (Complete...

  • In May 2017, the budget committee of Grand Stores assembles the following data in preparation of...

    In May 2017, the budget committee of Grand Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. Expected sales: June $507,300, July $608,800. 2. Cost of goods sold is expected to be 75% of sales. 3. Desired ending merchandise inventory is 30% of the following (next) month’s cost of goods sold. 4. The beginning inventory at June 1 will be the desired amount. Collapse question part (a) Compute the budgeted merchandise purchases...

  • Exercise 21-20 (Part Level Submission) In May 2017, the budget committee of Grand Stores assembles the...

    Exercise 21-20 (Part Level Submission) In May 2017, the budget committee of Grand Stores assembles the following data in preparation of budgeted merchandise purchases for the month of June. 1. Expected sales: June $501,000, July $607,300. 2. Cost of goods sold is expected to be 75% of sales. 3. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sold. 4. The beginning inventory at June 1 will be the desired amount. (a) Compute the budgeted...

  • Radical Logos buys logo-imprinted merchandise and then sells it to university bookstores. Sales are expected to...

    Radical Logos buys logo-imprinted merchandise and then sells it to university bookstores. Sales are expected to be $2,003,000 in September, $2,210,000 in October, $2,379,000 in November, and $2,560,000 in December. Radical Logos sets its prices to earn an average 40% gross profit on sales revenue. The company does not want inventory to fall below $440,000 plus 10% of the next month's cost of goods sold. Prepare an inventory, purchases, and cost of goods sold budget for the months of October...

  • Cool Logos buys logo-imprinted merchandise and then sells it to university bookstores. Sales are expected to...

    Cool Logos buys logo-imprinted merchandise and then sells it to university bookstores. Sales are expected to be $2,006,000 in September, $2,200,000 in October, $2,376,000 in November, and $2,570,000 in December. Cool Logos sets its prices to earn an average 40% gross profit on sales revenue. The company does not want inventory to fall below $425,000 plus 10% of the next month's cost of goods sold. Prepare an inventory, purchases, and cost of goods sold budget for the months of October...

  • Cool Logos buys logo-imprinted merchandise and then sells it to university bookstores. Sales are expected to be $2,002,...

    Cool Logos buys logo-imprinted merchandise and then sells it to university bookstores. Sales are expected to be $2,002,000 in September, $2,160,000 in October, $2,385,000 in November, and $2,560,000 in December. Cool Logos sets its prices to earn an average 30% gross profit on sales revenue. The company does not want inventory to fall below $425,000 plus 10% of the next month's cost of goods sold. Prepare a cost of goods sold, inventory, and purchases budget for the months of October...

  • Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown...

    Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity $ 69,400 166,000 83,700 257,000 $ 576,100 $ 246,600 216,000 113,500 $ 576,100 The company is in the process of preparing a budget for October and has assembled the...

  • Sipped Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as...

    Sipped Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below. Wheeling Company Balance Sheet September 30 Assets Cash $ 61,000 Accounts receivable 170 000 Inventory 86,400 Buildings and equipment, net of depreciation 249.000 Total assets $566,400 Liabilities and Stockholders' Equity Accounts payable $ 217900 Common stock 216000 Retained earnings 132.500 Total liabilities and stockholders' equity $566,400 ebook The company is in the process of preparing a budget for October and has assembled...

  • Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown...

    Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 Assets Cash $ 77,800 Accounts receivable 134,000 Inventory 62,100 Buildings and equipment, net of depreciation 284,000 Total assets $ 557,900 Liabilities and Stockholders’ Equity Accounts payable $ 225,900 Common stock 216,000 Retained earnings 116,000 Total liabilities and stockholders’ equity $ 557,900 The company is in the process of preparing a budget for October and has assembled the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT