Experience has shown that 50% percent of the sales of Geraghty Company sales are for cash.

Monthly sales are budgeted as follows: $280,000 for October, $240,000 for November, and $320,000 for December.

The rest are on credit with 70% of the credit sales are collected in the month of sale, 20% in the month following sale, and 5% in the second month following sale. The remainder is expected to be uncollectible.

Task: Create a schedule of expected cash collections for the month of December (5 marks).