Amount Review the Tableau visualization, and then answer the questions that follow. Total Accounts Receivable Age By Age Category Not yet due $160,000 $150,000 $140,000 its Receivable $100,000 $80,000 $60,000 O 1-60 days past due O>60 days past due Customer Individual Account Balance Customer # Amount: $159,696 0,000 118 $130,000 131 136 $20,000 $120,000 142 173 $0 177 $110,000 Not yet due 1-60 days past due >60 days past 183 due 208 $100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 216 219 224 50% 234 Average % Estimated Uncollectible 248 297 311 40% 312 339 359 30% 384 388 $0 $1,000 $2,000 20% Amount 10% 0% Not yet due 1-60 days past >60 days past $0 due due Amount Review the Tableau visualization, and then answer the questions that follow. Age Total Accounts Receivable $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 Average % Estimated Uncollectible Accounts Receivable $100,000 $80,000 $60,000 $40,000 $20,000 50% 40% 30% 20% 10% By Age Category Not yet due O1-60 days past due O >60 days past due Customer Individual Account Balance Customer # 124 134 137 160 170 $0 204 Not yet due 1-60 days >60 days past 239 past due 256 due 273 369 $0 $1,000 $2,000 Amount 0% Not yet due 1-60 days past >60 days past due due Amount Review the Tableau visualization, and then answer the questions that follow. Total Accounts Receivable $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 Accounts Receivable Age By Age Category O Not yet due $100,000 $80,000 $60,000 $40,000 $20,000 O 1-60 days past due O>60 days past due Customer Individual Account Balance Customer # 101 103 105 109 111 $0 113 Not yet due 1-60 days past due >60 days past 119 127 due 129 139 147 50% 152 156 165 168 40% 179 180 182 30% 185 189 194 196 20% 197 200 202 10% 212 218 221 0% 229 Not yet due 1-60 days past >60 days past $0 $1,000 $2,000 due due Amount Average % Estimated Uncollectible Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Estimate the amount of uncollectible receivables. Note: Round your answers to 1 decimal place. Data Analytics Not yet due 1 to 60 days past due >60 days past due Total Estimated Amount Uncollectible $ 0.0 < Required 1 Required 2 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Record the adjusting entry for uncollectible accounts. Assume the balance of Allowance for Uncollectible Accounts prior to the adjusting entry is $2,173 (credit). Note: 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. Show less View transaction list View journal entry worksheet (x) No Transaction General Journal Debit Credit 1 1 Allowance for Uncollectible Accounts Bad Debt Expense 2,173 20,827.00 Accounts Receivable 23,000 < Required 1 Required 3 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 Calculate net accounts receivable reported in the balance sheet. Note: Amounts to be deducted should be indicated with a minus sign. Round your answers to the nearest whole dollar amount. Net Accounts Receivable < Required 2 $ 0 Required 4 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 What amount of bad debt expense is reported in the income statement. Note: Round your answer to the nearest whole dollar amount. Bad debt expense < Required 3 Required 5 > Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Required 5 For accounts over 60 days past due, what customer owes the most and how much is owed by that customer? Customer # Amount owed < Required 4 Required 5 >