Tableau DA 7-1 (Algo): Quick Study, Percent of accounts receivable 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.
Select Firm → Firm A Firm B Firm C Firm D Firm E Firm F Firm G Firm H Firm I Firm J
Makeup of Current Assets
$1,317,600 $2,196,000 $3,074,400 $856,800
Cash Accounts Receivable Inventory Supplies
Accounts Receivable by Age
Over 90 days past due $21600
61-90 days past due $68,400
31-60 days past due 154,800
$457,200
1-30 days past due
Not yet due $1,494,000
$0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000
Accounts Receivable ($)
Percent Uncollectible by Age
68%
Cash Sales
60% $4,050,000
40%
20% 33%
Credit Sales
$12,870,000
Estimated Percent Uncollectible
7%
0% 2% 3%
Not yet due 1-30 days 31-60 days 61-90 days Over 90 days
past due past due past due past due
Percent Uncollectible by Accounts
Credit Sales 1%
Accounts Receivable 5%
View on Tableau Public Share
Important! Be sure to click the correct Firm at the top of the dashboard.
Firm Questions Answers
1. E Identify the amount of credit sales.
2. E Identify the amount of accounts receivable.
3. E 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.
