Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Management has provided a detailed aging schedule of accounts receivable below. Based on past collections history, management estimates the percentage uncollectible as follows: Number
Management has provided a detailed aging schedule of accounts receivable below. Based on past collections history, management estimates the percentage uncollectible as follows: Number of days outstanding percentage uncolectible. 0-30 31-60 0.5% 2% 61-90 91-120 Over 120 5% 10% 50% Required: Please see the requirements below the accounts receivable listing. Customer name Dr. Roger Goyette Dr. Camila Schuppe YYC Dr. Juanita Zboncak Dr. Terence Smitham Central Dr. Carmela Lebsack South Dr. Michaela Zulauf YEG 7,77262 Dr. Hillary Schuppe South 14,604.09 Dr. Isabella Stokes South 8,977.52 Dr. Camylle Wuckert YYC 19,188.22 Dr. Molly Stracke YYC 8,821.70 Dr. Stacy Kuhlman Sr. VEG 18.931.42 Dr. Aubree Hermiston South 15.681.70 Dr. Judy Ziemann YEG 24,792.78 6,442.18 11,441.13 8,076 20 12,778.68 8.977.52 19,188 22 18.931.42 15,681.70) 9,297 29 Region Total 0-30 Days 31-40 Days 61.40 Days 91-120 days 120 days South 5 5872.38 S 18,743.62 5.872.38 13,368.30 $ 5,355.32 North 6.442.18 11,441.13 $ 2010.05 $ 4,038 10 2.019.05 7,772.52 1,825.51 8.821.70 15,495.48 Dr. Charley Wilderman YYC Dr. Cletus Bashirian YYC Dr. Tyree Gorczany Dr. Dianna Mohr 6.137.98 6,137.08 3,270.38 945.38 2.325.00 South 7,953 26 7.953.26 YEG 10,879.24 Dr. Mackenzie Koch South 16,475.86 9,885.52 10,879.24 3,295.17 3.295.17 Dr. Winona Doyle South 7.208.53 7.208.53 Dr. Bennett Beer IV YYC 18,752.73 18,752.73 Dr. Bennie Romaguers Central 10.260.33 10,260.33 Dr. Deja Daniel North 17.937.80 17.937.80 Dr. Elvers Fisher Sr Central 19,187.91 19,187.91 Dr. Noemie Prohaska Central 13,049.77 13.049.77 Dr. Emely Aufderhar YEG 8,362.69 2,000.67 6,272.02 Dr. Fredrick Dayle YYC 9.674.21 4,424.21 5,250.00 Dr. Kira Hammes YYC 20,766.32 20,766.32 Dr. Maud Mayer YEG 19,755.57 19,756.57 Dr. Bell Grimes YEG 2.321.55 2.32165 Dr. Bradly Monahan South 7,887.04 6.310.36 1,577.59 Dr. Roscoe Daugherty YYC 17,818.34 2.068.34 15,750.00 Dr. Haylee Mitchell YEG 7,430.93 7,430.93 Dr. Carrie Schiller Central 17.65566 17,655.66 Dr. Bertha Mayer Central 10.238.68 10,238.68 Dr. Alba Barton YEG 9,264.75 9264.75 Dr. Misty Ankunding YYC 6.341.54 6,341.54 Dr. Elaina Monahan Central 10,000.64 10,900.64 Dr. Sylvan Runolfsson South 7.320.50 7,320.50 Dr. Jonas Spinka South 17.734 23 17,734.23 Dr. Delphia Schultz YYC 10,78 10 10,788.10 Dr. Telly Pfeffer YEG 15,255.82 10,005.82 Dr. Lamar Mayer YYC 10,063.73 10.963.73 Dr. Eve Dicki South 5,404.18 5250.00 5,494.18 Dr. Florence Balistreri YYC 14,579.27 14,579.27 Dr. Alana Feeney South 19,760.35 10,780.35 Dr. Cheyenne Steuber YYC 18.332 69 18.332.69 Dr. Edison Bergstrom South 21,264.10 21.264.10 Dr. Heria Anderson Central 2,293.46 2.293.46 Dr. Maci Weissnal South 16,407.76 16.497.76 Dr. Godfrey Lemke Central 15.124.87 12.090.00 3.024.97 Dr. Karley Adams YYC 4,165.35 4,165.33 Dr. Meagan Deckow YYC 19,813.04 19,813.04 Dr. Earlene Considine South 3,076.20 Dr. Alec Allenwerth 076.20 Central 36,131.65 15,131.65 21,000.00 Dr. Brel Nolan V Central 21,185.47 4,385.47 16.800.00 Dr. Talia Satterfield YYC 17,037.43 17,037.43 Dr. Caden Slokos North 8,097.93 8,097.93 Dr. Kylee Tilman YYC 4,44902 4,740.02 Dr. Braeden Nikolaus YYC 17,016.65 17,016.65 Dr. Toney Ulrich North 16,519.30 Total 772,100.00 16,519.30 564,967.98 $ 115.90018 113,758.18% 14.147-29 25,317.46
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started