Mo Bill Of Sale Accounting-Managerial Homework Help With Schedule Of Cash Payments For Purchases.?

Accounting-Managerial homework help with schedule of cash payments for purchases.? - mo bill of sale

Do you know how to make a schedule of expected cash payments for purchases prepared in July ???????????? Please, any idea?
Company sells a product that is $ 30 for $ 20 is purchased.
Because information:
Sales for the month of the income
May $ 30,000
June 42,000
July 48,000
August 60,000
Balance on 1 July are:
$ 20,000 in cash
Merchandise inventories 16,000
Accounts Receivable (Sales) 19200
Accounts Payable (Purchases) 15.000
Criteria
1. The company pays half of the purchases in the month of acquisition and the remainder in the following month.
2.End inventory should plan 50% of units sold for the next month.
3.2% discount on sales is allowed if payments are made during the month. Turnover.
Billing customers are:
50% collected in MO. Sales
40% made 1 month. after sale
8% 2 months. after sale
Uncollected 2%