The accounts receivable clerk for Quigley Industries prepared the following partially completed aging of receivables schedule as of the end of business on November 30: A B C D E F G 1 Not Days Past Due 2 Past Over 3 Customer Balance Due 1 30 31 60 61 90 90 4 Able Brothers Inc. 3,000 3,000 5 Accent Company 4,500 4,500 21 Zumpano Company 5,000 5,000 22 Subtotals 830,000 500,000 180,000 80,000 45,000 25,900 The following accounts were unintentionally omitted from the aging schedule and not included in the subtotals above: Customer Balance Due date Beltran Indistries $ 12,000 July 10 Doodle Company 8,000 September 20 La Corp Inc. 17,000 October 17 VIP Sales Company 10,000 November 4 We Go Company 23,000 December 21 a. Determine the number of days past due for each of the preceding accounts. b. Complete the aging of receivables schedule by adding the omitted accounts to the bottom of the schedule and updating the totals.