Question

In: Accounting

Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of...

Walker Company prepares monthly budgets. The current budget plans for a September ending merchandise inventory of 36,000 units. Company policy is to end each month with merchandise inventory equal to 20% of budgeted sales for the following month. Budgeted sales and merchandise purchases for the next three months follow. The company budgets sales of 180,000 units in October.

Sales (Units) Purchases (Units)
July 210,000 228,000
August 300,000 302,000
September 310,000 284,000


Prepare the merchandise purchases budgets for the months of July, August, and September.

Solutions

Expert Solution

WALKER COMPANY
Merchandise purchase budget
For July, August and September
July August September
Budgeted ending inventory 300,000*20% = 60,000 310,000*20% = 62,000 180,000*20% = 36,000
Add: Budgeted units sales                                 210,000                                 300,000                                 310,000
Required units available inventory                                 270,000                                 362,000                                 346,000
Less: Beginning inventory 210,000*20% = 42,000 300,000*20% = 60,000 310,000*20% = 62,000
Units to be purchased                                 228,000                                 302,000                                 284,000

You can reach me over comment box if you have any doubts. Please rate this answer

ekkarill92 answered 3 years ago
Next > < Previous

Related Solutions

Daniel Company uses a periodic inventory system. Data for the current year: beginning merchandise inventory (ending...
Daniel Company uses a periodic inventory system. Data for the current year: beginning merchandise inventory (ending inventory December 31, prior year), 2,130 units at $35; purchases, 7,800 units at $37; expenses (excluding income taxes), $193,200; ending inventory per physical count at December 31, current year, 1,690 units; sales, 8,240 units; sales price per unit, $76; and average income tax rate, 30 percent. Required information Required: 1. Compute cost of goods sold and prepare income statements under the FIFO, LIFO, and...
Daniel Company uses a periodic inventory system. Data for the current year: beginning merchandise inventory (ending...
Daniel Company uses a periodic inventory system. Data for the current year: beginning merchandise inventory (ending inventory December 31, prior year), 2,070 units at $35; purchases, 7,920 units at $37; expenses (excluding income taxes), $193,500; ending inventory per physical count at December 31, current year, 1,670 units; sales, 8,320 units; sales price per unit, $77; and average income tax rate, 36 percent. 1. Compute cost of goods sold and prepare income statements under the FIFO, LIFO, and average cost inventory...
TO Industries prepares monthly cash budgets. The following budget information is available for April and May...
TO Industries prepares monthly cash budgets. The following budget information is available for April and May 2020: April May Sales $650,000 $700,000 Direct material purchases 220,000 240,000 Direct labor 175,000 180,000 Manufacturing overhead 120,000 130,000 Selling and administrative expenses 150,000 150,000 All sales are credit sales. The company expects to collect 65% from customers in the month of the sale and the remaining 35% in first month following the sale. The company purchases direct materials on account. The company pays...
TO Industries prepares monthly cash budgets. The following budget information is available for July and August...
TO Industries prepares monthly cash budgets. The following budget information is available for July and August 2017: July August Sales $700,000 $800,000 Direct material purchases 220,000 240,000 Direct labor 200,000 230,000 Manufacturing overhead 120,000 150,000 Selling and administrative expenses 150,000 160,000 All sales are credit sales. The company expects to collect 60% from customers in the month of the sale and the remaining 40% in first month following the sale. The company purchases direct materials on account. The company pays...
TO Industries prepares monthly cash budgets. The following budget information is available for April and May...
TO Industries prepares monthly cash budgets. The following budget information is available for April and May 2019: April May Sales $650,000 $700,000 Direct material purchases 220,000 240,000 Direct labor 175,000 180,000 Manufacturing overhead 120,000 130,000 Selling and administrative expenses 150,000 150,000 All sales are credit sales. The company expects to collect 60% from customers in the month of the sale and the remaining 40% in first month following the sale. The company purchases direct materials on account. The company pays...
X Company was created on September 1 and prepares monthly financial statements. During September, X Company...
X Company was created on September 1 and prepares monthly financial statements. During September, X Company issued stock to investors for $98,000, borrowed $83,000 from a bank, bought merchandise that it planned to sell, paying $3,416 and promising to pay $5,166 in October, bought equipment, paying $5,100 and promising to pay $4,800 in December, paid $3,603 that it had promised to pay to suppliers for previous purchases on account, sold merchandise, receiving cash of $16,879 and promises to pay from...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $439,200 $488,000 Direct materials purchases 146,400 152,500 Direct labor 109,800 122,000 Manufacturing overhead 85,400 91,500 Selling and administrative expenses 96,380 103,700 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $ 426,960 $ 474,400 Direct materials purchases 142,320 148,250 Direct labor 106,740 118,600 Manufacturing overhead 83,020 88,950 Selling and administrative expenses 93,694 100,810 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows....
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2020 are as follows. January February Sales $435,600 $484,000 Direct materials purchases 145,200 151,250 Direct labor 108,900 121,000 Manufacturing overhead 84,700 90,750 Selling and administrative expenses 95,590 102,850 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows:...
Colter Company prepares monthly cash budgets. Relevant data from operating budgets for 2017 are as follows: January February Sales $ 425,520 $ 472,800 Direct materials purchases 141,840 147,750 Direct labor 106,380 118,200 Manufacturing overhead 82,740 88,650 Selling and administrative expenses 93,378 100,470 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT