Set up a spreadsheet that can be used to estimate cash received from customers. Then determine the cash received from customers with the following parameters:
A.
Accounts receivable, beginning ...................................................... $ 8,000
Accounts receivable, ending ........................................................... 12,000
Sales ................................................................................................ 450,000
B.
Accounts receivable, beginning ....................................................... $ 20,000
Accounts receivable, ending ............................................................ 30,000
Sales ................................................................................................. 900,000
C.
Accounts receivable, beginning ......................................................... $ 12,000
Accounts receivable, ending ............................................................. 8,000
Sales .................................................................................................. 450,000
D.
Accounts receivable, beginning ......................................................... $ 38,000
Accounts receivable, ending .............................................................. 50,000
Sales .................................................................................................... 875,000