Duffy Corporation Has Prepared the Following Sales Budget Collections Are 40% in the Month of Sale,45% in the l

Duffy Corporation has prepared the following sales budget:
$$\begin{array} { l r r } \text { Month } & \text { Cash Sales } & \text { Credit Sales } \\ \text { May } & \$ 16,000 & \$ 68,000 \\\text { June } & 20,000 & 80,000 \\\text { July } & 18,000 & 74,000 \\\text { August } & 24,000 & 92,000 \\\text { September } & 22,000 & 76,000\end{array}$$ Collections are 40% in the month of sale,45% in the month following the sale,and 10% two months following the sale.The remaining 5% is expected to be uncollectible.
Required:
Prepare a schedule of cash collections for July through September.