Nunez Company expects to have a cash balance of $43,000 on January 1, 2020. Relevant monthly budget data for the first two months of 2020 are as follows:

1.		Collections from customers: January $98,000; February $163,000
2.		Payments to suppliers: January $58,000; February $81,000
3.		Direct labour: January $31,000; February $47,000. Wages are paid in the month they are incurred.
4.		Manufacturing overhead: January $25,000; February $32,000. These costs include depreciation of $1,000 per month. All other overhead costs are paid as incurred.
5.		Selling and administrative expenses: January $15,000; February $19,000. These costs are exclusive of depreciation. They are paid as incurred.
6.		Sales of marketable securities in January are expected to realize $10,000 in cash.

Nunez Company has a line of credit at a local bank. It can borrow up to $24,000. The company wants to keep a minimum monthly cash balance of $23,000. Prepare a cash budget for January and February.

NUNEZ COMPANY Cash Budget For the Two Months Ending February 29, 2020
	Month
		Jan		Feb		Total
select an opening cash budget item Total FinancingExcess of Available Cash Over Cash DisbursementsTotal ReceiptsTotal DisbursementsFinancingCash ReceiptsDisbursementsTotal Available CashEnding Cash BalanceBeginning Cash Balance		$enter a dollar amount		$enter a dollar amount		$enter a total for the row
select between addition and deduction AddLess: select an opening name for section one Excess of Available Cash Over Cash DisbursementsBeginning Cash BalanceTotal Available CashCash ReceiptsEnding Cash BalanceFinancingTotal ReceiptsTotal Financing
select a cash budget item Direct MaterialsManufacturing OverheadPurchase Of LandBorrowingDirect LabourSelling And Administrative ExpensesSale Of Marketable SecuritiesIncome Tax ExpenseCollection Of Notes ReceivableRepaymentCollection From Customers		enter a dollar amount		enter a dollar amount		enter a total for the row
select a cash budget item Collection Of Notes ReceivablePurchase Of LandSelling And Administrative ExpensesDirect LabourManufacturing OverheadBorrowingIncome Tax ExpenseSale Of Marketable SecuritiesRepaymentDirect MaterialsCollection From Customers		enter a dollar amount		enter a dollar amount		enter a total for the row
select a closing name for section one FinancingTotal Available CashExcess of Available Cash Over Cash DisbursementsDisbursementsBeginning Cash BalanceEnding Cash BalanceCash ReceiptsTotal FinancingTotal ReceiptsTotal Disbursements		enter a total amount for section one		enter a total amount for section one		enter a total amount for section one
select a summarizing line for the first part Total ReceiptsExcess of Available Cash Over Cash DisbursementsFinancingTotal FinancingCash ReceiptsTotal DisbursementsDisbursementsTotal Available CashBeginning Cash BalanceEnding Cash Balance		enter a total amount for the first part		enter a total amount for the first part		enter a total amount for the first part
select between addition and deduction AddLess: select an opening name for section two DisbursementsTotal Available CashTotal DisbursementsTotal FinancingExcess of Available Cash Over Cash DisbursementsFinancingEnding Cash BalanceBeginning Cash Balance
select a cash budget item Purchase Of LandSale Of Marketable SecuritiesCollection Of Notes ReceivableDirect MaterialsDirect LabourCollection From CustomersManufacturing OverheadBorrowingIncome Tax ExpenseRepaymentSelling And Administrative Expenses		enter a dollar amount		enter a dollar amount		enter a total for the row
select a cash budget item Collection From CustomersSelling And Administrative ExpensesPurchase Of LandIncome Tax ExpenseSale Of Marketable SecuritiesDirect MaterialsRepaymentBorrowingManufacturing OverheadDirect LabourCollection Of Notes Receivable		enter a dollar amount		enter a dollar amount		enter a total for the row
select a cash budget item Sale Of Marketable SecuritiesBorrowingIncome Tax ExpensePurchase Of LandCollection Of Notes ReceivableSelling And Administrative ExpensesRepaymentCollection From CustomersDirect MaterialsManufacturing OverheadDirect Labour		enter a dollar amount		enter a dollar amount		enter a total for the row
select a cash budget item BorrowingCollection From CustomersSelling And Administrative ExpensesIncome Tax ExpenseRepaymentDirect LabourDirect MaterialsPurchase Of LandCollection Of Notes ReceivableManufacturing OverheadSale Of Marketable Securities		enter a dollar amount		enter a dollar amount		enter a total for the row
select a closing name for section two FinancingEnding Cash BalanceTotal DisbursementsExcess of Available Cash Over Cash DisbursementsTotal FinancingDisbursementsTotal Available CashBeginning Cash Balance		enter a total amount for section two		enter a total amount for section two		enter a total amount for section two
select a summarizing line for the second part Beginning Cash BalanceDisbursementsTotal DisbursementsTotal FinancingCash ReceiptsTotal ReceiptsTotal Available CashExcess of Available Cash Over Cash DisbursementsEnding Cash BalanceFinancing		enter a total amount for the second part		enter a total amount for the second part