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 Required 1 Required 2 Required 3 Required 4 Required 5 Show how the amounts related to accounts receivable should be presented on the 2019 income statement. BLUE SKIES EQUIPMENT COMPANY Income Statement (Partial) For the Year Ended December 31, 2019 Operating expenses: Required 1 Required 2 Required 3 Required 4 Required 5 Show how the amounts related to accounts receivable should be presented on the December 31, 2019 balance sheet. (Amounts to be deducted should be indicated by a minus sign.) BLUE SKIES EQUIPMENT COMPANY Balance Sheet (Partial) As of December 31, 2019 Current assets: Required 1 Required 2 Required 3 Required 4 Required 5 Which customer's account is most likely to require a writeoff? Which customer's account is most likely to require a writeoff