Prepare a schedule of cash collections for april

Question

Marvin Company has the following sales budget:

Month                Cash Sales          Credit Sales

February                 $14,000                   $30,000

March                        12,800                     32,000

April                          10,800                     28,000

Collections of credit sales are 40% in the month of sale, 50% in the month after sale and 10% two months after sale. No uncollectible accounts are expected.

Prepare a schedule of cash collections for April.