Tableau Dashboard Activity 7-2 Uncollectible Accounts

IBS is a global provider of point-of-sale systems and related services that enable businesses to accept electronic payments. As a new hire in the company’s international headquarters’ accounting department, one of your first assignments is to assist a team tasked with analyzing the company’s accounts receivable collections. As a starting point, the team is provided with the following Tableau Dashboard.

To see companies within a particular country, either click on that country or use the search field in the upper left corner. To return to the map’s global view, click on the Home icon in the upper left corner.

Drawing from the data available, assess the following:

Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios.

Which country appears to have the most need of improvement in collection procedures as measured by its receivables turnover ratio?

Which company in Peru is most responsible for that country’s low turnover ratio?

IBS has established estimates for percentages of outstanding accounts receivable that are past due for the following periods of time that will be uncollectible:

2%	0−30	days
5%	31−60	days
10%	61−90	days
15%	91−120	days
20%	>120	days

Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea.