Question

ABC Company has sales on account and for cash. Specifically, 57% of its sales are on account and 43% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $516,000 for April, $526,000 for May, and $551,000 for June. The beginning balance of Accounts Receivable is $297,700 on April 1. Prepare a schedule of budgeted cash receipts for April, May, and June.

Answer 1

Answer:

In April:

Total sales = $516,000

cash sales = 43% × $516,000

                  = $221,880

sales on account = 57% × $516,000

                             = $294,120

In May:

Total sales = $526,000

cash sales = 43% × $526,000

                  = $226,180

sales on account = 57% × $526,000

                             = $299,820

In June:

Total sales = $551,000

cash sales = 43% × $551,000

                  = $236,930

sales on account = 57% × $551,000

                             = $314,070

Therefore,

Budget cash receipts in April = cash sales + collection on accounts receivable(beginning balance of a/c receivable on April 1)

                                                 = $221,880 + $297,700

                                                 = $519,580

Budget cash receipts in May = cash sales + collection on accounts receivable of April

                                                 = $226,180 + $294,120

                                                 = $520,300

Budget cash receipts in June = cash sales + collection on accounts receivable of May

                                                 = $236,930 + $299,820

                                                 = $536,750