Quest for Learning is a start$-$up software development company that develops online training platforms for its clients. Expected revenues for the next few months are shown below.

Based on the past two years of operations, management expects to collect $50\%$ of a month's sales in the month of sale, $40\%$ in the month following the sale, and the remaining $10\%$ in the second month following the sale. May and June sales totalled $$190,000$ and $$250,000,$ respectively. The company is not expecting any bad debts.

Required:

a$.$ Prepare a schedule of expected cash collections from sales, by month and in total, for the three months.

$\backslash$table$[[$Schedule of Expected Cash Collections$],[,$July,,August,September,Total$],[$May sales,,,,,,,$$,0],[$June sales,,,,,,,,$0],[$July sales,,,,,,,,$0],[$August sales,,,,,,,,$0],[$September sales,,,,,,,,$0],[$Total cash collections,$$,0,$$$,0,$$$,0,$$$,0]]$

b$.$ Compute the accounts receivable balance as of September $30.$