In: Accounting
Fresplanade Co. had the following historical collection pattern
for its credit sales:
70% collected in the month of sale
14% collected in the first month after month of sale
8% collected in the second month after month of sale
6% collected in the third month after month of sale
2% uncollectible
The sales on open account (credit sales) have been budgeted for the
last six months of the year as shown below:
| July | $ | 84,000 | |
| August | $ | 96,000 | |
| September | $ | 108,000 | |
| October | $ | 120,000 | |
| November | $ | 132,000 | |
| December | $ | 114,000 | |
The estimated cash collection by Fresplanade Co. during August from July and August credit sales is:
Cash collection by Fresplanade Co. during August from July and August credit sales is = $78960
Working:
| Expected cash collection budget | ||
| July | August | |
| Sales | $ 84,000.00 | $ 96,000.00 |
| Schedule of expected cash collection | ||
| July sales |
$ 58,800.00 (84000*70%) |
$ 11,760.00 (84000*14%) |
| August sales |
$ 67,200.00 (96000*70%) |
|
| Total cash collection | $ 58,800.00 | $ 78,960.00 |
Please give positive rating. If you have any query ask in comments.