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.09 16.30 es 2020 Mapbox OpenStreetMap AR by Company Company Invoice Company 1186 IN-1235005 IN-1237863 Company 1187 IN-1236006 IN-1237864 Company 1208 IN-1234995 Company 1256 IN-1236009 IN-1237776 IN-1237836 IN-1237845 IN-1237867 Company 1633 IN-1235004 IN-1237862 Company 1799 IN-1236016 IN-1237783 IN-1237843 IN-1237852 Company 1800 IN-1236017 IN-1237784 IN-1237844 IN-1237853 Company 1801 IN-1236018 IN-1237785 0-30 Days 31-60 Days 61-90 Days 91-120 Days Past Due Past Due Past Due Past Due 45,009 0 0 0 0 6,004 0 15,000 278,003 0 0 0 19,002 0 0 0 44,118 0 0 0 2,096,650 0 0 0 120,000 0 0 0 0 15,000 0 92,805 0 0 0 5,000 0 0 300,987 0 0 0 34.000 0 0 3,008,009 0 0 0 3,500 0 0 0 0 0 35,000 0 0 43,000 0 0 308,000 0 0 0 100,400 7,000 0 0 0 0 0 32,000 0 0 -24,000 0 0 0 104,009 0 120,000 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 0 43,000 0 308,000 0 107,400 0 32,000 0 -24,000 0 104,009 0 120,000 100 AR by Company Company Invoice Company 1802 IN-1236019 IN-1237786 Company 1803 IN-1236020 IN-1237787 Company 1804 IN-1236021 IN-1237788 Company 1805 IN-1236022 IN-1237789 Company 1806 IN-1236023 IN-1237790 Company 2999 IN-66541 Company 3387 IN-1238226 Company 3388 IN-1238227 Company 3389 IN-1238228 Company 3390 IN-1238229 Company 3391 IN-1238230 Company 3392 IN-1238231 Company 3393 IN-1238232 Company 3394 IN-1238233 Company 3395 IN-1238234 Company 3396 IN-1238235 Company 3397 IN-1238236 0-30 Days 31-60 Days Past Due Past Due 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 0 509,000 31,900 0 0 0 0 0 300 0 0 0 9,000 0 16,000 0 15,000 0 45,000 0 1,200 0 1,500 0 21.000 0 0 61-90 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 36,881 0 402 91-120 Days Past Due 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 AR by Company Company Invoice Company 3397 IN-1238236 Company 3398 IN-1238237 Company 3399 IN-1238238 Company 3400 IN-1237858 IN-1237859 IN-1238239 Company 3401 IN-1238240 Company 3402 IN-1238241 Company 3403 IN-1238242 Company 3404 IN-1238243 Company 3405 IN-1238244 Company 3406 IN-1238245 Company 3407 IN-1238246 Company 3408 IN-1237798 IN-1237824 IN-1238247 Company 3409 IN-1237799 IN-1237825 IN-1238248 Company 3410 IN-1237800 IN-1237826 IN-1238249 0-30 Days Past Due 0 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 31-60 Days 61-90 Days 91-120 Days Past Due Past Due Past Duc 0 0 0 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 23,000 0 0 0 0 >120 Days Past Duc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 105,000 0 0 0 0 0 0 0 Grand Total 0 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 AR by Company 91-120 Days Past Due 0 >120 Days Past Due 0 0 0 0 0 0 0 0 0 61-90 Days Past Due 0 23,000 0 0 123,023 0 0 0 0 0 0 0 0-30 Days Past Due 0 0 11,900 0 0 2,009 0 0 0 0 164,541 35,000 0 12,040 200,876 0 11,290 22,300 0 0 0 31-60 Days Past Due 0 0 0 0 0 0 0 0 10,667 0 0 0 28,004 0 0 105,000 0 0 35,000 O Company Invoice Company 3410 IN-1237800 IN-1237826 IN-1238249 Company 3411 IN-1237801 IN-1237827 IN-1238250 Company 3412 IN-1237802 IN-1237828 IN-1238251 Company 3413 IN-1237803 IN-1237829 IN-1238252 Company 3414 IN-1237804 IN-1237830 IN-1238253 Company 3415 IN-1237805 IN-1237831 IN-1238254 Company 3416 IN-1237806 IN-1238255 Company 3417 IN-1237807 IN-1238256 0 0 0 0 0 0 0 0 O Grand Total 0 23,000 11,900 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 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28,900 39,000 0 0 0 0 0 20.800 0 0 0 AR by Company Company Invoice Company 3417 IN-1237807 IN-1238256 Company 3418 IN-1237808 IN-1238257 Company 3419 IN-1237809 IN-1238258 Company 3420 IN-1237810 IN-1238259 Company 3421 IN-1237811 IN-1238260 Company 3422 IN-1237812 IN-1238261 Company 3423 IN-1237813 IN-1238262 Company 3424 IN-1237814 IN-1238263 Company 3456 IN-1236660 Company 5200 IN-1235003 IN-1237861 Company 5679 IN-1238225 Company 8032 IN-1239036 Company 8033 IN-1237761 0-30 Days 31-60 Days Past Due Past Due 0 0 0 0 50.200 0 280,566 0 0 46,000 0 0 0 14,000 0 0 0 - 12,000 0 0 0 0 0 0 0 15,000 25,800 0 0 22,000 0 0 32,900 0 0 0 0 0 49,720 0 0 0 0 508,000 61-90 Days Past Due 0 0 0 0 0 0 0 35,000 0 0 0 0 0 0 0 0 0 80,565 0 0 13,669 0 91-120 Days >120 Days Past Due Past Due 39,000 0 0 20,800 0 0 0 0 0 0 2,088 0 0 0 0 0 0 0 75,400 0 0 0 0 3,200 0 0 0 0 0 0 0 0 0 0 0 0 45,000 0 0 0 0 0 0 0 Grand Total 39,000 20,800 50,200 280,566 46,000 2,088 14,000 35,000 -12,000 75,400 0 3,200 15,000 5,800 22,000 0 32,900 80,565 45,000 49,720 13,669 508,000 AR by Company >120 Days Past Due 0 91-120 Days Past Due 0 0 0 0 0 0 Company Company 8033 Company 8034 Company 8035 Company 8036 Company 8037 Company 8038 Company 8039 Company 8040 Company 8041 Company 8042 Company 8043 Company 8044 Company 8045 Company 8160 Company 8936 0 0 0 0 0 0 0 0 Invoice IN-1237761 IN-1237762 IN-1237763 IN-1237764 IN-1237765 IN-1237766 IN-1237767 IN-1237768 IN-1237769 IN-1237770 IN-1237771 IN-1237772 IN-1237773 IN-1237760 IN-1234997 IN-1235000 IN-1235001 IN-1236031 IN-1236032 IN-1236033 IN-1236034 IN-1236035 0-30 Days Past Due 0 12.000 19,000 25,000 0 16,000 15,000 45,000 1,200 1,500 21,000 0 56,000 4,434 43,928 126,400 113,891 0 412,000 390,350 500,223 188,300 31-60 Days Past Due 508,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12.000 0 0 0 129,344 61-90 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Grand Total 508,000 12,000 19,000 25,000 0 16,000 15,000 45,000 1,200 1,500 21,000 0 56,000 44,434 43,928 126,400 113,891 12,000 412,000 390,350 500,223 358,544 0 0 0 0 0 0 0 0 0 Company 9912 Company 9913 Company 9914 Company 9915 Company 9916 Company 9917 0 0 0 0 0 0 0 0 40,900 0 0 AR by Company 91-120 Days Past Due 40,900 0 >120 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 0 Company Invoice Company 9917 IN-1236035 Company 9918 IN-1236036 Company 9919 IN-1236037 Company 9920 IN-1236038 Company 9921 IN-1236039 Company 9922 IN-1236040 Company 9923 IN-1236041 Company 9924 IN-1236042 Company 9925 IN-1236043 Company 9926 IN-1236044 Company 9927 IN-1236045 Company 9928 IN-1236046 Company 9929 IN-1236047 Company 11561 IN-1236030 IN: 237797 IN-1237823 IN-1237881 Company 11644 IN-1236008 IN-1237775 IN-1237866 Company 11860 IN-1236024 IN-1237791 0-30 Days 31-60 Days 61-90 Days Past Due Past Due Past Due 188,300 129,344 0 433,000 0 0 399,400 0 0 200,800 0 0 306,000 0 0 208,900 0 0 209,300 0 0 280,933 0 0 320,900 0 0 190,550 0 0 1,204,050 0 0 0 0 180,300 208,000 0 0 280,500 0 0 0 12.000 0 0 O 123,000 23,000 0 0 0 44.900 0 0 0 43,000 200 0 0 109,300 0 37,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Grand Total 358,544 433,000 399,400 200,800 306,000 208,900 209,300 280,933 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19,440 -HOC. AR by Company 0-30 Days Past Due 31-60 Days Past Due 91-120 Days Past Due >120 Days Past Due Grand Total UUUUU 0 0 0 0 0 0 0 19,440 0 0 0 Company Invoice puede IN-1237775 IN-1237866 Company 11860 IN-1236024 IN-1237791 Company 11861 IN-1236025 IN-1237792 IN-1237876 Company 12441 IN-1234996 Company 12678 IN-1234998 Company 12862 IN-1236026 IN-1237793 IN-1237877 Company 13065 IN-1234999 Company 13557 IN-1236010 IN 237777 IN-1237837 IN-1237846 IN-1237868 Company 13558 IN-1236011 IN-1237778 IN-1237838 IN-1237847 0 0 0 0 0 0 61-90 Days Past Due 43,000 0 37,000 0 0 0 0 0 0 0 0 0 163,483 0 120,000 0 0 0 0 0 0 0 0 200 109,300 0 209,060 0 305,000 44,097 43,745 209,000 0 66,400 12,009 27,900 0 0 0 3,055 16,690 32,010 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35,000 0 0 0 0 120,000 31,000 0 0 0 120,000 284,493 0 43,000 200 146,300 19,440 209,060 0 305,000 44,097 43,745 209,000 35,000 66,400 175,492 27.900 120,000 120,000 31,000 3,055 16,690 32,010 120,000 284,493 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 AR by Company 91-120 Days Past Due 0 0 0 >120 Days Past Due 0 0 ces 0 0 0 0 0 0 0 0 0 Company Invoice Company 13559 IN-1236012 IN-1237779 IN-1237839 IN-1237848 IN-1237870 Company 13560 IN-1236013 IN-1237780 IN-1237840 IN-1237849 IN-1237871 Company 13561 IN-1236014 IN-1237781 IN-1237841 IN-1237850 IN-1237872 Company 13562 -1236015 IN-1237782 IN-1237842 IN-1237851 IN-1237873 Company 13776 IN-1235002 IN-1237860 0 0 0-30 Days Past Due 0 55,300 32,010 0 0 33,500 120,000 0 0 0 438.880 -24,000 0 0 0 305,000 12,000 0 15,660 190,000 O 61-90 Days Past Due 0 0 0 80,000 0 0 0 14,000 0 50,200 0 0 - 12.000 0 46,000 0 31-60 Days Past Duc 205,633 0 0 0 25,000 O 0 0 33,400 0 0 0 0 0 0 0 0 23,008 0 0 0 0 0 Grand Total 205,633 55,300 32,010 80,000 25,000 33,500 120,000 14,000 33,400 50,200 438,880 -24,000 - 12.000 0 46,000 305,000 12.000 23.008 15,660 190,000 106,500 12,700 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12,700 106,500 0 O 0 14 ARRAR Inn AR by Company 61-90 Days Past Duc 31-60 Days Past Due 0 0 1,200 0 0 0 0 91-120 Days Past Due 0 24,900 0 0 0 0 0 0 >120 Days Past Due 0 0 0 0 0 0 0 0 0 0 Company Invoice Company 14229 IN-1236007 IN-1237774 IN-1237865 Company 14558 IN-1236027 IN-1237794 IN-1237878 Company 15559 IN-1236028 IN-1237795 IN-1237821 IN-1237879 Company 16332 IN-98552 Company 17300 IN-1234993 Company 17560 IN-1236029 IN-1237796 IN-1237822 1-1237880 Company 17796 IN-1234994 Company 17932 IN-1236050 Company 17933 IN-1236051 Company 17934 IN-1236052 Company 17935 IN-1236053 Company 17936 IN-1236054 0 0 0 0 0 0 0 0 0 0-30 Days Past Due 12,900 0 0 460,800 0 35,000 90,500 0 0 402,900 7,733 44,390 450,000 0 45,000 250,300 44,306 0 22,793 230.000 688 0 0 O 12,500 0 0 0 0 0 15,300 0 0 0 0 0 0 0 Grand Total 12,900 24,900 1,200 460,800 0 35,000 90,500 12,500 0 402,900 7.733 44,390 450,000 15,300 45,000 250.300 44,306 22,900 27,093 238.000 2,178 190,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4,300 0 0 0 0 0 8,000 1.100 190,000 22,900 0 0 390 0 0 0 AR by Company 0-30 Days Past Due 31-60 Days Past Due 240.000 12,000 0 0 2,030 159,444 0 0 24,088 0 25,003 0 0 Company Invoice Company 1930 IN-123005D Company 17939 IN-1236057 Company 17940 IN-1236058 Company 17941 IN-1236059 Company 17942 IN-1236060 Company 17943 IN-1236061 Company 17944 IN-1236062 Company 17945 IN-1236063 Company 17946 IN-1236064 Company 17947 IN-1236065 Company 17948 IN-1236066 Company 17949 IN-1236067 Company 17950 IN-1236068 Company 19930 IN-1236048 IN-1237815 IN-1238264 Company 19931 IN-1236049 IN-1237816 IN-1238265 Company 19932 IN-1237817 IN-1237874 IN-1237882 IN-1238266 61-90 Days Past Due U 0 66,400 0 33,500 0 18,000 250,900 0 15,000 109,000 0 0 61,090 80,900 0 0 0 0 1,500 >120 Days Past Due U 0 0 0 0 0 0 0 0 0 91-120 Days Past Due U 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12,000 0 28,900 0 35,000 387,000 0 3.200 0 0 500 500 305,000 450,700 20.800 0 0 23,000 14.800 78,440 0 250.800 250,900 120.990 0 Grand Total 240,000 40,900 66,400 35,000 422,530 159,444 21,200 250,900 24,088 15,500 134,503 305,000 450,700 81,890 80,900 12,000 23,000 14,800 78,440 1,500 250.800 250,900 120,990 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 eee 0 0 0 0 AR by Company 61-90 Days Past Due 0 0 12,300 0 0 0 0 91-120 Days Past Due 0 0 0 0 0 0 27,000 74,211 0 0 >120 Days Past Due 32,000 0 0 0 0 0 0 31-60 Days Past Due 0 240,000 0 0 0 1,300 0 0 0 0 0 0 50,700 0 14,000 0 0 0 Company Invoice Company 19933 IN-1237818 IN-1237875 IN-1238267 Company 19934 IN-1237819 IN-1238268 Company 19935 IN-1237820 IN-1238269 Company 19936 IN-1238270 Company 19937 IN-1238271 Company 19938 IN-1238272 Company 19939 IN-1238273 Company 19940 IN-1238274 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 19948 IN-1238282 Company 19949 IN-1238283 Company 19950 IN-1238284 0 0-30 Days Past Due 0 0 0 4,600 17,000 0 160,874 38,000 80,500 6,500 10,900 130,000 0 27,000 29,000 28,000 30,000 307,000 55,900 120,000 28,000 120,900 0 2,900 0 0 0 3,009 0 0 0 Grand Total 32,000 240,000 12,300 4,600 17,000 1,300 187,874 112,211 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8,700 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 AR by Company >120 Days Past Due 0 20.555 0 61-90 Days 91-120 Days Past Due Past Due 0 0 0 0 0 0 0 0 0 12,000 0 12,900 0 0 9,000 0 0 0 0 0 Company Invoice Company 19951 IN-1238285 Company 19952 IN-1238286 Company 19953 IN-1238287 Company 19954 IN-1238288 Company 19955 IN-1238289 Company 19956 IN-1238290 Company 19957 IN-1238291 Company 19958 IN-1238292 Company 19959 IN-1238293 Company 19960 IN-1238294 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 0-30 Days 31-60 Days Past Due Past Due 103,900 0 109,400 55,002 0 109,000 0 0 0 0 0 0 8,100 0 0 0 0 1,300 800 0 0 0 0 0 44,005 45,800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Grand Total 103,900 20,555 109,400 55,002 109,000 12,000 12,900 9,000 8.100 0 0 2,100 0 12,800 44,005 45,800 0 1.200 5.400 0 0 0 0 0 O 0 0 0 0 0 0 5,400 0 0 0 0 12,800 0 0 0 0 0 0 1,200 0 0 0 0 0 0 0 Can 2601 0 0 IN 095551 AR by Company 61-90 Days Past Due 91-120 Days >120 Days Past Due Past Due Grand Total 0 0-30 Days 31-60 Days Past Due Past Due 0 0 1,300 800 0 0 0 0 0 44,005 45,800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12,800 0 0 0 0 0 0 0 1,200 0 0 0 Company Invoice Lumpally u 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 5,400 0 0 0 0 0 0 0 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 1,380 0 0 0 0 0 0 0 105,000 35,988 0 0 0 12.700 16.900 55,300 0 77,000 120,000 0 0 0 0 0 0 12,000 0 0 3,500 150,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 +ableau I 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 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: 28 56 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, Complete this question by entering your answers in the tabs below. 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 Turnnyer Ratio Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. 5 Required 1 Hequired 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 Turnover Ratio Required Required 2 > Complete this question by entering your answers in the tabs below. 5 Required 1 Required 2 Required 3 Required 4 Which country appears to have the most need of improvement in collection procedures as measured by its receivables turnover ratio? (Round your answer to 2 decimal places.) Country Receivables Turnover Ratio Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. K Complete this question by entering your answers in the tabs below. ices Required 1 Required 2 Recaired 3 Required 4 Which company in Peru is most responsible for that country's low turnover ratio? Company 1186 Company 3417 Company 11644 O Company 19949 Company 9913 ces Using these estimates, calculate the Allowance for Uncollectible Accounts for 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 0 43,000 0 308,000 0 107,400 0 32,000 0 -24,000 0 104,009 0 120,000 100 AR by Company Company Invoice Company 1802 IN-1236019 IN-1237786 Company 1803 IN-1236020 IN-1237787 Company 1804 IN-1236021 IN-1237788 Company 1805 IN-1236022 IN-1237789 Company 1806 IN-1236023 IN-1237790 Company 2999 IN-66541 Company 3387 IN-1238226 Company 3388 IN-1238227 Company 3389 IN-1238228 Company 3390 IN-1238229 Company 3391 IN-1238230 Company 3392 IN-1238231 Company 3393 IN-1238232 Company 3394 IN-1238233 Company 3395 IN-1238234 Company 3396 IN-1238235 Company 3397 IN-1238236 0-30 Days 31-60 Days Past Due Past Due 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 0 509,000 31,900 0 0 0 0 0 300 0 0 0 9,000 0 16,000 0 15,000 0 45,000 0 1,200 0 1,500 0 21.000 0 0 61-90 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 36,881 0 402 91-120 Days Past Due 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 AR by Company Company Invoice Company 3397 IN-1238236 Company 3398 IN-1238237 Company 3399 IN-1238238 Company 3400 IN-1237858 IN-1237859 IN-1238239 Company 3401 IN-1238240 Company 3402 IN-1238241 Company 3403 IN-1238242 Company 3404 IN-1238243 Company 3405 IN-1238244 Company 3406 IN-1238245 Company 3407 IN-1238246 Company 3408 IN-1237798 IN-1237824 IN-1238247 Company 3409 IN-1237799 IN-1237825 IN-1238248 Company 3410 IN-1237800 IN-1237826 IN-1238249 0-30 Days Past Due 0 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 31-60 Days 61-90 Days 91-120 Days Past Due Past Due Past Duc 0 0 0 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 23,000 0 0 0 0 >120 Days Past Duc 0 0 0 0 0 0 0 0 0 0 0 0 0 0 105,000 0 0 0 0 0 0 0 Grand Total 0 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 AR by Company 91-120 Days Past Due 0 >120 Days Past Due 0 0 0 0 0 0 0 0 0 61-90 Days Past Due 0 23,000 0 0 123,023 0 0 0 0 0 0 0 0-30 Days Past Due 0 0 11,900 0 0 2,009 0 0 0 0 164,541 35,000 0 12,040 200,876 0 11,290 22,300 0 0 0 31-60 Days Past Due 0 0 0 0 0 0 0 0 10,667 0 0 0 28,004 0 0 105,000 0 0 35,000 O Company Invoice Company 3410 IN-1237800 IN-1237826 IN-1238249 Company 3411 IN-1237801 IN-1237827 IN-1238250 Company 3412 IN-1237802 IN-1237828 IN-1238251 Company 3413 IN-1237803 IN-1237829 IN-1238252 Company 3414 IN-1237804 IN-1237830 IN-1238253 Company 3415 IN-1237805 IN-1237831 IN-1238254 Company 3416 IN-1237806 IN-1238255 Company 3417 IN-1237807 IN-1238256 0 0 0 0 0 0 0 0 O Grand Total 0 23,000 11,900 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 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28,900 39,000 0 0 0 0 0 20.800 0 0 0 AR by Company Company Invoice Company 3417 IN-1237807 IN-1238256 Company 3418 IN-1237808 IN-1238257 Company 3419 IN-1237809 IN-1238258 Company 3420 IN-1237810 IN-1238259 Company 3421 IN-1237811 IN-1238260 Company 3422 IN-1237812 IN-1238261 Company 3423 IN-1237813 IN-1238262 Company 3424 IN-1237814 IN-1238263 Company 3456 IN-1236660 Company 5200 IN-1235003 IN-1237861 Company 5679 IN-1238225 Company 8032 IN-1239036 Company 8033 IN-1237761 0-30 Days 31-60 Days Past Due Past Due 0 0 0 0 50.200 0 280,566 0 0 46,000 0 0 0 14,000 0 0 0 - 12,000 0 0 0 0 0 0 0 15,000 25,800 0 0 22,000 0 0 32,900 0 0 0 0 0 49,720 0 0 0 0 508,000 61-90 Days Past Due 0 0 0 0 0 0 0 35,000 0 0 0 0 0 0 0 0 0 80,565 0 0 13,669 0 91-120 Days >120 Days Past Due Past Due 39,000 0 0 20,800 0 0 0 0 0 0 2,088 0 0 0 0 0 0 0 75,400 0 0 0 0 3,200 0 0 0 0 0 0 0 0 0 0 0 0 45,000 0 0 0 0 0 0 0 Grand Total 39,000 20,800 50,200 280,566 46,000 2,088 14,000 35,000 -12,000 75,400 0 3,200 15,000 5,800 22,000 0 32,900 80,565 45,000 49,720 13,669 508,000 AR by Company >120 Days Past Due 0 91-120 Days Past Due 0 0 0 0 0 0 Company Company 8033 Company 8034 Company 8035 Company 8036 Company 8037 Company 8038 Company 8039 Company 8040 Company 8041 Company 8042 Company 8043 Company 8044 Company 8045 Company 8160 Company 8936 0 0 0 0 0 0 0 0 Invoice IN-1237761 IN-1237762 IN-1237763 IN-1237764 IN-1237765 IN-1237766 IN-1237767 IN-1237768 IN-1237769 IN-1237770 IN-1237771 IN-1237772 IN-1237773 IN-1237760 IN-1234997 IN-1235000 IN-1235001 IN-1236031 IN-1236032 IN-1236033 IN-1236034 IN-1236035 0-30 Days Past Due 0 12.000 19,000 25,000 0 16,000 15,000 45,000 1,200 1,500 21,000 0 56,000 4,434 43,928 126,400 113,891 0 412,000 390,350 500,223 188,300 31-60 Days Past Due 508,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12.000 0 0 0 129,344 61-90 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Grand Total 508,000 12,000 19,000 25,000 0 16,000 15,000 45,000 1,200 1,500 21,000 0 56,000 44,434 43,928 126,400 113,891 12,000 412,000 390,350 500,223 358,544 0 0 0 0 0 0 0 0 0 Company 9912 Company 9913 Company 9914 Company 9915 Company 9916 Company 9917 0 0 0 0 0 0 0 0 40,900 0 0 AR by Company 91-120 Days Past Due 40,900 0 >120 Days Past Due 0 0 0 0 0 0 0 0 0 0 0 0 Company Invoice Company 9917 IN-1236035 Company 9918 IN-1236036 Company 9919 IN-1236037 Company 9920 IN-1236038 Company 9921 IN-1236039 Company 9922 IN-1236040 Company 9923 IN-1236041 Company 9924 IN-1236042 Company 9925 IN-1236043 Company 9926 IN-1236044 Company 9927 IN-1236045 Company 9928 IN-1236046 Company 9929 IN-1236047 Company 11561 IN-1236030 IN: 237797 IN-1237823 IN-1237881 Company 11644 IN-1236008 IN-1237775 IN-1237866 Company 11860 IN-1236024 IN-1237791 0-30 Days 31-60 Days 61-90 Days Past Due Past Due Past Due 188,300 129,344 0 433,000 0 0 399,400 0 0 200,800 0 0 306,000 0 0 208,900 0 0 209,300 0 0 280,933 0 0 320,900 0 0 190,550 0 0 1,204,050 0 0 0 0 180,300 208,000 0 0 280,500 0 0 0 12.000 0 0 O 123,000 23,000 0 0 0 44.900 0 0 0 43,000 200 0 0 109,300 0 37,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Grand Total 358,544 433,000 399,400 200,800 306,000 208,900 209,300 280,933 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19,440 -HOC. AR by Company 0-30 Days Past Due 31-60 Days Past Due 91-120 Days Past Due >120 Days Past Due Grand Total UUUUU 0 0 0 0 0 0 0 19,440 0 0 0 Company Invoice puede IN-1237775 IN-1237866 Company 11860 IN-1236024 IN-1237791 Company 11861 IN-1236025 IN-1237792 IN-1237876 Company 12441 IN-1234996 Company 12678 IN-1234998 Company 12862 IN-1236026 IN-1237793 IN-1237877 Company 13065 IN-1234999 Company 13557 IN-1236010 IN 237777 IN-1237837 IN-1237846 IN-1237868 Company 13558 IN-1236011 IN-1237778 IN-1237838 IN-1237847 0 0 0 0 0 0 61-90 Days Past Due 43,000 0 37,000 0 0 0 0 0 0 0 0 0 163,483 0 120,000 0 0 0 0 0 0 0 0 200 109,300 0 209,060 0 305,000 44,097 43,745 209,000 0 66,400 12,009 27,900 0 0 0 3,055 16,690 32,010 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35,000 0 0 0 0 120,000 31,000 0 0 0 120,000 284,493 0 43,000 200 146,300 19,440 209,060 0 305,000 44,097 43,745 209,000 35,000 66,400 175,492 27.900 120,000 120,000 31,000 3,055 16,690 32,010 120,000 284,493 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 AR by Company 91-120 Days Past Due 0 0 0 >120 Days Past Due 0 0 ces 0 0 0 0 0 0 0 0 0 Company Invoice Company 13559 IN-1236012 IN-1237779 IN-1237839 IN-1237848 IN-1237870 Company 13560 IN-1236013 IN-1237780 IN-1237840 IN-1237849 IN-1237871 Company 13561 IN-1236014 IN-1237781 IN-1237841 IN-1237850 IN-1237872 Company 13562 -1236015 IN-1237782 IN-1237842 IN-1237851 IN-1237873 Company 13776 IN-1235002 IN-1237860 0 0 0-30 Days Past Due 0 55,300 32,010 0 0 33,500 120,000 0 0 0 438.880 -24,000 0 0 0 305,000 12,000 0 15,660 190,000 O 61-90 Days Past Due 0 0 0 80,000 0 0 0 14,000 0 50,200 0 0 - 12.000 0 46,000 0 31-60 Days Past Duc 205,633 0 0 0 25,000 O 0 0 33,400 0 0 0 0 0 0 0 0 23,008 0 0 0 0 0 Grand Total 205,633 55,300 32,010 80,000 25,000 33,500 120,000 14,000 33,400 50,200 438,880 -24,000 - 12.000 0 46,000 305,000 12.000 23.008 15,660 190,000 106,500 12,700 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12,700 106,500 0 O 0 14 ARRAR Inn AR by Company 61-90 Days Past Duc 31-60 Days Past Due 0 0 1,200 0 0 0 0 91-120 Days Past Due 0 24,900 0 0 0 0 0 0 >120 Days Past Due 0 0 0 0 0 0 0 0 0 0 Company Invoice Company 14229 IN-1236007 IN-1237774 IN-1237865 Company 14558 IN-1236027 IN-1237794 IN-1237878 Company 15559 IN-1236028 IN-1237795 IN-1237821 IN-1237879 Company 16332 IN-98552 Company 17300 IN-1234993 Company 17560 IN-1236029 IN-1237796 IN-1237822 1-1237880 Company 17796 IN-1234994 Company 17932 IN-1236050 Company 17933 IN-1236051 Company 17934 IN-1236052 Company 17935 IN-1236053 Company 17936 IN-1236054 0 0 0 0 0 0 0 0 0 0-30 Days Past Due 12,900 0 0 460,800 0 35,000 90,500 0 0 402,900 7,733 44,390 450,000 0 45,000 250,300 44,306 0 22,793 230.000 688 0 0 O 12,500 0 0 0 0 0 15,300 0 0 0 0 0 0 0 Grand Total 12,900 24,900 1,200 460,800 0 35,000 90,500 12,500 0 402,900 7.733 44,390 450,000 15,300 45,000 250.300 44,306 22,900 27,093 238.000 2,178 190,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4,300 0 0 0 0 0 8,000 1.100 190,000 22,900 0 0 390 0 0 0 AR by Company 0-30 Days Past Due 31-60 Days Past Due 240.000 12,000 0 0 2,030 159,444 0 0 24,088 0 25,003 0 0 Company Invoice Company 1930 IN-123005D Company 17939 IN-1236057 Company 17940 IN-1236058 Company 17941 IN-1236059 Company 17942 IN-1236060 Company 17943 IN-1236061 Company 17944 IN-1236062 Company 17945 IN-1236063 Company 17946 IN-1236064 Company 17947 IN-1236065 Company 17948 IN-1236066 Company 17949 IN-1236067 Company 17950 IN-1236068 Company 19930 IN-1236048 IN-1237815 IN-1238264 Company 19931 IN-1236049 IN-1237816 IN-1238265 Company 19932 IN-1237817 IN-1237874 IN-1237882 IN-1238266 61-90 Days Past Due U 0 66,400 0 33,500 0 18,000 250,900 0 15,000 109,000 0 0 61,090 80,900 0 0 0 0 1,500 >120 Days Past Due U 0 0 0 0 0 0 0 0 0 91-120 Days Past Due U 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12,000 0 28,900 0 35,000 387,000 0 3.200 0 0 500 500 305,000 450,700 20.800 0 0 23,000 14.800 78,440 0 250.800 250,900 120.990 0 Grand Total 240,000 40,900 66,400 35,000 422,530 159,444 21,200 250,900 24,088 15,500 134,503 305,000 450,700 81,890 80,900 12,000 23,000 14,800 78,440 1,500 250.800 250,900 120,990 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 eee 0 0 0 0 AR by Company 61-90 Days Past Due 0 0 12,300 0 0 0 0 91-120 Days Past Due 0 0 0 0 0 0 27,000 74,211 0 0 >120 Days Past Due 32,000 0 0 0 0 0 0 31-60 Days Past Due 0 240,000 0 0 0 1,300 0 0 0 0 0 0 50,700 0 14,000 0 0 0 Company Invoice Company 19933 IN-1237818 IN-1237875 IN-1238267 Company 19934 IN-1237819 IN-1238268 Company 19935 IN-1237820 IN-1238269 Company 19936 IN-1238270 Company 19937 IN-1238271 Company 19938 IN-1238272 Company 19939 IN-1238273 Company 19940 IN-1238274 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 19948 IN-1238282 Company 19949 IN-1238283 Company 19950 IN-1238284 0 0-30 Days Past Due 0 0 0 4,600 17,000 0 160,874 38,000 80,500 6,500 10,900 130,000 0 27,000 29,000 28,000 30,000 307,000 55,900 120,000 28,000 120,900 0 2,900 0 0 0 3,009 0 0 0 Grand Total 32,000 240,000 12,300 4,600 17,000 1,300 187,874 112,211 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8,700 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 AR by Company >120 Days Past Due 0 20.555 0 61-90 Days 91-120 Days Past Due Past Due 0 0 0 0 0 0 0 0 0 12,000 0 12,900 0 0 9,000 0 0 0 0 0 Company Invoice Company 19951 IN-1238285 Company 19952 IN-1238286 Company 19953 IN-1238287 Company 19954 IN-1238288 Company 19955 IN-1238289 Company 19956 IN-1238290 Company 19957 IN-1238291 Company 19958 IN-1238292 Company 19959 IN-1238293 Company 19960 IN-1238294 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 0-30 Days 31-60 Days Past Due Past Due 103,900 0 109,400 55,002 0 109,000 0 0 0 0 0 0 8,100 0 0 0 0 1,300 800 0 0 0 0 0 44,005 45,800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Grand Total 103,900 20,555 109,400 55,002 109,000 12,000 12,900 9,000 8.100 0 0 2,100 0 12,800 44,005 45,800 0 1.200 5.400 0 0 0 0 0 O 0 0 0 0 0 0 5,400 0 0 0 0 12,800 0 0 0 0 0 0 1,200 0 0 0 0 0 0 0 Can 2601 0 0 IN 095551 AR by Company 61-90 Days Past Due 91-120 Days >120 Days Past Due Past Due Grand Total 0 0-30 Days 31-60 Days Past Due Past Due 0 0 1,300 800 0 0 0 0 0 44,005 45,800 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12,800 0 0 0 0 0 0 0 1,200 0 0 0 Company Invoice Lumpally u 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 5,400 0 0 0 0 0 0 0 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 1,380 0 0 0 0 0 0 0 105,000 35,988 0 0 0 12.700 16.900 55,300 0 77,000 120,000 0 0 0 0 0 0 12,000 0 0 3,500 150,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 +ableau I 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 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: 28 56 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, Complete this question by entering your answers in the tabs below. 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 Turnnyer Ratio Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. 5 Required 1 Hequired 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 Turnover Ratio Required Required 2 > Complete this question by entering your answers in the tabs below. 5 Required 1 Required 2 Required 3 Required 4 Which country appears to have the most need of improvement in collection procedures as measured by its receivables turnover ratio? (Round your answer to 2 decimal places.) Country Receivables Turnover Ratio Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. K Complete this question by entering your answers in the tabs below. ices Required 1 Required 2 Recaired 3 Required 4 Which company in Peru is most responsible for that country's low turnover ratio? Company 1186 Company 3417 Company 11644 O Company 19949 Company 9913 ces Using these estimates, calculate the Allowance for Uncollectible Accounts for 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
