Simpson Glove Company has made the following sales projection for the next 6 months all sales are credit sales
March $36,000 June $42,000
April 45,000 July 53,000
May 27,000 August 57,000
Sales in January and February were $41,000 and $39,000 respectively. Experience has shown that of total .sales receipts, 10% are uncollected, 40% are collected in the month of sale, 30% are collected in the following month and 20% are collected 2 months after sale.
Prepare a monthly cash receipts schedule for the firm for March through August.