Jekell Catering Inc. is a caterer of corporate lunches and events. The following is Jekell's sales forecast by quarter for the upcoming year.

Jekell Catering Inc.

Forecasted Sales

For the Year Ended December $31,2020$

Q$1$ Q$2$ Q$3$ Q$4$ Total

Sales $$122,000$ $$282,000$ $$367,000$ $$233,000$ $$1,004,000$

In addition, sales in Q$3$ and Q$4$ of $2019$ totaled $$138,000$ and $$216,000$ respectively. According to the company's sales records, all revenue is invoiced $($i$.$e$.$ credit sales$).$ Assume the following historical trends were noted by management regarding credit sales:

$47\%$ of credit customers pay during the quarter in which the sale took place

$29\%$ of credit customers pay in the quarter immediately following the quarter of sale

$24\%$ of credit customers pay in the second quarter following the quarter of sale

Do not enter dollar signs or commas in the input boxes.

Prepare a schedule of cash receipts on a quarterly basis.

Jekell Catering Inc.

Cash Receipts

For the Year Ended December $31,2020$

Q$1$ Q$2$ Q$3$ Q$4$ Total

Q$32019$ $Answer

$Answer

Q$42019$ $Answer

$Answer

$Answer

Q$12020$ $Answer

$Answer

$Answer

$Answer

Q$22020$ $Answer

$Answer

$Answer

$Answer

Q$32020$ $Answer

$Answer

$Answer

Q$42020$ $Answer

$Answer

Total Cash Receipts $Answer

$Answer

$Answer

$Answer

$Answer