Question: 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

 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 Accounts Recelvable
Value (\$) Value (\$) Accounts Receivable by Age 61.90 days past due
31.60 days past due 1.30 darr past due Makeup of Total Sales
Percent Uncollectible by Accounts 1. Estimate the balance of the Allowance for
Doubtful Accounts using aging of accounts receivable. 2. Make the adjusting entry

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 Accounts Recelvable Value (\$) Value (\$) Accounts Receivable by Age 61.90 days past due 31.60 days past due 1.30 darr past due Makeup of Total Sales Percent Uncollectible by Accounts 1. Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable. 2. Make the adjusting entry to record Bad Debts Expense assuming the unadjusted balance in the Allowance for Doubtful Accounts is a $5,000 credit and use of the aging of accounts receivables method. 3. Make the adjusting entry to record Bad Debts Expense assuming the unadjusted balance in the Allowance for Doubtful Accounts is an $8,000 debit and use of the aging of accounts receivables method. 4. Based on further analysis, assume we find that the percentages in the graphic "Percent Uncollectible by Age" are too high. When alerting the manager, she responds that this is intentional. What are the income statement impacts from the overstated percentages? Complete this question by entering your answers in the tabs befow. Estimate the balance of the Allowance for Doubtful Accounts using oging of accounts recelvable. Estimate the balance, of the Allowance for Doubtful Accounts using aging of accounts receivab Journal entry worksheet Journal entry worksheet Note: Enter debits before credits. Complete this question by entering your answers in the tabs below. Based on further analysis, assume we find that the percentoges in the grophic "Percent Uncollectible by Age" are too high. Whan ale the manager, she responds that this is intentional. What are the income statement impacts from the overstated percentoges

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!