solve the table ? please

Check Problem 4-18 Schedule of cash receipts (LO4-2] Simpson Glove Company has made the following sales projections for the next six months. All sales are credit sales. March April May June July August $48,000 57,000 39,000 54,000 65,000 69,000 Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible. 40 percent are collected in the month of sale, 30 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare a monthly cash receipts schedule for the firm for March through August. Simpson Glove Company Cash Receipts Schedule March April January February May June July August Credit sales Check or May June July August 39,000 54,000 65,000 69,000 Sales in January and February were $41,000 and $39,000, respectively. Experience has shown that of total sales receipts 10 percent are uncollectible, 40 percent are collected in the month of sale, 30 percent are collected in the following month, and 20 percent are collected two months after sale. Prepare a monthly cash receipts schedule for the firm for March through August. Simpson Glove Company Cash Receipts Schedule March April January February May June July August Credit sales In month of sale One month after sale Two months after sale Total cash receipts $ 0 $ 0 $ 0 $ 0 $ 0