The manager asks you to assist her with the data analytics on bad debts expense at year-end. To do this, you access the following Tableau Dashboard for your company. Makeup of Current Assets Cash Accounts Receivable Inventory Supplies Accounts Receivable by Age Over 90 days past due 61-90 days past due 31-60 days past due 1-30 days past due $0 $200,000 $600,000 $800,000 $400,000 Accounts Receivable ($) Percent Uncollectible by Age Makeup of Total Sales 70% Cash Sales 60% 50% 40% Estimated Percent Uncollectible 30% Credit Sales 20% 10% Percent Uncollectible by Accounts Credit Sales 1% Accounts Receivable 0% Not yet due 1-30 days past due 5% 31-60 days 61-90 days Over 90 days past due past due past due # tableau E K TO 1. Estimate the balance of the Allowance for Doubtful Accounts using percent of sales method. Assume a $0 existing balance in Allowance for Doubtful Accounts. Hint: Identify the percent of uncollectible for credit sales. 2. Estimate the balance of the Allowance for Doubtful Accounts using percent of receivables method. Assume a $0 existing balance in Allowance for Doubtful Accounts. Hint: Identify the percent of uncollectible for accounts receivable. 3. Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable. Assume a $0 existing balance in Allowance for Doubtful Accounts. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Req 1 and 2 Req3 1. Estimate the balance of the Allowance for Doubtful Accounts using percent of sales method. Assume a $0 existing balance in Allowance for Doubtful Accounts. Hint: Identify the percent of uncollectible for credit sales. 2. Estimate the balance of the Allowance for Doubtful Accounts using percent of receivables method. Assume a $0 existing balance in Allowance for Doubtful Accounts. Hint: Identify the percent of uncollectible for accounts receivable. Show less $ 1. 2. Estimate the balance of the Allowance for Doubtful Accounts Estimate the balance of the Allowance for Doubtful Accounts 61,000 61,000 $ Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Req 1 and 2 Reg 3 Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable. Assume a $0 existing balance in Allowance for Doubtful Accounts. Percent uncollectible (%) 68% X $ 8,160 33% X = Accounts receivable Not yet due: 12,000 X X 1 to 30: 38,000 X 31 to 60 86,000 61 to 90: 830,000 X Over 90 1,220,000 X X Estimated balance of allowance for uncollectibles 12,540 6,020 7% = 3% X = 2% X= 24,900 24,400 $ 76,020 credit