Number of days past due

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 $21$ $$12,000$

Bales Auto October $82,400$

Derby Auto Repair June $253,900$

Lucky's Auto Repair September $56,600$

Pit Stop Auto September $251,100$

Reliable Auto Repair July $19,750$

Trident Auto August $231,800$

Valley Repair & Tow May $244,000$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Open spreadsheet

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 $21$ fill in the blank $2$

Bales Auto October $8$ fill in the blank $3$

Derby Auto Repair June $25$ fill in the blank $4$

Lucky's Auto Repair September $5$ fill in the blank $5$

Pit Stop Auto September $25$ fill in the blank $6$

Reliable Auto Repair July $1$ fill in the blank $7$

Trident Auto August $23$ fill in the blank $8$

Valley Repair & Tow May $24$ fill in the blank $9$