Indian River Beverage Distributors projects the following sales: April May June $ 165,000 $ 187,000 $ 116,000 83 percent of Indian River's sales are on credit with 62 percent of receivables collected in the month after the sale and the rest of receivables collected in the second month after the sale. February sales were $145,000 and March sales were $156,000. In the past Ellis' bad debt percentage has been 0 and is expected to continue. Prepare a monthly schedule of cash receipts for April-June and submit it as an Excel worksheet to support the following answers (this worksheet is REQUIRED): Enter whole numbers, do not use $ sign or commas, i.e. 12345 a) Cash Receipts for April b) Cash Receipts for May c) Cash Receipts for June d) Accounts receivable at June 30.