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 a Merchandise Purchase Budget).
Budgeted Cost of Goods Sold:
Add: Desired ending merchandise inventory:
Total materials required:
Less: Beginning merchandise inventory:
Required merchandise purchases:
-Prepare the budgeted multiple-step income statement for June through gross profit:
Sales:
Cost of goods sold:
Gross Profit:
Solutions:
| Merchandise Purchase Budget | |
| Budgeted Cost of Goods Sold ($501000*75%) | 375750 |
| Add: Desired ending merchandise inventory:($607400*75%*30%) | 136665 |
| Total materials required: | 512415 |
| Less: Beginning merchandise inventory: ($375750*30%) | 112725 |
| Required merchandise purchases: | 399690 |
| Merchandise Purchase Budget budgeted multiple-step income statement | |
| Sales: | 501000 |
| Cost of goods sold: | 375750 |
| Gross Profit: | 125250 |
In May 2020, the budget committee of Johnson 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 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...
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...
Good morning,
I am having an issue figuring out the second part of my
assignment this week. Any help is appreciated. Thank you in
advance.
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 $517,600, July $608,600. 2. Cost of goods sold is expected to be 75% of sales. 3. Desired ending merchandise inventory is 30%...
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...
On January 1, 2020, the Johnson Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales Units: First quarter 5,600; second quarter 6,400; third quarter 7,000 Ending raw materials inventory: 40% of the next quarter's production requirements. Ending finished goods inventory: 25% of the next quarter's expected sales units. Third-quarter production: 7,440 Units The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
Problem 22-05A (Part Level Submission) The budget committee of Suppar Company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2020. 1. Sales for May are expected to be $800,000. Sales in June and July are expected to be 5% higher than the preceding month. 2. Cost of goods sold is expected to be 75% of sales. 3. Company policy is to maintain ending merchandise inventory at 10% of the following...
Problem 22-05A (Part Level Submission) The budget committee of Suppar Company collects the following data for its San Miguel Store in preparing budgeted income statements for May and June 2020. 1. Sales for May are expected to be $800,000. Sales in June and July are expected to be 5% higher than the preceding month. 2. Cost of goods sold is expected to be 75% of sales. 3. Company policy is to maintain ending merchandise inventory at 10% of the following...
1. 2. 3. 4. Expected sales: June $507,300, July $608,800. Cost of goods sold is expected to be 75% of sales. Desired ending merchandise inventory is 30% of the following (next) month's cost of goods sol The beginning inventory at June 1 will be the desired amount. Compute the budgeted merchandise purchases for June. (Round answers to the nearest whole d GRAND STORES Merchandise Purchases Budget For the Month Ending June 30, 2017 Y if you would like to Show...
Moore Wholesalers is preparing its merchandise purchases budget. Budgeted sales are $430,000 for April and $500,000 for May. Cost of goods sold is expected to be 62% of sales. The company's desired ending inventory is 23% of the following month's cost of goods sold. Compute the required purchases for April. Moore Wholesalers Purchases Budget