In: Accounting
#10
Sharon Corporation collects
10%
in the second month following sale,
55%
in the month following sale and
30%
of a month's sales in the month of sale. The company has found that
55%
of their sales are uncollectible. Budgeted sales for the upcoming four months are:
August budgeted sales |
$$340,000 |
September budgeted sales |
$ $310,000 |
October budgeted sales |
$ $380,000 |
November budgeted sales |
$ $230,000 |
The amount of cash that will be collected in November is budgeted to be
As provided Sales collections are as follows;
30% in the month of sale, 55% in the following month, 10% in the second following month and 5% is not collectible.
So for August sales, 30% will be collected in August, 55% in September, 10% in Octoebr and 5% shall not be collected. Basis this the below table is prepard.
Particulars | August | September | October | November |
Sales | 340,000 | 310,000 | 380,000 | 230,000 |
Collections | ||||
30% in the month of sale | 102,000 | 93,000 | 114,000 | 69,000 |
55% in the following month | - | 187,000 | 170,500 | 209,000 |
10% in the second following month | 34,000 | 31,000 | ||
102,000 | 280,000 | 318,500 | 309,000 | |
Not collected | ||||
5% not collectible | 17,000 | 15,500 | 19,000 | 11,500 |
Hence November cash collections shall be 309,000. (30% of Nov sales +55% of Oct sales + 10% of Sept sales)