In: Accounting
Schedule of Cash Collections
PetJoy Wholesale Inc., a pet wholesale supplier, was organized on March 1, 2016. Projected sales for each of the first three months of operations are as follows:
| March | $150,000 |
| April | 160,000 |
| May | 240,000 |
The company expects to sell 10% of its merchandise for cash. Of sales on account, 56% are expected to be collected in the month of the sale, 40% in the month following the sale, and the remainder in the second month following the sale.
Prepare a schedule indicating cash collections from sales for March, April, and May.
| PetJoy Wholesale Inc. | |||
| Schedule of Cash Collections | |||
| For the Three Months Ending May 31, 2016 | |||
| March | April | May | |
| Receipts from cash sales: | |||
| Cash sales | $ | $ | $ |
| March sales on account: | |||
| Collected in March | |||
| Collected in April | |||
| Collected in May | |||
| April sales on account: | |||
| Collected in April | |||
| Collected in May | |||
| May sales on account: | |||
| Collected in May | |||
| Total cash collected | $ | $ | $ |
| Working Note | ||||||
| Sales | 150000 | 160000 | 240000 | |||
| Cash sales=10% of total sales | 15000 | 16000 | 24000 | |||
| Credit sales=90% of total sales | 135000 | 144000 | 216000 | |||
| PetJoy Wholesale Inc. | ||||||
| Schedule of cash collections | ||||||
| For the three months ending May 31, 2016 | ||||||
| March | April | May | ||||
| $ | $ | $ | ||||
| Receipts from cash sales | ||||||
| Cash Sales | 15000 | 16000 | 24000 | |||
| March Sales on account | ||||||
| Collected in March(56%) | 75600 | |||||
| Collected in April(40%) | 54000 | |||||
| Collected in May(Remaining 4%) | 5400 | |||||
| April Sales on account | ||||||
| Collected in April(56%) | 80640 | |||||
| Collected in May(40%) | 57600 | |||||
| May Sales on account | ||||||
| Collected in May(56%) | 120960 | |||||
| Total Cash collected | 90600 | 150640 | 207960 | |||
| If above presentation does not fit into answer, please try the alternative presentation as given below | ||||||
| PetJoy Wholesale Inc. | ||||||
| Schedule of cash collections | ||||||
| For the three months ending May 31, 2016 | ||||||
| March | April | May | ||||
| $ | $ | $ | ||||
| Receipts from cash sales | ||||||
| Cash Sales | 15000 | 16000 | 24000 | |||
| March Sales on account | ||||||
| Collected in March(56%) | 75600 | |||||
| Collected in April(40%) | 54000 | |||||
| Collected in May(Remaining 4%) | 5400 | |||||
| April Sales on account | ||||||
| Collected in April(56%) | 80640 | |||||
| Collected in May(40%) | 57600 | |||||
| May Sales on account | ||||||
| Collected in May(56%) | 120960 | |||||
| Total Cash collected | 150000 | 154240 | 144960 | |||
| If you find this answer useful, Please do rate it. | ||||||
| Thank You | ||||||