Frank's Sporting Goods projects sales for the second quarter of 20XX to be as follows:

Frank's Sporting Goods projects sales for the second quarter of 20XX to be asfollows:April $100,000 May $120,000 June $110,00020% of Frank's sales are for cash, 70% of accounts receivable are collected onemonth following the sale, and the rest are collected two months following the sale.January sales were $40,000, February sales were $60,000, and March sales were$80,000.a) Prepare a monthly schedule of cash receipts for the second quarter of 20XX. SEEHINT BELOW.b) What is the balance in accounts receivable at the end of June?