Question

In: Accounting

BBTalk Company Limited sells tiles and other decoration products. Data of the store's operations are as...

BBTalk Company Limited sells tiles and other decoration products. Data of the store's operations are as follow:

• Sales are budgeted at $340,000 for November 2019, $320,000 for December 2019, and $330,000 for January 2020.

• Collections are expected to be 85% in the month of sale, 14% in the month following the sale, and 1% uncollectible will be recorded as bad debt expense.

• The cost of goods sold is 60% of sales.

•The company purchases 78% of its merchandise in the month prior to the month of sale and 22% in the month of sale. Payment for inventory is made in the month following the purchase.

• Depreciation is $20,200 per month.

• Other monthly expenses to be paid in cash are $18,000.

• Other information as at 31 Oct 2019:
Cash $42,000
Accounts receivable (net of allowance for uncollectible accounts) $85,000
Accounts payable $218,000

• Ignore taxes.

Required:

a. Prepare a Schedule of Expected Cash Collection for November and December.

b. Prepare a Merchandise Purchases Budget for November and December.

c. Prepare a Cash Budget showing the captions with figures of beginning, excess/(deficiency), ending balance and so on for November and December.

d. Prepare an Income Statement Budget for November and December.

Solutions

Expert Solution


Related Solutions

The corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow:...
The corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $250,000 for November, $270,000 for December, and 235,000 for January Cash collections expected to be 246,000 for Nov, 273,000 for Dec, and 244,000 for Jan Cost of goods sold = 65% Cash disbursements for food product purchases are expected to be 197,000 for nov, 202,000 for Dec, and 188,000 for Jan Other monthly expenses to be paid in cash are...
Dresser Corporation sells bedroom furniture. Data regarding the store's operations follow: •    Sales are budgeted at...
Dresser Corporation sells bedroom furniture. Data regarding the store's operations follow: •    Sales are budgeted at $330,000 for November, $300,000 for December, and $320,000 for January. •    Collections are expected to be 85% in the month of sale and 15% in the month following the sale. •    The cost of goods sold is 60% of sales. •    The company desires an ending merchandise inventory equal to 80% of the cost of goods sold in the following month. •    Payment for...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow:...
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:...
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:...
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 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:...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: o Sales are budgeted at $340,000 for November, $320,000 for December, and $310,000 for January. o Collections are expected to be 80% in the month of sale and 20% in the month following the sale. o The cost of goods sold is 75% of sales. o The company would like to maintain ending merchandise inventories equal to 60% of the next month's cost of...
Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales...
Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $250,000 for November, $270,000 for December, and $235,000 for January. Cash collections are expected to be $246,000 for November, $273,000 for December, and $244,000 for January. The cost of goods sold is 65% of sales. Cash disbursements for food product purchases are expected to be $197,000 for November, $202,000 for December, and $188,000 for January. Other monthly expenses to be paid...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow:...
Bramble Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: Sales are budgeted at $230,000 for November, $210,000 for December, and $200,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 65% of sales. The company would like maintain ending merchandise inventories equal to 55% of the next month's cost of goods sold. Payment for merchandise...
ABC Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow:...
ABC Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: ▪ Sales are budgeted at $330,000 for November, $300,000 for December, and $320,000 for January. ▪ Collections are expected to be 85% in the month of sale and 15% in the month following the sale. ▪ The cost of goods sold is 60% of sales. ▪ The company desires an ending merchandise inventory equal to 80% of the cost of goods sold in the...
Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are...
Capes Corporation is a wholesaler of industrial goods. Data regarding the store's operations follow: Sales are budgeted at $470,000 for November, $480,000 for December, and $460,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 70% of sales. The company desires an ending merchandise inventory equal to 40% of the cost of goods sold in the following month. Payment for merchandise is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT