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

1.		Collections from customers: January $90,700; February $110,400.
2.		Payments to suppliers: January $39,800; February $50,100.
3.		Direct labour: January $30,100; February $35,100. Wages are paid in the month they are incurred.
4.		Manufacturing overhead: January $25,100; February $29,900. Overhead costs are paid as incurred.
5.		Selling and administrative expenses: January $15,900; February $21,900. 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. Shamrock Company wants to keep a minimum monthly cash balance of $20,000. Ignore any interest on amounts borrowed.

Prepare a cash budget for January and February.

SHAMROCK COMPANY Cash Budget For 2022
		January		February
select an opening cash budget item Ending cash balanceCash receiptsBeginning cash balanceTotal receiptsFinancing borrowing needsTotal cash disbursementsTotal cash availableExcess of cash over cash disbursementsCash disbursements		$enter a dollar amount		$enter a dollar amount
select between addition and deduction AddLess: select an opening name for section one Cash disbursementsTotal cash availableTotal cash disbursementsFinancing borrowing needsEnding cash balanceExcess of cash over cash disbursementsBeginning cash balanceTotal receiptsCash receipts
select a cash budget item Collection of notes receivablePayment to suppliersPurchase of landSelling and administrative expensesLabourPurchase of equipmentManufacturing overheadCollections from customersSale of investments		enter a dollar amount		enter a dollar amount
select a cash budget item Sale of investmentsCollection of notes receivablePayment to suppliersPurchase of landCollections from customersSelling and administrative expensesLabourManufacturing overheadPurchase of equipment		enter a dollar amount		enter a dollar amount
select a summarizing line for the first part Cash receiptsTotal cash availableFinancing borrowing needsExcess of cash over cash disbursementsTotal receiptsEnding cash balanceTotal cash disbursementsBeginning cash balanceCash disbursements		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 Total cash disbursementsFinancing borrowing needsBeginning cash balanceExcess of cash over cash disbursementsEnding cash balanceTotal cash availableCash disbursementsTotal receiptsCash receipts
select a cash budget item Manufacturing overheadPayment to suppliersCollections from customersLabourCollection of notes receivableSelling and administrative expensesSale of investmentsPurchase of equipmentPurchase of land		enter a dollar amount