I would REALLY appreciate any help you could give me with this problem:

Sales
May 60,000
June 70,000
July 80,000
August 100,000
All sales are on credit. Records show that 60 percent of the customers pay during the month of the sale, 20 percent pay the month after the sale, and the remaining 15 percent pay the second month after the sale. 5% are uncollectable.

Prepare a cash collections budget for July and August.

Thanks so much!

CaptainForest

July Cash Collections
July sales = 80,000 * .6 = 48,000
June sales = 70,000 * .2 = 14,000
May sales = 60,000 * .15 = 9,000
TOTAL CASH COLLECTIONS IN JULY = 71,000

August Cash Collections
August sales = 100,000 * .6 = 60,000
July sales = 80,000 * .2 = 16,000
June sales = 70,000 * .15 = 10,500
TOTAL CASH COLLECTIONS IN AUGUST = 86,500