How do I make a cash budget with this info?

MarineWest Enterprises Inc. (MWEI) is experiencing cash flow difficulties and the bank is considering demanding repayment of an existing loan due to the uncertainty of the company's ability to make loan payments as they become due.The bank has asked that the company provide a cash budget for the three months (May, June, and July). They are interested in knowing if the company can re-pay $50,000 of a term loan, due at the end of June.

Exhibit one contains the sales revenue for the past three months as well as estimated sales revenue for June and July. MEI's busiest month is in June. On average, 25% of the monthly sales are collected in cash and the remaining 75% of the sales are sold on credit.The collection pattern for the credit sales is that 20% are received in the month of the sale, 70% are received in the first month following sale and 8% are received in the second month following the sale. Any remaining amounts are deemed uncollectible.

MWEI purchased significant amounts of inventory in as June is its busiest month. Typically, MWEI pays 50% of the cost of the purchases in the month of the purchase and 50% in the month following. Actual and anticipated sales revenue and purchases of inventory are provided in exhibit one.

Exhibit One

Exhibit One Month Sales Revenue Units Purchased March (actual) $400,000 2,000 April (actual) $400,000 4,000 May (actual) $500,000 10,000 June (estimated) $700,000 5,000 July (estimated) $300,000 2,000 August (estimated) $350,000 3,000