Purchase Budget | ||||||
Nov | Dec | Jan | ||||
Sales in $ | 370000 | 350000 | 340000 | |||
Cost of Goods sold @ 70% of sales | 259000 | 245000 | 238000 | |||
Add: Ending Inventory of FG | 147000 | 142800 | ||||
Total Rrequirement | 406000 | 387800 | ||||
Less: Desired Beginning Inventory | 155400 | 147000 | ||||
Budgeted Purchases | 250600 | 240800 | ||||
Cash Disbursement of Dec: | ||||||
Nov Purchases (100% of 250600) | 250600 | |||||
Total cash disbursements for dec | 250600 | |||||
Answer is $ 250600 | ||||||
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow:...
Provide formulas, procedure in excel QUESTION 6 Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $370,000 for November, $350,000 for December, and $340,000 for January. Collections are expected to be 55% in the month of sale and 45% in the month following the sale. The cost of goods sold is 70% of sales. The company would like maintain ending merchandise inventories equal to 60% of the next month's...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $440,000 for November, $420,000 for December, and $410,000 for January. Collections are expected to be 65% in the month of sale and 35% in the month following the sale. The cost of goods sold is 80% of sales. The company would like to maintain ending merchandise inventories equal to 70% of the next month's cost of goods sold. Payment for...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $350,000 for November, $330,000 for December, and $320,000 for January. Collections are expected to be 45% in the month of sale and 55% in the month following the sale. The cost of goods sold is 75% of sales. The company would like to maintain ending merchandise inventories equal to 80% of the next month's cost of goods sold. Payment for...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $260,000 for November, $240,000 for December, and $230,000 for January. Collections are expected to be 55% in the month of sale and 45% in the month following the sale. The cost of goods sold is 80% of sales. The company would like to maintain ending merchandise inventories equal to 70% of the next month's cost of goods sold. Payment for...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $450,000 for November, $430,000 for December, and $420,000 for January. Collections are expected to be 40% in the month of sale and 60% in the month following the sale. The cost of goods sold is 75% of sales. The company would like to maintain ending merchandise inventories equal to 65% of the next month's cost of goods sold. Payment for...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $400,000 for November, $380,000 for December, and $370,000 for January. Collections are expected to be 45% in the month of sale and 55% in the month following the sale. The cost of goods sold is 75% of sales. The company would like maintain ending merchandise inventories equal to 65% of the next month's cost of goods sold. Payment for merchandise...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $250,000 for November, $230,000 for December, and $220,000 for January. Collections are expected to be 60% in the month of sale and 40% in the month following the sale. The cost of goods sold is 75% of sales. The company would like to maintain ending merchandise inventories equal to 65% of the next month's cost of goods sold. Payment for...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $340,000 for November, $320,000 for December, and $310,000 for January. Collections are expected to be 80% in the month of sale and 20% in the month following the sale. The cost of goods sold is 75% of sales. The company would like to maintain ending merchandise inventories equal to 60% of the next month's cost of goods sold. Payment for...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $280.000 for November. $260.000 for December, and $250,000 for January · Collections are expected to be 45% in the month of sale and 55% in the month following the sale. • The cost of goods sold is 80% of sales. . The company would like to maintain ending merchandise inventories equal to 70% of the next month's cost of goods...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $210,000 for November, $190,000 for December, and $180,000 for January. Collections are expected to be 50% in the month of sale and 50% in the month following the sale. The cost of goods sold is 55% of sales. The company would like maintain ending merchandise inventories equal to 45% of the next month's cost of goods sold. Payment for merchandise...