Tableau Dashboard Activity 5-1 Account for Uncollectible Accounts Using the Aging Method Review the Tableau visualization,...

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: 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. (Amounts to be deducted should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) Net Accounts Receivable 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: 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. (Amounts to be deducted should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) Net Accounts Receivable

Answer rating: 100% (QA)

Detailed Explanation The task involves analyzing a Tableau dashboard that visualizes accounts receivable categorized by age to determine the net accou... View the full answer