4

Accounts Receivable by Age Over 90 days past due 1 61-90 days past due 31-60 days past due 1-30 days past due Not yet due $0 $200,000 $400,000 $600,000 $800,000 Accounts Receivable (s) Percent Uncollectible by Age Makeup of Total Sales 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 Identity the percent of uncollectible for accounts receivable. 1. Credit sales 2. Total accounts receivable 3. Allowance for Doubtful Accounts Accounts Receivable (s) Percent Uncollectible by Age Makeup of Total Sales 70% 60% Cash Sales 50% 40% Estimated Percent Uncollectible 30% Credit Sales 20% 10% 0% Percent Uncollectible by Accounts Credit Sales 196 Accounts Receivable 596 Not yet due 1-30 days past due 31-60 days 61-90 days Over 90 days past due past due past due Tableau DA 9-1: Quick Study, Percent of accounts recelvable method LO P3 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 Cash Accounts Receivablo Inventory Supplies Accounts Receivable by Age Over 90 days past due 1 61-90 days past due 31-60 days past due 1-30 days past due Not yet due $0 $200,000 $600,000 $800,000 $400,000 Accounts Receivable ($) Accounts Receivable (5) 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 59 0% Not yet due 1-30 days 31-60 days 61-90 days Over 90 days past due past due past due past due 10% 0% Percent Uncollectible by Accounts Credit Sales Accounts Receivable 596 Not yet due 1% 1-30 days 31-60 days past due past due 61-90 days Over 90 days past due past due 8 +obleau 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 Accounts Receivable by Age Over 90 days past due 1 61-90 days past due 31-60 days past due 1-30 days past due Not yet due $0 $200,000 $400,000 $600,000 $800,000 Accounts Receivable (s) Percent Uncollectible by Age Makeup of Total Sales 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 Identity the percent of uncollectible for accounts receivable. 1. Credit sales 2. Total accounts receivable 3. Allowance for Doubtful Accounts Accounts Receivable (s) Percent Uncollectible by Age Makeup of Total Sales 70% 60% Cash Sales 50% 40% Estimated Percent Uncollectible 30% Credit Sales 20% 10% 0% Percent Uncollectible by Accounts Credit Sales 196 Accounts Receivable 596 Not yet due 1-30 days past due 31-60 days 61-90 days Over 90 days past due past due past due Tableau DA 9-1: Quick Study, Percent of accounts recelvable method LO P3 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 Cash Accounts Receivablo Inventory Supplies Accounts Receivable by Age Over 90 days past due 1 61-90 days past due 31-60 days past due 1-30 days past due Not yet due $0 $200,000 $600,000 $800,000 $400,000 Accounts Receivable ($) Accounts Receivable (5) 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 59 0% Not yet due 1-30 days 31-60 days 61-90 days Over 90 days past due past due past due past due 10% 0% Percent Uncollectible by Accounts Credit Sales Accounts Receivable 596 Not yet due 1% 1-30 days 31-60 days past due past due 61-90 days Over 90 days past due past due 8 +obleau 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