how do i create a cash colection?

Attached are budgeted sales for the month's of September October. September October $120,000 $140,000 25% of sales are collected immediately in cash, Of the 75% which are credit sales - 50% is collected later in the month sold, 30% are collected the month following the sale, 15% is collected two months later The remainder is uncollectible. 3 5 5 Prepare a schedule of the months cash collections will occur from sales for the months of September and October