Problem #1 Dr. Stanbrown is a chiropractor who provides most of his services on account. The accounts receivable clerk for Dr. Stanbrown prepared the following partially completed aging-of-receivables schedule as of the end of business on December 31, 2022: Not Past Days Past Due Customer Balance Due 1-30 31-60 61-90 91-120 Over 120 Allan, Marsha 2,200 2,200 Meyers, Chris 1,250 1,250 Zanka, Phil 875 875 Subtotals 115,500 74,200 24,100 9,850 The following accounts were unintentionally omitted from the aging schedule. 4,700 2,000 650 Customer Due Date Balance Bentley, Charles September 29, 2022 775 Doer, Dale January 10, 2023 1,550 Essex, Kim November 16, 2022 1,010 Hernandez, Livan August 13, 2022 2,300 Jenkins, Jill December 3, 2022 850 Nuttler, Butch October 18, 2022 1,920 Portley, Olive November 6, 2022 2,070 Santiago, Benito September 10, 2022 925 Dr. Stanbrown has a past history of uncollectible accounts by age category, as follows: Age Class Percentage Uncollectible Not past due 3% 1-30 days past due 5 31-60 days past due 9 61-90 days past due 22 91-120 days past due 45 Over 120 days past due 85 Instructions for Problem #1 (Note: Round to the nearest penny when necessary) 1.) Determine the number of days past due for each of the preceding accounts. (Use "Past Due Days" sheet on Final Exam Problem #1 Template) 2.) Complete the aging-of-receivables schedule by adding the omitted accounts to the bottom of the schedule and updating the totals. (Use "Aging & Journal" sheet on Final Exam Problem #1 Template) 3.) Estimate the allowance for doubtful accounts, based on the aging-of-receivables schedule. 4.) Assume that the Allowance for Doubtful Accounts for Dr. Stanbrown has a debit balance of $6,542.00 before adjustment on December 31, 2022. Journalize the adjusting entry for the uncollectible accounts expense for the year. (Use "Aging & Journal" sheet on Final Exam Problem #1 Template) h 1 2 3: Aging of Receivables Schedule December 31, 2022 Customer Not Past Balance 1-30 31-60 61-90 91-120 Over 120 4 Due 5 Allan, Marsha 2,200 2,200 Meyers, Chris 7- 1,250 1,250 8 Zanka, Phil 875 5 Subtotals 115,500 74,200 24,100 9,850 4,700 2,000 650 10 Bentley, Charles 775 11 Doer, Dale 1,550 13 Essex, Kim 1,010 13 Hernandez, Livan 2.300 14 Jenkins, Jill 850 15 Nuttler, Butch 16 Portley, Olive 1,920 2,070 17 Santiags, Benito 18 Totals 925 126,900 19 Percent Uncollectible 20 Estimate of Uncollectible Accounts 21 22 Journal Entry: 23 25 26 27 28