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 follo
$200,000 $600,000 $800,000 $400,000 Accounts Receivable ($) Percent Uncollectible by Age Makeup of Total Sales 70% Cash Sales
1. Estimate the balance of the Allowance for Doubtful Accounts using percent of sales method. Assume a $0 existing balance in
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Allowance of doubtful debts using aging of Accounts receivable
Accounts Receivable ($)* Percent Uncollectible (%)* Total
Not yet due                       10,000 x                               1.50                 150
1 to 30                       25,000 x 3                 750
31 to 60                       90,000 x 8             7,200
61 to 90                     240,000 x 33           79,200
Over 90                     820,000 x 68.5        561,700
Total Allowance        649,000

* Based on the graphical presentation given, closely estimated amounts are plotted

As percentages of uncollectible is given, allowance for bad debts for that amount is created.

Add a comment
Know the answer?
Add Answer to:
The manager asks you to assist her with the data analytics on bad debts expense at...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The manager asks you to assist her with the data analytics on bad debts expense at...

    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 1,220,000 1,708,000 732,000 476,000 Cash Accounts Receivable Inventory Supplies Value ($) Accounts Receivable by Age Over 90 days past due 12,000 61-90 days past due 38,000 31-60 days past due 86,000 1-30 days past due 254,000 1.30 days past due Not yet due Not yet due 830,000...

  • cash: 732,000 A/R: 1,220,000 Inventory: 1,708,000 Supplies: 476,000 over 90: 12,000 61-90: 38,000 31-60: 86,000 1-30:...

    cash: 732,000 A/R: 1,220,000 Inventory: 1,708,000 Supplies: 476,000 over 90: 12,000 61-90: 38,000 31-60: 86,000 1-30: 254,000 not yet: 830,000 cash sales: 2,250,000 Credit sales: 7,150,000 Makeup of Current Assets Cash Accounts Receivable Supplies Value ($) Accounts Receivable by Age Over 90 days past due 61-90 days past due 31-60 days past due 1-30 days past due Not yet due mie $0 $200,000 $800,000 $400,000 Accounts Receivable ($) $200,000 $600,000 $800,000 $400,000 Accounts Receivable ($) Percent Uncollectible by Age Makeup...

  • Tableau DA 7-2: Percent of sales method, percent of recelvables method, and aging of receivables method...

    Tableau DA 7-2: Percent of sales method, percent of recelvables method, and aging of receivables 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. $732000 Makeup of Current Assets $1220000 $1708000 $476000 Cash Accounts Receivable Inventory Supplies Value (5) Accounts Receivable by Age Over 90 days past due $12000 61.90 days past due $38000 31.60 days past...

  • Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 [The...

    Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 [The following information applies to the questions displayed below.] Jarden Company has credit sales of $2,200,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $14,666. Jarden prepares a schedule of its December 31, 2017 accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category...

  • Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 The...

    Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 The following information applies to the questions displayed below.] Jarden Company has credit sales of $2,400,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $14,904. Jarden prepares a schedule of its December 31, 2017, accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category...

  • Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 (The...

    Required information Problem 9-3A Aging accounts receivable and accounting for bad debts LO P2, P3 (The following information applies to the questions displayed below.) Jarden Company has credit sales of $2,500,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $14,900. Jarden prepares a schedule of its December 31, 2017, accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category...

  • A company uses the aging of accounts receivable method to estimate its bad debts expense. On...

    A company uses the aging of accounts receivable method to estimate its bad debts expense. On December 31 of the current year an aging analysis of accounts receivable revealed the following 4. A company uses the aging of accounts receivable method to estimate its bad debts expense On December 31 of the current year an aging analysis of accounts receivable revealed the following Account Age Current (not yet due) 1-30 days past due 30 60 days past due 61-90 days...

  • Required information [The following information applies to the questions displayed below.] Jarden Company has credit sales...

    Required information [The following information applies to the questions displayed below.] Jarden Company has credit sales of $2,600,000 for year 2017. On December 31, 2017, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $15,066. Jarden prepares a schedule of its December 31, 2017, accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category that will become uncollectible. This information is summarized here. December 31, 2017 Accounts...

  • Required Information [The following information applies to the questions displayed below.) Jarden Company has credit sales...

    Required Information [The following information applies to the questions displayed below.) Jarden Company has credit sales of $2,900,000 for year 2018. On December 31, 2018, the company's Allowance for Doubtful Accounts has an unadjusted credit balance of $21,659. Jarden prepares a schedule of its December 31, 2018 accounts receivable by age. On the basis of past experience, it estimates the percent of receivables in each age category that will become uncollectible. This information is summarized here. December 31, 2018 Accounts...

  • Check my Roby Reg 2 Prepare the adjusting entry to record bad debts expense assuming the...

    Check my Roby Reg 2 Prepare the adjusting entry to record bad debts expense assuming the unadjusted balance in the Allowance for Doubtful Accounts is a $1,400 credit. View transaction list Journal entry worksheet Record estimated bad debts assuming that allowance for Doubtful Accounts has a $1,400 credit balance. Net Zero Products, a wholesaler of sustainable raw materials. Prepared the following aging of receivables analysis. Days Past Due Total 0 1 $129,000 $84,000 Accounts receivable Percent uncollectible to 30 31...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT