Circle a Company Is Preparing Its Cash Collections Budget for the 2^nd

Circle A Company is preparing its cash collections budget for the 2^nd quarter of 2012. Budgeted sales are as follows:
$$\begin{array} { | l | r | r | r | } \hline \text { Budgeted stalas } &{ \text { Apr } } & { \text { May } } & { \text { Jun } } \\\hline \text { Cash sales } & \$ 10,000 & \$ 9,000 & \$ 7,500 \\\hline \text { Credit sales } & 24,000 & 20,000 & 16,500 \\\hline \text { Total sales } & \$ 34,000 & \$ 29,000 & \$ 24,000 \\\hline\end{array}$$
Accounts receivable at March 31 were $14,000. The budget assumes that 20% of credit sales are collected in the month of sale, and the remaining 80% are collected one month later. Using the format below, please prepare the cash collections budget.
$$\begin{array} { | l | l | l | l | } \hline \text { Budgeted cash collections } & \text { Apr } & \text { May } & \text { Jun } \\\hline \text { Cash sales collected in month of sale } & & & \\\hline \text { Credit sales } - 20 \% \text { collected in current month } & & & \\\hline \text { Credit sales - } 80 \% \text { collected from previous } & & & \\\text { month } & & & \\\hline \text { Total collections } & & & \\\hline\end{array}$$