please help me fill out the chart with the given information. thank you!

Kingston budgets total sales for June and July of $390,000 and $388,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 15% are collected in the month of sale, 65% are collected during the first month after the sale, and the remaining 20% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company's budgeted balance sheet as of July 31 . Hint: Determine the percent of June and July sales that are uncollected at July 31