Schedule of Cash Collections of Accounts Receivable
Pet Stop Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows:
May | $280,000 |
June | 360,000 |
July | 510,000 |
All sales are on account. Of sales on account, 60% are expected to be collected in the month of the sale, 35% in the first month following the sale, and the remainder in the second month following the sale.
Prepare a schedule indicating cash collections from sales for May, June, and July.
PET STOP INC. | |||
Schedule of Collections from Sales | |||
For the Three Months Ending July 31 | |||
May | June | July | |
May sales on account: | |||
Collected in May | |||
Collected in June | |||
Collected in July | |||
June sales on account: | |||
Collected in June | |||
Collected in July | |||
July sales on account: | |||
Collected in July | |||
Total cash collected | $ | $ | $ |
Prepare a schedule indicating cash collections from sales for May, June, and July.
PET STOP INC. | |||
Schedule of Collections from Sales | |||
For the Three Months Ending July 31 | |||
May | June | July | |
May sales on account: | |||
Collected in May | 280000*60% = 168000 | ||
Collected in June | 280000*35% = 98000 | ||
Collected in July | 280000*5% = 14000 | ||
June sales on account: | |||
Collected in June | 360000*60% = 216000 | ||
Collected in July | 360000*35% = 126000 | ||
July sales on account: | |||
Collected in July | 510000*60% = 306000 | ||
Total cash collected | $168000 | $314000 | $446000 |
Schedule of Cash Collections of Accounts Receivable Pet Stop Inc., a pet wholesale supplier, was organized...
Schedule of Cash Collections of Accounts Receivable Pet Stop Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $230,000 June 320,000 July 420,000 All sales are on account. Of sales on account, 58% are expected to be collected in the month of the sale, 37% in the first month following the sale, and the remainder in the second month following the sale. Prepare a...
Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $240,000 June 360,000 July 540,000 All sales are on account. Of sales on account, 57 % are expected to be collected in the month of the sale, 38 % in the month following the sale, and the remainder in the second month following the sale....
Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $330,000 June 390,000 July 520,000 All sales are on account. Of sales on account, 51% are expected to be collected in the month of the sale, 45% in the month following the sale, and the remainder in the second month following the sale. Prepare a...
Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May June $310,000 420,000 560,000 July All sales are on account. Of sales on account, 51% are expected to be collected in the month of the sale, 45% in the month following the sale, and the remainder in the second month following the sale. Prepare a...
Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $320,000 June 460,000 July 620,000 All sales are on account. Of sales on account, 55% 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 of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $200,000 June 250,000 July 330,000 All sales are on account. Of sales on account, 60% are expected to be collected in the month of the sale, 35% in the month following the sale, and the remainder in the second month following the sale. Prepare a...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $280,000 June 310,000 July 450,000 All sales are on account. 57 percent of sales are expected to be collected in the month of the sale, 31% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...
Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: 2. May 5310,000 3. June 450,000 July 590,000 4. All sales are on account. Of sales on account, 52 % are expected to be collected in the month of the sale, 44% in the month following the sale, and the remainder in the second month following...
Schedule of Cash Collections of Accounts Receivable Pet Place Supplies Inc., a pet wholesale supplier, was organized on May 1. Proiected sales for each of the first three months of operations are as follows: May $134,000 June 155,000 July 169,000 All sales are on account. Sixty-five percent of sales are expected to be collected in the month of the sale, 30% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...
Schedule of Cash Collections of Accounts Receivable Furry Friends Supplies Inc., a pet wholesale supplier, was organized on May 1. Projected sales for each of the first three months of operations are as follows: May $150,000 June 170,000 July 250,000 All sales are on account. 53 percent of sales are expected to be collected in the month of the sale, 36% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule...