In: Accounting
Schedule of Cash Collections of Accounts Receivable
Pet Supplies Inc., a pet wholesale supplier, was organized on January 1. Projected sales for each of the first three months of operations are as follows:
January | $260,000 |
February | 340,000 |
March | 510,000 |
All sales are on account. 55% of sales 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 January, February, and March.
Pet Supplies Inc. | |||
Schedule of Cash Collections from Sales | |||
For the Three Months Ending March 31 | |||
January | February | March | |
January sales on account: | |||
Collected in January | $ | ||
Collected in February | $ | ||
Collected in March | $ | ||
February sales on account: | |||
Collected in February | |||
Collected in March | |||
March sales on account: | |||
Collected in March | |||
Total cash collected | $ | $ | $ |