Bramble Company expects to have a cash balance of $$54,900$ on January $1,2022.$ Relevant monthly budget data for the first $2$ months of $2022$ are as follows.

Collections from customers: January $$103,700,$ February $$183,000.$

Payments for direct materials: January $$61,000,$ February $$91,500.$

Direct labor: January $$36,600,$ February $$54,900.$ Wages are paid in the month they are incurred.

Manufacturing overhead: January $$25,620,$ February $$30,500.$ These costs include depreciation of $$1,830$ per month. All other overhead costs are paid as incurred.

Selling and administrative expenses: January $$18,300,$ February $$24,400.$ These costs are exclusive of depreciation. They are paid as incurred.

Sales of marketable securities in January are expected to realize $$14,640$ in cash. Bramble Company has a line of credit at a local bank that enables it to borrow up to $$30,500.$ The company wants to maintain a minimum monthly cash balance of $$24,400.$

Prepare a cash budget for January and February.

BRAMBLE COMPANY

Cash Budget