In: Accounting
The following credit sales are budgeted by Sheridan
Electronics:
January | $123600 |
February | 120000 |
March | 135600 |
April | 141000 |
May | 141300 |
The company's past experience indicates that 50% of the accounts
receivable are collected in the month of sale, 30% in the month
following the sale, and 19% in the second month following the sale.
1 percent are uncollectible. How much does the company anticipate
as cash receipts for March?
$134244 |
$127284 |
$136947 |
$123564 |
Solution : The anticipated cash receipts for the month of March is $127,284,
Based on the given information,
a) 50% of the credit sale are collected in the month of sale.
b) 30% of the credit sale are collected in the month following the sale.
c) 19% of the credit sale are collected in the second month following the sale.
Therefore, the anticipated cash collection can be calculated with the help of the below table
All the figures are in $ | Month | ||||
Jan | Feb | Mar | Apr | May | |
Credit Sales | 123,600.00 | 120,000.00 | 135,600.00 | 141,000.00 | 141,300.00 |
Cash Collection in March | |||||
50% of current sales (i.e. March) | 67,800.00 | ||||
30% of previous month sale (i.e. February) | 36,000.00 | ||||
19% of sale done 2 months before (i.e. January) | 23,484.00 | ||||
Total Cash Receipts (anticipated) | 127,284.00 |