QS $22-22($Algo$)$ Computing budgeted accounts receivable LO P$2$

Kingston budgets total sales for June and July of $$370,000$ and $$328,000,$ respectively. Cash sales are $60\%$ of total sales. Of the credit sales, $20\%$ are collected in the month of sale, $65\%$ are collected during the first month after the sale, and the remaining $15\%$ 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.$

Answer is complete but not entirely correct.

$\backslash$table$[[$Sales month,Total Sales,Credit Sales,As of July $31],[\backslash$table$[[$Percent$],[$Uncollected$]],\backslash$table$[[$Amount$],[$Uncollected$]]],[$June$,$$$,370,000,$$$,222,000\backslash$times $,15\%,33,300\backslash$times $],[$July$,,328,000,,196,800\backslash$times $,80\%,157,440\backslash$times $],[$Total$,,,,,,190,740]]$