1 Type 2 Sales 3 Sales 4 Sales A B C D TransactionNumber Applied ToTransaction Number CustNum CustName E G 1001 1002 1836 Runner's Market 1168 Bigmart 1003 1167 Goodway 5 Sales 1004 6 Sales 1005 1841 Neighborhood Athletic Supply 1842 Northern Lites 7 Sales 1005 8 Sales 1007 1168 Bigmart 1167 Goodway TransactionDate Amount 5-Mar-15 $ 16,157.44 5-Mar-15 $9,144.00 5-Mar-15 $ 16,737.60 8-Mar-15 $ 6,008.00 8-Mar-15 $ 7,241.60 13-Mar-15 $ 8,476.00 InvoiceDate ShipDate 13-Mar-15 $ 15,737.60 9 Sales 1008 1814 ValueChoice 13-Mar-15 $ 9,084.40 10 Sales 1009 1841 Neighborhood Athletic Supply 16-Mar-15 $ 4,240.00 11 Sales 1010 1842 Northern Lites 16-Mar-15 $ 5,993.60 12 Sales 1011 1843 Southeast Regional 13 Sales 1012 14 Sales 1013 15 Sales 1014 16 Sales 1015 17 Sales 1016 18 Sales 1017 19 Sales 1018 20 Sales 1019 21 Sales 1020 1838 Urban Runner 22 Sales 1021 1661 Family Fit 1863 Fit N Fun 1864 Cross Country Mart 1840 Super Runners Mark 1841 Neighborhood Athletic Supply 1842 Northern Lites 1167 Goodway 1814 ValueChoice 1863 Fit N Fun 16-Mar-15 $ 9,019.12 23-Mar-15 $ 6,552.40 23 Sales 1022 1864 Cross Country Mart 24 Sales 1023 1861 Family Fit 25 Sales 1024 1862 Corner Runner 26 Sales 1025 1840 Super Runners Mark 27 Sales 1026 1841 Neighborhood Athletic Supply 23-Mar-15 $ 5,008.64 23-Mar-15 $ 11,113.60 27-Mar-15 $ 17,677.04 27-Mar-15 $ 4,240.00 30-Mar-15 $ 7,241.60 2-Apr-15 $ 19,672.00 3-Apr-15 $ 6,975.00 3-Apr-15 $ 16,230.00 6-Apr-15 $ 7,330.80 6-Apr-15 $ 13,892.00 6-Apr-15 $ 8,074.40 6-Apr-15 $ 9,642.00 10-Apr-15 $ 22,096.30 10-Apr-15 $ 7,510.00 28 Sales 1027 29 Sales 1028 30 Sales 1029 31 Sales 1030 32 Sales 1031 33 Sales 1032 34 Sales 1033 35 Sales 1034 36 Sales 1035 37 Sales 1036 38 Sales 1037 39 Sales 1038 40 Sales 41 Sales 1040 1039 1842 Northern Lites 1861 Family Fit 1842 Northern Lites 1843 Southeast Regional 1836 Runner's Market 1841 Neighborhood Athletic Supply 1168 Bigmart 1837 Cool Threads 1841 Neighborhood Athletic Supply 1814 ValueChoice 1167 Goodway 1861 Family Fil 1837 Cool Threads 1842 Northern Lites 12-Apr-15 $ 9,052.00 17-Apr-15 $ 8,190.50 17-Apr-15 $ 9,052.00 5-Mar-15 5-Mar-15 5-Mar-15 5-Mar-15 5-Mar-15 5-Mar-15 8-Mar-15 8-Mar-15 8-Mar-15 8-Mar-15 13-Mar-15 13-Mar-15 13-Mar-15 13-Mar-15 13-Mar-15 13-Mar-15 16-Mar-15 16-Mar-15 16-Mar-15 16-Mar-15 16-Mar-15 16-Mar-15 23-Mar-15 23-Mar-15 23-Mar-15 23-Mar-15 23-Mar-15 23-Mar-15 27-Mar-15 27-Mar-15 27-Mar-15 27-Mar-15 30-Mar-15 30-Mar-15 2-Apr-15 2-Apr-15 3-Apr-15 3-Apr-15 3-Apr-15 3-Apr-15 6-Apr-15 6-Apr-15 6-Apr-15 6-Apr-15 6-Apr-15 6-Apr-15 6-Apr-15 6-Apr-15 10-Apr-15 10-Apr-15 10-Apr-15 10-Apr-15 12-Apr-15 12-Apr-15 17-Apr-15 17-Apr-15 17-Apr-15 17-Apr-15 17-Apr-15 $ 11,273.90 17-Apr-15 17-Apr-15 23-Apr-15 $ 19,571.80 23-Apr-15 $1,300.00 23-Apr-15 $ 835.00 23-Apr-15 $ 7,600.00 23-Apr-15 $ 702.00 23-Apr-15 $ 4,380.50 23-Apr-15 $ 19,312.00 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 23-Apr-15 24-Apr-15 $ 8,074.40 24-Apr-15 24-Apr-15 24-Apr-15 $ 14,092.60 24-Apr-15 24-Apr-15 27-Apr-15 $ 9,052.00 27-Apr-15 27-Apr-15 42 Sales 1041 1843 Southeast Regional 27-Apr-15 $ 11,119.10 27-Apr-15 27-Apr-15 43 Sales 1042 44 Sales 1043 45 Sales 1044 46 Sales 1045 47 Sales 1045 48 Sales 1047 49 Sales 1048 50 Sales 1049 51 Sales 52 Sales 1051 53 Sales 1052 54 Sales 1053 55 Sales 1054 1050 1168 Bigmart 1814 ValueChoice 1837 Cool Threads 1168 Bigmart 1862 Corner Runner 1863 Fit N Fun 1842 Northern Lites 1843 Southeast Regional 1861 Family Fit 1839 Southern Runners 1840 Super Runners Mark 1841 Neighborhood Athletic Supply 1861 Family Fit 1-May-15 $ 663.60 1-May-15 1-May-15 1-May-15 $ 8,641.08 1-May-15 $ 11,424.67 1-May-15 1-May-15 1-May-15 1-May-15 4-May-15 $ 520.80 4-May-15 4-May-15 4-May-15 $ 7,851.48 4-May-15 4-May-15 4-May-15 $ 11-May-15 $ 11-May-15 $ 6,159.72 7,603 68 9,340.04 4-May-15 4-May-15 11-May-15 11-May-15 11-May-15 $ 6,880.02 11-May-15 11-May-15 11-May-15 11-May-15 15-May-15 $ 20,832.00 15-May-15 $ 18,528.38 15-May-15 $ 3,015.60 15-May-15 15-May-15 15-May-15 15-May-15 15-May-15 15-May-15 18-May-15 $ 6,555.70 18-May-15 18-May-15 56 Sales 1055 57 Sales 1056 1843 Southeast Regional 1840 Super Runners Mark 18-May-15 $ 9,537.44 18-May-15 18-May-15 22-May-15 $ 18,713.67 22-May-15 22-May-15 58 Sales 1057 1842 Northern Lites 25-May-15 $ 7,125.23 25-May-15 25-May-15 50 Sales 1058 1839 Southern Runners 27-May-15 $ 21,258.94 27-May-15 27-May-15 60 Sales 1059 1841 Neighborhood Athletic Supply 27-May-15 $ 3,071.88 27-May-15 27-May-15 61 Sales 1060 62 Sales 1061 63 Sales 1062 64 Sales 1063 1840 Super Runners Mark 1838 Urban Runner 1842 Northern Lites 1167 Goodway 27-May-15 $ 18,899.93 27-May-15 27-May-15 27-May-15 $ 18,766.27 27-May-15 27-May-15 29-May-15 $ 3,408.72 65 Sales 1064 1843 Southeast Regional 66 Sales 1065 1842 Northern Lites 67 Sales 1066 68 Sales 1067 69 Sales 1068 70 Sales 1069 71 Sales 1070 72 Sales 1071 73 Sales 1072 74 Sales 1073 75 Sales 1074 76 Sales 1075 77 Sales 1076 78 Sales 1077 79 Sales 1078 80 Sales 1079 81 Sales 1000 82 Sales 1081 83 Sales 1082 84 Sales 1083 85 Sales 1084 86 Sales 1085 87 Sales 1086 1861 Family Fit 1861 Family Fit 1862 Corner Runner 1863 Fit N Fun 1864 Cross Country Mart 1168 Bigmart 1861 Family Fil 1842 Northern Lites 1863 Fit N Fun 1862 Corner Runner 1837 Cool Threads 1840 Super Runners Mark 1842 Northern Lites 1843 Southeast Regional 1861 Family Fit 1843 Southeast Regional 1836 Runner's Market 1862 Corner Runner 1167 Goodway 1836 Runner's Market 1814 ValueChoice 29-May-15 $ 5,066.88 29-May-15 $ 10,341.24 2-Jun-15 $ 8,391.94 2-Jun-15 $ 7,813.39 29-May-15 29-May-15 29-May-15 29-May-15 29-May-15 29-May-15 2-Jun-15 2-Jun-15 2-Jun-15 2-Jun-15 5-Jun-15 $ 7,896.37 5-Jun-15 5-Jun-15 8-Jun-15 $ 9,441.82 8-Jun-15 $ 7,441.67 8-Jun-15 $ 13,940.70 11-Jun-15 $ 11,738.30 12-Jun-15 $ 7,979.70 12-Jun-15 $ 8,551.80 15-Jun-15 $ 7,527.80 15-Jun-15 $ 9,537.44 19-Jun-15 $ 13,744.34 19-Jun-15 $ 22,709.74 8-Jun-15 8-Jun-15 8-Jun-15 8-Jun-15 8-Jun-15 8-Jun-15 11-Jun-15 11-Jun-15 12-Jun-15 12-Jun-15 12-Jun-15 12-Jun-15 15-Jun-15 15-Jun-15 15-Jun-15 15-Jun-15 19-Jun-15 19-Jun-15 19-Jun-15 19-Jun-15 22-Jun-15 $ 8,632.26 22-Jun-15 22-Jun-15 22-Jun-15 $ 11,688.63 29-Jun-15 $ 8,147.34 22-Jun-15 22-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 $ 11,805.61 29-Jun-15 29-Jun-15 88 Sales 1087 1840 Super Runners Mark 89 Sales 1088 1841 Neighborhood Athletic Supply 90 Sales 1089 1843 Southeast Regional 29-Jun-15 $ 19,709.89 29-Jun-15 $ 9,731.16 2-Jul-15 $ 22,114.82 2-Jul-15 $ 23,674.76 3-Jul-15 $ 12,327.94 3-Jul-15 $ 26,463.75 3-Jul-15 $ 4,283.44 6-Jul-15 $ 13,625.81 29-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 2-Jul-15 2-Jul-15 2-Jul-15 2-Jul-15 3-Jul-15 3-Jul-15 3-Jul-15 3-Jul-15 3-Jul-15 3-Jul-15 6-Jul-15 6-Jul-15 91 Sales 1090 1842 Northern Lites 92 Sales 1091 on sales 1000 1864 Cross Country Mart 1963 FILES. 6-Jul-15 $ 10,051.11 6-Jul-15 $ 16,594.74 15 8.000 72 6-Jul-15 6-Jul-15 6-Jul-15 6-Jul-15 615 615 > 2015 data + 1 Type 92 Sales 93 Sales 94 Sales A B D TransactionNumber Applied To Transaction Number CustNum CustName G 1091 1092 1093 1864 Cross Country Mart 1863 F N Fun 1168 Bigmart 95 Sales 1094 1862 Corner Runner 96 Sales 1095 1837 Cool Threads 97 Sales 1096 98 Sales 1097 1840 Super Runners Mark 1863 Fit N Fun 99 Sales 100 Sales 1099 101 Sales 102 Sales 1101 103 Sales 1102 1098 1100 1842 Northern Lites 1843 Southeast Regional 1168 Bigmart 1842 Northern Lites 1864 Cross Country Mart 104 Sales 1103 1839 Southern Runners 105 Sales 1104 106 Sales 1105 107 Sales 1106 1842 Northern Lites 1814 ValueChoice 1862 Corner Runner TransactionDate Amount 6-Jul-15 $ 16,594.74 6-Jul-15 $ 8,902.72 15-Jul-15 $ 7,527.80 15-Jul-15 $ 9,537.44 17-Jul-15 $ 13,744.34 17-Jul-15 $ 22,709.74 20-Jul-15 $ 9.105.39 20-Jul-15 $ 16,932.51 21-Jul-15 $ 8,632 26 21-Jul-15 $ 11,688.63 21-Jul-15 $ 25,976.16 22-Jul-15 $ 8,212.96 22-Jul-15 $ 49,452.37 22-Jul-15 $ 23,758.22 InvoiceDate ShipDate 6-Jul-15 6-Jul-15 6-Jul-15 6-Jul-15 15-Jul-15 15-Jul-15 15-Jul-15 15-Jul-15 17-Jul-15 17-Jul-15 17-Jul-15 17-Jul-15 20-Jul-15 20-Jul-15 20-Jul-15 20-Jul-15 21-Jul-15 21-Jul-15 21-Jul-15 21-Jul-15 21-Jul-15 21-Jul-15 22-Jul-15 22-Jul-15 22-Jul-15 22-Jul-15 24-Jul-15 $ 12,687.02 22-Jul-15 22-Jul-15 24-Jul-15 24-Jul-15 3-Aug-15 $ 12,421.74 3-Aug-15 3-Aug-15 108 Sales 1107 1863 Fit N Fun 3-Aug-15 $ 9,895.25 3-Aug-15 3-Aug-15 109 Sales 1108 1864 Cross Country Mart 3-Aug-15 $ 18,357.25 3-Aug-15 3-Aug-15 110 Sales 1109 1843 Southeast Regional 6-Aug-15 $ 13,328.83 6-Aug-15 6-Aug-15 111 Sales 1110 1814 ValueChoice 7-Aug-15 $ 13,231.73 7-Aug-15 7-Aug-15 112 Sales 1111 113 Sales 1112 1842 Northern Lites 1167 Goodway 7-Aug-15 $ 9,608.54 7-Aug-15 7-Aug-15 7-Aug-15 $ 11,152.68 7-Aug-15 7-Aug-15 114 Sales 1113 115 Sales 1114 116 Sales 1115 117 Sales 1116 118 Sales 1117 1843 Southeast Regional 1841 Neighborhood Athletic Supply 1861 Family Fit 1843 Southeast Regional 1836 Runner's Market 7-Aug-15 $ 8,723.65 7-Aug-15 7-Aug-15 119 Sales 1118 120 Sales 1119 1841 Neighborhood Athletic Supply 1842 Northern Lites 121 Sales 1120 122 Sales 1121 1843 Southeast Regional 1168 Bigmart 10-Aug-15 $ 10-Aug-15 $ 10,516.60 10-Aug-15 $ 15,195.80 10-Aug-15 $ 19,040.00 10-Aug-15 $ 2,825.06 18-Aug-15 $ 13,513.05 20-Aug-15 $ 6,771.10 20-Aug-15 $ 10,771.88 4,757.86 123 Sales 1122 124 Sales 1123 125 Sales 1124 126 Sales 1125 1838 Urban Runner 1843 Southeast Regional 1836 Runner's Market 1839 Southern Runners 20-Aug-15 $ 13,231.73 20-Aug-15 $ 9,608.54 26-Aug-15 $ 10,771.88 26-Aug-15 $ 13,231.73 10-Aug-15 10-Aug-15 10-Aug-15 10-Aug-15 10-Aug-15 10-Aug-15 10-Aug-15 10-Aug-15 10-Aug-15 10-Aug-15 18-Aug-15 18-Aug-15 20-Aug-15 20-Aug-15 20-Aug-15 20-Aug-15 20-Aug-15 20-Aug-15 20-Aug-15 20-Aug-15 26-Aug-15 26-Aug-15 26-Aug-15 26-Aug-15 127 Sales 1126 128 Sales 1127 129 Sales 1128 130 Sales 1129 131 Sales 1130 132 Sales 1131 133 Sales 1132 134 Sales 1133 135 Sales 1134 136 Sales 1135 1864 Cross Country Mart 1862 Corner Runner 1814 ValueChoice 1837 Cool Threads 1861 Family Fit 1843 Southeast Regional 1842 Northern Lites 1840 Super Runners Mark 1843 Southeast Regional 1168 Bigmart 31-Aug-15 $ 18,917.60 31-Aug-15 31-Aug-15 31-Aug-15 $ 12,798.02 31-Aug-15 31-Aug-15 31-Aug-15 $ 14,034.27 31-Aug-15 31-Aug-15 31-Aug-15 $ 18,241.81 31-Aug-15 31-Aug-15 7-Sep-15 $ 12,419.54 7-Sep-15 7-Sep-15 7-Sep-15 $ 17,941.92 7-Sep-15 $ 14,103.74 7-Sep-15 7-Sep-15 10-Sep-15 $ 29,830.01 7-Sep-15 7-Sep-15 10-Sep-15 10-Sep-15 10-Sep-15 $ 7,155.00 10-Sep-15 10-Sep-15 11-Sep-15 $ 18,400.58 11-Sep-15 11-Sep-15 137 Sales 1136 138 Sales 1137 1841 Neighborhood Athletic Supply 1862 Corner Runner 11-Sep-15 $ 11,184.75 11-Sep-15 11-Sep-15 11-Sep-15 $ 14,055.44 11-Sep-15 11-Sep-15 139 Sales 1138 140 Sales 1139 141 Sales 1140 142 Sales 1141 143 Sales 1142 144 Sales 1143 145 Sales 1144 146 Sales 1145 147 Sales 1146 148 Sales 1147 1838 Urban Runner 1168 Bigmart 1839 Southern Runners 1836 Runner's Market 1167 Goodway 1168 Bigmart 1837 Cool Threads 1861 Family Fit 1814 ValueChoice 1168 Bigmart 11-Sep-15 $ 1,674.00 11-Sep-15 11-Sep-15 17-Sep-15 $ 18,479.10 22-Sep-15 $ 17-Sep-15 17-Sep-15 843.75 22-Sep-15 22-Sep-15 22-Sep-15 $ 9,101.70 22-Sep-15 22-Sep-15 23-Sep-15 $ 15,329.93 24-Sep-15 $ 25-Sep-15 $ 12,220.20 23-Sep-15 23-Sep-15 7,155.00 24-Sep-15 24-Sep-15 25-Sep-15 25-Sep-15 28-Sep-15 $ 9,402.08 28-Sep-15 28-Sep-15 28-Sep-15 $ 9,175.14 28-Sep-15 28-Sep-15 149 Sales 1148 150 Sales 1149 1840 Super Runners Mark 1168 Bigmart 151 Sales 1150 152 Sales 1151 153 Sales 1152 154 Sales 1153 155 Sales 1154 156 Sales 1155 157 Sales 1156 158 Sales 1157 1837 Cool Threads 1814 ValueChoice 1863 Fil N Fun 1837 Cool Threads 1167 Goodway 1168 Bigmart 1863 Fit N Fun 1862 Corner Runner 30-Sep-15 $ 9,416.25 30-Sep-15 $ 19,137.74 1-Oct-15 $ 7,681.50 2-Oct-15 $ 14,966.69 2-Oct-15 $ 9,684.87 5-Oct-15 $ 13,052.49 6-Oct-15 $ 16,287.75 6-Oct-15 $ 28,032.60 30-Sep-15 30-Sep-15 30-Sep-15 30-Sep-15 1-Oct-15 1-Oct-15 2-Oct-15 2-Oct-15 2-Oct-15 2-Oct-15 5-Oct-15 5-Oct-15 6-Oct-15 6-Oct-15 159 Sales 1158 1842 Northern Lites 8-Oct-15 $ 19,505.72 15-Oct-15 $ 13,052.49 15-Oct-15 $ 17,234.59 15-Oct-15 $ 11,061.21 6-Oct-15 6-Oct-15 8-Oct-15 8-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 160 Sales 1159 1843 Southeast Regional 15-Oct-15 $ 13,742 20 15-Oct-15 15-Oct-15 161 Sales 1160 162 Sales 1161 163 Sales 1162 164 Sales 1163 165 Sales 1164 1837 Cool Threads 1862 Corner Runner 1863 Fil N Fun 1836 Runner's Market 1843 Southeast Regional 16-Oct-15 $ 14,966.69 19-Oct-15 $ 17,234.59 16-Oct-15 16-Oct-15 19-Oct-15 19-Oct-15 19-Oct-15 $ 13,052.49 19-Oct-15 19-Oct-15 20-Oct-15 $ 1,852.50 20-Oct-15 20-Oct-15 21-Oct-15 $ 23,127.75 21-Oct-15 21-Oct-15 166 Sales 1165 167 Sales 1166 1861 Family Fit 1863 Fit N Fun 168 Sales 1167 1864 Cross Country Mart 23-Oct-15 $ 9,924.41 26-Oct-15 $ 13,052.49 26-Oct-15 $ 20,636.35 23-Oct-15 23-Oct-15 26-Oct-15 26-Oct-15 26-Oct-15 26-Oct-15 169 Sales 1168 170 Sales 1169 171 Sales 1170 1838 Urban Runner 1836 Runner's Market 1842 Northern Lites 28-Oct-15 S 788.03 28-Oct-15 28-Oct-15 28-Oct-15 $ 14,658.00 28-Oct-15 28-Oct-15 172 Sales 1171 173 Sales 1172 174 Sales 1173 175 Sales 1174 1864 Cross Country Mart 1839 Southern Runners 1837 Cool Threads 1168 Bigmart 176 Sales 1175 177 Sales 1176 178 Sales 1177 179 Sales 1178 1838 Urban Runner 1840 Super Runners Mark 1842 Northern Lites 1861 Family Fit 28-Oct-15 $ 19,381.14 28-Oct-15 $ 21,275.25 29-Oct-15 $ 912.00 4-Nov-15 $ 12,287.05 5-Nov-15 $ 20,019.02 5-Nov-15 $ 8,321.63 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 29-Oct-15 29-Oct-15 4-Nov-15 5-Nov-15 5-Nov-15 4-Nov-15 5-Nov-15 5-Nov-15 180 Sales 1179 181 Sales 1180 182 Sales 1181 183 Bales 1182 1814 ValueChoice 1837 Cool Threads 1839 Southern Runners 1963 EN EVA 0 Nov 15 $ 5-Nov-15 $ 1,164.15 5-Nov-15 $ 13,454.51 5-Nov-15 $ 20,019.02 6-Nov-15 $ 9,939.74 6-Nov-15 $ 15,360.55 6-Nov-15 $ 9.939 74 13.305.08. 5-Nov-15 5-Nov-15 5-Nov-15 5-Nov-15 5-Nov-15 5-Nov-15 6-Nov-15 6-Nov-15 6-Nov-15 6-Nov-15 6-Nov-15 0 Nov 15 Now 35 6-Nov-15 2015 data A B D E G Type 182 Sales 183 Sales TransactionNumber Applied To Transaction Number CustNum CustName 1181 1839 Southern Runners 1182 1863 Fit N Fun 184 Sales 1183 185 Sales 1184 186 Sales 1185 1168 Bigmart 1838 Urban Runner 1167 Goodway 187 Sales 1186 1839 Southern Runners 188 Sales 1187 1840 Super Runners Mark 189 Sales 1188 190 Sales 1189 191 Sales 1190 1838 Urban Runner 1842 Northern Lites 1836 Runner's Market 192 Sales 1191 193 Sales 1192 194 Sales 1193 1840 Super Runners Mark 1837 Cool Threads 1167 Goodway 195 Sales 1194 196 Sales 1195 197 Sales 1196 1839 Southern Runners 1168 Bigmart 1842 Northern Lites 198 Sales 1197 199 Sales 1198 200 Sales 1199 1840 Super Runners Mark 1839 Southern Runners 1167 Goodway 201 Sales 1200 1842 Northern Lites 202 Sales 1201 1841 Neighborhood Athletic Supply 203 Sales 1202 1838 Urban Runner 204 Sales 1203 205 Sales 1204 1842 Northern Lifes 1168 Bigmart 206 Sales 1205 207 Sales 1206 208 Sales 1207 209 Sales 1208 1839 Southern Runners 1836 Runner's Market 1840 Super Runners Mark 1838 Urban Runner TransactionDate Amount 6-Nov-15 $ 9,939.74 9-Nov-15 $ 13,395.98 10-Nov-15 $ 14,816.13 10-Nov-15 $ 17,765 95 11-Nov-15 $ 21,835.13 11-Nov-15 $ 12,116.81 12-Nov-15 $ 5,250.38 12-Nov-15 $ 15,445.09 13-Nov-15 $10,724.51 13-Nov-15 $ 13,669.99 16-Nov-15 $ 18,141.76 17-Nov-15 $ 14.964.64 17-Nov-15 $ 11,889.85 18-Nov-15 $ 15,195.18 20-Nov-15 $ 23,462 23 23-Nov-15 $5,740.31 25-Nov-15 $ 15,345.63 30-Nov-15 $ 13,618.43 30-Nov-15 $ 12,795.24 1-Dec-15 $ 9,939.74 2-Dec-15 $ 11,735 30 4-Dec-15 $ 14,162.74 4-Dec-15 $ 17,000.53 4-Dec-15 $ 13,464.67 11-Dec-15 $ 14,306.15 14-Dec-15 $ 13,464.67 InvoiceDate ShipDate 6-Nov-15 6-Nov-15 9-Nov-15 9-Nov-15 10-Nov-15 10-Nov-15 10-Nov-15 10-Nov-15 11-Nov-15 11-Nov-15 11-Nov-15 11-Nov-15 12-Nov-15 12-Nov-15 12-Nov-15 12-Nov-15 13-Nov-15 13-Nov-15 13-Nov-15 13-Nov-15 16-Nov-15 16-Nov-15 17-Nov-15 17-Nov-15 17-Nov-15 17-Nov-15 18-Nov-15 18-Nov-15 20-Nov-15 20-Nov-15 23-Nov-15 23-Nov-15 25-Nov-15 25-Nov-15 30-Nov-15 30-Nov-15 30-Nov-15 30-Nov-15 1-Dec-15 1-Dec-15 2-Dec-15 2-Dec-15 4-Dec-15 4-Dec-15 4-Dec-15 4-Dec-15 4-Dec-15 4-Dec-15 11-Dec-15 11-Dec-15 14-Dec-15 14-Dec-15 210 Sales 1209 1837 Cool Threads 14-Dec-15 $ 17,778.84 17-Dec-15 $ 6,264.99 17-Dec-15 $ 12,786.27 14-Dec-15 14-Dec-15 17-Dec-15 17-Dec-15 17-Dec-15 17-Dec-15 211 Sales 1210 1814 ValueChoice 18-Dec-15 $ 9,542.40 18-Dec-15 18-Dec-15 212 Sales 1211 1841 Neighborhood Athletic Supply 213 Sales 1212 1861 Family Fit 214 Sales 1213 215 Sales 1214 216 Sales 1215 217 Sales 1216 218 Sales 1217 219 Sales 1218 1863 Fit N Fun 1842 Northern Lites 1838 Urban Runner 1843 Southeast Regional 1838 Urban Runner 1836 Runner's Market 18-Dec-15 $ 11,561.40 21-Dec-15 $ 9,615.96 21-Dec-15 $ 12,786.27 21-Dec-15 $ 17,328.80 21-Dec-15 $ 12,786.27 22-Dec-15 $ 11,039.70 23-Dec-15 $ 830.84 23-Dec-15 $ 23,293.06 18-Dec-15 18-Dec-15 21-Dec-15 21-Dec-15 21-Dec-15 21-Dec-15 21-Dec-15 21-Dec-15 21-Dec-15 21-Dec-15 22-Dec-15 22-Dec-15 220 Sales 1219 221 Sales 1220 1843 Southeast Regional 1842 Northern Lifes 23-Dec-15 $ 16,029.20 23-Dec-15 4-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 222 Sales 1221 223 Sales 1222 224 Sales 1223 1843 Southeast Regional 1837 Cool Threads 1842 Northern Lites 23-Dec-15 $ 20,819.88 23-Dec-15 $ 9,990.71 23-Dec-15 $ 830.84 24-Dec-15 $ 11,410.51 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 24-Dec-15 24-Dec-15 225 Sales 1224 226 Sales 1225 227 Sales 1226 228 Sales 1227 1814 ValueChoice 1843 Southeast Regional 1842 Northern Lites 1168 Bigmart 24-Dec-15 $ 14,176.16 28-Dec-15 $ 18,904.57 28-Dec-15 $ 14,462.35 28-Dec-15 $ 12,821.28 24-Dec-15 24-Dec-15 28-Dec-15 6-Jan-16 28-Dec-15 6-Jan-16 28-Dec-15 6-Jan-16 229 Sales 1228 1839 Southern Runners 28-Dec-15 $ 12,786.27 28-Dec-15 28-Dec-15 230 Sales 1229 1842 Northern Lites 231 Sales 1230 1837 Cool Threads 30-Dec-15 $ 25,838.52 31-Dec-15 $ 7,496.02 30-Dec-15 30-Dec-15 31-Dec-15 6-Jan-16 232 CashReceipt 11001 1001 1836 Runner's Market 25-Mar-15 $ (16,157.44) 233 CashReceipt 11002 1002 1168 Bigmart 8-Apr-15 $ (9,144.00) 234 CashReceipt 11003 1003 1167 Goodway 16-Apr-15 $ (15,737.60) 235 CashReceipt 11004 1004 1841 Neighborhood Athletic Supply 9-Apr-15 $ (6,008.00) 236 CashReceipt 11005 1005 1842 Northern Lites 3-Apr-15 $ (7.241.60) 237 CashReceipt 11005 1006 1168 Bigmart 22-Apr-15 $ (8,476.00) 238 CashReceipt 11007 1007 1167 Goodway 30-Apr-15 $ (15,737.60) 239 CashReceipt 11008 1008 1814 ValueChoice 4-May-15 $ (9,084.40) 240 CashReceipt 11009 1009 1841 Neighborhood Athletic Supply 19-May-15 $ (4,240.00) 241 CashReceipt 11010 1010 1842 Northern Lites 28-May-15 $ (5,093.60) 242 CashReceipt 11011 1011 1843 Southeast Regional 12-May-15 $ (9,019.12) 243 CashReceipt 11012 1012 1861 Family Fit 2-May-15 $ (6,552.40) 244 CashReceipt 11013 1013 1863 Fit N Fun 25-May-15 $ (5,008.64) 245 CashReceipt 11014 1014 1864 Cross Country Mart 7-May-15 $ (11,113.60) 246 CashReceipt 11015 1015 1840 Super Runners Mark 14-May-15 $ (17,677.04) 247 CashReceipt 11016 1016 1841 Neighborhood Athletic Supply 18-May-15 $ (4,240.00) 248 CashReceipt 11017 1017 1842 Northern Lites 22-Apr-15 $ (7,241.60) 249 CashReceipt 11018 1018 1167 Goodway 30-Apr-15 $ (19,672.00) 250 CashReceipt 11019 1019 1814 ValueChoice 7-May-15 $ (6,975.00) 251 CashReceipt 11020 1020 1838 Urban Runner 19-May-15 $ (16,230.00) 252 CashReceipt 11021 1021 1863 Fit N Fun 29-May-15 $ (7,330.80) 253 CashReceipt 11022 1022 1864 Cross Country Mart 254 CashReceipt 11023 1023 1861 Family Fit 255 CashReceipt 11024 1024 1862 Corner Runner 256 CashReceipt 11025 1025 1840 Super Runners Mark 257 CashReceipt 11026 1026 1841 Neighborhood Athletic Supply 11-May-15 $ (13,892.00) 14-May-15 $ (8,074.40) 25-May-15 $ (9,642.00) 8-Jun-15 $ (22,096.30) 10-May-15 $ (7,510.00) 258 CashReceipt 11027 1027 1842 Northern Lites 16-May-15 $ (9,052.00) 259 CashReceipt 11028 1028 1861 Family Fit 10-Jun-15 $ (8,190.50) 260 CashReceipt 11029 1029 1842 Northern Lites 11-May-15 $ (9,052 00) 261 CashReceipt 11030 1030 1843 Southeast Regional 15-May-15 $ (11,273.90) 262 CashReceipt 11031 1031 1836 Runner's Market 23-May-15 $ (19,571.80) 263 CashReceipt 11032 1032 1841 Neighborhood Athletic Supply 29-May-15 $ (1,300.00) 264 Cash Receipt 11033 1033 1168 Bigmart 265 CashReceipt 11034 1034 1837 Cool Threads 4-Jun-15 $ (835.00) 18-Jul-15 $ (7,600.00) 266 CashReceipt 11035 1035 267 CashReceipt 11036 1036 1814 ValueChoice 268 CashReceipt 11037 1037 1167 Goodway 269 CashReceipt 11038 1038 1861 Family Fit 270 CashReceipt 11039 1039 1837 Cool Threads 1841 Neighborhood Athletic Supply (702.00) 6-Jul-15 $ 20-Jun-15 $ (4,380.50) 10-Jun-15 $ (19,312.00) 3-Jul-15 $ (8,074.40) 25-Jun-15 $ (14,002 60) 271 CashReceipt 11040 1040 1842 Northern Lites 23-Jun-15 $ (9,002.00) 272 CashReceipt 11041 1041 1843 Southeast Regional 11042 1042 1168 Blamart 5 Jun 15 26-Jun-15 $ (11,119.10) 1663.601 2015 data A B C D E 1 Type 272 CashReceipt TransactionNumber Applied ToTransaction Number CustNum CustName 11041 1041 1843 Southeast Regional 273 CashReceipt 11042 1042 1168 Bigmart 274 CashReceipt 11043 1043 1814 ValueChoice 275 Cash Receipt 11044 1044 1837 Cool Threads 276 Cash Receipt 11045 1045 1168 Bigmart 277 CashReceipt 11046 1046 1862 Corner Runner 278 Cash Receipt 11047 1047 1863 Fit N Fun 279 CashReceipt 11048 1048 1842 Northern Lites 280 CashReceipt 11049 1049 1843 Southeast Regional 281 Cash Receipt 11050 1050 1861 Family Fit 282 Cash Receipt 11051 1051 1839 Southern Runners 283 CashReceipt 11052 1052 1840 Super Runners Mark 284 CashReceipt 11053 1053 1841 Neighborhood Athletic Supply 285 CashReceipt 11054 1054 1861 Family Fit 286 CashReceipt 11055 1055 1843 Southeast Regional 287 CashReceipt 11056 1056 1840 Super Runners Mark 288 Cash Receipt 11057 1057 1842 Northern Lites 289 Cash Receipt 11058 1058 1839 Southern Runners 290 Cash Receipt 11059 1059 1841 Neighborhood Athletic Supply 291 CashReceipt 11060 1060 1840 Super Runners Mark 292 CashReceipt 11061 1061 1838 Urban Runner 293 CashReceipt 11062 1062 1842 Northern Lites 294 Cash Receipt 11063 1063 1167 Goodway 295 CashReceipt 11064 1064 1843 Southeast Regional TransactionDate Amount 26-Jun-15 $ (11,119.10) 5-Jun-15 $ (663.60) 31-May-15 $ (8,641.08) 5-Jun-15 $ (11,424.67) 19-Jun-15 $ (520.80) 26-Jun-15 $ (7,851.48) 24-Jun-15 $ (6,159.72) 22-Jun-15 $ (7,603.68) 2-Jul-15 $ (9,340.04) 10-Jul-15 $ (6,880.02) 7-Jul-15 $ (20,832.00) 29-Jul-15 $ (18,528.38) 21-Jul-15 $ (3,015.60) 20-Jul-15 $ (6,555.70) 23-Jul-15 $ (9,537.44) 30-Jun-15 $ (18,713.67) 6-Jul-15 $ (7,125.23) 18-Jul-15 $ (21,258.94) 30-Jul-15 $ (3,071.88) 7-Aug-15 $ (18,899.93) 20-Jul-15 $ (18,766.27) 13-Jul-15 $ (3,408.72) 23-Jul-15 $ (5,066.88) 18-Jul-15 $ (10,341.24) H InvoiceDate 296 Cash Receipt 11065 1065 1842 Northern Lites 297 Cash Receipt 11066 1066 1861 Family Fit 298 Cash Receipt 11067 1067 1861 Family Fit 299 CashReceipt 11068 1068 1862 Corner Runner 7-Jul-15 $ (8,391.94) 10-Jul-15 $ (7,813.39) 3-Aug-15 $ (7,896.37) 15-Jul-15 $ (9,441.82) 300 CashReceipt 11069 1069 1863 Fit N Fun 301 CashReceipt 11070 1070 1864 Cross Country Mart 302 Cash Receipt 11071 1071 1168 Bigmart 9-Jul-15 $ (7,441.67) 31-Jul-15 $ (13,940.70) 13-Aug-15 $ (11,738.30) 303 Cash Receipt 11072 1072 1861 Family Fit 304 Cash Receipt 11073 1073 1842 Northern Lites 20-Jul-15 $ (7,979.70) 23-Jul-15 $ (8,551.80) 305 Cash Receipt 11074 1074 1863 Fit N Fun 306 Cash Receipt 11075 1075 1862 Corner Runner 11-Aug-15 $ (7,527.80) 22-Jul-15 $ (9,537.44) 307 CashReceipt 11076 1076 1837 Cool Threads 20-Jul-15 $ (13,744.34) 308 CashReceipt 11077 1077 1840 Super Runners Mark 309 Cash Receipt 11078 1078 1842 Northern Lites 3-Aug-15 $ (22,709.74) 13-Aug-15 $ (8,632.26) 310 Cash Receipt 11079 1079 1843 Southeast Regional 17-Aug-15 $ (11,688.63) 311 CashReceipt 11080 1080 1861 Family Fit 312 Cash Receipt 11081 1081 1843 Southeast Regional 7-Sep-15 $ (8,147.34) 15-Sep-15 $ (11,805.61) 313 Cash Receipt 11082 1082 1836 Runner's Market 314 Cash Receipt 11083 1083 1862 Corner Runner 31-Aug-15 $ (19,709.89) 26-Aug-15 $ (9,731.16) 315 CashReceipt 11084 1084 1167 Goodway 21-Sep-15 $ (22,114.82) 316 CashReceipt 11085 1085 1836 Runner's Market 11-Sep-15 $ (23,674.76) 317 CashReceipt 11086 1086 1814 ValueChoice 9-Sep-15 $ (12,327.94) 318 Cash Receipt 11087 1087 1840 Super Runners Mark 13-Sep-15 $ (26,463.75) 319 CashReceipt 11088 1088 1841 Neighborhood Athletic Supply 14-Aug-15 $ (4,283.44) 320 Cash Receipt 11089 1089 1843 Southeast Regional 21-Aug-15 $ (13,625.81) 321 Cash Receipt 11090 1090 1842 Northern Lites 28-Aug-15 $ (10,051.11) 322 Cash Receipt 11091 1091 1864 Cross Country Mart 21-Aug-15 $ (16,594.74) 323 CashReceipt 11092 1092 1863 Fit N Fun 28-Aug-15 $ (8,902.72) 324 CashReceipt 11093 1093 1168 Bigmart 9-Sep-15 $ (7,527.80) 325 Cash Receipt 11094 1094 1862 Corner Runner 326 Cash Receipt 11095 1095 1837 Cool Threads 327 Cash Receipt 11096 1096 1840 Super Runners Mark 328 Cash Receipt 11097 1097 1863 Fit N Fun 1-Sep-15 $ (9,537.44) 15-Sep-15 $ (13,744.34) 25-Sep-15 $ (22,709.74) 16-Sep-15 $ (9,105.39) 329 Cash Receipt 11098 1098 1864 Cross Country Mart 8-Oct-15 $ (16,932.51) 330 Cash Receipt 11099 1099 1842 Northern Lites 1-Oct-15 $ (8,632.26) 331 CashReceipt 11100 1100 1843 Southeast Regional 332 CashReceipt 11101 1101 1168 Bigmart 333 Cash Receipt 11102 1102 334 Cash Receipt 11103 1103 1842 Northern Lites 1839 Southern Runners 335 CashReceipt 11104 1104 1842 Northern Lites 7-Sep-15 $ (11,688.63) 11-Sep-15 $ (25,976.16) 4-Sep-15 $ (8,212.96) 8-Sep-15 $ (49,452.37) 25-Aug-15 $ (23,758.22) 336 Cash Receipt 11105 1105 1814 ValueChoice 8-Sep-15 $ (12,687.02) 337 Cash Receipt 11106 1106 1862 Corner Runner 16-Oct-15 $ (12,421.74) 338 Cash Receipt 11107 1107 1863 Fit N Fun 28-Sep-15 $ (9,895.25) 339 CashReceipt 11108 1108 1864 Cross Country Mart 31-Aug-15 $ (18,357.25) 340 CashReceipt 11109 1109 1843 Southeast Regional 29-Sep-15 $ (13,328.83) 341 Cash Receipt 11110 1110 1814 ValueChoice 8-Oct-15 $ (13,231.73) 342 Cash Receipt 11111 1111 1842 Northern Lites 16-Oct-15 $ (9,608.54) 343 CashReceipt 11112 1112 1167 Goodway 8-Oct-15 $ (11,152.68) 344 CashReceipt 11113 1113 1843 Southeast Regional 9-Oct-15 $ (8,723.65) 345 Cash Receipt 11114 1114 1841 Neighborhood Athletic Supply 7-Nov-15 $ (4,757.86) 346 Cash Receipt 11115 1115 1861 Family Fit 13-Oct-15 $ (10,516.60) 347 CashReceipt 11116 1116 1843 Southeast Regional 2-Oct-15 $ (15,195.80) 348 CashReceipt 11117 1117 1836 Runner's Market 6-Oct-15 $ (19,040.00) 349 Cash Receipt 11118 1118 1841 Neighborhood Athletic Supply 7-Nov-15 $ (2,825.06) 350 CashReceipt 11119 1119 1842 Northern Lites 351 CashReceipt 11120 1120 1843 Southeast Regional 3-Dec-15 $ (13,513.05) 20-Nov-15 $ (6,771.10) 352 CashReceipt 11121 1121 1168 Bigmart 353 Cash Receipt 11122 1122 1838 Urban Runner 354 Cash Receipt 11123 1123 1843 Southeast Regional 355 CashReceipt 11124 1124 1836 Runner's Market 356 CashReceipt 11125 1125 1839 Southern Runners 5-Oct-15 $ (10,771.88) 11-Dec-15 $ (13,231.73) 17-Nov-15 $ (9,608.54) 20-Nov-15 $ (10,771.88) 15-Oct-15 $ (13,231.73) 357 CashReceipt 11126 1126 1864 Cross Country Mart 16-Nov-15 $ (18,917.60) 358 CashReceipt 11127 1127 1862 Corner Runner 18-Nov-15 $ (12,798.02) 359 CashReceipt 11128 1128 1814 ValueChoice 3-Nov-15 $ (14,034.27) 360 CashReceipt 11129 1129 1837 Cool Threads 1-Dec-15 $ (18,241.81) 361 CashReceipt 11130 1130 1861 Family Fit 22-Oct-15 $ (12,419.54) 362 Cash Receipt 11131 1131 363 Cash Receint 11133 1133 1843 Southeast Regional 1940 Super Dunners Mark 4-Dec-15 $ (17,941.92) 27 Nov 15 $ 120.830.011 2015 data + A B E 1 Type 335 CashReceipt TransactionNumber Applied To TransactionNumber CustNum CustName TransactionDate Amount 11104 1104 1842 Northem Lites 336 CashReceipt 11105 1105 1814 ValueChoice 337 CashReceipt 11106 1106 1862 Corner Runner 338 CashReceipt 11107 1107 1863 Fit N Fun 339 CashReceipt 11108 1108 1864 Cross Country Mart 25-Aug-15 $ (23,758.22) 8-Sep-15 $ (12,687.02) 16-Oct-15 $ (12,421.74) 28-Sep-15 $ (9,895.25) 31-Aug-15 $ (18,357.25) H InvoiceDate ShipDate 340 CashReceipt 11109 1109 1843 Southeast Regional 29-Sep-15 $ (13,328.83) 341 CashReceipt 11110 1110 1814 ValueChoice 342 CashReceipt 11111 1111 1842 Northem Lites 343 CashReceipt 11112 1112 1167 Goodway 344 CashReceipt 11113 1113 1843 Southeast Regional 8-Oct-15 $ (13,231.73) 16-Oct-15 $ (9,608.54) 8-Oct-15 $ (11,152.68) 9-Oct-15 $ (8,723.65) 345 CashReceipt 11114 1114 1841 Neighborhood Athletic Supply 7-Nov-15 $ (4,757.86) 346 CashReceipt 11115 1115 1861 Family Fit 347 CashReceipt 11116 1116 1843 Southeast Regional 348 CashReceipt 11117 1117 1836 Runner's Market 13-Oct-15 $ (10,516.60) 2-Oct-15 $ (15,195.80) 6-Oct-15 $ (19,040.00) 349 CashReceipt 11118 1118 1841 Neighborhood Athletic Supply 350 CashReceipt 11119 1119 1842 Northem Lites 7-Nov-15 $ (2,825.06) 3-Dec-15 $ (13,513.05) 351 CashReceipt 11120 1120 1843 Southeast Regional 352 CashReceipt 11121 1121 1168 Bigmart 353 CashReceipt 11122 1122 1838 Urban Runner 354 CashReceipt 11123 1123 1843 Southeast Regional 355 CashReceipt 11124 1124 356 CashReceipt 11125 1125 1836 Runner's Market 1839 Southem Runners 357 CashReceipt 11126 1126 1864 Cross Country Mart 358 CashReceipt 11127 1127 1862 Corner Runner 359 CashReceipt 11128 1128 1814 ValueChoice 360 CashReceipt 11129 1129 1837 Cool Threads 361 CashReceipt 11130 1130 1861 Family Fit 20-Nov-15 $ (6,771.10) 5-Oct-15 $ (10,771.88) 11-Dec-15 $ (13,231.73) 17-Nov-15 $ (9,608.54) 20-Nov-15 $ (10,771.88) 15-Oct-15 $ (13,231.73) 16-Nov-15 $ (18,917.60) 18-Nov-15 $ (12,798.02) 3-Nov-15 $ (14,034.27) 1-Dec-15 $ (18,241.81) 22-Oct-15 $ (12,419.54) 362 CashReceipt 11131 1131 1843 Southeast Regional 4-Dec-15 $ (17,941.92) 363 CashReceipt 11133 1133 1840 Super Runners Mark 27-Nov-15 $ (29,830.01) 364 CashReceipt 11134 1134 1843 Southeast Regional 19-Nov-15 $ (7,155.00) 365 CashReceipt 11135 1135 1168 Bigmart 28-Dec-15 $ (18,400.58) 366 CashReceipt 11136 1136 1841 Neighborhood Athletic Supply 2-Nov-15 $ (11,184.75) 367 CashReceipt 11137 1137 1862 Corner Runner 368 CashReceipt 11138 1138 1838 Urban Runner 369 CashReceipt 11139 1139 1168 Bigmart 370 CashReceipt 11140 1140 1839 Southem Runners 371 CashReceipt 11141 1141 1836 Runner's Market 7-Dec-15 $ (14,955.44) 26-Oct-15 $ (1,674.00) 10-Nov-15 $ (18,479.10) 11-Dec-15 $ 22-Dec-15 $ (9.101.70) (843.75) 372 CashReceipt 11142 1142 1167 Goodway 16-Dec-15 $ (15,329.93) 373 CashReceipt 11143 1143 1168 Bigmart 374 CashReceipt 11144 1144 1837 Cool Threads 28-Dec-15 $ (7,155.00) 3-Dec-15 $ (12,220.20) 375 CashReceipt 11145 1145 1861 Family Fit 31-Dec-15 $ (9,402.08) 376 CashReceipt 11146 1146 1814 ValueChoice 2-Dec-15 $ (9,175.14) 377 CashReceipt 11147 1147 1168 Bigmart 28-Dec-15 $ (9,416.25) 378 CashReceipt 11148 1148 1840 Super Runners Mark 19-Nov-15 $ (19,137.74) 379 CashReceipt 11149 1149 1168 Bigmart 17-Dec-15 $ (7.681.50) 380 CashReceipt 11150 1150 1837 Cool Threads 18-Dec-15 $ (14,966.69) 381 CashReceipt 11151 1151 1814 ValueChoice 4-Dec-15 $ (9,684.87) 382 CashReceipt 11152 1152 1863 Fit N Fun 16-Dec-15 $ (13,052.49) 383 CashReceipt 11153 1153 1837 Cool Threads 21-Dec-15 $ (16,287.75) 384 CashReceipt 11154 1154 1167 Goodway 11-Dec-15 $ (28,032.60) 385 CashReceipt 11155 1155 1168 Bigmart 1-Dec-15 $ (19,505.72) 386 CashReceipt 11156 1156 1863 Fit N Fun 387 CashReceipt 11157 1157 1862 Corner Runner 388 CashReceipt 11160 1160 1837 Cool Threads 389 CashReceipt 11161 1161 1862 Corner Runner 390 CashReceipt 11162 1162 1863 Fit N Fun 391 CashReceipt 11163 1163 1836 Runner's Market 392 CashReceipt 11164 1164 1843 Southeast Regional 393 CashReceipt 11165 1165 1861 Family Fit 394 CashReceipt 11166 1166 1863 Fit N Fun 395 CashReceipt 11167 1167 1864 Cross Country Mart 25-Nov-15 $ (13,052.49) 4-Dec-15 $ (17,234.59) 24-Dec-15 $ (14,966.69) 30-Nov-15 $ (17,234.59) 26-Dec-15 $ (13,052.49) 23-Dec-15 $ (1,852.50) 28-Dec-15 $ (23,127.75) 28-Dec-15 $ (9,924.41) 31-Dec-15 $ (13,052.49) 21-Dec-15 $ (20,636.35) 396 CashReceipt 11170 1170 1842 Northem Lites 24-Dec-15 $ (19,381.14) 397 CashReceipt 11173 1173 1837 Cool Threads 30-Dec-15 $ (12,287.05) 398 CashReceipt 11174 1174 1168 Bigmart 23-Dec-15 $ (20,019.02) 399 CashReceipt 11175 1175 1838 Urban Runner 22-Dec-15 $ (8,321.63) 400 CashReceipt 11180 1180 1837 Cool Threads 31-Dec-15 $ (15,360.55) 401 CashReceipt 11181 1181 1839 Southern Runners 24-Dec-15 $ (9.939.74) 402 CashReceipt 11182 1182 1863 Fit N Fun 20-Nov-15 $ (13,395.98) 403 CashReceipt 11184 1184 1838 Urban Runner 404 CashReceipt 11187 1187 1840 Super Runners Mark 7-Dec-15 $ (17,765.95) 18-Dec-15 $ (5,250.38) 405 CashReceipt 11190 1190 1836 Runner's Market 406 CashReceipt 11192 1192 1837 Cool Threads 29-Dec-15 $ (13,669.99) 23-Dec-15 $ (14,964.64) 407 CashReceipt 11196 1196 1842 Northem Lites 18-Dec-15 $ (5,740.31) 408 CashReceipt 11200 1200 1842 Northern Lites 28-Dec-15 $ (9,939.74) 409 CashReceipt 11214 1214 1842 Northern Lites 28-Dec-15 $ (17,328.80) 410 411 412 413 414 415 416 417 418 ShipDate: this is the date the goods were shipped. Required Become familiar with your data file. Make certain that your data is complete and accurate before performing any analysis. Complete the following using Excel. Save your work for each requirement as a separate sheet. Where necessary, add notes near the top of the relevant sheet to explain your analysis and your conclusions from each step. 1. You've been told that the accounts receivable balance on the general ledger at December 31, 2015, is $684,491.19. You also know that as a start-up company, the beginning accounts receivable balance is zero. You are also told that there are no returns or write-offs in 2015. Verify this balance. 2. You've also been told that TechWear only conducts business with the following 15 approved customers. Validate that there are no other customer names and that no customer names are misspelled. Bigmart Cool Threads Corner Runner Cross Country Mart Family Fit Fit N Fun Goodway Neighborhood Athletic Supply Northern Lites Runner's Market Southeast Regional Southern Runners Super Runners Mark Urban Runner ValueChoice Analytics mindset case studies - TechWear 2016 Ernst & Young Foundation (US). All Rights Reserved. SCORE No. 02315-161US 2 3. The sales transaction log shows that 230 sales were transacted this year, beginning with transaction 1001. Verify that the data for all of these invoices has been captured and that there are no additional invoices or duplicates included in the file. Part II: Required: Now that you have your data, you need to perform appropriate analytics techniques to inform your risk assessment for the order-to-cash cycle for TechWear. 1. Develop an accounts receivable (AR) trial balance (one by customer and one by invoice) as of December 31, 2015. Recall that beginning AR + sales - sales returns - cash receipts - bad debt write-offs = ending AR. As mentioned in Part I, the beginning accounts receivable balance is zero and there are no returns or write-offs in 2015. Perform the following analyses relating to collectibility risk (which is the risk the company won't collect money for its sales) on the December 31, 2015, accounts receivable balance. For each procedure, provide a brief statement regarding your findings. 2. Display the year-to-date trend in sales and cash receipts by month for 2015 (with dollars on the x-axis and months on the y-axis). Use a visualization to best highlight any concerns about potential collection issues. Hint: you will be analyzing year-to-date amounts for each month. 3. Compute the year-to-date days-sales-outstanding (DSO) ratio for each month. Show the results numerically and with a visualization. For the latter, use a column chart, also called a vertical bar chart, to best highlight any concerns about potential collection issues. DSO = ending AR balance for the period / total sales for the period (year-to-date)) * number of days in the period (year-to-date) 4. Develop an aging analysis by customer and invoice using 30-day increments (0-30 days, 31-60 days, 61-90 days and > 90 days). Provide a visualization of the percentage of accounts receivable in each aging category at the company level using a column chart.