prepare an analysis of cash receipts from sales for abc comany for august

ABC Company's budgeted sales for June, July, ad August are 15,800, 19,800, and 17,500 units respectively. The selling price for each unit is $18. Based on past experience, ABC expects that 30% of a month's sales will be collected in the month of sale, 60% in the following month, and 4% in the second month following the sale. Required: Prepare an analysis of cash receipts from sales for ABC Company for August