ABC Companys budgeted sales for June, July, and August are 12,600, 16,600, and 14,600 units. The selling price for each unit is $16. Based on past experience, ABC expects that 25% of a months sales will be collected in the month of sale, 70% in the following month, and 3% in the second month following the sale.

Required:

Prepare an analysis of cash receipts from sales for ABC Company for August.

	June	July	August
Budgeted sales units
Unit selling price
Budgeted sales revenue
August collections
Current months sales
Prior months sales
second prior months sales
Total collections