1. Determine the total estimated amount uncollectible (ending AFDA). % uncollectible Amount uncollectible TOTAL AFDA 2. Prepare the journal entry on December 31st to adjust the allowance for doubtful accounts to the appropriate ending balance. The allowance for doubtful accounts has an unadjusted credit balance of $4,500. Date Account Titles Debit Credit Management has provided a detailed aging schedule of accounts receivable below. Based on past collections history, management estimates the percentage uncollectible as follows: 0-30 3 1-60 61-90 Number of days outstanding CSumateu percentage 91-120 10% over 120 50% 0.5% 2% 5% Required: Please see the requirements below the accounts receivable listing. 31-60 Days 61-90 Days 91-120 days > 120 days $ 4.116.66 $ 4,308.35 $ 8.616.71 $ 4,308.35 3,973.09 2.011.90 8,596.39 o lolololololololol lol 6,507.79 2,325.00 6,044.93 2.670.48 2,670.48 lol 9.957.68 lol la 5,633.51 12.408.90 5.250.00 15,237.48 1,932.08 Customer name Region Dr. Roger Goyette North Dr. Camila Schuppe YYC Dr. Juanita Zboncak YYC Dr. Terence Smitham South Dr. Carmella Lebsack YEG Dr. Michaela Zulauf North Dr. Hillary Schuppe South Dr. Isabella Stokes Central Dr. Camylle Wuckert YEG Dr. Molly Stracke Central Dr. Stacy Kuhlman Sr. YEG Dr. Aubree Hermiston YYC Dr. Judy Ziemann South Dr. Charley Wilderman North Dr. Cletus Bashirian Central Dr. Tyree Gorczany South Dr. Dianna Mohr Central Dr. Mackenzie Koch YEG Dr. Winona Doyle Central Dr. Bennett Beer IV South Dr. Bennie Romaguera North Dr. Deja Daniel Central Dr. Elvera Fisher Sr North Dr. Noemie Prohaska South Dr. Emely Aufderhar YYC Dr. Fredrick Doyle YYC Dr. Kira Hammes Central Dr. Maud Mayer Y YC Dr. Bell Grimes Central Dr. Bradly Monahan YYC Dr. Roscoe Daugherty Central Dr. Haylee Mitchell YEG Dr. Carrie Schiller North Dr. Bertha Mayert Central Dr. Alba Barton YYC Dr. Misty Ankunding Central Dr. Elaina Monahan YYC Dr. Sylvan Runolfsson YEG Dr. Jonas Spinka North Dr. Delphia Schultz Central Dr. Telly Pfeffer South Dr. Lamar Mayer Central Dr. Eve Dicki South Dr. Florence Balistreri Central Dr. Alana Feeney Central Dr. Cheyenne Steuber South Dr. Edison Bergstrom YYC Dr. Herta Anderson South Dr. Maci Weissnat YYC Dr. Godfrey Lemke South Dr. Karley Adams Central Dr. Meagan Deckow YYC Dr. Earlene Considine Central Dr. Alec Altenwerth Central Dr. Bret Nolan V Central Dr. Talia Satterfield YEG Dr. Caden Stokes South Dr. Kylee Tillman YYC Dr. Braeden Nikolaus Central Dr. Toney Ullrich South Total Total 0-30 Days 12,010.73 $ 12,010.73 14,408.31 10,291.65 7,789.98 7,789.98 17.432.01 17.432.01 17,233.41 3,973.09 16,095.17 14,083.28 8,199.56 8,199.56 5,014.50 5,014.50 8,596.39 7,968.83 7,968.83 19,005.12 19,005.12 10.412.47 3,904.68 7,498.95 7,498.95 20,831.93 18,506.93 9,155.50 9,155.50 6,044.93 13,352.39 8,011.43 15,982.41 15,982.41 17,434.72 17.434.72 12,075.88 12,075.88 9,957.68 20,506.80 20,506.80 11,489.86 11,489.86 7,511.35 1,877.84 17,658.90 13.165.79 13,165.79 18,962.77 18,962.77 15,237.48 9,660.39 7,728.31 22.137.48 6,387.48 6,091.35 6,091.35 15,541.47 8,898.71 8,898.71 2,737.45 2,737.45 4,786.51 4,786.51 15,578.21 15,578.21 20.849.33 6,243.41 6,243.41 9,650.46 13,978.81 8,728.81 4,321.98 4,321.98 4,601.81 15,563.09 15,563.09 7,544.52 7,544.52 20,619.19 20,619.19 10,066.59 10,066.59 4,373.84 7,458.55 7,458.55 15,119.56 4,605.28 4,605 28 8,011.90 8.011.90 20,871.66 31,985.33 10,985.33 35,748.92 18,948.92 17,945.55 13,075.37 4,996.96 4,996.96 21,069.32 21,069.32 19,916.62 $ 769,056.49 $ 461,741.06 15,750.00 15,541.47 20.849.33 9.650.46 5,250.00 4,601.81 4,373.84 12,095.65 3,023.91 20,871.66 21,000.00 16,800.00 17,945.55 13,075.37 19.916.62 $ 126,024.40 $ 105,097.90 $ 32,829.83 $ 43,363.30