ABC Company December 31, 2018 Customer Balance at December 31, 2018 Customer No. Invoice Date* 8 9 James Bond 1 $ Eric Ragner 2 $ Anneda Carl 3 $ Joe Kang 4 Joy Swanson 5 $ 2 Deshan Imar 6 $ 3 Kadri Martinez 7 $ 4 Yazzie Shimear 8 5 Uthread Wessex 9 6 Levi Levy 10 $ 7 Benjamin Abelman 11 $ 18 Trisha Westerland 12 $ 19 Susan Summerland 13 20 Elizabeth Miller 14 $ 21 Jacob Platzon 15 $ 22 Consuela Cortez 16 23 Francesca Flowers 17 $ 24 Caroline Rosenberg 18 $ 25 Inge Solomon 19 26 Sigfried Johnson 20 27 Sherrie Stoneman 21 $ 28 Kevin Hans 22 29 katina Galanos 23 30 Peter Manis 24 31 Betty Flowers 25 32 Todd Signing 26 33 Terry Strong 27 34 Joseph Norris 28 35 Margarette Ghallager 29 36 Devin Heisness 30 37 38 All invoices are due 30 days from date of issuance. 39 V V V V V V V V W W W W W W W W W W W W W W W W W W W W W W 599,122 571,275 47,008 700,470 367,049 5,754 247,774 35,250 314,410 85,110 45,175 136,513 294,141 13,438 720,444 329,238 2,562 62,356 321,619 84,032 20,140 4,059 25,438 345,079 30,012 42,400 45,242 357,259 970,111 11,728 3/20/2018 4/20/2018 5/9/2018 6/4/2018 12/15/2018 11/24/2018 12/28/2018 10/30/2018 7/10/2018 8/24/2018 11/18/2018 11/10/2018 11/24/2018 10/24/2018 11/13/2018 12/13/2018 8/24/2018 8/16/2018 9/14/2018 2/14/2018 11/1/2018 10/24/2018 7/15/2018 8/6/2018 9/25/2018 10/1/2018 9/28/2018 10/15/2018 9/16/2018 9/7/2018 10 Attached is a spreadsheet containing customer accounts and balances for a fictitious company called ABC company. Using the data in this spreadsheet, prepare an Accounts Receivable Trial Balance similar to the one provided in Exhibit 7.10. At the bottom of your spreadsheet, using the historical percentages below, calculate the reserve for each of the aging columns and the total amount that will need to be reserved for bad debts, prepare a conclusion on the quality of the outstanding receivables and your recommendations on the course of actions for the company. You will also need this information: Historically the amounts written off by category are: Current 90 Days: 40% Prepared DNS 2/14/2021 Review ADD 2/16/2021 30-60 Days $173406,37 Past Our 60-90 Du 90 Day Current 30 Days I $ 11,630.14 718 986.45 242.568 89 $ 461.09 DUNDER-MIFFLIN INC Accounts Receivable Aged Trial Balance For Year Ended 12/312020 (Prepared by Cient 2020 Total Balance Cort Mo DateMuled Date Reed 5 173,406 37 11630.14 718,986 45 10 1/15 122 242.568.88 46109 6.822.725.10 20 1/15 1/27 3.18149 164441 32.028.09 BE 115 20093295 405.346.10 15.02657 4E 1/15 125 127.907.18 SNR V150 wa 1012.239.57 66 1/15 22 37943 $16.410.002.71CF TO 75.765.08185 $1.057.54325 Pay More Paper Nude M. Office Supplies Bet Your Life Printing Paper Shad Shradables Mall Wart House of Paper Sunshine ce Supplies Imelda Printing Hp Hop Intim The Paper Federation Office at Lamang Bully Peyton Paper Total 2.181.40 121 1644.41 32.023.89 230,012.05 405.846,10 Y39875 Y1641532 127.07.10 1.01.239.57 370.41 510231296.72 35360MG 245,01 1996
