Bauer Corporation anticipates the following sales revenue over a five-month period:

Bauer Corporation's sales are 50 % cash and 50% credit. The Bauer Corporation's collection history indicates that credit sales are collected as follows:

Required: Prepare a cash collections budget for each month in the quarter (January, February, and March) and for the quarter in total.

November Sales revenue $20,000 December $22,000 January $26,000 February $18,000 March $21,000