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.

$$

The manager asks you to assist her with the data analytics on bad debts expense at year$-$end. To do this, you access the followin

Tableau Dashboard for your company.

Makeup of Current Assets

Percent Uncollectible by Age

Makeup of Total Sales

Cash Sales

$6,075,000$

Credit Sales

$19,305,000$

Percent Uncollectible by Accounts

View on Tableau Public

Complete this question by entering your answers in the tabs below.

Required $1$

For Firm I, estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable.

Important! Be sure to click the correct Firm at the top of the dashboard.

Journal entry worksheet

$1$

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 receivable method.

Note: Enter debits before credits.

Journal entry worksheet

$1$

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 receivable method.

Note: Enter debits before credits.

Based on further analysis, assume we find that the percentages in the graphic "Percent Uncollectible by Age" are too high.

Please make the steps easy to read