Here are some important figures from the budget of Nashville Nougats Inc. for the second quarter of 2017:AprilMayJuneCredit sales$1,214,000$1,147,000$1,783,000Cash disbursementsWages, taxes, and expenses355,800365,000357,300Interest121,100121,100121,100Equipment purchases153,000198,0000Collections are as follows: 30% the month of the sale, 35% the month following the sale and the remaining the second month following the sale.The company estimates that 2% will be uncollectable. Purchases are as follows: 45% of the next month Sales. Accounts payable period is 10days.In February 2017 credit sales were 1,780,000 $. In March 2017, credit sales were $1,894,000. Credit sales for July are estimated to be 10% more than June. Using this information, complete the following cash budget:

AprilMayJuneBeginning cash balance$12,100Cash receiptsCash collections from credit salesTotal cash availableCash disbursementsPayments of Accounts PayableWages, taxes, and expensesInterestEquipment purchasesTotal cash disbursementsEnding cash balanceThe company has to have 10,000 $ always in its bank account. Prepare a short term financial plan for the quarter.