Please create a schedule of expected cash collections with this information

12. Sales are ona cash and credit basis, with 75% collected during the month of the sale, 15% the following month, and 9.5% the month thereafter. of 1% of sales are considered uncollectible (bad debt expense). 13. Sales in November and December 2019 are expected to be $641,250 and $855,000 respectively. Based on the above collection pattern this will result in Accounts Receivable of $270,394 at December 31, 2019 which will be collected in January and February, 2020. O39 0.25 V N C Teyu Corp. Sales Budget For the year ended December 31, 2020 feb Apr Aug Sep Oct Nov Dec Year Mar May un Percent of Annual Sales Expected Sales in Units Selling Price per Unit Total Budgeted Sales 15% 20% 100% 10% 10% 10N A000 50.00 10,000 5,000 a5,000 5000 100,000 3,000 3,000 5,000 s0.00 5,000 31,000 50.00 20,000 10,000 50.00 10,000 50.00 50.00 50.00 50.00 5000 S 50.00 S0.00 s0.00 $150,000.00 $150,000.00 $150,000.00 $250,000.00 $500,000.00 $500,00o.00 $500,000.00 $250,000.00 $250,000.00 $550,000.00 $750,000.00 $1,000,000.00 $5,000,000.00