QS $22-21($Algo$)$ Schedule of cash receipts with uncollectibles LO P$2$

Wells Company reports the following budgeted sales: September, $$53,000$; October, $$60,000$; and November, $$81,000.$ All sales are on credit, and $5\%$ of those credit sales are budgeted as uncollectible. Collection of the remaining $95\%$ of credit sales are budgeted as follows: $60\%$ in the first month after sale and $35\%$ in the second month after sale. Prepare a schedule of cash receipts from sales for November.

$\backslash$table$[[$WELLS COMPANY$],[$Schedule of Cash Receipts from Sales$],[$November$],[$Sales$,,$$$,81,000],[$Cash receipts from:$],[$Cash sales,,$$,0],[$Collection of September sales$],[$Collection of October sales$],[$Total cash receipts,,$$,34,200]]$