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 Receivable
by Age Over 90 days past due 6190 daysspast due 3160 doys
past due 130 days past due Percent Uncollectible by Age Makeup of
Total Sales 1. Estimate the balance of the Allowance for Doubtful Accounts

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 Receivable by Age Over 90 days past due 6190 daysspast due 3160 doys past due 130 days past due Percent Uncollectible by Age Makeup of Total Sales 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 recelvables 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 below. Estimate the balance of the Alsowance for Doubtful Accounts using aging of accounts receivable. Complete this question by entering your answers in the tabs below. 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. Journal entry worksheet Complete this question by entering your answers in the tabs below. Make the adjusting entry to record Bad Debts Expense assuming the unadjusted balance in the Allowance for Doubthul Accounts is an $8,000 debit and use of the aging of accounts recelvables method. Journal entry worksheet kint Enter sebwes before rtears Based on further analysis, assume we find that the percentages in the graphic percent Uncollectible by Age" are too high. Whee alerting 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!