Pet Joy Wholesale Inc., a pet wholesale supplier, was organized on May 1, 2010. Projected sales for each of the first three months of operations are as follows:

May                  $360,000

June                   450,000

July                    600,000

The company expects to sell 10% of its merchandise for cash. Of sales on account, 50% are expected to be collected in the month of the sale, 35% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for May, June, and July.