Exercise $20-18($Algo$)$ Schedule of cash receipts LO P$2$

Jasper Company has $59\%$ of its sales on credit and $41\%$ for cash. All credit sales are collected in full in the first month following the sale. The company budgets sales of $$517,000$ for April, $$527,000$ for May, and $$552,000$ for June. Total sales for March are $$306,300.$

Prepare a schedule of cash receipts from sales for April, May, and June.

$\backslash$table$[[$JASPER COMPANY$],[$Schedule of Cash Receipts from Sales$],[,,$April,,May,,June$],[$Sales$,,517,000,,527,000,,552,000],[$Cash receipts from:$],[$Cash sales,$$,211,970,$$$,216,070,$$$,226,320],[$Collections of prior period sales,,$180,717,,,,],[$Total cash receipts,$$,392,687,,,,]]$