Not Days Past Due Past Customer Balance Due 1-30 31-60 61-90 91-120 Over 120 ABC Beauty 21,000 21,000 Angel Wigs 7,000 7,000 Zodiac Beauty 4,200 4,200 Subtotals 1,305,300 755,100 283,600 127,300 39,500 21,700 78,100 The following accounts were unintentionally omitted from the aging schedule. Assume all due dates are for the current year except for Visions Hair & Nail, which is due in the next year. Customer Due Date Balance Arcade Beauty Aug. 17 $4,600 Creative Images Oct. 30 5,200 Excel Hair Products July 3 8,500 First Class Hair Care Sept. 8 6,900 Golden Images Nov. 23 3,600 Oh That Hair Nov. 29 2,400 One Stop Hair Designs Dec. 7 6,800 Visions Hair & Nail Jan. 11 4,500 Wig Creations has a past history of uncollectible accounts by age category, as follows: Percent Age Class Uncollectible Not past due 1 % 1-30 days past due 2. 31-60 days past due 8 61-90 days past due 28 91-120 days past due 38 Over 120 days past due 85 Required: 1. Determine the number of days past due for each of the preceding accounts. If an account is not past due, enter a zero. 1. Determine the number of days past due for each of the preceding accounts. If an account is not past due, enter a zero. Customer Due Date Number of Days Past Due Arcade Beauty Aug. 17 136 days Creative Images Oct. 30 62 days Excel Hair Products July 3 153 X days X > First Class Hair Care Sept. 8 114 days Golden Images Nov. 23 38 days Oh That Hair Nov. 29 32 days One Stop Hair Designs Dec. 7 24 days Visions Hair & Nail Jan. 11 0 days 2. Complete the aging of receivables schedule by adding the omitted accounts to the bottom of the schedule and updating the totals. If an amount box does not require an entry, leave it blank Wig Creations Company Aging of Receivables Schedule December 31, 2017 Not Past Days Past Days Past Due Due 1-30 Due 31-60 Days Past Days Past Due 61-90 Due 91-120 Days Past Due Over 120 Balance 21,000 Customer ABC Beauty Angel Wigs Zodiac Beauty 21,000 7,000 4,200 7,000 4,200 Subtotals 1,305,300 755,100 283,600 127,300 39,500 21,700 78,100 Arcade Beauty 10,000 X Creative Images Excel Hair Products First Class Hair Care Golden Images Oh That Hair One Stop Hair Designs Visions Hair & Nail Totals 0 E Percent uncollectible (%) % % % % % %