Toot Auto Supply distributes new and used automobile parts to local dealers throughout the Midwest. Toots 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 18 $12,000

Bales Auto October 9 2,400

Derby Auto Repair June 15 3,900

Lucky's Auto Repair September 10 6,600

Pit Stop Auto September 22 1,100

Reliable Auto Repair July 2 9,750

Trident Auto August 21 1,800

Valley Repair & Tow May 24 4,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. Round your answers to the nearest whole number.

Account Due Date Number of Days Past Due

Avalanche Auto August 18

Bales Auto October 9

Derby Auto Repair June 15

Lucky's Auto Repair September 10

Pit Stop Auto September 22

Reliable Auto Repair July 2

Trident Auto August 21

Valley Repair & Tow May 24