Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. the manager asks you to assist her with the data a

The manager asks you to assist her with the data analytics on bad debts expense...

80.2K

Verified Solution

Question

Accounting

image
image
image
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 Cash $732,000 Supplies $476,000 Accounts Receivable Inventory $1,220,000 $1,708,000 Value (5) 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 Not yet due $830,000 50 $200.000 $400.000 $600.000 $800.000 Percent Uncollectible by Age 68% Makeup of Total Sales 70% Cash Sales 6096 $2,250,000 50% 4096 Estimated Percent Uncollectible 33% 3096 $7,150,000 Credit Sales 20% 1096 7% 2% 3% Percent Uncollectible by Accounts Credit Sales 1% Accounts Receivable 59 0% Not yet duo 1-30 days past due 31-60 days 61-90 days Over 90 days past due past due past due ** + ableau 1. Identify the amount of credit sales. 2. Identify the amount of accounts receivable 3. Estimate the balance of the Allowance for Doubtful Accounts using the percent of accounts receivable method. Hint Identify the percent of uncollectible for accounts receivable. S 1. Credit salon 2 Totalccounts receivable 3 Allowance for Doubtful Accounts $ 94,000 470,000 12,000 XXX $

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students