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 Receivables Turnover R AR by Country 0.00 16.30 Ship to Country: Canada 0-30 Days Past Due: 11,020,300 31-60 Days Past Due: 0 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 11,020,300 Receivables Turnover Ratio: 10.40 Ship to Country United States 0-30 Days Past Due: 11,400,233 31-60 Days Past Due: 245,900 61-90 Days Past Due. 153,500 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 11,799,633 Receivables Turnover Ratio: 16.30 Ship to Country Mexico 0-30 Days Past Due 275,400 31-60 Days Past Due: 35,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 310,400 Receivables Turnover Ratio: 8.60 Ship to Country: Guatemala 0-30 Days Past Due: 0 31-60 Days Past Due: 190,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 190,000 Receivables Turnover Ratio: 6.10 Ship to Country: Honduras 0-30 Days Past Due 0 31-60 Days Past Due: 240,000 61.90 Days Past Due: 12,300 91-120 Days Past Due: 0 >120 Days Past Due: 32,000 Grand Total: 284,300 Receivables Turnover Ratio: 3.30 Ship to Country: Colombia 0-30 Days Past Due: 0 31-60 Days Past Due: 0 61-90 Days Past Due: 180,300 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 180,300 Receivables Turnover Ratio: 4.80 Ship to Country: Venezuela 0-30 Days Past Due: 0 31-60 Days Past Due: 0 61-90 Days Past Due: 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 0 Receivables Turnover Ratio: 7.80 Ship to Country: Ecuador 0-30 Days Past Due: 48,700 31-60 Days Past Due: 418,493 61-90 Days Past Due: 35,000 91-120 Days Past Due: 180,000 >120 Days Past Due: 20,555 Grand Total: 702,748 Receivables Turnover Ratio: 5.20 Ship to Country: Peru 0-30 Days Past Due: 28,200 31-60 Days Past Due: 44,900 61-90 Days Past Due: 43,000 91-120 Days Past Due: 39,000 >120 Days Past Due: 20,800 Grand Total: 175,900 Receivables Turnover Ratio: 3.20 Ship to Country: Brazil 0-30 Days Past Due: 0 31-60 Days Past Due: 12,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 12,000 Receivables Turnover Ratio: 5.80 Ship to Country: Brazil 0-30 Days Past Due: 0 31-60 Days Past Due: 12,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 12,000 Receivables Turnover Ratio: 5.80 Ship to Country: Argentina 0-30 Days Past Due: 87,310 31-60 Days Past Due: 218,633 61-90 Days Past Due: 80,000 91-120 Days Past Due: 75,400 >120 Days Past Due: 0 Grand Total: 461,343 Receivables Turnover Ratio: 3.90 Ship to Country: South Africa 0-30 Days Past Due: 188,300 31-60 Days Past Due: 129,344 61-90 Days Past Due: 0 91-120 Days Past Due: 40,900 >120 Days Past Due: 0 Grand Total: 358,544 Receivables Turnover Ratio: 6.90 Ship to Country Congo, Democratic Republic 0-30 Days Past Due 0 31-60 Days Past Due: 120,000 61-90 Days Past Due: 104,009 91-120 Days Past Due: >120 Days Past Due: Grand Total: 224,009 Receivables Turnover Ratio: 3.30 Ship to Country Nigeria 0-30 Days Past Due 0 31-60 Days Past Due: 240,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 240,000 Receivables Turnover Ratio: 5.90 Ship to Country Kenya 0-30 Days Past Due: 41,518 31-60 Days Past Due: 22,000 61.90 Days Past Due: 163,483 91-120 Days Past Due: 0 >120 Days Past Due: 105,000 Grand Total: 332,001 Receivables Turnover Ratio: 3.80 Ship to Country Egypt 0-30 Days Past Due: 387,000 31-60 Days Past Due: 2,030 61.90 Days Past Due: 33,500 91-120 Days Past Due: 0 >120 Days Past Due 0 Grand Total: 422,530 Receivables Turnover Ratio: 7.10 Ship to Country Saudi Arabia 0-30 Days Past Due 587,577 31-60 Days Past Due: 94,000 61.90 Days Past Due: 0 91-120 Days Past Due 0 >120 Days Past Due: 0 Grand Total: 681,577 Receivables Turnover Ratio: 16.10 Ship to Country: Turkey 0-30 Days Past Due: 21,458 31-60 Days Past Due: 10,667 61-90 Days Past Due: 80,565 91-120 Days Past Due: 45,000 >120 Days Past Due: 0 Grand Total: 157,690 Receivables Turnover Ratio: 5.70 Ship to Country: Greece 0-30 Days Past Due: 420,680 31-60 Days Past Due: 15,000 61-90 Days Past Due: 34,000 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 469,680 Receivables Turnover Ratio: 7.70 Ship to Country: Ukraine 0-30 Days Past Due: 408,400 31-60 Days Past Due: 7,000 61.90 Days Past Due: -24,000 91-120 Days Past Due: 32,000 >120 Days Past Due: 0 Grand Total: 423,400 Receivables Turnover Ratio: 4.90 Ship to Country: Hungary 0-30 Days Past Due: 564,925 31-60 Days Past Due: 34,008 61-90 Days Past Due: 0 91-120 Days Past Due: 15,000 >120 Days Past Due: 0 Grand Total: 613,933 Receivables Turnover Ratio: 6.90 Ship to Country United Kingdom 0 30 Days Past Due: 2,258,602 31-60 Days Past Due: 132,300 61-90 Days Past Due: 24,000 91-120 Days Past Due: 0 >120 Days Past Due 0 Grand Total: 2,414,902 Receivables Turnover Ratio: 15.30 Ship to Country: Russian Federation 0-30 Days Past Due: 3,011,509 31-60 Days Past Due: 43,000 61-90 Days Past Due: 35,000 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 3,089,509 Receivables Turnover Ratio: 13.50 Ship to Country: Pakistan 0-30 Days Past Due: 134,855 31-60 Days Past Due: 197,000 61-90 Days Past Due: 120,000 91-120 Days Past Due: 2,088 >120 Days Past Due: 0 Grand Total: 453,943 Receivables Turnover Ratio: 3.30 Ship to Country: Australia 0-30 Days Past Due: 31,900 31-60 Days Past Dues 509,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total 540,900 Receivables Turnover Ratio: 11.20 Company Company 1186 Company 1187 Company 1208 Company 1256 91-120 Days Past Duc 0 15.000 0 0 0 0 0 0 0 61-90 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 0 0 Invoice IN-1235005 IN-1237863 IN-1236006 IN-1237864 IN-1234995 IN-1236009 IN-1237776 IN-1237836 IN-1237845 IN-1237867 IN-1235004 IN-1237862 IN-1236016 IN-1237783 IN-1237843 IN-1237852 IN-1236017 IN-1237784 IN-1237844 IN-1237853 IN-1236018 IN-1237785 0-30 Days 31-60 Days Past Due Past Due 45,009 0 0 6,004 278,003 0 19.002 0 44,118 0 2,096,650 0 120,000 0 0 15,000 92.805 0 5.000 0 300,987 0 34.000 3,008,009 0 3.500 0 0 0 0 13,000 308,000 0 100,400 7.000 0 0 0 0 0 0 0 120.000 Company 1633 >120 Days Grand Past Due Total 0 45,009 21,004 0 278,003 0 19,002 0 44,118 02.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 0 43,000 0 308,000 0 107,400 0 32,000 0 -24.000 0 104,009 0 120,000 D 0 0 0 0 0 0 D Company 1799 Company 1800 35,000 0 0 0 0 -24,000 104,009 D 32.000 0 0 0 Company 1801 91-120 Days Past Due Invoice Company Company 1802 31-60 Days Past Due 0 0 0 0 0 0 0 0 0 0 Company 1803 Company 1804 Company 1805 Company 1806 0-30 Days Past Due 209.400 1,200 11,290.833 0 2,098,600 0 10,900,300 120,000 0 31,900 0 0 300 0 9,000 16,000 15,000 45,000 1.200 1,500 21,000 0 61-90 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 36,881 0 402 0 0 0 IN-1236019 IN-1237786 IN-1236020 IN-1237787 IN-1236021 IN-1237788 IN-1236022 IN-1237789 IN-1236023 IN-1237790 IN-66541 IN-1238226 IN-1238227 IN-1238228 IN-1238229 IN-1238230 IN-1238231 IN-1238232 IN-1238233 IN-1238234 IN-1238235 IN-1238236 0 509,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 >120 Days Grand Past Due Total 0 209,400 0 1,200 0 11,290.833 0 0 0 2,098,600 0 0 0 10,900,300 0 120,000 0 509,000 0 31,900 8.399 8,399 0 36,881 0 300 0 402 0 9,000 0 16,000 0 15,000 0 45,000 0 1,200 0 1,500 0 21,000 0 0 0 0 D Company 2999 Company 3387 Company 3388 Company 3389 Company 3390 Company 3391 Company 3392 Company 3393 Company 3394 Company 3395 Company 3396 Company 3397 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D Company Company 3398 Company 3399 Company 3400 Company 3401 Company 3402 Company 3403 Company 3404 Company 3405 Company 3406 Company 3407 Company 3408 Invoice IN-1238237 IN-1238238 IN-1237858 IN-1237859 IN-1238239 IN-1238240 IN-1238241 IN-1238242 IN-1238243 IN-1238244 IN-1238245 IN-1238246 IN-1237798 IN-1237824 IN-1238247 IN-1237799 IN-1237825 IN-1238248 IN-1237800 IN-1237826 IN-1238249 IN-1237801 0-30 Days Past Duc 0 2.458 23,000 0 9.049 0 0 20,593 55,000 0 398,095 83,000 0 0 28,009 0 0 102,600 0 0 11,900 0 31-60 Days 61-90 Days 91-120 Days Past Due Past Due Past Duc 0 0 3,977 0 0 0 0 0 0 60,000 0 0 0 0 0 0 0 0 3,050 0 0 0 0 0 0 0 0 2,206 0 0 0 0 0 0 0 0 22,000 0 0 0 0 0 0 0 0 22,000 0 0 0 2,300 0 0 0 0 0 0 0 0 23,000 0 0 0 0 0 0 0 >120 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 0 0 105,000 0 0 0 0 0 0 0 0 Grand Total 3,977 2,458 23,000 60,000 9,049 0 3,050 20,593 55,000 2,206 398,095 83.000 22,000 105,000 28,009 22,000 2,300 102,600 0 23,000 11,900 0 Company 3409 Company 3410 Company 3411 0-30 Days 2 Past Due 91120 Days Past Duc 0 0 0 Past Due 0 0 2,009 0 0 0 D D 0 0 0 0 0 D 0 0 0 0 0 0 0 0 Company Invoice Company 3411 IN-1237801 IN-1237827 IN-1238250 Company 3412 IN-1237802 IN-1237828 IN-12.38251 Company 3413 IN-1237803 IN-1237829 IN-1238252 Company 3414 IN-1237804 IN-1237830 IN-1238253 Company 3415 IN-12.17NOS IN-1237831 IN-123254 Company 3416 IN-1237806 IN-1238255 Company 3417 IN-1237807 IN-1 2.38256 Company 3418 IN-1237808 IN-1238257 Company 3419 IN-1237809 IN 1970 31-60 Days 61.90 Days Past Due Past Duc 0 0 0 123,023 0 0 0 0 0 10.667 0 0 0 0 0 28,004 0 0 0 0 0 105,000 0 0 0 0 35,000 0 0 D 0 0 0 0 46.000 0 0 0 164,541 35,000 0 12,040 200,876 0 11.290 22.100 O 0 0 0 50.200 280,566 O 0 0 Total 0 123,023 2,009 0 0 10,667 0 164.541 35,000 28,004 12,040 200,876 105,000 11,290 22,300 35,000 28,900 39,000 20.800 50,200 280,566 46,000 7.00 0 0 0 28.900 39,000 0 0 0 0 0 0 0 0 20,800 0 0 0 D no (0-30 Days 31-60 Days Past Duc Past Duc 14,000 61.90 Days 91-120 Days Past Duc Past Due >120 Days Past Due Grand Total U 0 0 35,000 0 D 0 0 0 12,000 0 75.00 0 0 0 0 0 3.200 0 0 15.000 0 22.000 0 0 0 Company Invoice Company 3420 IN-12310 IN-1238259 Company 3421 IN-1237811 IN-1238260 Company 3422 IN-1237812 IN-12318261 Company 342 IN 1237813 INo1238262 Company 424 IN 1237814 IN-12826) Company 46 IN-126660 Company s200 IN-1200 IN 121861 Company S679 1N123N225 Company s032 IN-12.390.36 Campany song IN-1237761 Company 8034 IN 1217762 Company so18 IN-123776 Company 800 IN 1217764 Company so17 IN121776s Company 1038 IN-1237766 Company so39 IN-1237767 S80) 0 0 32.000 0 0 0 80, 6S 0 0 D 0 14,000 35,000 -12.000 75,400 0 3.200 15,000 S800 22,000 0 32,900 80,565 45,000 49.720 13,669 SO8,000 12,000 19,000 25,000 0 450) 0 0 0 0 13.669 0 308.000 0 0 0 0 0 19.720 0 0 12,000 19.000 25.000 0 16,000 15,000 0 0 0 0 0 0 0 0 0 0 0 16,000 15,000 0 5120 Days Past Duc 0 0 0 Company Company 8040 Company so41 Company 8042 Company 8043 Company 8044 Company 8045 Company 8160 8936 0 0 Invoice IN-1217768 IN1237760 IN-1237770 IN-1237771 IN-1237772 IN-1237773 1N-1237760 IN-124907 IN-1235000 IN-1285001 IN 123601 IN 122 IN 12301) IN 126) IN 125 IN 12316 IN12337 IN-1236038 IN1236) 9 IN-1236) 40 IN-1236041 IN-123-12 Company 912 9913 Company 2014 Company 9915 Company 2016 Company 9917 Company 2018 Company 9919 Company 9920) Company 9921 9922 Company 9021 Company 924 (0-30 Days 31-60 Days 6100 Days 9-120 Days Past Due Past Due Past Due Past Due 45,000 0 0 1.200 0 0 1,500 0 0 0 21.000 0 0 0 0 0 0 56.000 0 0 0 44.434 0 0 43.928 0 0 D 126,400 0 0 113.891 0 0 0 12.00 0 0 112,000 0 300,150 0 So), 221 0 0 188) 12914 0 40.900 411,000 0 0 0 399 400 0 0 0 200,800 0 0 D 306,000 0 0 0 268,904) 0 0 209,100 0 280,93 0 0 0 0 0 0 0 0 0 Grand Total 45,000 1.200 1.500 21.000 0 56,000 44.434 43.928 126.400 113,891 12.000 412,000 190,350 500,223 358,544 433,000 399 400 200,800 306,000 208,900 209,300 280,93 0 0 0 0 0 61-00 Days Past Duc 91-120 Days Past Due >120 Days Past Due 0 0 0 180,300 0 0 0 0 0 0 D 123,000 0 Company Invoice sk Company 9925 IN-1236043 Company 9926 IN-12360-44 Company 9927 IN-1 2.16045 Company 9928 IN-1236046 Company 9929 IN-1216047 Company 11561 IN-1236030 IN-1237797 IN-1237823 IN-1237881 Company 11644 IN-1236008 IN-1237775 IN-1237866 Company 11860 IN 12:36024 IN-1237791 Company 11861 IN-1236025 IN-1237792 IN-1237876 Company 12441 IN-1234996 Company 12678 IN.1234998 Company 12862 IN-1236826 IN-1237793 IN-1237877 0-30 Days 31-60 Days Past Duc Past Due 320,900 0 190.550 0 1.204,050 0 0 0 208,000 0 280,500 D 0 12,000 D 0 23,000 ( 44.900 0 200 0 109,300 0 0 O 209.060 0 0 305,000 D 44,097 13.745 0 209,000 0 35,000 66,400 0 0 0 0 0 0 0 Grand Total 320,900 190.550 1,204,050 180,300 208,000 280.500 12,000 123,000 23,000 44,900 43,000 200 146,300 19,440 209,060 0 305.000 44,097 43,745 209,000 35,000 66,400 0 0 0 0 0 0 0 0 0 0 0 43.000 0 37,000 0 0 19,440 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Grand Total 175.492 >120 Days Past Due 0 0 0 0 0 27.900 0 0 0 0 0 Company Invoice Company 13065 IN-1234999 Company 13557 IN-1236010 IN-1237777 IN-1237837 IN-1237846 IN1237868 Company 13558 IN-1236011 IN-1237778 IN-1237838 IN-1237847 IN-1237869 Company 13559 IN-1236012 IN-1237779 IN.12.1739 IN-12.378-48 IN-1237870 Company 13560 IN-1236013 IN.12.17780 IN-12378-40 IN-1237849 IN-1237871 Company 13561 IN-1236014 0-30 Days 31-60 Days 61-90 Days 91-120 Days Past Die Past Due Past Duc Past Duc 12.009 0 163,483 27.900 0 0 0 0 0 120,000 0 0 120,000 0 0 0 31.000 0 0 3,055 0 0 0 16.690 0 0 32.010 0 0 0 0 120.000 0 0 284,493 0 0 0 180.000 0 205.633 0 0 55.300 0 32.010 0 0 0 80,000 0 O 25.000 33,500 0 0 120,000 0 0 0 d 14.000 0 0 0 0 0 50.200 0 438,880 0 0 0 0 0 0 120.000 120,000 31,000 3,055 16,690 32,010 120,000 284,493 180,000 205,633 55,100 32,010 80,000 25,000 33.500 120.000 14,000 303,400 50,200 438,880 0 0 0 0 . 0-30 Days 31.60 Days Pas Due Past Duc 438.880 0 24,000 >120 Days Past Due 0 0 0 0 0 0 2008 305,000 12.000 0 15.660 190,000 0 Company Invoice Company 13561 IN-1236014 IN-1217781 IN-1217841 IN-1237850 IN-1237872 Company 13562 IN-1236015 IN-1237782 IN.12.27842 IN-1217851 IN-1237873 Company 13776 IN-12.15002 IN. 1237860 Company 14229 IN-1236007 IN-1237774 IN-1237865 Company 14558 IN 1236027 IN-1237794 IN-123787 Company 15559 IN-1236028 IN-1237795 IN-1237821 IN-1237879 C.14733 61-90 Days 91-120 Days Past Duc Past Du 0 0 0 - 12.000 0 0 0 46,000 0 0 D 0 0 0 D 0 0 0 0 106,500 0 0 0 0 0 0 24,900 0 0 D 0 0 0 0 13 0 0 0 0 0 0 0 0 0 0 0 Grand Total 438.880 -24,000 -12.000 0 46,000 305,000 12,000 23.008 15,660 190,000 106,500 12,700 12,900 24.900 1.200 460.800 0 35,000 90,500 12,500 0 402,900 12,700 . 0 1.200 12.900 0 0 460.800 0 35,000 90.500 0 0 0 D 0 12.500 0 0 0 0 0 0 0 0 102.900 11 DET 0 0 0 0 15 100 0 0 0 0 D 0 0 0 0 0 0 0 0 7,733 44.90 150,000 0 45,000 250,00 44,106 0 22.793 230,000 0 0 0 0 22.900 0 0 0 0 0 11 0 3.000 1.100 190,000 0 Company 16332 IN 98552 Company 17300 IN-1234993 Company 17560 IN-12:36029 IN.1237796 IN-1217822 IN-123780 Company 17796 IN-1234994 Company 17932 IN-1236050 Company 17933 IN-1236051 Company 17934 IN 1216053 Company 17935 IN.1216053 Company 17936 IN.1236054 Company 17937 IN-1236055 Company 17938 IN-1236056 Company 17999 IN-1236057 Company 17940 IN-123605 Company 17941 IN.12.2059 Company 17942 IN 1216060 Company 17943 IN-1236061 Company 17944 IN-1236062 Company 17945 IN-1216063 Company 17946 IN-1236064 6 0 2.58.800 0 700 D 0 0 0 7,733 44.390 450,000 15.300 45,000 250.300 44.306 22,900 27,093 238,000 2,178 190,000 250,00 240,000 40,900 66,400 35.000 422.330 159.444 21,200 250,900 24.088 0 0 0 4,300 0 0 0 0 0 0 16,400 0 13.500 0 18,000 250,000 0 0 0 240,000 12.000 0 0 . 15,000 187.000 0 0 0 0 2030 159.00 3,200 0 ON oble ou >120 Days Past Doc 0 0 0 0 12000 0 0 0 0 Company Invoice Company 17947 IN-1236065 Company 17945 IN-1236066 Company 17949 IN-1236067 Company 17950 IN-123606 Company 19930 IN-123614% IN.12.17315 IN 1238261 Company 19931 IN-12.049 IN-1237816 IN 12265 Company 19931 IN1237817 IN-1237874 IN.1237882 IN-121266 Company 19933 IN 1217NIN IN-1237875 IN-1218267 Company 19934 IN-1237819 IN-1228268 Company 19915 IN-1237820 IN-123209 Company 19936 IN 1208270 10017 IN.173771 0-30 Days 31-60 Days 61.90 Days 91-120 Days Last Duc Past Due Past Duc Past Due 500 15,000 500 25.000 109.000 0 305,000 D 0 0 450,00 0 20,000 61.090 0 0 30,000 D D 23.000 D 14.00 B 78.400 0 0 0 1.500 150,00 0 0 250.000 120.990 0 0 0 10.000 0 12,300 4.600 0 17,000 0 1.100 0 0 160,74 0 27.000 18,000 D 74.211 0 0 0 0 0 32,000 0 0 Grand Total 15,500 134,503 305.000 450,700 1,990 80,900 12,000 23,000 14,800 78.440 1,500 250,800 250,900 120.990 32,000 240,000 12.300 4,600 17,000 1.300 187,874 112,211 CI 0 0 0 0 >120 Days Past Duc 0 0 0 0 0 0 Company Invoice Company 19937 IN-1238271 Company 19938 IN-1238272 Company 19939 IN-1238273 Company 19940 IN 1218274 Company 19941 IN 1238275 Company 19942 IN 1238276 Company 19943 IN-1238277 Company 19944 IN 1238278 Company 19945 IN 1238279 Company 19946 IN.1238280 Company 19947 IN-1238281 Company 1994 IN1218282 Company 19949 IN12323 Company 19950 IN 1238284 Company 19951 IN-121285 Company 19952 IN 121286 Company 19953 IN 1238287 Company 19954 IN-1238288 Company 19955 IN 1238289 Company 19956 IN-1238290 Company 19957 IN-1238291 Company 19958 IN.1218292 0-30 Days 31-60 Days 61.90 Days 91-120 Days Past Duc Past Doc Past Due Past Duc 50,500 0 0 6.500 2.900 10.900 0 0 130,000 0 0 50.700 0 27,000 3.009 19.000 14.000 0 1,200 28.000 . 0 30,000 0 107.000 0 55.900 0 0 120.000 0 O 28,000 0 120.900 0 0 101,900 0 0 0 0 109,400 0 $5,002 0 0 0 109.000 0 0 12,000 0 0 0 12.900 0 0 9,000 Grand Total 80.500 9.400 10,900 130,000 50,700 30,009 51,700 28,000 30,000 307,000 55.900 120,000 28,000 120,900 103.900 20.555 109,400 55,002 109,000 12,000 12.900 9,000 0 0 0 0 20.555 0 0 O 0 91-120 Days Past Duo 120 Days Past Due 0-30 Days 31-60 Days 61.90 Days Past Due Past Duc Past Duc 3.100 0 0 0 Grand Total 3.100 0 0 0 0 800 1,100 0 0 12.00 0 0 0 0 0 2,100 0 12.800 44,005 45.800 0 1,200 5.400 0 0 0 45,800 0 Company Invoice Company 19959 IN-1238293 Company 19960 IN 1238294 Company 19961 IN-1218295 Company 19962 IN-123296 Company 19963 IN 1238297 Company 19964 IN123529 Company 1995 IN 1238209 Company 19966 IN-1218300 Company 19967 IN-1238301 Company 19968 IN 1238302 Company 19969 IN1238301 Company 19970 IN 12 Company 19971 IN 1238305 Company 19972 IN 1218300 Company 22501 IN-985551 Company 44152 IN 12370 Company 44153 IN 1237813 IN-124 IN 127856 Company 44154 IN 121754 IN1217 IN-1237857 0 0 0 D 1.200 0 0 0 5.400 0 0 0 0 1.30 12,700 0 0 5 0 0 55.300 0 0 14,080 16,000 55.00 12,000 77,000 120.000 3.500 150.000 0 0 12.000 . 0 3.500 150.000 0 120.000 0-30 Days 31-60 Days Past Due 61-90 Days Past Due 91-120 Days Past Duc Grand Total Past Due 0 800 0 1,300 0 0 0 45.800 0 0 0 0 0 0 0 0 1.200 >120 Days Past Due 0 0 0 12.800 0 0 0 0 0 Company Invoice El ru Company 19961 IN-1238295 Company 19962 IN-1238296 Company 19963 IN-1238297 Company 19964 IN-1238298 Company 19965 IN-1238299 Company 19966 IN-1238300 Company 19967 IN-1238301 Company 19968 IN-1238302 Company 19969 IN-1238303 Company 19970 IN-1238304 Company 19971 IN-1238305 Company 19972 IN-1238306 Company 22501 IN-985551 Company 44152 IN-1237832 Company 44153 IN-1237833 IN-1237854 IN-1237856 Company 44154 IN-1237834 IN-1237855 IN-1237857 Company 44155 IN. 1237835 Company 97551 In-1267221 0 0 0 0 0 0 0 0 5.400 0 0 0 0 0 0 0 0 44,005 0 0 0 0 0 0 0 12.700 16.900 55.300 0 77,000 120,000 0 0 0 0 0 1,380 0 0 0 0 0 0 0 0 0 0 0 0 0 12,000 0 0 3.500 150,000 0 0 0 2.100 0 12,800 44,005 45,800 0 1,200 5.400 0 0 0 14,080 16,900 55,300 12,000 77,000 120,000 3,500 150,000 105,000 35,988 0 0 0 0 0 0 0 0 0 0 105,000 35,988 0 0 0 0 0 0 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 turnover 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: 25 50 101 150 200 0-30 days 31-60 days 61-90 days 91-120 days >120 days Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea 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 Receivables Turnover R AR by Country 0.00 16.30 Ship to Country: Canada 0-30 Days Past Due: 11,020,300 31-60 Days Past Due: 0 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 11,020,300 Receivables Turnover Ratio: 10.40 Ship to Country United States 0-30 Days Past Due: 11,400,233 31-60 Days Past Due: 245,900 61-90 Days Past Due. 153,500 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 11,799,633 Receivables Turnover Ratio: 16.30 Ship to Country Mexico 0-30 Days Past Due 275,400 31-60 Days Past Due: 35,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 310,400 Receivables Turnover Ratio: 8.60 Ship to Country: Guatemala 0-30 Days Past Due: 0 31-60 Days Past Due: 190,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 190,000 Receivables Turnover Ratio: 6.10 Ship to Country: Honduras 0-30 Days Past Due 0 31-60 Days Past Due: 240,000 61.90 Days Past Due: 12,300 91-120 Days Past Due: 0 >120 Days Past Due: 32,000 Grand Total: 284,300 Receivables Turnover Ratio: 3.30 Ship to Country: Colombia 0-30 Days Past Due: 0 31-60 Days Past Due: 0 61-90 Days Past Due: 180,300 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 180,300 Receivables Turnover Ratio: 4.80 Ship to Country: Venezuela 0-30 Days Past Due: 0 31-60 Days Past Due: 0 61-90 Days Past Due: 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 0 Receivables Turnover Ratio: 7.80 Ship to Country: Ecuador 0-30 Days Past Due: 48,700 31-60 Days Past Due: 418,493 61-90 Days Past Due: 35,000 91-120 Days Past Due: 180,000 >120 Days Past Due: 20,555 Grand Total: 702,748 Receivables Turnover Ratio: 5.20 Ship to Country: Peru 0-30 Days Past Due: 28,200 31-60 Days Past Due: 44,900 61-90 Days Past Due: 43,000 91-120 Days Past Due: 39,000 >120 Days Past Due: 20,800 Grand Total: 175,900 Receivables Turnover Ratio: 3.20 Ship to Country: Brazil 0-30 Days Past Due: 0 31-60 Days Past Due: 12,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 12,000 Receivables Turnover Ratio: 5.80 Ship to Country: Brazil 0-30 Days Past Due: 0 31-60 Days Past Due: 12,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 12,000 Receivables Turnover Ratio: 5.80 Ship to Country: Argentina 0-30 Days Past Due: 87,310 31-60 Days Past Due: 218,633 61-90 Days Past Due: 80,000 91-120 Days Past Due: 75,400 >120 Days Past Due: 0 Grand Total: 461,343 Receivables Turnover Ratio: 3.90 Ship to Country: South Africa 0-30 Days Past Due: 188,300 31-60 Days Past Due: 129,344 61-90 Days Past Due: 0 91-120 Days Past Due: 40,900 >120 Days Past Due: 0 Grand Total: 358,544 Receivables Turnover Ratio: 6.90 Ship to Country Congo, Democratic Republic 0-30 Days Past Due 0 31-60 Days Past Due: 120,000 61-90 Days Past Due: 104,009 91-120 Days Past Due: >120 Days Past Due: Grand Total: 224,009 Receivables Turnover Ratio: 3.30 Ship to Country Nigeria 0-30 Days Past Due 0 31-60 Days Past Due: 240,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 240,000 Receivables Turnover Ratio: 5.90 Ship to Country Kenya 0-30 Days Past Due: 41,518 31-60 Days Past Due: 22,000 61.90 Days Past Due: 163,483 91-120 Days Past Due: 0 >120 Days Past Due: 105,000 Grand Total: 332,001 Receivables Turnover Ratio: 3.80 Ship to Country Egypt 0-30 Days Past Due: 387,000 31-60 Days Past Due: 2,030 61.90 Days Past Due: 33,500 91-120 Days Past Due: 0 >120 Days Past Due 0 Grand Total: 422,530 Receivables Turnover Ratio: 7.10 Ship to Country Saudi Arabia 0-30 Days Past Due 587,577 31-60 Days Past Due: 94,000 61.90 Days Past Due: 0 91-120 Days Past Due 0 >120 Days Past Due: 0 Grand Total: 681,577 Receivables Turnover Ratio: 16.10 Ship to Country: Turkey 0-30 Days Past Due: 21,458 31-60 Days Past Due: 10,667 61-90 Days Past Due: 80,565 91-120 Days Past Due: 45,000 >120 Days Past Due: 0 Grand Total: 157,690 Receivables Turnover Ratio: 5.70 Ship to Country: Greece 0-30 Days Past Due: 420,680 31-60 Days Past Due: 15,000 61-90 Days Past Due: 34,000 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 469,680 Receivables Turnover Ratio: 7.70 Ship to Country: Ukraine 0-30 Days Past Due: 408,400 31-60 Days Past Due: 7,000 61.90 Days Past Due: -24,000 91-120 Days Past Due: 32,000 >120 Days Past Due: 0 Grand Total: 423,400 Receivables Turnover Ratio: 4.90 Ship to Country: Hungary 0-30 Days Past Due: 564,925 31-60 Days Past Due: 34,008 61-90 Days Past Due: 0 91-120 Days Past Due: 15,000 >120 Days Past Due: 0 Grand Total: 613,933 Receivables Turnover Ratio: 6.90 Ship to Country United Kingdom 0 30 Days Past Due: 2,258,602 31-60 Days Past Due: 132,300 61-90 Days Past Due: 24,000 91-120 Days Past Due: 0 >120 Days Past Due 0 Grand Total: 2,414,902 Receivables Turnover Ratio: 15.30 Ship to Country: Russian Federation 0-30 Days Past Due: 3,011,509 31-60 Days Past Due: 43,000 61-90 Days Past Due: 35,000 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total: 3,089,509 Receivables Turnover Ratio: 13.50 Ship to Country: Pakistan 0-30 Days Past Due: 134,855 31-60 Days Past Due: 197,000 61-90 Days Past Due: 120,000 91-120 Days Past Due: 2,088 >120 Days Past Due: 0 Grand Total: 453,943 Receivables Turnover Ratio: 3.30 Ship to Country: Australia 0-30 Days Past Due: 31,900 31-60 Days Past Dues 509,000 61-90 Days Past Due: 0 91-120 Days Past Due: 0 >120 Days Past Due: 0 Grand Total 540,900 Receivables Turnover Ratio: 11.20 Company Company 1186 Company 1187 Company 1208 Company 1256 91-120 Days Past Duc 0 15.000 0 0 0 0 0 0 0 61-90 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 0 0 Invoice IN-1235005 IN-1237863 IN-1236006 IN-1237864 IN-1234995 IN-1236009 IN-1237776 IN-1237836 IN-1237845 IN-1237867 IN-1235004 IN-1237862 IN-1236016 IN-1237783 IN-1237843 IN-1237852 IN-1236017 IN-1237784 IN-1237844 IN-1237853 IN-1236018 IN-1237785 0-30 Days 31-60 Days Past Due Past Due 45,009 0 0 6,004 278,003 0 19.002 0 44,118 0 2,096,650 0 120,000 0 0 15,000 92.805 0 5.000 0 300,987 0 34.000 3,008,009 0 3.500 0 0 0 0 13,000 308,000 0 100,400 7.000 0 0 0 0 0 0 0 120.000 Company 1633 >120 Days Grand Past Due Total 0 45,009 21,004 0 278,003 0 19,002 0 44,118 02.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 0 43,000 0 308,000 0 107,400 0 32,000 0 -24.000 0 104,009 0 120,000 D 0 0 0 0 0 0 D Company 1799 Company 1800 35,000 0 0 0 0 -24,000 104,009 D 32.000 0 0 0 Company 1801 91-120 Days Past Due Invoice Company Company 1802 31-60 Days Past Due 0 0 0 0 0 0 0 0 0 0 Company 1803 Company 1804 Company 1805 Company 1806 0-30 Days Past Due 209.400 1,200 11,290.833 0 2,098,600 0 10,900,300 120,000 0 31,900 0 0 300 0 9,000 16,000 15,000 45,000 1.200 1,500 21,000 0 61-90 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 36,881 0 402 0 0 0 IN-1236019 IN-1237786 IN-1236020 IN-1237787 IN-1236021 IN-1237788 IN-1236022 IN-1237789 IN-1236023 IN-1237790 IN-66541 IN-1238226 IN-1238227 IN-1238228 IN-1238229 IN-1238230 IN-1238231 IN-1238232 IN-1238233 IN-1238234 IN-1238235 IN-1238236 0 509,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 >120 Days Grand Past Due Total 0 209,400 0 1,200 0 11,290.833 0 0 0 2,098,600 0 0 0 10,900,300 0 120,000 0 509,000 0 31,900 8.399 8,399 0 36,881 0 300 0 402 0 9,000 0 16,000 0 15,000 0 45,000 0 1,200 0 1,500 0 21,000 0 0 0 0 D Company 2999 Company 3387 Company 3388 Company 3389 Company 3390 Company 3391 Company 3392 Company 3393 Company 3394 Company 3395 Company 3396 Company 3397 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 D Company Company 3398 Company 3399 Company 3400 Company 3401 Company 3402 Company 3403 Company 3404 Company 3405 Company 3406 Company 3407 Company 3408 Invoice IN-1238237 IN-1238238 IN-1237858 IN-1237859 IN-1238239 IN-1238240 IN-1238241 IN-1238242 IN-1238243 IN-1238244 IN-1238245 IN-1238246 IN-1237798 IN-1237824 IN-1238247 IN-1237799 IN-1237825 IN-1238248 IN-1237800 IN-1237826 IN-1238249 IN-1237801 0-30 Days Past Duc 0 2.458 23,000 0 9.049 0 0 20,593 55,000 0 398,095 83,000 0 0 28,009 0 0 102,600 0 0 11,900 0 31-60 Days 61-90 Days 91-120 Days Past Due Past Due Past Duc 0 0 3,977 0 0 0 0 0 0 60,000 0 0 0 0 0 0 0 0 3,050 0 0 0 0 0 0 0 0 2,206 0 0 0 0 0 0 0 0 22,000 0 0 0 0 0 0 0 0 22,000 0 0 0 2,300 0 0 0 0 0 0 0 0 23,000 0 0 0 0 0 0 0 >120 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 0 0 105,000 0 0 0 0 0 0 0 0 Grand Total 3,977 2,458 23,000 60,000 9,049 0 3,050 20,593 55,000 2,206 398,095 83.000 22,000 105,000 28,009 22,000 2,300 102,600 0 23,000 11,900 0 Company 3409 Company 3410 Company 3411 0-30 Days 2 Past Due 91120 Days Past Duc 0 0 0 Past Due 0 0 2,009 0 0 0 D D 0 0 0 0 0 D 0 0 0 0 0 0 0 0 Company Invoice Company 3411 IN-1237801 IN-1237827 IN-1238250 Company 3412 IN-1237802 IN-1237828 IN-12.38251 Company 3413 IN-1237803 IN-1237829 IN-1238252 Company 3414 IN-1237804 IN-1237830 IN-1238253 Company 3415 IN-12.17NOS IN-1237831 IN-123254 Company 3416 IN-1237806 IN-1238255 Company 3417 IN-1237807 IN-1 2.38256 Company 3418 IN-1237808 IN-1238257 Company 3419 IN-1237809 IN 1970 31-60 Days 61.90 Days Past Due Past Duc 0 0 0 123,023 0 0 0 0 0 10.667 0 0 0 0 0 28,004 0 0 0 0 0 105,000 0 0 0 0 35,000 0 0 D 0 0 0 0 46.000 0 0 0 164,541 35,000 0 12,040 200,876 0 11.290 22.100 O 0 0 0 50.200 280,566 O 0 0 Total 0 123,023 2,009 0 0 10,667 0 164.541 35,000 28,004 12,040 200,876 105,000 11,290 22,300 35,000 28,900 39,000 20.800 50,200 280,566 46,000 7.00 0 0 0 28.900 39,000 0 0 0 0 0 0 0 0 20,800 0 0 0 D no (0-30 Days 31-60 Days Past Duc Past Duc 14,000 61.90 Days 91-120 Days Past Duc Past Due >120 Days Past Due Grand Total U 0 0 35,000 0 D 0 0 0 12,000 0 75.00 0 0 0 0 0 3.200 0 0 15.000 0 22.000 0 0 0 Company Invoice Company 3420 IN-12310 IN-1238259 Company 3421 IN-1237811 IN-1238260 Company 3422 IN-1237812 IN-12318261 Company 342 IN 1237813 INo1238262 Company 424 IN 1237814 IN-12826) Company 46 IN-126660 Company s200 IN-1200 IN 121861 Company S679 1N123N225 Company s032 IN-12.390.36 Campany song IN-1237761 Company 8034 IN 1217762 Company so18 IN-123776 Company 800 IN 1217764 Company so17 IN121776s Company 1038 IN-1237766 Company so39 IN-1237767 S80) 0 0 32.000 0 0 0 80, 6S 0 0 D 0 14,000 35,000 -12.000 75,400 0 3.200 15,000 S800 22,000 0 32,900 80,565 45,000 49.720 13,669 SO8,000 12,000 19,000 25,000 0 450) 0 0 0 0 13.669 0 308.000 0 0 0 0 0 19.720 0 0 12,000 19.000 25.000 0 16,000 15,000 0 0 0 0 0 0 0 0 0 0 0 16,000 15,000 0 5120 Days Past Duc 0 0 0 Company Company 8040 Company so41 Company 8042 Company 8043 Company 8044 Company 8045 Company 8160 8936 0 0 Invoice IN-1217768 IN1237760 IN-1237770 IN-1237771 IN-1237772 IN-1237773 1N-1237760 IN-124907 IN-1235000 IN-1285001 IN 123601 IN 122 IN 12301) IN 126) IN 125 IN 12316 IN12337 IN-1236038 IN1236) 9 IN-1236) 40 IN-1236041 IN-123-12 Company 912 9913 Company 2014 Company 9915 Company 2016 Company 9917 Company 2018 Company 9919 Company 9920) Company 9921 9922 Company 9021 Company 924 (0-30 Days 31-60 Days 6100 Days 9-120 Days Past Due Past Due Past Due Past Due 45,000 0 0 1.200 0 0 1,500 0 0 0 21.000 0 0 0 0 0 0 56.000 0 0 0 44.434 0 0 43.928 0 0 D 126,400 0 0 113.891 0 0 0 12.00 0 0 112,000 0 300,150 0 So), 221 0 0 188) 12914 0 40.900 411,000 0 0 0 399 400 0 0 0 200,800 0 0 D 306,000 0 0 0 268,904) 0 0 209,100 0 280,93 0 0 0 0 0 0 0 0 0 Grand Total 45,000 1.200 1.500 21.000 0 56,000 44.434 43.928 126.400 113,891 12.000 412,000 190,350 500,223 358,544 433,000 399 400 200,800 306,000 208,900 209,300 280,93 0 0 0 0 0 61-00 Days Past Duc 91-120 Days Past Due >120 Days Past Due 0 0 0 180,300 0 0 0 0 0 0 D 123,000 0 Company Invoice sk Company 9925 IN-1236043 Company 9926 IN-12360-44 Company 9927 IN-1 2.16045 Company 9928 IN-1236046 Company 9929 IN-1216047 Company 11561 IN-1236030 IN-1237797 IN-1237823 IN-1237881 Company 11644 IN-1236008 IN-1237775 IN-1237866 Company 11860 IN 12:36024 IN-1237791 Company 11861 IN-1236025 IN-1237792 IN-1237876 Company 12441 IN-1234996 Company 12678 IN.1234998 Company 12862 IN-1236826 IN-1237793 IN-1237877 0-30 Days 31-60 Days Past Duc Past Due 320,900 0 190.550 0 1.204,050 0 0 0 208,000 0 280,500 D 0 12,000 D 0 23,000 ( 44.900 0 200 0 109,300 0 0 O 209.060 0 0 305,000 D 44,097 13.745 0 209,000 0 35,000 66,400 0 0 0 0 0 0 0 Grand Total 320,900 190.550 1,204,050 180,300 208,000 280.500 12,000 123,000 23,000 44,900 43,000 200 146,300 19,440 209,060 0 305.000 44,097 43,745 209,000 35,000 66,400 0 0 0 0 0 0 0 0 0 0 0 43.000 0 37,000 0 0 19,440 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Grand Total 175.492 >120 Days Past Due 0 0 0 0 0 27.900 0 0 0 0 0 Company Invoice Company 13065 IN-1234999 Company 13557 IN-1236010 IN-1237777 IN-1237837 IN-1237846 IN1237868 Company 13558 IN-1236011 IN-1237778 IN-1237838 IN-1237847 IN-1237869 Company 13559 IN-1236012 IN-1237779 IN.12.1739 IN-12.378-48 IN-1237870 Company 13560 IN-1236013 IN.12.17780 IN-12378-40 IN-1237849 IN-1237871 Company 13561 IN-1236014 0-30 Days 31-60 Days 61-90 Days 91-120 Days Past Die Past Due Past Duc Past Duc 12.009 0 163,483 27.900 0 0 0 0 0 120,000 0 0 120,000 0 0 0 31.000 0 0 3,055 0 0 0 16.690 0 0 32.010 0 0 0 0 120.000 0 0 284,493 0 0 0 180.000 0 205.633 0 0 55.300 0 32.010 0 0 0 80,000 0 O 25.000 33,500 0 0 120,000 0 0 0 d 14.000 0 0 0 0 0 50.200 0 438,880 0 0 0 0 0 0 120.000 120,000 31,000 3,055 16,690 32,010 120,000 284,493 180,000 205,633 55,100 32,010 80,000 25,000 33.500 120.000 14,000 303,400 50,200 438,880 0 0 0 0 . 0-30 Days 31.60 Days Pas Due Past Duc 438.880 0 24,000 >120 Days Past Due 0 0 0 0 0 0 2008 305,000 12.000 0 15.660 190,000 0 Company Invoice Company 13561 IN-1236014 IN-1217781 IN-1217841 IN-1237850 IN-1237872 Company 13562 IN-1236015 IN-1237782 IN.12.27842 IN-1217851 IN-1237873 Company 13776 IN-12.15002 IN. 1237860 Company 14229 IN-1236007 IN-1237774 IN-1237865 Company 14558 IN 1236027 IN-1237794 IN-123787 Company 15559 IN-1236028 IN-1237795 IN-1237821 IN-1237879 C.14733 61-90 Days 91-120 Days Past Duc Past Du 0 0 0 - 12.000 0 0 0 46,000 0 0 D 0 0 0 D 0 0 0 0 106,500 0 0 0 0 0 0 24,900 0 0 D 0 0 0 0 13 0 0 0 0 0 0 0 0 0 0 0 Grand Total 438.880 -24,000 -12.000 0 46,000 305,000 12,000 23.008 15,660 190,000 106,500 12,700 12,900 24.900 1.200 460.800 0 35,000 90,500 12,500 0 402,900 12,700 . 0 1.200 12.900 0 0 460.800 0 35,000 90.500 0 0 0 D 0 12.500 0 0 0 0 0 0 0 0 102.900 11 DET 0 0 0 0 15 100 0 0 0 0 D 0 0 0 0 0 0 0 0 7,733 44.90 150,000 0 45,000 250,00 44,106 0 22.793 230,000 0 0 0 0 22.900 0 0 0 0 0 11 0 3.000 1.100 190,000 0 Company 16332 IN 98552 Company 17300 IN-1234993 Company 17560 IN-12:36029 IN.1237796 IN-1217822 IN-123780 Company 17796 IN-1234994 Company 17932 IN-1236050 Company 17933 IN-1236051 Company 17934 IN 1216053 Company 17935 IN.1216053 Company 17936 IN.1236054 Company 17937 IN-1236055 Company 17938 IN-1236056 Company 17999 IN-1236057 Company 17940 IN-123605 Company 17941 IN.12.2059 Company 17942 IN 1216060 Company 17943 IN-1236061 Company 17944 IN-1236062 Company 17945 IN-1216063 Company 17946 IN-1236064 6 0 2.58.800 0 700 D 0 0 0 7,733 44.390 450,000 15.300 45,000 250.300 44.306 22,900 27,093 238,000 2,178 190,000 250,00 240,000 40,900 66,400 35.000 422.330 159.444 21,200 250,900 24.088 0 0 0 4,300 0 0 0 0 0 0 16,400 0 13.500 0 18,000 250,000 0 0 0 240,000 12.000 0 0 . 15,000 187.000 0 0 0 0 2030 159.00 3,200 0 ON oble ou >120 Days Past Doc 0 0 0 0 12000 0 0 0 0 Company Invoice Company 17947 IN-1236065 Company 17945 IN-1236066 Company 17949 IN-1236067 Company 17950 IN-123606 Company 19930 IN-123614% IN.12.17315 IN 1238261 Company 19931 IN-12.049 IN-1237816 IN 12265 Company 19931 IN1237817 IN-1237874 IN.1237882 IN-121266 Company 19933 IN 1217NIN IN-1237875 IN-1218267 Company 19934 IN-1237819 IN-1228268 Company 19915 IN-1237820 IN-123209 Company 19936 IN 1208270 10017 IN.173771 0-30 Days 31-60 Days 61.90 Days 91-120 Days Last Duc Past Due Past Duc Past Due 500 15,000 500 25.000 109.000 0 305,000 D 0 0 450,00 0 20,000 61.090 0 0 30,000 D D 23.000 D 14.00 B 78.400 0 0 0 1.500 150,00 0 0 250.000 120.990 0 0 0 10.000 0 12,300 4.600 0 17,000 0 1.100 0 0 160,74 0 27.000 18,000 D 74.211 0 0 0 0 0 32,000 0 0 Grand Total 15,500 134,503 305.000 450,700 1,990 80,900 12,000 23,000 14,800 78.440 1,500 250,800 250,900 120.990 32,000 240,000 12.300 4,600 17,000 1.300 187,874 112,211 CI 0 0 0 0 >120 Days Past Duc 0 0 0 0 0 0 Company Invoice Company 19937 IN-1238271 Company 19938 IN-1238272 Company 19939 IN-1238273 Company 19940 IN 1218274 Company 19941 IN 1238275 Company 19942 IN 1238276 Company 19943 IN-1238277 Company 19944 IN 1238278 Company 19945 IN 1238279 Company 19946 IN.1238280 Company 19947 IN-1238281 Company 1994 IN1218282 Company 19949 IN12323 Company 19950 IN 1238284 Company 19951 IN-121285 Company 19952 IN 121286 Company 19953 IN 1238287 Company 19954 IN-1238288 Company 19955 IN 1238289 Company 19956 IN-1238290 Company 19957 IN-1238291 Company 19958 IN.1218292 0-30 Days 31-60 Days 61.90 Days 91-120 Days Past Duc Past Doc Past Due Past Duc 50,500 0 0 6.500 2.900 10.900 0 0 130,000 0 0 50.700 0 27,000 3.009 19.000 14.000 0 1,200 28.000 . 0 30,000 0 107.000 0 55.900 0 0 120.000 0 O 28,000 0 120.900 0 0 101,900 0 0 0 0 109,400 0 $5,002 0 0 0 109.000 0 0 12,000 0 0 0 12.900 0 0 9,000 Grand Total 80.500 9.400 10,900 130,000 50,700 30,009 51,700 28,000 30,000 307,000 55.900 120,000 28,000 120,900 103.900 20.555 109,400 55,002 109,000 12,000 12.900 9,000 0 0 0 0 20.555 0 0 O 0 91-120 Days Past Duo 120 Days Past Due 0-30 Days 31-60 Days 61.90 Days Past Due Past Duc Past Duc 3.100 0 0 0 Grand Total 3.100 0 0 0 0 800 1,100 0 0 12.00 0 0 0 0 0 2,100 0 12.800 44,005 45.800 0 1,200 5.400 0 0 0 45,800 0 Company Invoice Company 19959 IN-1238293 Company 19960 IN 1238294 Company 19961 IN-1218295 Company 19962 IN-123296 Company 19963 IN 1238297 Company 19964 IN123529 Company 1995 IN 1238209 Company 19966 IN-1218300 Company 19967 IN-1238301 Company 19968 IN 1238302 Company 19969 IN1238301 Company 19970 IN 12 Company 19971 IN 1238305 Company 19972 IN 1218300 Company 22501 IN-985551 Company 44152 IN 12370 Company 44153 IN 1237813 IN-124 IN 127856 Company 44154 IN 121754 IN1217 IN-1237857 0 0 0 D 1.200 0 0 0 5.400 0 0 0 0 1.30 12,700 0 0 5 0 0 55.300 0 0 14,080 16,000 55.00 12,000 77,000 120.000 3.500 150.000 0 0 12.000 . 0 3.500 150.000 0 120.000 0-30 Days 31-60 Days Past Due 61-90 Days Past Due 91-120 Days Past Duc Grand Total Past Due 0 800 0 1,300 0 0 0 45.800 0 0 0 0 0 0 0 0 1.200 >120 Days Past Due 0 0 0 12.800 0 0 0 0 0 Company Invoice El ru Company 19961 IN-1238295 Company 19962 IN-1238296 Company 19963 IN-1238297 Company 19964 IN-1238298 Company 19965 IN-1238299 Company 19966 IN-1238300 Company 19967 IN-1238301 Company 19968 IN-1238302 Company 19969 IN-1238303 Company 19970 IN-1238304 Company 19971 IN-1238305 Company 19972 IN-1238306 Company 22501 IN-985551 Company 44152 IN-1237832 Company 44153 IN-1237833 IN-1237854 IN-1237856 Company 44154 IN-1237834 IN-1237855 IN-1237857 Company 44155 IN. 1237835 Company 97551 In-1267221 0 0 0 0 0 0 0 0 5.400 0 0 0 0 0 0 0 0 44,005 0 0 0 0 0 0 0 12.700 16.900 55.300 0 77,000 120,000 0 0 0 0 0 1,380 0 0 0 0 0 0 0 0 0 0 0 0 0 12,000 0 0 3.500 150,000 0 0 0 2.100 0 12,800 44,005 45,800 0 1,200 5.400 0 0 0 14,080 16,900 55,300 12,000 77,000 120,000 3,500 150,000 105,000 35,988 0 0 0 0 0 0 0 0 0 0 105,000 35,988 0 0 0 0 0 0 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 turnover 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: 25 50 101 150 200 0-30 days 31-60 days 61-90 days 91-120 days >120 days Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea
