Tableau Dashboard Activity 5-1 Account for Uncollectible Accounts Using the Aging Method Review the Tableau visualization,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Tableau Dashboard Activity 5-1 Account for Uncollectible Accounts Using the Aging Method Review the Tableau visualization, and then answer the questions that follow. Total Accounts Receivable Amount $160,000 $150,000 $140,000 $130,000 $120,000 $110,000 $100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0 #+ableau Accounts Receivable Average % Estimated Uncollectible $100,000 $80,000 $60,000 $40,000 $20,000 $0 50% By Age Category 40% 30% 20% 10% 0% Not yet due 1-60 days >60 days past past due due Not yet due 1-60 days past >60 days past due due Age O Not yet due O 1-60 days past due O >60 days past due Customer Individual Account Balance Customer # 242 246 251 261 265 269 271 276 279 282 286 288 292 294 301 303 307 317 318 322 323 326 329 333 335 343 347 349 353 $0 $1,000 $2,000 Amount O Required 1 Required 2 Required 3 Record the adjusting entry for uncollectible accounts. Assume the balance of Allowance for Uncollectible Accounts prior to the adjusting entry is $2,173 (credit). (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field. Round your answers to the nearest whole dollar amount.) View transaction list Journal entry worksheet 1 Record the adjusting entry for uncollectible accounts. Note: Enter debits before credits. Required 4 Required 5 Transaction 1 Record entry General Journal Clear entry Debit Credit View general journal Tableau Dashboard Activity 5-1 Account for Uncollectible Accounts Using the Aging Method Review the Tableau visualization, and then answer the questions that follow. Total Accounts Receivable Amount $160,000 $150,000 $140,000 $130,000 $120,000 $110,000 $100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $0 #+ableau Accounts Receivable Average % Estimated Uncollectible $100,000 $80,000 $60,000 $40,000 $20,000 $0 50% By Age Category 40% 30% 20% 10% 0% Not yet due 1-60 days >60 days past past due due Not yet due 1-60 days past >60 days past due due Age O Not yet due O 1-60 days past due O >60 days past due Customer Individual Account Balance Customer # 242 246 251 261 265 269 271 276 279 282 286 288 292 294 301 303 307 317 318 322 323 326 329 333 335 343 347 349 353 $0 $1,000 $2,000 Amount O Required 1 Required 2 Required 3 Record the adjusting entry for uncollectible accounts. Assume the balance of Allowance for Uncollectible Accounts prior to the adjusting entry is $2,173 (credit). (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field. Round your answers to the nearest whole dollar amount.) View transaction list Journal entry worksheet 1 Record the adjusting entry for uncollectible accounts. Note: Enter debits before credits. Required 4 Required 5 Transaction 1 Record entry General Journal Clear entry Debit Credit View general journal
Expert Answer:
Answer rating: 100% (QA)
To record the adjusting entry for uncollectible accounts we need to estimat... View the full answer
Related Book For
Financial Accounting an introduction to concepts, methods and uses
ISBN: 978-0324789003
13th Edition
Authors: Clyde P. Stickney, Roman L. Weil, Katherine Schipper, Jennifer Francis
Posted Date:
Students also viewed these accounting questions
-
3. Show how accounts receivable will appear on the December 31, 2023, balance sheet. Assets Current assets: Partial Balance Sheet Accounts receivable Less: Allowance for doubtful accounts 22,525
-
Softball Magazine Company received advance payments of $75,000 from customers during 2019. At December 31, 2019, $20,000 of the advance payments still had not been earned. Required: After the...
-
The following information comes from the accounting records of Hercep Ltd. for the first three years of its existence: Required a. Based on above information, analyze and comment on the changes in...
-
From 2008 to 2015, auto loan rates in the United States declined from around 8% to near historic lows of around 4%. At the same time, auto sales increased dramatically. How, if at all, does this...
-
Carole Dahl is chief financial officer of the Phoenix Division of Dahl Corporation, a multinational company with three operating divisions. As part of the budgeting process, Dahl's staff is...
-
A. Based on this topology, what is the NTP level at SW2? Fa0/24 2960-24TT SW1 Internet Fa0/1 3 192.168.123.0/24 Server-PT pool.ntp.org 146.105.130.223 2 Fa0/24 2960-24TT SW2
-
Compute using acquisition analysis. show calculation and journal entries. Cash Accounts Receivable (net) $20,000.00 $42,000.00 Inventories $95,000.00 Property, Plant and Equipment (net) $228,000.00...
-
Suppose you were to start your own business as a solo CPA doing taxes. What pieces of the opportunity cost of running such a business resemble a fixed cost, and which pieces of the opportunity cost...
-
The table shows the demand schedule facing Nina, a monopolist selling baskets. What is the change in total revenue if she raises the price from $10 to $12? Price Number of Baskets Sold $ 20 3 18 5 16...
-
the Foreign Corrupt Practices Act (FCPA) of 1977 was the first major international law to address bribery. I'm sure you've read about the pros and cons of the bribery argument. What arguments are...
-
Assume that the typical consumer basket consists of 5 bushels of peaches and 10 bushels of walnuts and that the base year is 2014. What is the consumer price index for 2014? Year peaches pecans 2014...
-
A forward contract has only one payment cash flow that occurs at the time of delivery
-
10. Which of the following occurs during the initiation stage of a radical mechanism? a. Nonradicals are formed from radicals. b. Radicals are formed from other radicals. c. Radicals are formed from...
-
What will be the final value of DI after executing the following piece of code? Execute the instructions dependently one after another. CLD MOU CX,OFOH MOU AX.02874H MOU DI,01000H MOU ES, DI SUB...
-
Accounting for long-term bonds. The notes to the financial statements of Aggarwal Corporation for 2008 reveal the following information with respect to long-term debt. All interest rates in this...
-
Selected data from the statement of cash flows for Jackson Corporation for the years ended October 31, 2008, 2007, and 2006 appear as follows (amounts millions) Prepare a statement of cash flows for...
-
Flow of manufacturing costs. The Sandvik Group is a Swedish-based, high-technology engineering firm. It follows IFRS and reports its results in millions of Swedish kronor (SEK). For the years ended...
-
Predictions of future technological advances and breakthroughs are notoriously unreliable. For example, in the 1960 some futurists predicted that we would all soon be commuting to work in our own...
-
What overriding goal should every systems designer, in performing input design, never lose sight of?
-
Despite the inroads being made by other input methods, the venerable keyboard is still far and away the most common method used for data input, and it is likely to stay that way for a while. But...
Study smarter with the SolutionInn App