adia Company expects to have a cash balance of $45,300 on January 1, 2020. Nadia has budgeted the following for the first two months of the year 2020:

1.		Collections from customers: January $89,700; February $110,200.
2.		Payments to suppliers: January $40,100; February $50,400.
3.		Direct labour: January $30,000; February $35,000. Wages are paid in the month they are incurred.
4.		Manufacturing overhead: January $24,900; February $30,300. Overhead costs are paid as incurred.
5.		Selling and administrative expenses: January $15,900; February $21,700. These costs do not include depreciation and they are paid as incurred.
6.		Sales of investments in January are expected to realize $10,100 in cash. Nadia Company wants to keep a minimum monthly cash balance of $20,000.

Prepare a cash budget for January and February.

NADIA COMPANY Cash Budget For 2020
		January		February
Ending cash balanceCash disbursementsExcess of cash over cash disbursementsFinancing borrowing needsTotal disbursementsCash receiptsTotal receiptsBeginning cash balanceTotal cash available		$		$
AddLess: Total cash availableTotal receiptsBeginning cash balanceExcess of cash over cash disbursementsCash receiptsEnding cash balanceFinancing borrowing needs
Manufacturing overheadPayment to suppliersLabourPurchase of landSale of investmentsCollection of notes receivableCollections from customersSelling and administrative expensesPurchase of equipment
Collection of notes receivablePurchase of landLabourSale of investmentsPurchase of equipmentPayment to suppliersManufacturing overheadSelling and administrative expensesCollections from customers
Total cash availableBeginning cash balanceExcess of cash over cash disbursementsFinancing borrowing needsTotal receiptsEnding cash balanceCash receipts
AddLess: Financing borrowing needsEnding cash balanceCash disbursementsExcess of cash over cash disbursementsTotal disbursementsBeginning cash balanceTotal cash available
LabourPayment to suppliersCollection of notes receivablePurchase of equipmentManufacturing overheadPurchase of landSelling and administrative expensesSale of investmentsCollections from customers
Collection of notes receivableSelling and administrative expensesSale of investmentsPayment to suppliersPurchase of landPurchase of equipmentManufacturing overheadCollections from customersLabour
Sale of investmentsCollection of notes receivablePayment to suppliersCollections from customersPurchase of landLabourPurchase of equipmentManufacturing overheadSelling and administrative expenses
Sale of investmentsCollection of notes receivableSelling and administrative expensesManufacturing overheadCollections from customersPurchase of landPurchase of equipmentPayment to suppliersLabour
Cash receiptsFinancing borrowing needsBeginning cash balanceExcess of cash over cash disbursementsTotal disbursementsEnding cash balanceTotal cash availableTotal receiptsCash disbursements
Ending cash balanceTotal cash availableCash receiptsExcess of cash over cash disbursementsTotal disbursementsCash disbursementsTotal receiptsFinancing borrowing needsBeginning cash balance
Total cash availableEnding cash balanceTotal receiptsCash disbursementsTotal disbursementsCash receiptsExcess of cash over cash disbursementsBeginning cash balanceFinancing borrowing needs		$		$