4. Analyze the chart prepared below. It includes the beginning AR balance for each company at...

Transcribed Image Text:

4. Analyze the chart prepared below. It includes the beginning AR balance for each company at January 1, 2016; 2016 Sales; 2016 Cash Receipts; 2016 adjustments related to errors identified by the auditor; 2017 Cash Receipts (related to the 2016 AR balance); Returns of merchandise soled in 2016 on account; and Write-offs of specific AR balances based on communication between Tech Wear and its customers. CustName Atletico Madrid SA Awesome Threads Best Time Bigmart Boston Marathon Califomia Clothes Cool Runnings OpeningBalance 2016Sales 2016CashReceipt 2016AuditAdjustments 2017Cash Receipt 2017Returns 2017Write-off 153,246.89 Grand Total 153,246.89 619,826.95 (113,970.40) (45,046.55) (605,856.55) (45,046.55) 869,846.81 (171,836.00) (109,274.78) (474,578.06) (64,188.90) 49,969.07 64,564.31 1,108,246.92 (898,323.36) (26,764.14) (92,385.13) 155,338.60 1,114,491.38 (259,856.00) (24,687.87) (617,721.53) 212,225.98 1,847,445.51 (501,788.40) (131,389.06) (1,034,843.62) 179,424.43 1.841,756.64 (575,329.80) (47,608.70) (740,638.79) (48,221.72) 429,957.63 Cool Threads 21,113.13 1,218,132.42 (958,890.78) (20,614.58) (106,500.65) 153,239.54 Comer Runner 829,846.81 (761,184.33) (23,576.60) (10,754.64) 34,331.24 Cross Country Mart 21,275.25 1,157,143.73 (1,000,130.34) (28,040.30) (43,937 44) 106,310.90 Family Fit 29,634.98 605,897.95 (596,215.64) (27,011.94) 12,305.35 Fast N FA 947,634.18 (246,877.60) (66,575.66) (600,005.22) 34,175.70 Finishers' World 1,903,919.45 (463,400.00) (312,820.91) (1,109,518 40) (31,377.36) (13,197.22) First Place 1,751,911.73 (1,751,911.73) Fit N Fun 12,786.27 640,859.82 (484,653.02) (17,396.28) (63,529.01) 88,067.78 Goodway 46,520.22 1,714,251.11 (1,428,987.08) (82,443.01) 249,341.24 Great Run 645,068.61 (116.541.60) (17,142.35) (488,854.04) -22,530.62 Hot Sox 3,769,633.46 (877,921.20) (94,713.71) (2,099,484.78) (294,945.82) 402,567.95 Millennial Mile 943,220.13 (251,782.40) (19,287.29) (508,514.87) 163,635.57 Neighborhood Athletic Supply 23,296.70 462,535.80 (437,546.50) (28,603.50) 19,682.50 Northam Lites 138,875.76 694,841.88 (761,820.85) (61,650.14) 10,246.65 Oakland Athletics 706,905.88 (186,084.00) (50,775.30) (461,003.71) 9,042.87 On Your Mark 471,251.80 (149,836.00) (23,615.40) (233,291.00) 64,509.40 Runner's Market 51,416.71 1,848,391.73 (1,648,524.68) (52,437.36) 198,846.40 Southeast Regional 69,706.38 914,597.73 (846,014.28) (19,290.38) (73,864.96) 45,134.49 Southem Runners 68,934.84 2.118,984.90 (1.736,649.68) (322,720.30) 128,549.76 Super Runners Mark 52,430.38 1,788,308.84 (1,594.949.46) (137,556.01) 108,233.75 Track Time 2,168,804.90 (649,420.00) (113,408.88) (1,078,003.02) (117,268 92) 210,704.08 Urban Runner 50.277.96 ValueChoice Grand Total 33,658.30 684,491.19 1,586,305.20 890,681.70 37,333,890.86 (1,324,408.60) (38,905.70) (133,623.28) 139,645.58 (860,637.45) (19,903,579.45) (12,982.86) (2,995,829.03) (50.619.69) (112,410.62) (949,448.65) 3,323,020.20 (10,734,094.10) There are two numbers on this table that should be of concern to you that indicate there is something wrong with the underlying data making up the table. Identify the two numbers and tell me why they are a concern to you. (Note: this data is different from the dataset you will be using for Part 5 of TechWear.) 4. Analyze the chart prepared below. It includes the beginning AR balance for each company at January 1, 2016; 2016 Sales; 2016 Cash Receipts; 2016 adjustments related to errors identified by the auditor; 2017 Cash Receipts (related to the 2016 AR balance); Returns of merchandise soled in 2016 on account; and Write-offs of specific AR balances based on communication between Tech Wear and its customers. CustName Atletico Madrid SA Awesome Threads Best Time Bigmart Boston Marathon Califomia Clothes Cool Runnings OpeningBalance 2016Sales 2016CashReceipt 2016AuditAdjustments 2017Cash Receipt 2017Returns 2017Write-off 153,246.89 Grand Total 153,246.89 619,826.95 (113,970.40) (45,046.55) (605,856.55) (45,046.55) 869,846.81 (171,836.00) (109,274.78) (474,578.06) (64,188.90) 49,969.07 64,564.31 1,108,246.92 (898,323.36) (26,764.14) (92,385.13) 155,338.60 1,114,491.38 (259,856.00) (24,687.87) (617,721.53) 212,225.98 1,847,445.51 (501,788.40) (131,389.06) (1,034,843.62) 179,424.43 1.841,756.64 (575,329.80) (47,608.70) (740,638.79) (48,221.72) 429,957.63 Cool Threads 21,113.13 1,218,132.42 (958,890.78) (20,614.58) (106,500.65) 153,239.54 Comer Runner 829,846.81 (761,184.33) (23,576.60) (10,754.64) 34,331.24 Cross Country Mart 21,275.25 1,157,143.73 (1,000,130.34) (28,040.30) (43,937 44) 106,310.90 Family Fit 29,634.98 605,897.95 (596,215.64) (27,011.94) 12,305.35 Fast N FA 947,634.18 (246,877.60) (66,575.66) (600,005.22) 34,175.70 Finishers' World 1,903,919.45 (463,400.00) (312,820.91) (1,109,518 40) (31,377.36) (13,197.22) First Place 1,751,911.73 (1,751,911.73) Fit N Fun 12,786.27 640,859.82 (484,653.02) (17,396.28) (63,529.01) 88,067.78 Goodway 46,520.22 1,714,251.11 (1,428,987.08) (82,443.01) 249,341.24 Great Run 645,068.61 (116.541.60) (17,142.35) (488,854.04) -22,530.62 Hot Sox 3,769,633.46 (877,921.20) (94,713.71) (2,099,484.78) (294,945.82) 402,567.95 Millennial Mile 943,220.13 (251,782.40) (19,287.29) (508,514.87) 163,635.57 Neighborhood Athletic Supply 23,296.70 462,535.80 (437,546.50) (28,603.50) 19,682.50 Northam Lites 138,875.76 694,841.88 (761,820.85) (61,650.14) 10,246.65 Oakland Athletics 706,905.88 (186,084.00) (50,775.30) (461,003.71) 9,042.87 On Your Mark 471,251.80 (149,836.00) (23,615.40) (233,291.00) 64,509.40 Runner's Market 51,416.71 1,848,391.73 (1,648,524.68) (52,437.36) 198,846.40 Southeast Regional 69,706.38 914,597.73 (846,014.28) (19,290.38) (73,864.96) 45,134.49 Southem Runners 68,934.84 2.118,984.90 (1.736,649.68) (322,720.30) 128,549.76 Super Runners Mark 52,430.38 1,788,308.84 (1,594.949.46) (137,556.01) 108,233.75 Track Time 2,168,804.90 (649,420.00) (113,408.88) (1,078,003.02) (117,268 92) 210,704.08 Urban Runner 50.277.96 ValueChoice Grand Total 33,658.30 684,491.19 1,586,305.20 890,681.70 37,333,890.86 (1,324,408.60) (38,905.70) (133,623.28) 139,645.58 (860,637.45) (19,903,579.45) (12,982.86) (2,995,829.03) (50.619.69) (112,410.62) (949,448.65) 3,323,020.20 (10,734,094.10) There are two numbers on this table that should be of concern to you that indicate there is something wrong with the underlying data making up the table. Identify the two numbers and tell me why they are a concern to you. (Note: this data is different from the dataset you will be using for Part 5 of TechWear.)