Tableau Dashboard Activity 6-1 Determining Bad Debt Expense Based on Aging Analysis LO 6-2 Blue Skies Equipment Company uses the aging approach to estimate bad debt expense at the end of each accounting year. Credit sales occur frequently on terms n/60. The balance of each account receivable is aged on the basis of three time periods as follows: (1) not yet due, (2) up to one year past due, and (3) more than one year past due. Only five customers have unpaid balances on December 31, 2019. To do your analysis, you are provided with the following Tableau Dashboard: Aging of Accounts Receivable Estimated Uncollectible % Aging Analysis of Accounts Receivable $50,000 $40,000 nt Check my $40,000 $30,000 Accounts Receivable Amount $ $20,000 I. $10,000 $0 B. Brown D. Donalds N. Napier S. Strothers T. Thomas Totals Measure Names (a) Not Yet Due (b) Up to One Year Past Due (c) More Than One Year Past Due 25% 20% Estimated uncollectable percentages 15% 10% 5% 0% (a) Not Yet Due (b) Unto One Year Past Due (c) More Than One Year Past Due # + ableau K Required: 1. Compute the total estimated uncollectible amounts as of December 31, 2019. 2. Give the adjusting entry for bad debt expense at December 31, 2019. The Allowance for Doubtful Accounts balance is $920 (credit) before the end-of-period adjusting entry is made. 3. Show how the amounts related to accounts receivable should be presented on the 2019 income statement. 4. Show how the amounts related to accounts receivable should be presented on the December 31, 2019 balance sheet. 5. Which customer's account is most likely to require a writeoff? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Compute the total estimated uncollectible amounts as of December 31, 2019. Amount Not yet due Up to one year past due More than one year past due Total Required 1 Required 2 Required 3 Required 4 Required 5 Give the adjusting entry for bad debt expense at December 31, 2019. The Allowance for Doubtful Accounts balance is $920 (credit) before the end-of-period adjusting entry is made. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) View transaction list Journal entry worksheet Record the journal entry for bad debt expense at December 31, 2019. Note: Enter debits before credits. General Journal Debit Credit Transaction Record entry Clear entry View general journal