Question

1 Approved Answer

Posted on Jul 27, 2024

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 companys

image text in transcribed 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 companys international headquarters accounting department, one of your first assignments is to assist a team tasked with analyzing the companys accounts receivable collections. As a starting point, the team is provided with the following Tableau Dashboard.

image text in transcribed

AR by Company AR by Company AR by Company AR by Company Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. Calculate the Allowance for Uncollectible accounts for South Korea. Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. Which company in Peru is most responsible for that country's low turnover ratio? Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. 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.) o 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 nap'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 atio? 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 hat will be uncollectible: Jsing these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. (Round your answers to 2 decimal places.) \begin{tabular}{lrrrrrrr} \hline Company 44152 & IN-1237832 & 0 & 16,900 & 0 & 0 & 0 & 16,900 \\ \hline Company 44153 & IN-1237833 & 0 & 55,300 & 0 & 0 & 0 & 55,300 \\ & IN-1237854 & 0 & 0 & 12,000 & 0 & 0 & 12,000 \\ \cline { 2 - 7 } & IN-1237856 & 0 & 77,000 & 0 & 0 & 0 & 77,000 \\ \hline Company 44154 & IN-1237834 & 0 & 120,000 & 0 & 0 & 0 & 120,000 \\ & IN-1237855 & 0 & 0 & 3,500 & 0 & 0 & 3,500 \\ \cline { 2 - 7 } & IN-1237857 & 0 & 0 & 150,000 & 0 & 0 & 150,000 \\ \hline Company 44155 & IN-1237835 & 105,000 & 0 & 0 & 0 & 0 & 105,000 \\ \hline Company 97551 & In-1267221 & 35,988 & 0 & 0 & 0 & 0 & 35,988 \end{tabular} \begin{tabular}{lrrrrrr} \hline IN-1237780 & 120,000 & 0 & 0 & 0 & 120,000 \\ \hline IN-1237840 & 0 & 0 & 14,000 & 0 & 0 & 14,000 \\ \hline IN-1237849 & 0 & 33,400 & 0 & 0 & 0 & 33,400 \\ \hline IN-1237871 & 0 & 0 & 50,200 & 0 & 0 & 50,200 \\ \hline IN-1236014 & 438,880 & 0 & 0 & 0 & 0 & 438,880 \\ \hline IN-1237781 & 24,000 & 0 & 0 & 0 & 0 & 24,000 \\ \hline IN-1237841 & 0 & 0 & 12,000 & 0 & 0 & 12,000 \\ \hline IN-1237850 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline IN-1237872 & 0 & 0 & 46,000 & 0 & 0 & 46,000 \\ \hline IN-1236015 & 305,000 & 0 & 0 & 0 & 0 & 305,000 \\ \hline IN-1237782 & 12,000 & 0 & 0 & 0 & 0 & 12,000 \\ \hline IN-1237842 & 0 & 23,008 & 0 & 0 & 0 & 23,008 \\ \hline IN-1237851 & 15,660 & 0 & 0 & 0 & 0 & 15,660 \\ \hline IN-1237873 & 190,000 & 0 & 0 & 0 & 0 & 190,000 \\ \hline IN-1235002 & 0 & 0 & 106,500 & 0 & 0 & 106,500 \\ \hline IN-1237860 & 0 & 12,700 & 0 & 0 & 0 & 12,700 \\ \hline IN-1236007 & 12,900 & 0 & 0 & 0 & 0 & 12,900 \\ \hline IN-1237774 & 0 & 0 & 0 & 24,900 & 0 & 24,900 \\ \hline IN-1237865 & 0 & 1,200 & 0 & 0 & 1,200 \\ \hline IN-1236027 & 460,800 & 0 & 0 & 0 & 0 & 460,800 \\ \hline IN-1237794 & 0 & 0 & 0 & 0 & 0 & \\ \hline \end{tabular} Company 3418 IN-1238257 50,200 280,566 IN-1237809 IN-1238258 2,088 46,000 2,088 IN-1238259 35,000 \begin{tabular}{rrr} IN-1237811 & 0 & 12,000 \\ \hline IN-1238260 & 0 & 0 \end{tabular} Company 3422 IN-1237812 0000 075,400 Company 3423 Company 3424 \begin{tabular}{lr} IN-1237813 & 0 \\ \hline IN-1238262 & 5,800 \end{tabular} 15,000 IN-1237814 IN-1238263 0022,000 Company 3456 IN-1236660 32,900 Company 5200 IN-1235003 IN-1237861 49,720 IN-1239036 IN-1237761 IN-1237762 0012,0000508,0000 Company 3411 IN-1238249 11,900 IN-1237801 0 IN-1237827 IN-1238250 2,009 000000123,0230 000011,9000123,0232,009 Company 3412 IN-1237802 0 0 0 IN-1237828 IN-1238251 00010,667 0 \begin{tabular}{rr} \hline IN-1237829 & 164,541 \\ \hline IN-1238252 & 35,000 \end{tabular} 164,541 35,000 Company 3414 \begin{tabular}{lr} IN-1237804 & 0 \\ \hline IN-1237830 & 12,040 \\ \hline IN-1238253 & 200,876 \end{tabular} 28,004 200,876 Company 3415 IN-1237805 105,000 IN-1237831 IN-1238254 11,290 22,300 11,290 Con IN-1237806 0 Company 3417 00035,00000 \begin{tabular}{ll} IN-1237807 & 0 \\ \hline IN-1238256 & 0 \end{tabular} \begin{tabular}{rr|} \hline 35,000 \\ \hline 28,900 \\ \hline 20,800 & 39,000 \\ \hline \end{tabular} AR by Company AR by Company AR by Company AR by Company Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. Calculate the Allowance for Uncollectible accounts for South Korea. Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. Which company in Peru is most responsible for that country's low turnover ratio? Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. 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.) o 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 nap'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 atio? 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 hat will be uncollectible: Jsing these estimates, calculate the Allowance for Uncollectible Accounts for South Korea. Complete this question by entering your answers in the tabs below. Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. (Round your answers to 2 decimal places.) \begin{tabular}{lrrrrrrr} \hline Company 44152 & IN-1237832 & 0 & 16,900 & 0 & 0 & 0 & 16,900 \\ \hline Company 44153 & IN-1237833 & 0 & 55,300 & 0 & 0 & 0 & 55,300 \\ & IN-1237854 & 0 & 0 & 12,000 & 0 & 0 & 12,000 \\ \cline { 2 - 7 } & IN-1237856 & 0 & 77,000 & 0 & 0 & 0 & 77,000 \\ \hline Company 44154 & IN-1237834 & 0 & 120,000 & 0 & 0 & 0 & 120,000 \\ & IN-1237855 & 0 & 0 & 3,500 & 0 & 0 & 3,500 \\ \cline { 2 - 7 } & IN-1237857 & 0 & 0 & 150,000 & 0 & 0 & 150,000 \\ \hline Company 44155 & IN-1237835 & 105,000 & 0 & 0 & 0 & 0 & 105,000 \\ \hline Company 97551 & In-1267221 & 35,988 & 0 & 0 & 0 & 0 & 35,988 \end{tabular} \begin{tabular}{lrrrrrr} \hline IN-1237780 & 120,000 & 0 & 0 & 0 & 120,000 \\ \hline IN-1237840 & 0 & 0 & 14,000 & 0 & 0 & 14,000 \\ \hline IN-1237849 & 0 & 33,400 & 0 & 0 & 0 & 33,400 \\ \hline IN-1237871 & 0 & 0 & 50,200 & 0 & 0 & 50,200 \\ \hline IN-1236014 & 438,880 & 0 & 0 & 0 & 0 & 438,880 \\ \hline IN-1237781 & 24,000 & 0 & 0 & 0 & 0 & 24,000 \\ \hline IN-1237841 & 0 & 0 & 12,000 & 0 & 0 & 12,000 \\ \hline IN-1237850 & 0 & 0 & 0 & 0 & 0 & 0 \\ \hline IN-1237872 & 0 & 0 & 46,000 & 0 & 0 & 46,000 \\ \hline IN-1236015 & 305,000 & 0 & 0 & 0 & 0 & 305,000 \\ \hline IN-1237782 & 12,000 & 0 & 0 & 0 & 0 & 12,000 \\ \hline IN-1237842 & 0 & 23,008 & 0 & 0 & 0 & 23,008 \\ \hline IN-1237851 & 15,660 & 0 & 0 & 0 & 0 & 15,660 \\ \hline IN-1237873 & 190,000 & 0 & 0 & 0 & 0 & 190,000 \\ \hline IN-1235002 & 0 & 0 & 106,500 & 0 & 0 & 106,500 \\ \hline IN-1237860 & 0 & 12,700 & 0 & 0 & 0 & 12,700 \\ \hline IN-1236007 & 12,900 & 0 & 0 & 0 & 0 & 12,900 \\ \hline IN-1237774 & 0 & 0 & 0 & 24,900 & 0 & 24,900 \\ \hline IN-1237865 & 0 & 1,200 & 0 & 0 & 1,200 \\ \hline IN-1236027 & 460,800 & 0 & 0 & 0 & 0 & 460,800 \\ \hline IN-1237794 & 0 & 0 & 0 & 0 & 0 & \\ \hline \end{tabular} Company 3418 IN-1238257 50,200 280,566 IN-1237809 IN-1238258 2,088 46,000 2,088 IN-1238259 35,000 \begin{tabular}{rrr} IN-1237811 & 0 & 12,000 \\ \hline IN-1238260 & 0 & 0 \end{tabular} Company 3422 IN-1237812 0000 075,400 Company 3423 Company 3424 \begin{tabular}{lr} IN-1237813 & 0 \\ \hline IN-1238262 & 5,800 \end{tabular} 15,000 IN-1237814 IN-1238263 0022,000 Company 3456 IN-1236660 32,900 Company 5200 IN-1235003 IN-1237861 49,720 IN-1239036 IN-1237761 IN-1237762 0012,0000508,0000 Company 3411 IN-1238249 11,900 IN-1237801 0 IN-1237827 IN-1238250 2,009 000000123,0230 000011,9000123,0232,009 Company 3412 IN-1237802 0 0 0 IN-1237828 IN-1238251 00010,667 0 \begin{tabular}{rr} \hline IN-1237829 & 164,541 \\ \hline IN-1238252 & 35,000 \end{tabular} 164,541 35,000 Company 3414 \begin{tabular}{lr} IN-1237804 & 0 \\ \hline IN-1237830 & 12,040 \\ \hline IN-1238253 & 200,876 \end{tabular} 28,004 200,876 Company 3415 IN-1237805 105,000 IN-1237831 IN-1238254 11,290 22,300 11,290 Con IN-1237806 0 Company 3417 00035,00000 \begin{tabular}{ll} IN-1237807 & 0 \\ \hline IN-1238256 & 0 \end{tabular} \begin{tabular}{rr|} \hline 35,000 \\ \hline 28,900 \\ \hline 20,800 & 39,000 \\ \hline \end{tabular}