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