ableau-3 0 Tableau DA 7-3: Mini-Case, Aging of recelvables The manager asks you to assist her with the data analytics on ba Tableau Dashboard for your company. Makeup of Current Cash Cash: $732,000 Receivable Accounts Receivable Over 90 days past due 61 90 days past due 31-60 days past due 1-80 days past dus eceivables metho assist her with the data analytics on bad deb Our company. Makeup of Current Ass Accounts Receivable: 51,220,000 Accounts Receivable by ton Or Tableau-3 X .html?_con=con&external_browser=0&launchUrl=https% Saved of receivables method and adjusting entries LO P3 he data analytics on bad debts expense at year-end. To do this, you a =up of Current Assets ble Inventory Supplies Inventory: 51,708,000 nts Receivable by Aye &external_browser=0&launchUn=https%253A%252F%252Flms.mheducate Seved es method and adjusting entries LO P3 on bad debts expense at year-end. To do this, you access the following Fent Assets Inventory Supplies Supplies: 5476,000 vable by Age counts Recavabos ext/map/index.html?_con=con&external browser=08 Ch 07 Tableau-3 1 Tableau DA 7-3. Mini-Case, Aging of receivables method and adjustin ents The manager asks you to assist her with the data analytics on bad debts expense at year Tableau Dashboard for your company BOOK Makeup of Current Assets Account Receivable Inventory Accounts Receivable by Age Orsay paste 61-80 days Over 90 days past due: $12.000 31-60 days pastu Sadays past $ 5200.000 5400 000 Accounts Receivable (5) $500.000 here to search Accounts Rece past due 61-90 days past due: $38,000 E 31-60 days past due: $86,000 5430 0 1-30 days past due: 5254,000 5400 000 Accounts Rece Not yet due: 5830,000 $200,000 5400,000 5600,000 Accounts Receivable (5) ceivable ($) Makeup of Total Sales Cash Sales Credit Sales: 57,150,000 Credit Sales Percent Uncollectible by Accounts Credit Sales 198 days Accounts Receivable keup of Total Sales Cash Sales Cash Sales: 52,250,000 Sales cent Uncollectible by Accounts La Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Estimate the balance of the Allowance for Doubtful Accounts using aging of accounts receivable. 11 11 Accounts Percent receivable uncollectible (%) Not yet due: X 1 to 30: 31 to 60 X 61 to 90 X Over 90: Estimated balance of allowance for uncollectibles = = = = = #1 $ Make the adjusting entry to record Bad Debts Expense assuming the unadjusted balance in the Allowanc $5,000 credit and use of the aging of accounts receivables method. View transaction list Journal entry worksheet 1 Record the estimated bad debts. Note: Enter debits before credits Transaction General Journal Debit Credit Dec. 31 Record entry Clear entry View general journal View transaction list Journal entry worksheet 1 Record the estimated bad debts. Note: Enter debits before credits. Transaction General Journal Debit Credit Dec. 31 Record entry Clear entry View general journal Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Based on further analysis, assume we find that the percentages in the graphic "Percent Uncollectible by Age are too high. When alerting the manager, she responds that this is intentional. What are the income statement impacts from the overstated percentages? What are the income statement impacts from the overstated percentages? Show All Items
