Help please! I have provided a checkpoint in column d73- the totals should total to the 3,147.23

A H D E F G You have been employed by Emerson Company to help them with the accounts receivable and determine the bad debts allowance. They have provided you with the following information: Account Balance At 12/31/2019 10,575 13,525 9,560 10,800 8,600 8,310 1,250 Customer Amerson Company Buick Organization Colorado Trail Company Devonshire Electric Franklin Bank Graphic Packaging 8/15/2019 3,325 12/10/2019 9,925 11/30/2019 5,000 12/25/2019 4,425 11/24/2019 3,100 9/20/2019 2,750 12/7/2019 Invoices and Dates 7,250 9/25/2019 2,350 10/15/2019 4,560 12/1/2019 6,375 10/1/2019 5,500 9/12/2019 3,330 11/20/2019 2,230 10/15/2019 Required: 1. Prepare an accounts receivable aging schedule using the information above. 3 4 E F Based on the company's history they have provided you their experience with uncollecitble accounts based on the age of the invoice. Age of Uncollectible Account Percentage 0-30 Days 0.50% 31-60 Days 1.75% 61-90 Days 3.00% 91-120 Days 11.00% Over 120 Days 55% UI 7 3 0 1 Required: 2. Using the schedule prepared in #1, determine the allowance for Bad Debt balance as of December 31, 2019. 2 3 4 15 36 3. The company has asked you to prepare the year end adjusting entry. The balance in the Allowance for Bad Debts account was a credit balance of $2500 before adjustment. 18 49 50 51 Sheet1 + D E F G Emerson Company Accounts Receivable Aging Report December 31, 2019 Total Receivable 91-120 0-30 Days 31-60 Days 61-90 Days Over 120 Days Days Customer Amerson Company Buick Organization Colorado Trail Company Devonshire Electric Franklin Bank Graphic Packaging 2. 0-30 Days 31-60 Days 61-90 Days 191-120 Days 2. +120 Days 3 0.50% 1.75% 3.00% 11.00% 55% ooooo 3,147.23 Sheet1 + A 25 C D E 26 3. 27 Bad Debt Expense 78 Allowance for Bad Debts 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94