Question #1 Avery is charged with projecting cash receipts that will be collected over the next six months for the Belloff Medical Clinic. Based on historical data, she has compiled the following projections for patient service revenue. She also has developed the estimated collection rates shown in green below. Please complete the calculations for cash receipts by filling in the table below in yellow. Projected cash receipts by month Month revenue is earned Patient service revenue for month Total projected cash receipts for the month of service Jan Feb March April May June Jan Feb March April May June Total 00000 90,000 110,000 115,000 95,000 90,000 115,000 615,000 $ Estimated collection rates: Cash collected ir in month of service Cash collected in month after month of service Cash collected two months after month of service TTI Please complete the calculations for cash receipts by filling in the table above in yellow. 35% 35% 10% 80%