Bauer Corporation Anticipates the Following Sales Revenue Over a Five

Bauer Corporation anticipates the following sales revenue over a five month period:
$$\begin{array} { |l | c | c | c | c | r |} \hline& \text { November } & \text { December } & \text { January } & \text { February } & \text { March } \\\hline \text { Sales revenue } & \$ 20,000 & \$ 22,000 & \$ 26,000 & \$ 18,000 & \$ 21,000\\\hline\end{array}$$
Bauer Corporation's sales are 40% cash and 60% credit.The Bauer Corporation's collection history indicates that credit sales are collected as follows:
$$\begin{array} { | l | r | } \hline \text { Month of sale } & 20 \% \\\hline \text { Month after sale } & 50 \% \\\hline \text { Two months after sale } & 25 \% \\\hline \text { Uncallectible } & 5 \% \\\hline\end{array}$$ Required:
Prepare a cash collections budget for each month in the quarter (January,February,and March)and for the quarter in total.