1 Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios RTR US RTR Saudi Arabia RTR UK 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 countrys low turnover ratio a Company 1186 b Company 3417 c Company 11644 d Company 19949 e Company 9913 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 2 030 days 5 3160 days 10 6190 days 15 91120 days 20 120 days Using these estimates, calculate the Allowance for Uncollectible Accounts for South Korea es 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 AR by Country 2020 Mapbox OpenStreetMap Receivables Turnover R 0 00 16 30

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on May 22, 2022

1.Identify the three countries with the most favorable collection experience as measured by their receivables turnover ratios. RTR US = RTR Saudi Arabia = RTR

IBS is a global provider of point-of-sale systems and related services that enable businesses to accept electronic payments.

AR by Company Company Invoice Company 1186 IN-1235005 IN-1237863 Company 1187 IN-1236006 IN-1237864 Company 1208 IN-1234995 C

AR by Company 31-60 Days Past Due 00 61-90 Days Past Due 00 091-120 Days Past Due 00 00 00 00 00 00 0-30 Days Past D

AR by Company Company Company 3397 Company 3398 Company 3399 Company 3400 Company 3401 Company 3402 Company 3403 Company 3404

AR by Company 91-120 Days Past Due 0>120 Days Past Due 00 00 00 00 00 61-90 Days Past Due 023,000 00 123,023 00 00

AR by Company 31-60 Days Past Due 00 0Company Invoice Company 3417 IN-1237807 IN-1238256 Company 3418 IN-1237808 IN-1238257

AR by Company >120 Days Past Due 061-90 Days 91-120 Days Past Due Past Due 00 00 00 00 00 0Company Company 8033 Compan

AR by Company 91-120 Days Past Duc 40,900 0>120 Days Past Due 00 00 00 00 00 00 00 Company Invoice Company 9917 IN-12

AR by Company 0-30 Days Past Due 31-60 Days Past Due 61-90 Days Past Due 91-120 Days Past Due >120 Days Past Due Grand Total

AR by Company 31-60 Days Past Duc 205,633 091-120 Days Past Due 00 >120 Days Past Duc 00 00 00 0ces 00 0O 00 00 61-

AR by Company 61-90 Days Past Due 00 091-120 Days Past Due 024,900 00 00 00 >120 Days Past Due 00 00 00 00 00-30 D

AR by Company 0-30 Days Past Due Company Invoice Company 19958 IN-I ZDUSD Company 17939 IN-1236057 Company 17940 IN-1236058 C

AR by Company 0-30 Days 31-60 Days Past Due 0240,000 00 01,300 091-120 Days Past Duc 00 00 00 27,000 74,211 0>120 Day

AR by Company Company Invoice Company 19951 IN-1238285 Company 19952 IN-1238286 Company 19953 IN-1238287 Company 19954 IN-123

AR by Company Grand Total TIJULY w0-30 Days 31-60 Days Past Due Past Due 00 1,300 800 00 00 0 44,005 45,800 00 00 0Com

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

RTR US =

RTR Saudi Arabia =

RTR UK =

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?

a.Company 1186

b.Company 3417

c.Company 11644

d.Company 19949

e.Company 9913

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:

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.

es 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. AR by Country 2020 Mapbox OpenStreetMap Receivables Turnover R... 0.00 16.30

Step by Step Solution

★★★★★

3.40 Rating (162 Votes )

There are 3 Steps involved in it

Step: 1

Query 1 The three countries with the most favorable collection experience as measured by their receivables turnover ratios are Country Receivables Turnover Ratio United States 123 Saudi Arabia 115 Uni... blur-text-image