Here are some important figures from the budget of Nashville Nougats, Incorporated, for the second quarter of 2022:

	April	May	June
Credit sales	$ 416,000	$ 365,000	$ 453,000
Credit purchases	193,000	181,000	214,000
Cash disbursements
Wages, taxes, and expenses	81,100	76,600	105,300
Interest	10,800	10,800	10,800
Equipment purchases	40,000	12,500	161,000

The company predicts that 5 percent of its credit sales will never be collected, 25 percent of its sales will be collected in the month of the sale, and the remaining 70 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2022, credit sales were $343,000.

Using this information, complete the following cash budget.

AprilMayJuneBeginning cash balance $123,000Cash receiptsCash collections from credit salesTotal cash availableCash disbursementsPurchases$185,000Wages, taxes, and expensesInterestEquipment purchasesTotal cash disbursementsEnding cash balance