P9.3B Presented below is an aging schedule for Loucks Company. Worksheet.xls HomeInsert Page Layout Formulas Data Review View P18 Number of Days Past Due Not Yet Due Customer Total 30,00 45,0 75,000 57,000 1-30 13,500 $16,500 31-60 61-90 Over 90 4 Alma 5 Browne 6 Conlon 7 Dalton 8 Others 45,000 22,500 7,500 45,000 $57,000 9,000 5396,000 $205,500 $43,5006,000 $45,000 $66,000 189,000138,000 22,500 19,500 Estimated 10 Percentage Uncollectible Total Estimated 2% 6% .10% 25% 40% 11 Bad Debts 12 $47,970 4,110 2,610 3,600 11,250 $26,400