Kay’s Hardware Ltd’s budgeted monthly sales for January to June 2016 are given below. About 70% of the monthly sales are expected to be on credit. Approximately 60% of the credit sales are collected in the month of sale, 30% in the month following the sale, and 5% in the second month following the sale; 5% are never collected and are written off.

The budgeted gross sales including GST of 10% by month are:

January       $115000

February        162000

March            139000

April               125000

May               150000

June               130000

Required

Prepare a schedule of expected cash receipts from sales for April, May and June 2016