ACCT1115 52020. group project da eh File Home Insen Formulas Da View Help Openi Desktop App All 11 B Merge General A124 D Question 2: Accounts Receivable Management has provided a detailed aging schedule of accounts receivable below 5 Based on past Hections history management estimates the percentage uncollectible as follows 0-30 31-60 7 61.90 91-120 over 120 Number of days outstanding SU porcentage unitatible 0.5% 2% 10% 5096 61.90 Days 91-120 days >120 daye $ 165175 $200 303.505 165175 1068.70 10 11 12 Required: Please see the requirements below the accounts receivable listing 17 14 15 16 Customer name Region Total 0-30 Days 31-60 Days 17 Dr Roger Goyette Central S 19 17549 19 7548 TO Dr Camila Schuppe North 7330 27 5 235 91 S 2 094.36 19 Dr Juanita Zboncak South 21,917 91 21 917 91 20 Dr Terence Smitham YYC 9.288 08 9.288 08 21 Dr. Carmella Leback Central 6,607 01 22 Dr Michaela Zulauf YEG 10 400 85 10400 85 23 Dr Hillary Schuppe YYC 8.549 57 7480 87 24 Dr. Isabella Stokes South 80631 8063 15 25 Dr Camyle Wuckert YEG 20.157.55 20 157 55 26 Dr Molly Stracke South 6,558.31 27 Or Stacy Kuhlman Sr. YYC 15 519 94 15519.94 28 Dr Autree Hermiston North 19,964.19 19.964.19 29. Dr. Judy Zemann Central 26.82755 10.060.33 16.767 22 30 Dr. Charley Wilderman South 18.488.70 18.48678 31 Dr Cletus Bashirian South 1838120 16038:20 32 DY Tyree Gorczany YEG 10.990.70 10 990.70 33. Dr Dianna Mohr North 2028.68 2028 68 Dr Mackenzie Koch YEG 14,540.60 8.724 42 2908 14 35 Dr Winona Doyle YEG 4123 26 4.12326 16 Dr Bennett Beer IV YYC 9149 21 9.149 21 37 Dy Bennie Romaguera North 18.239 97 18,239.97 35 Dr Deja Daniel YEG 12 610 90 39 Dr. Elvera Fisher S Central 3.470 71 3.470 71 40 Dr. Noemie Prohaska Central 12 006.06 12,006.06 41 Dr Emely Aulderhar South 21.908.16 5,47704 16,431 12 6.558,31 2.325.00 2.908.14 12610.98 Overview Q1 Financial Statements QZ Accounts Receivable Q3 Inventory 04 Long Term Assets + Colabion Mode: Automatic Workbook Statistics Search for anything o ACCTI115 52020 group project da... File Home Insert Formula View Help Openine App 0 Tell me what you want to co Arial B 1 General A124 D-Laye 71-120 days >10 200436 5205915 21 01/01 92000 165175330350 S 10,400.85 165175 106870 rre 7 480.87 8.063 15 2015/55 6558 31 16.767 22 15 519.94 19,964 19 10.050.33 18.486.78 16.03620 10,899.70 2.325.00 2028.68 2908 14 2008 14 8,724.42 412326 9.149 21 18 239 97 Customer name Kegion 17. Dr. Roger Goyette Central Dr. Camia Schuppe North 19 Dr Juanita Zboncak South 20 Dr Terence Smitham YYC 21 Dr. Carmella Leback Central 21 Dr. Michaela Zulu YEG Dr Hilary Schuppe 24 Dr Isabella Stokes South 25 Dr Canye Wackert YEG 26. Dr Molly Stracke South 27 Dr Stacy Kuhlman SrYYO 20 D Aubree Hermiston North Dr Judy Zimann Central 30 Dr Charley Wilderman South 21 Dr Cletus Bashirian South Dr Tyree Gorczy YEG 33 Or Deanna Mohr North 34 Dr Mackenzie Koch YEG 35 Or Winona Doyle YEG 38 Dr. Bennett Beer IV YYC 37 Dr. Bennie Romaguera North 3a Dr Deja Daniel YEG 39 Dr Elvera Fisher Sr Central 40 Dr. Noeme Prohaska Central 41 Dr Emely Aulderhar South Dr Fredrck Doyle North 43 Dr. Kira Hammes YEG 44. Dr Maud Mayer YYC 15 Dr. Bell Grimes North 46 Dr Bradly Monahan North 47 Dr Roscoe Daugherty North 4 Dr Haylee Mitchell Central 19. Dr Came Schiller Central 50 Dr Bertha Mayert South 51 Dr Alba Barton North 52 Dr Misty Ankunding YEG 53 Or Elaina Monahan YEG 54 Dr. Sylvan Runolfsson YEG 55 Dr Jonas Spinka South 56 Dr Delphia Schultz Central 57 Dr. Telly Pfeffer North 58 Dr Lamar Mayer YYC 59 Dr. Eve Dicki YEG TO 15 709027 2191701 9.298,00 6,60701 10.400.35 8,54957 8,083 15 20157.55 6558 31 15 519 94 19,964 19 26,827 55 18.486.78 18,361 20 10 999 70 2,028.68 14,540.60 412326 9.14921 18,23997 12 610.00 3.470.71 12 006.06 21908.16 12 502 21 8.782 14 244103 5,588 42 11,585.64 33 000 84 20.922.02 8.049.09 17 209 39 638185 15 352 05 7 135 67 1030554 3046 41 7383 34 11,584 93 23,89439 2 876.76 12.610.98 3.470 71 12006.00 547704 16 431.12 7,252 21 5,250 00 8.762.14 2.441.03 5,588.42 2,317 13 9,268.51 17 258 84 20,82202 15.750 00 8.049.09 17209,39 6.381 85 15 352 05 7135 67 10 306 54 3,046 41 7383.34 5,250 00 6.334.93 23.89439 2.876.78 Q2 Accounts Receivable Q3 Inventory 04 Long Term Assets Overview 1 Financial Statements Calculation Mode: Automatic Workbook Statistics Search for anything o i e 0 1080 ACCT15 S2020 group project de... a search Home Inet Form Here View OpenDesktop ADD + Merge Arla B 1 A124 C 59 Dr Eve Dicki YEG O Dr Florence Distrieri South 01 De Alana Feeney Central Dr. Cheyenne Steuber South Dr Edison Bergstrom South 64 Dr Horta Anderson North 65 De Mad Weissna YEO 6 Dr Godfrey Lemke YYC 67 Dr. Karley Adams Central 68 Dr Meagan Deckow Central 9 D Earlene Considine YEG 70 Dr Alec Altenwerth YEG 71 Dr Bret Nolan V YYC 72 De Talia Satterfield Central 73 De Caden Stokes South 74 Dr. Kylee Taman South 75 Dr. Braeden Nikolaus YYC 76 Dr Toney Ulrich North 7 Total 9.177.30 9.17730 4822.32 482232 4,587.80 4.58760 13 313 38 13,313 36 304233 3,042 33 21 17 2117853 10.802 25 35410 2150 45 17 179.15 17.179:35 7 175 70 717679 20 638 57 20 357 37 206,27 16.205.27 21.000.00 21.689 13 4 88013 16 00 00 16524 03 1852403 9.345 83 9.945.83 352430 352488 2179340 21.233 40 18.535 58 $ 777,373.81 $ 505,353215 124 429.46 $95 287.79$ 14,811,025 37.492 33 19. 1. Determine the total estimated amount uncollectible (ending AFDA) 30 1 uncollectible 33 Amount uncollectible! 01 34 TOTAL AFDA 2. Prepare the journal entry on December 31st to adjust the allowance for doubtful accounts to the appropriate ending balance. The 66 allowance for doubtful accounts has an unadjusted credit balance of $4,500 Dute Account Titles Debit Credit 09 90 3. Critical Thinking: How would the journal entry you've just created affect the accounts receivable turnover and average collection period that you calculated in Question 1? 8 90 95 97 518 4. Create a bar chart that shows accounts receivable by age. 02 Accounts Receivable 03 Inventory 04 Long Term Assets Overview Q1 Financial Statements Calculation Mode Automatic Workbook Statistics O e Search for anything 1080) acer ACT 4. bershaw Bir B E What can you from barcha T17 Caterpie chart that women corto centyments on Abuta warns - R.YO. Wow, Care 114 8 WEGYO trompech 02 A 0 Search for the FULL HD 1080 acer