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

1.		Collections from customers: January $90,600; February $110,800.
2.		Payments to suppliers: January $40,000; February $50,400.
3.		Direct labour: January $30,000; February $35,100. Wages are paid in the month they are incurred.
4.		Manufacturing overhead: January $24,800; February $30,300. Overhead costs are paid as incurred.
5.		Selling and administrative expenses: January $16,100; February $22,100. These costs do not include depreciation and they are paid as incurred.
6.		Sales of investments in January are expected to realize $9,900 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
Total receiptsExcess of cash over cash disbursementsFinancing borrowing needsCash receiptsEnding cash balanceTotal disbursementsTotal cash availableCash disbursementsBeginning cash balance		$		$
AddLess: Ending cash balanceTotal receiptsFinancing borrowing needsTotal cash availableExcess of cash over cash disbursementsCash receiptsBeginning cash balance
Purchase of equipmentPurchase of landCollection of notes receivableCollections from customersManufacturing overheadSale of investmentsLabourSelling and administrative expensesPayment to suppliers
Purchase of equipmentCollection of notes receivableManufacturing overheadPayment to suppliersSale of investmentsSelling and administrative expensesPurchase of landLabourCollections from customers
Total receiptsCash receiptsFinancing borrowing needsBeginning cash balanceTotal cash availableExcess of cash over cash disbursementsEnding cash balance
AddLess: Ending cash balanceTotal disbursementsCash disbursementsTotal cash availableBeginning cash balanceFinancing borrowing needsExcess of cash over cash disbursements
Manufacturing overheadSelling and administrative expensesPayment to suppliersCollection of notes receivablePurchase of landSale of investmentsLabourCollections from customersPurchase of equipment
LabourManufacturing overheadSale of investmentsPurchase of equipmentPurchase of landCollections from customersSelling and administrative expensesPayment to suppliersCollection of notes receivable
Payment to suppliersSelling and administrative expensesCollections from customersLabourSale of investmentsManufacturing overheadPurchase of equipmentCollection of notes receivablePurchase of land
Collection of notes receivablePayment to suppliersPurchase of equipmentCollections from customersSale of investmentsPurchase of landSelling and administrative expensesManufacturing overheadLabour
Cash disbursementsTotal disbursementsCash receiptsTotal receiptsExcess of cash over cash disbursementsTotal cash availableEnding cash balanceBeginning cash balanceFinancing borrowing needs
Financing borrowing needsTotal cash availableExcess of cash over cash disbursementsEnding cash balanceTotal receiptsBeginning cash balanceCash receiptsTotal disbursementsCash disbursements
Cash disbursementsBeginning cash balanceCash receiptsTotal receiptsFinancing borrowing needsEnding cash balanceTotal disbursementsTotal cash availableExcess of cash over cash disbursements		$		$