80.2K

Verified Solution

Link Copied!

help plse if someone can di this correctly

help

The manager asks you to assist her with the data analytics on bad debts expense at year-end. To do this, you access the fallowing Tableau Dashboard for your company. Makeup of Current Assets Inventory Value ( (5) Accounts Receivable by Age 61.90 dars past due 3160 days past due 1-30 days past due \begin{tabular}{|l|l|l|} \hline Cash & Accounts Receivable & Inventory \\ \hline Value ($) & \\ \hline Sapplies \\ \hline \end{tabular} Accounts Receivable by Age Over 90 days past due 6190 days past due 31-60 days past due 1.30 days past due Not yet due 50 $200,000 5400,000 $600.000 $300.000 Accounts Recelvable (s) Accounts Receivable (\$) Percent Uncollectible by Age rose 5045 407 3095 \#20\% 10% Mot yet due 1.30 days past due 3140 days 61.90 dars Over 90 fays past due past due past due bast due Makeup of Total Sales Percent Uncollectible by Accounts Creditsales Accounts Recelvable 1. Estimate the balance of the Allowance for Doubtful Accounts using percent of sales method. Assume a 50 existing balance in Allowance for Doubtful Accounts. Hint identify the percent of uncollectible for credit sales. 2. Estimate the balance of the Allowance for Doubtful Accounts using percent of recelvables method. Assume a 50 existing balance in Allowance for Doubtful Accounts. Hint identafy the percent of uncollectible for accounts receivable. 3. Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts recelvable. Assume a 50 existing balance in Aliowance for Doubtful Accounts. Complete this question by entering your answers in the tabs below. 1. Estimate the balance of the Allowance foe Doubtiul Accounts using percent of sales method. Assume a 10 arie the balance in Alowance for Doubtful Accounts. Hint: Identify the percent of uncollectible for credit siales. 2. Estimate the balance of the Allowance for Doubthal Accounts unang percent of receivables method. Assume a 10 esating balance in Alowance for Doubtful Accounts. Hint: fdentify the percent of uncobectible for accesunts recerrable. Nlowance for Doubtid Accoures balance in Alowange hr Cvethe acokinth. 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 Accounts Receivable by Age Over 90 deys post due 61. 90 days past due 31-60 days past due 130 days past due Makeup of Current Assets Cash Accounts Receivable Inventory Accounts Receivable by Age Over 90 days past due 61.90 days past due 31-60 days past due 1-30 days pest due Not yet due 50 $200,000 $400,000 5+00,000 $900,000 Makeup of Current Assets Quts Reccivable Inventory Accounts Receivable by Age \begin{tabular}{|l|l|l|l|} \hline Cash & Accounts Receivable & Inventory & Supplits \\ Value (\$) \end{tabular} Accounts Receivable by Age Over 90 days pest due 61-90 days past due 61-90 days past due: $38,000 31. 60 days past due 1.30 days pest due Not yet due 50 $200,000 $400,000 5600,000 5000,000 Makeup of Current Assets Makeup of Current Assets Cash Accounts Receivable Inventory Accounts Receivable by Age Over 90 dirys past due 6190 days pest due 31.60 dess past due 1-30 dorn post due 1-30 days past due: \$254,000 Not yet due 505200,0005400,0005600,000580,000 Makeup of Current Assets Accounts Receivable by Age Over 90 days past due 61-90 dirs pest due 3160 days pest due 1.30 deys past due Not yet due sin $200,000 5400,000 Not jwt doe: 5330,000 Snov,000 soveroeo Percent Uncollectible by Age Makeup of Total Sales 1. Estimate the balance of the Allowance for Doubtful Accounts using percent of sales method. Assume a 50 existing balance in Allowance for Doubtful Accounts. Hint idertify the percent of uncollectible for credit sales 2. Estimate the balance of the Allowance for Doubtful Accounts using percent of recetvables method. Assume a 50 existing batance in Allowance for Doubtful Accounts. Hint identify the percent of uncollectible for accounts receivabie 3. Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable. Assume a 50 exusting balance in Allowance for Doubtful Accounts Complete this question by entering your answers in the tabs below. Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable. Assume a 30 easting balance in Allowance for Doubtful Accounts. 1. Estimate the balance of the Allowance for Doubtful Accounts using percent of sales method. Assume a 50 exsting baiance in Allowance for Doubtil Accounts. Hint identify the percent of uncollectible for credit sales 2. Estimate the balance of the Allowance for Doubtful Accounts using percent of recelvables method. Assume a 50 existing baiance in Allowance for Doubtuil Accounts. Hint identify the percent of uncollectible for accounts receivable 3. Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable. Assame a 50 existing balance in Allowance for Doubtful Accounts. Coraplete this question by entering your answers in the tabs below. 1. Estimate the balance of the Allowance for Doubtful Accounts using percent of sales method. Asaums a so casthng balance in Allowance for Doubtful Accounts. Hent: Identify the percent of uncollectible for credit saks. 2. Estimate the balance of the Allowance for Doubtful Accounts using percent of recerables method. Assume a fo eviutug balance in Allowance for Doubtful Accounts. Hint: Identify the percent of uncollectble for accounts recekable

Answer & Explanation Solved by verified expert

See Answer