Carter Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow:
o Sales are budgeted at $380,000 for November, $390,000 for December, and $400,000 for January.
o Collections are expected to be 70% in the month of sale, 27% in the month following the sale, and 3% uncollectible.
o The cost of goods sold is 65% of sales.
o The company desires to have an ending merchandise inventory equal to 80% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase. o Other monthly expenses to be paid in cash are $22,000.
o Monthly depreciation is $20,000.
o Ignore taxes.
---------------------------------------------------------------------------------
Balance Sheet October 31
Assets
Cash $13,000
Accounts receivable, net of allowance for uncollectible accounts 77,000
Inventory 197,600
Property, plant and equipment, net of $502,000 accumulated depreciation 992,000
Total assets $1,279,600
Liabilities and Stockholders' Equity:
Accounts payable $240,000
Common stock 780,000
Retained earnings 259,600
Total liabilities and stockholders' equity $1,279,600
---------------------------------------------------------------------------------------
What is the cash balance at the end of December?
Schedule of cash collections and Schedule of purchase budget is prepared first to find out the total cash collections and purchases and then cash budget is prepared to find out the cash balance as on December 31.
Carter Lumber sells lumber and general building supplies to building contractors in a medium-sized town in...
Carver Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow: .Sales are budgeted at $350,000 for November, $320,000 for December, and $300,000 for January. Collections are expected to be 90% in the month of sale and 10% in the month following the sale. The cost of goods sold is 75% of sales The company desires to have an ending merchandise inventory equal to 60% of the following...
Carver Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow: Sales are budgeted at $350,000 for November, $320,000 for December, and $300,000 for January. Collections are expected to be 90% in the month of sale and 10% in the month following the sale. The cost of goods sold is 75% of sales. The company desires to have an ending merchandise inventory equal to 60% of the following...
Carver Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow: • Sales are budgeted at $350,000 for November, $320,000 for December, and $300,000 for January • Collections are expected to be 90% in the month of sale and 10% in the month following the sale. • The cost of goods sold is 75% of sales. • The company desires to have an ending merchandise inventory equal to...
Carver Lumber sells lumber and general building supplies to building contractors in a medium sized town in Montana Data regarding the store's operations follow • Sales are budgeted at $368.000 for November. $338,000 for December, and $318.000 for January • Collections are expected to be 90% in the month of sale and 10% in the month following the sale. • The cost of goods sold is 75% of sales • The company desires to have an ending merchandise inventory equal...
Carter Lumber sells lumber and general building supplies to building contracttors in a medium-sized town in Montana Deta regarding the store's operations follow o Sales are budgeted at $438,000 for November, $448,000 for December, and $458,000 for January o Collections are expected to be 70% in the month of sale. 27 % in the month following the sale, and 3 % uncollectible. o The cost of goods sold is 70 % of sales o The company desires to have an...
TB MC Qu. 8-211 Carver Lumber sells lumber and general ... Carver Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow: • Sales are budgeted at $350,000 for November, $320,000 for December, and $300,000 for January. • Collections are expected to be 90% in the month of sale and 10% in the month following the sale. • The cost of goods sold is 75% of sales. •...
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: 18 • Sales are budgeted at $251,000 for November, $291,000 for December, and $218,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 desires to have an ending merchandise inventory at the end of each...
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: 18 • Sales are budgeted at $251,000 for November, $291,000 for December, and $218,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 desires to have an ending merchandise inventory at the end of each...
Bracken Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: o Sales are budgeted at $462,000 for November, $348,000 for December, and $380,000 for January. o Collections are expected to be 80% in the month of sale, 17% in the month following the sale, and 3% uncollectible. o The cost of goods sold is 85% of sales. o The company would like to maintain ending merchandise inventories equal to 70% of the next month's...
Bracken Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: • Sales are budgeted at $380,000 for November, $400,000 for December, and $400,000 for January • Collections are expected to be 80% In the month of sale, 19% In the month following the sale, and 1% uncollectible. • 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...