In: Accounting
Toot Auto Supply distributes new and used automobile parts to local dealers throughout the Midwest. Toot’s credit terms are n/30. As of the end of business on October 31, the following accounts receivable were past due:
| Account | Due Date | Amount |
| Avalanche Auto | August 15 | $12,000 |
| Bales Auto | October 4 | 2,400 |
| Derby Auto Repair | June 26 | 3,900 |
| Lucky's Auto Repair | September 10 | 6,600 |
| Pit Stop Auto | September 24 | 1,100 |
| Reliable Auto Repair | July 2 | 9,750 |
| Trident Auto | August 25 | 1,800 |
| Valley Repair & Tow | May 23 | 4,000 |
Determine the number of days each account is past due as of October 31.
| Account | Due Date | Number of Days Past Due |
| Avalanche Auto | August 15 | |
| Bales Auto | October 4 | |
| Derby Auto Repair | June 26 | |
| Lucky's Auto Repair | September 10 | |
| Pit Stop Auto | September 24 | |
| Reliable Auto Repair | July 2 | |
| Trident Auto | August 25 | |
| Valley Repair & Tow | May 23 |
| Account | Due Date | Number of Days Past Due |
| Avalanche Auto | August 15 | 77 |
| Bales Auto | October 4 | 27 |
| Derby Auto Repair | June 26 | 127 |
| Lucky's Auto Repair | September 10 | 51 |
| Pit Stop Auto | September 24 | 37 |
| Reliable Auto Repair | July 2 | 121 |
| Trident Auto | August 25 | 67 |
| Valley Repair & Tow | May 23 | 161 |
Working Notes
Calculate no, of days from past due on october 31
1 Avalanche Auto
| Past Due Days | |
| Number of Days from August 15 to August 31 | 16 |
| Number of Days from September 1 to September 30 | 30 |
| Number of Days from October 1 to october 31 | 31 |
| TOTAL DAYS | 77 days |
2.Bales Auto
| Past Due Days | |
| Number of Days from October 4 to october 31 | 27 |
| TOTAL DAYS | 27 |
3 . Derby Auto Repair
| Past Due Days | |
| Number of days from June 26 to June 30 | 4 |
| Number of days from July 1 to July 31 | 31 |
| Number of Days from August 1 to August 31 | 31 |
| Number of Days from September 1 to September 30 | 30 |
| Number of Days from October 1 to october 31 | 31 |
| TOTAL DAYS | 127 days |
4.Lucky's Auto Repair
| Number of Days from September 10 to September 30 | 20 |
| Number of Days from October 1 to october 31 | 31 |
| TOTAL DAYS | 51 days |
5.Pit Stop Auto
| Number of Days from September 24 to September 30 | 6 |
| Number of Days from October 1 to october 31 | 31 |
| TOTAL DAYS | 37 days |
6.Reliable Auto Repair
| Number of days from July 2 to July 31 | 29 |
| Number of Days from August 1 to August 31 | 31 |
| Number of Days from September 1 to September 30 | 30 |
| Number of Days from October 1 to october 31 | 31 |
| TOTAL DAYS | 121 days |
7.Trident Auto
| Number of Days from August 25 to August 31 | 6 |
| Number of Days from September 1 to September 30 | 30 |
| Number of Days from October 1 to october 31 | 31 |
| TOTAL DAYS | 67 days |
8.Valley Repair & Tow
| Past Due Days | |
| Number of days from May 23 to May 31 | 8 |
| Number of days from June 1 to June 30 | 30 |
| Number of days from July 1 to July 31 | 31 |
| Number of Days from August 1 to August 31 | 31 |
| Number of Days from September 1 to September 30 | 30 |
| Number of Days from October 1 to october 31 | 31 |
| TOTAL DAYS | 161 days |