5 1 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. points eBook Print References Makeup of Current Assets Cash Accounts Receivable Over 90 days past due 61-90 days past due 31-60 days past due 1-30 days past due 70% 60% 50% 10% 30% 20% 10% Not yet due Inventory Supplies Accounts Receivable by Age $0 $200,000 $400,000 $600,000 $800,000 Accounts Receivable ($) Makeup of Total Sales Percent Uncollectible by Age Credit Sales Cash Sales Percent Uncollectible by Accounts 0% Not yet due 1-30 days past due 31-60 days 61-90 days Over 90 days past due past due past due Credit Sales Accounts Receivable 1% 5% +ableau 1. Identify the amount of credit sales. 2. Identify the amount of accounts receivable. 3. Estimate the balance of the Allowance for Doubtful Accounts using the percent of accounts receivable method. Hint Identify the percent of uncollectible for accounts receivable. 1. Credit sales 2. Total accounts receivable 3. Allowance for Doubtful Accounts