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 61-90 Days Past Due 0 0 91-120 Days Past Due 0 15,000 0 0 0 AR by Company 0-30 Days 31-60 Days Company Invoice Past Duc Past Due Company 1186 IN-1235005 45,009 0 IN-1237863 0 6.004 Company 1187 IN-1236006 278.003 0 IN-1237864 19,002 0 Company 1208 IN-1234995 44.118 0 Company 1256 IN-1236009 2,096,650 0 IN-1237776 120,000 IN-1237836 0 15.000 IN-1237845 92,805 0 IN-1237867 5,000 Company 1633 IN-1235004 300,987 0 IN-1237862 0 34,000 Company 1799 IN-1236016 3.008.009 D IN-1237783 3.500 IN-1237813 0 IN-1237852 13.000 Company 1800 IN-1236017 305.000 IN-1237754 100,400 IN-1207844 IN-1237853 0 0 0 0 0 0 0 0 0 0 0 0 0 0 >120 Days Grand Past Due Total 0 45,009 0 21,004 0 278,003 0 19,002 0 44,118 0 2,096,650 0 120.000 0 15,000 0 92,805 0 5,000 0 300,987 0 34,000 0 3,008,009 0 3.500 0 35,000 43,000 0 308,000 0 107.400 32,000 -24.000 0 O 0 0 0 0 35.000 0 0 0 D -24.000 32,000 w 0 Company 1801 IN-1237853 IN-1236018 IN-1237785 0 0 0 0 0 120.000 -24.000 104,009 0 0 0 0 0 0 -24,000 104,009 120,000 SOM ARA son * + ableau Red To 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: 1. Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. 2. Which country appears to have the most need of improvement in collection procedures as measured by its receivables turnover ratio? 3. Which company in Peru is most responsible for that country's low tumover ratio? 4. IBS has established estimates for percentages of outstanding accounts receivable that are past due for the following periods of time that will be uncollectible! 2x 5 10% 15% 20% 0-30 days 31-68 days 61-90 days 91-120 days >120 days Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea Required 1 Required 2 Required 3 Required 4 Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. (Round your answers to 2 decimal places.) Country Receivables Tumover Ratio Required 2 > Required 1 Required 2 Required 3 Required 4 Which country appears to have the most need of improvement in collection procedures as measured by turnover ratio? (Round your answer to 2 decimal places.) Country Receivables Turnover Ratio Required 1 Required 2 Required 3 Required 4 Which company in Peru is most responsible for that country's low turnover ratio? Company 1186 O Company 3417 O Company 11644 Company 19949 O Company 9913 Tor South Korea. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Calculate the Allowance for Uncollectible accounts for South Korea. Allowance for Uncollectible Accounts 120 Days Grand Past Due Total 0 45,009 0 21,004 0 278,003 0 19,002 0 44,118 0 2,096,650 0 120.000 0 15,000 0 92,805 0 5,000 0 300,987 0 34,000 0 3,008,009 0 3.500 0 35,000 43,000 0 308,000 0 107.400 32,000 -24.000 0 O 0 0 0 0 35.000 0 0 0 D -24.000 32,000 w 0 Company 1801 IN-1237853 IN-1236018 IN-1237785 0 0 0 0 0 120.000 -24.000 104,009 0 0 0 0 0 0 -24,000 104,009 120,000 SOM ARA son * + ableau Red To 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: 1. Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. 2. Which country appears to have the most need of improvement in collection procedures as measured by its receivables turnover ratio? 3. Which company in Peru is most responsible for that country's low tumover ratio? 4. IBS has established estimates for percentages of outstanding accounts receivable that are past due for the following periods of time that will be uncollectible! 2x 5 10% 15% 20% 0-30 days 31-68 days 61-90 days 91-120 days >120 days Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea Required 1 Required 2 Required 3 Required 4 Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. (Round your answers to 2 decimal places.) Country Receivables Tumover Ratio Required 2 > Required 1 Required 2 Required 3 Required 4 Which country appears to have the most need of improvement in collection procedures as measured by turnover ratio? (Round your answer to 2 decimal places.) Country Receivables Turnover Ratio Required 1 Required 2 Required 3 Required 4 Which company in Peru is most responsible for that country's low turnover ratio? Company 1186 O Company 3417 O Company 11644 Company 19949 O Company 9913 Tor South Korea. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Calculate the Allowance for Uncollectible accounts for South Korea. Allowance for Uncollectible Accounts