Preparing a schedule of cash collections on accounts receivable

weiland and company is a medical billing services firm. all sales of billing services are billed to the client (there are no cash sales). weiland expects that, on average, 15% will be paid in the month of billing, 40% will be paid in the month following billing, and 42% will be paid in the second month following billing. for the next 5 months, the following sales billings are expected:

may $184,000
june 192,000
july 207,000
august 175,000
september 164,000
required:

prepare a schedule showing the cash expected in payments on accounts receivable in august and in september. if an amount box does not require an entry, enter "0".

schedule for cash collections on accounts

schedule for cash collections on accounts receivable
august september
june:
$ × % $ $
july:
$ × %
$ × %
august:
$ × %
$ × %
september:
$ × %
total cash receipts $ $