Prime Products hopes to borrow $$93,000$ on April $1$ and repay it plus interest of $$1,280$ on June $30.$ The following data are available for the months April through June, during which the loan will be used:

On April $1,$ the start of the loan period, the cash balance will be $$36,000.$ Accounts receivable on April $1$ will total $$179,200,$ of which $$153,600$ will be collected during April and $$20,480$ will be collected during May. The remainder will be uncollectible.

The company estimates $30\%$ of a month$$s sales are collected in the month of sale, $60\%$ in the month following sale, and $8\%$ in the second month following sale. The other $2\%$ are bad debts that are never collected. Budgeted sales and expenses for the three$-$month period follow:

April May June

Sales $($all on account$)$ $ $232,000$ $ $476,000$ $ $296,000$

Merchandise purchases $ $188,000$ $ $163,500$ $ $135,500$

Payroll $ $22,800$ $ $22,800$ $ $26,900$

Lease payments $ $31,400$ $ $31,400$ $ $31,400$

Advertising $ $63,600$ $ $63,600$ $ $41,680$

Equipment purchases $$ $ $102,000$

Depreciation $ $17,800$ $ $17,800$ $ $17,800$

Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid in April, total $$162,500.$

Required:

Calculate the expected cash collections for April, May, and June, and for the three months in total.

Prepare a cash budget, by month and in total, for the three$-$month period. Assume the $$93,000$ loan is made on April $1$ and repaid with interest on June $30.$