Number of days past due

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 21	$12,000
Bales Auto	October 3	2,400
Derby Auto Repair	June 22	3,900
Lucky's Auto Repair	September 2	6,600
Pit Stop Auto	September 23	1,100
Reliable Auto Repair	July 4	9,750
Trident Auto	August 26	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 21	fill in the blank 2
Bales Auto	October 3	fill in the blank 3
Derby Auto Repair	June 22	fill in the blank 4
Lucky's Auto Repair	September 2	fill in the blank 5
Pit Stop Auto	September 23	fill in the blank 6
Reliable Auto Repair	July 4	fill in the blank 7
Trident Auto	August 26	fill in the blank 8
Valley Repair & Tow	May 24	fill in the blank 9