This section allows you to become familiar with the background company and the data for the order-to-cash business process (sales and cash receipts covering the start-up period of operations, which runs from March 5 through December 31, 2015). You are asked to perform some select steps in the ETL process to make certain of the integrity of the data they will be using for their analysis (note that there are more possible steps that could be done, but the requirements are limited for purposes of this case). This work is done in Excel. You are using some basic Excel skills, including (covering questions 1 through 3): View tab - freeze top row Home tab - summation Data tab - remove duplicates Data tab - data validation Part 1 - Background: TechWear is a privately-owned business that began operations in March 2015. Its sole business is the manufacture and sale of upper-end, high-tech sportswear. It only sells to large distribution outlets. Its primary product is a line of lightweight exercise clothes that contain a new, long-range RFID chip that captures the following information about the user based on personal data (age, weight, etc.) entered by the user: Heart rate Perspiration rate Calories burned Exercise efficiency (percent of capacity) The chip is able to continuously send this information to a host device as far away as 15 miles. The clothes are also GPS enabled and able to track routes, distances and elevations. Management prides itself on being on the cutting edge. The company expects to conduct an IPO within a year or two. TechWear recently retained your firm as its auditors, largely because of your commitment to conduct a highly efficient, technology-enabled audit. Data You are first responsible for performing a risk assessment of TechWear related to its order-to-cash function. Therefore, you know that your focus needs to be on sales and cash transactions. Your first task is to acquire the data for these transactions. You work with TechWear's IT group to gain access to its sales and cash receipts data for its start-up period of operations, March through December 2015. You have been provided with an Excel file with this data (Analytics_mindset_case_studies_Techwear_P1.xls) so you can begin your analysis. The data file includes the following fields: Type: this is the type of transaction, which is either a sale (Sales) or a cash receipt (CashReceipt). Transaction Number: this is the transaction number (beginning with 1001). Applied To Transaction Number: this is the sales transaction number to which a cash receipt is applied. CustNum: this is a unique customer number used to identify each customer. CustName: this is the customer's name. Transaction Date: this is the date of the sale or cash receipt. Amount: this is the amount of the sale or cash receipt. Cash receipts will show a negative amount. InvoiceDate: this is the date the sale was invoiced (billed). 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: 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. o Bigmart o Cool Threads o Corner Runner o Cross Country Mart o Family Fit o Fit N Fun o Goodway o Neighborhood Athletic Supply o Northern Lites o Runner's Market o Southeast Regional o Southern Runners o Super Runners Mark o Urban Runner o Value Choice 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. 1838 Type Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Transaction Number Applied To Transaction Number CustNum 1001 1836 1002 1168 1003 1167 1004 1841 1005 1842 1006 1168 1007 1167 1008 1814 1009 1841 1010 1842 1011 1843 1012 1861 1013 1863 1014 1864 1015 1840 1016 1841 1017 1842 1018 1167 1019 1814 1020 1021 1863 1022 1864 1023 1861 1024 1862 1025 1840 1026 1841 1027 1842 1028 1861 1029 1842 1030 1843 1031 1836 1032 1841 1033 1168 1034 1837 1035 1841 1036 1814 1037 1167 1038 1861 1039 1837 1842 1041 1843 1042 1168 1043 1814 1044 1837 1045 1168 1046 1862 1047 1863 1048 1842 1049 1843 1050 1861 1051 1839 1040 1840 1841 1861 1843 1840 1842 1839 1841 1840 Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1 102 1103 1838 1842 1167 1843 1842 1861 1861 1862 1863 1864 1168 1861 1842 1863 1862 1837 1840 1842 1843 1861 1843 1836 1862 1167 1836 1814 1840 1841 1843 1842 1864 1863 1168 1862 1837 1840 1863 1864 1842 1843 1168 1842 1839 Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1842 1814 1862 1863 1864 1843 1814 1842 1167 1843 1841 1861 1843 1836 1841 1842 1843 1168 1838 1843 1836 1839 1864 1862 1814 1837 1861 1843 1842 1840 1843 1168 1841 1862 1838 1168 1839 1836 1167 1168 1837 1861 1814 1168 1840 1168 1837 1814 1863 1837 1167 1168 1151 1152 1153 1154 1155 1030 1031 1032 1033 1843 1836 1841 1168 1837 1841 1814 1167 1861 1837 1842 1843 1168 1814 1837 1168 1862 1863 1842 1843 1861 1839 1840 1841 1861 1843 Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt CashReceipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt CashReceipt Cash Receipt Cash Receipt Cash Receipt 11030 11031 11032 11033 11034 11035 11036 11037 11038 11039 11040 11041 11042 11043 11044 11045 11046 11047 11048 11049 11050 11051 11052 11053 11054 11055 11056 11057 11058 11059 11060 11061 11062 11063 11064 11065 11066 11067 11068 11069 11070 11071 11072 11073 11074 11075 11076 11077 11078 11079 11080 11081 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1840 1842 1839 1841 1840 1838 1842 1167 1843 1842 1861 1861 1862 1863 1864 1168 1861 1842 1863 1862 1837 1840 1842 1843 1861 1843 Super Runners Mark Neighborhood Athletic Supply Family Fit Southeast Regional Super Runners Mark Northern Lites Southern Runners Neighborhood Athletic Supply Super Runners Mark Urban Runner Northern Lites Goodway Southeast Regional Northern Lites Family Fit Family Fit Corner Runner Fit N Fun Cross Country Mart Bigmart Family Fit Northern Lites Fit N Fun Corner Runner Cool Threads Super Runners Mark Northern Lites Southeast Regional Family Fit Southeast Regional Runner's Market Corner Runner Goodway Runner's Market Value Choice Super Runners Mark Neighborhood Athletic Supply Southeast Regional Northern Lites Cross Country Mart Fit N Fun Bigmart Corner Runner Cool Threads Super Runners Mark Fit N Fun Cross Country Mart Northern Lites Southeast Regional Bigmart Northern Lites Southern Runners 15-May-15 $ 18,528.38 15-May-15 $ 3,015.60 18-May-15 $ 6,555.70 18-May-15 $ 9,537.44 22-May-15 $ 18,713.67 25-May-15 $ 7,125.23 27-May-15 $ 21,258.94 27-May-15 $ 3,071.88 27-May-15 $ 18,899.93 27-May-15 $ 18,766.27 29-May-15 $ 3,408.72 29-May-15 $ 5,066.88 29-May-15 $ 10,341.24 2-Jun-15 $ 8,391.94 2-Jun-15 $ 7,813.39 5-Jun-15 $ 7,896.37 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 22-Jun-15 $ 8,632.26 22-Jun-15 $ 11,688.63 29-Jun-15 $ 8,147.34 29-Jun-15 $ 11,805.61 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 6-Jul-15 $ 10,051.11 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 15-May-15 15-May-15 15-May-15 15-May-15 18-May-15 18-May-15 18-May-15 18-May-15 22-May-15 22-May-15 25-May-15 25-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 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 5-Jun-15 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 22-Jun-15 22-Jun-15 22-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 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 6-Jul-15 6-Jul-15 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 Super Runners Mark Neighborhood Athletic Supply Family Fit Southeast Regional Super Runners Mark Northern Lites Southern Runners Neighborhood Athletic Supply Super Runners Mark Urban Runner Northern Lites Goodway Southeast Regional Northern Lites Family Fit Family Fit Corner Runner Fit N Fun Cross Country Mart Bigmart Family Fit Northern Lites Fit N Fun Corner Runner Cool Threads Super Runners Mark Northern Lites Southeast Regional Family Fit Southeast Regional Runner's Market Corner Runner Goodway Runner's Market Value Choice Super Runners Mark Neighborhood Athletic Supply Southeast Regional Northern Lites Cross Country Mart Fit N Fun Bigmart Corner Runner Cool Threads Super Runners Mark Fit N Fun Cross Country Mart Northern Lites Southeast Regional Bigmart Northern Lites Southern Runners 15-May-15 $ 18,528.38 15-May-15 $ 3,015.60 18-May-15 $ 6,555.70 18-May-15 $ 9,537.44 22-May-15 $ 18,713.67 25-May-15 $ 7,125.23 27-May-15 $ 21,258.94 27-May-15 $ 3,071.88 27-May-15 $ 18,899.93 27-May-15 $ 18,766.27 29-May-15 $ 3,408.72 29-May-15 $ 5,066.88 29-May-15 $ 10,341.24 2-Jun-15 $ 8,391.94 2-Jun-15 $ 7,813.39 5-Jun-15 $ 7,896.37 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 22-Jun-15 $ 8,632.26 22-Jun-15 $ 11,688.63 29-Jun-15 $ 8,147.34 29-Jun-15 $ 11,805.61 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 6-Jul-15 $ 10,051.11 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 15-May-15 15-May-15 15-May-15 15-May-15 18-May-15 18-May-15 18-May-15 18-May-15 22-May-15 22-May-15 25-May-15 25-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 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 5-Jun-15 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 22-Jun-15 22-Jun-15 22-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 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 6-Jul-15 6-Jul-15 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 Northern Lites Value Choice Corner Runner Fit N Fun Cross Country Mart Southeast Regional Value Choice Northern Lites Goodway Southeast Regional Neighborhood Athletic Supply Family Fit Southeast Regional Runner's Market Neighborhood Athletic Supply Northern Lites Southeast Regional Bigmart Urban Runner Southeast Regional Runner's Market Southern Runners Cross Country Mart Corner Runner Value Choice Cool Threads Family Fit Southeast Regional Northern Lites Super Runners Mark Southeast Regional Bigmart Neighborhood Athletic Supply Corner Runner Urban Runner Bigmart Southern Runners Runner's Market Goodway Bigmart Cool Threads Family Fit Value Choice Bigmart Super Runners Mark Bigmart Cool Threads Value Choice Fit N Fun Cool Threads Goodway Bigmart 22-Jul-15 $ 23,758.22 24-Jul-15 $ 12,687.02 3-Aug-15 $ 12,421.74 3-Aug-15 $ 9,895.25 3-Aug-15 $ 18,357.25 6-Aug-15 $ 13,328.83 7-Aug-15 $ 13,231.73 7-Aug-15 $ 9,608.54 7-Aug-15 $ 11,152.68 7-Aug-15 $ 8,723.65 10-Aug-15 $ 4,757.86 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 20-Aug-15 $ 13,231.73 20-Aug-15 $ 9,608.54 26-Aug-15 $ 10,771.88 26-Aug-15 $ 13,231.73 31-Aug-15 $ 18,917.60 31-Aug-15 $ 12,798.02 31-Aug-15 $ 14,034.27 31-Aug-15 $ 18,241.81 7-Sep-15 $ 12,419.54 7-Sep-15 $ 17,941.92 7-Sep-15 $ 14,103.74 10-Sep-15 $ 29,830.01 10-Sep-15 $ 7,155.00 11-Sep-15 $ 18,400.58 11-Sep-15 $ 11,184.75 11-Sep-15 $ 14,955.44 11-Sep-15 $ 1,674.00 17-Sep-15 $ 18,479.10 22-Sep-15 $ 843.75 22-Sep-15 $ 9,101.70 23-Sep-15 $ 15,329.93 24-Sep-15 $ 7,155.00 25-Sep-15 $ 12,220.20 28-Sep-15 $ 9,402.08 28-Sep-15 $ 9,175.14 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 8-Oct-15 $ 19,505.72 22-Jul-15 22-Jul-15 24-Jul-15 24-Jul-15 3-Aug-15 3-Aug-15 3-Aug-15 3-Aug-15 3-Aug-15 3-Aug-15 6-Aug-15 6-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-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 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 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 7-Sep-15 7-Sep-15 7-Sep-15 7-Sep-15 7-Sep-15 7-Sep-15 10-Sep-15 10-Sep-15 10-Sep-15 10-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 17-Sep-15 17-Sep-15 22-Sep-15 22-Sep-15 22-Sep-15 22-Sep-15 23-Sep-15 23-Sep-15 24-Sep-15 24-Sep-15 25-Sep-15 25-Sep-15 28-Sep-15 28-Sep-15 28-Sep-15 28-Sep-15 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 6-Oct-15 6-Oct-15 8-Oct-15 8-Oct-15 Fit N Fun Comer Runner Northern Lites Southeast Regional Cool Threads Comer Runner Fit N Fun Runner's Market Southeast Regional Family Fit Fit N Fun Cross Country Mart Urban Runner Runner's Market Northern Lites Cross Country Mart Southern Runners Cool Threads Bigmart Urban Runner Super Runners Mark Northern Lites Family Fit Value Choice Cool Threads Southern Runners Fit N Fun Bigmart Urban Runner Goodway Southern Runners Super Runners Mark Urban Runner Northern Lites Runner's Market Super Runners Mark Cool Threads Goodway Southern Runners Bigmart Northern Lites Super Runners Mark Southern Runners Goodway Northern Lites Neighborhood Athletic Supply Urban Runner Northern Lites Bigmart Southern Runners Runner's Market Super Runners Mark 15-Oct-15 $ 13,052.49 15-Oct-15 $ 17,234.59 15-Oct-15 $ 11,061.21 15-Oct-15 $ 13,742.20 16-Oct-15 $ 14,966.69 19-Oct-15 $ 17,234.59 19-Oct-15 $ 13,052.49 20-Oct-15 $ 1,852.50 21-Oct-15 $ 23,127.75 23-Oct-15 $ 9,924.41 26-Oct-15 $ 13,052.49 26-Oct-15 $ 20,636.35 28-Oct-15$ 788.03 28-Oct-15 $ 14,658.98 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 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 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 -Dec-15 $ 17,000.53 4-Dec-15 $ 13,464.67 11-Dec-15 $ 14,306.15 14-Dec-15 $ 13,464.67 14-Dec-15 $ 17,778.84 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 16-Oct-15 16-Oct-15 19-Oct-15 19-Oct-15 19-Oct-15 19-Oct-15 20-Oct-15 20-Oct-15 21-Oct-15 21-Oct-15 23-Oct-15 23-Oct-15 26-Oct-15 26-Oct-15 26-Oct-15 26-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 29-Oct-15 29-Oct-15 4-Nov-15 4-Nov-15 5-Nov-15 5-Nov-15 5-Nov-15 5-Nov-15 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 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 -15 -15 4-Dec-15 4-Dec-15 11-Dec-15 11-Dec-15 14-Dec-15 14-Dec-15 14-Dec-15 14-Dec-15 17-Dec-15 17-Dec-15 17-Dec-15 17-Dec-15 18-Dec-15 18-Dec-15 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 23-Dec-15 4-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 24-Dec-15 24-Dec-15 24-Dec-15 24-Dec-15 28-Dec-15 6-Jan-16 28-Dec-15 6-Jan-16 28-Dec-15 6-Jan-16 28-Dec-15 28-Dec-15 30-Dec-15 30-Dec-15 31-Dec-15 6-Jan-16 Urban Runner Cool Threads Value Choice Neighborhood Athletic Supply Family Fit Fit N Fun Northern Lites Urban Runner Southeast Regional Urban Runner Runner's Market Southeast Regional Northern Lites Southeast Regional Cool Threads Northern Lites Value Choice Southeast Regional Northern Lites Bigmart Southern Runners Northern Lites Cool Threads Runner's Market Bigmart Goodway Neighborhood Athletic Supply Northern Lites Bigmart Goodway Value Choice Neighborhood Athletic Supply Northern Lites Southeast Regional Family Fit Fit N Fun Cross Country Mart Super Runners Mark Neighborhood Athletic Supply Northern Lites Goodway Value Choice Urban Runner Fit N Fun Cross Country Mart Family Fit Corner Runner Super Runners Mark Neighborhood Athletic Supply Northern Lites Family Fit Northern Lites 17-Dec-15 $ 6,264.99 17-Dec-15 $ 12,786.27 18-Dec-15 $ 9,542.40 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 23-Dec-15 $ 16,029.20 23-Dec-15 $ 20,819.88 23-Dec-15 $ 9,990.71 23-Dec-15 $ 830.84 24-Dec-15 $ 11,410.51 24-Dec-15 $ 14,176.16 28-Dec-15 $ 18,904.57 28-Dec-15 $ 14,462.35 28-Dec-15 $ 12,821.28 28-Dec-15 $ 12,786.27 30-Dec-15 $ 25,838.52 31-Dec-15 $ 7,496.02 25-Mar-15 $ (16,157.44) 8-Apr-15 $ (9,144.00) 16-Apr-15 $ (15,737.60) 9-Apr-15 $ (6,008.00) 3-Apr-15 $ (7,241.60) 22-Apr-15 $ (8,476.00) 30-Apr-15 $ (15,737.60) 4-May-15 $ (9,084.40) 19-May-15 $ (4,240.00) 28-May-15 $ (5,993.60) 12-May-15 $ (9,019.12) 2-May-15 $ (6,552.40) 25-May-15 $ (5,008.64) 7-May-15 $ (11,113.60) 14-May-15 $ (17,677.04) 18-May-15 $ (4,240.00) 22-Apr-15 $ (7,241.60) 30-Apr-15 $ (19,672.00) 7-May-15 $ (6,975.00) 19-May-15 $ (16,230.00) 29-May-15 $ (7,330.80) 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) 16-May-15 $ (9,052.00) 10-Jun-15 $ (8,190.50) 11-May-15 $ (9,052.00) Southeast Regional Runner's Market Neighborhood Athletic Supply Bigmart Cool Threads Neighborhood Athletic Supply Value Choice Goodway Family Fit Cool Threads Northern Lites Southeast Regional Bigmart Value Choice Cool Threads Bigmart Corner Runner Fit N Fun Northern Lites Southeast Regional Family Fit Southern Runners Super Runners Mark Neighborhood Athletic Supply Family Fit Southeast Regional Super Runners Mark Northern Lites Southern Runners Neighborhood Athletic Supply Super Runners Mark Urban Runner Northern Lites Goodway Southeast Regional Northern Lites Family Fit Family Fit Corner Runner Fit N Fun Cross Country Mart Bigmart Family Fit Northern Lites Fit N Fun Corner Runner Cool Threads Super Runners Mark Northern Lites Southeast Regional Family Fit Southeast Regional 15-May-15 $ (11,273.90) 23-May-15 $ (19,571.80) 29-May-15 $ (1,300.00) 4-Jun-15 $ (835.00) 18-Jul-15 $ (7,600.00) 6-Jul-15 $ (702.00) 20-Jun-15 $ (4,380.50) 10-Jun-15 $ (19,312.00) 3-Jul-15 $ (8,074.40) 25-Jun-15 $ (14,092.60) 23-Jun-15 $ (9,052.00) 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) 2-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) 7-Jul-15 $ (8,391.94) 10-Jul-15 $ (7,813.39) 3-Aug-15 $ (7,896.37) 15-Jul-15 $ (9,441.82) 9-Jul-15 $ (7,441.67) 31-Jul-15 $ (13,940.70) 13-Aug-15 $ (11,738.30) 20-Jul-15 $ (7,979.70) 23-Jul-15 $ (8,551.80) 11-Aug-15 $ (7,527.80) 22-Jul-15 $ (9,537.44) 20-Jul-15 $ (13,744.34) 3-Aug-15 $ (22,709.74) 13-Aug-15 $ (8,632.26) 17-Aug-15 $ (11,688.63) 7-Sep-15 $ (8,147.34) 15-Sep-15 $ (11,805.61) Runner's Market Corner Runner Goodway Runner's Market Value Choice Super Runners Mark Neighborhood Athletic Supply Southeast Regional Northern Lites Cross Country Mart Fit N Fun Bigmart Corner Runner Cool Threads Super Runners Mark Fit N Fun Cross Country Mart Northern Lites Southeast Regional Bigmart Northern Lites Southern Runners Northern Lites Value Choice Corner Runner Fit N Fun Cross Country Mart Southeast Regional Value Choice Northern Lites Goodway Southeast Regional Neighborhood Athletic Supply Family Fit Southeast Regional Runner's Market Neighborhood Athletic Supply Northern Lites Southeast Regional Bigmart Urban Runner Southeast Regional Runner's Market Southern Runners Cross Country Mart Corner Runner Value Choice Cool Threads Family Fit Southeast Regional Super Runners Mark Southeast Regional 31-Aug-15 $ (19,709.89) 26-Aug-15 $ (9,731.16) 21-Sep-15 $ (22,114.82) 11-Sep-15 $ (23,674.76) 9-Sep-15 $ (12,327.94) 13-Sep-15 $ (26,463.75) 14-Aug-15 $ (4,283.44) 21-Aug-15 $ (13,625.81) 28-Aug-15 $ (10,051.11) 21-Aug-15 $ (16,594.74) 28-Aug-15 $ (8,902.72) 9-Sep-15 $ (7,527.80) 1-Sep-15 $ (9,537.44) 15-Sep-15 $ (13,744.34) 25-Sep-15 $ (22,709.74) 16-Sep-15 $ (9,105.39) 8-Oct-15 $ (16,932.51) 1-Oct-15 $ (8,632.26) 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) 8-Sep-15 $ (12,687.02) 16-Oct-15 $ (12,421.74) 28-Sep-15 $ (9,895.25) 31-Aug-15 $ (18,357.25) 29-Sep-15 $ (13,328.83) 8-Oct-15 $ (13,231.73) 16-Oct-15 $ (9,608.54) 8-Oct-15 $ (11,152.68) 9-Oct-15 $ (8,723.65) 7-Nov-15 $ (4,757.86) 13-Oct-15 $ (10,516.60) 2-Oct-15 $ (15,195.80) 6-Oct-15 $ (19,040.00) 7-Nov-15 $ (2,825.06) 3-Dec-15 $ (13,513.05) 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) 4-Dec-15 $ (17,941.92) 27-Nov-15 $ (29,830.01) 19-Nov-15 $ (7,155.00) Bigmart Neighborhood Athletic Supply Corner Runner Urban Runner Bigmart Southern Runners Runner's Market Goodway Bigmart Cool Threads Family Fit Value Choice Bigmart Super Runners Mark Bigmart Cool Threads Value Choice Fit N Fun Cool Threads Goodway Bigmart Fit N Fun Corner Runner Cool Threads Corner Runner Fit N Fun Runner's Market Southeast Regional Family Fit Fit N Fun Cross Country Mart Northern Lites Cool Threads Bigmart Urban Runner Cool Threads Southern Runners Fit N Fun Urban Runner Super Runners Mark Runner's Market Cool Threads Northern Lites Northern Lites Northern Lites 28-Dec-15 $ (18,400.58) 2-Nov-15 $ (11,184.75) 7-Dec-15 $ (14,955.44) 26-Oct-15 $ (1,674.00) 10-Nov-15 $ (18,479.10) 11-Dec-15 $ (843.75) 22-Dec-15 $ (9,101.70) 16-Dec-15 $ (15,329.93) 28-Dec-15 $ (7,155.00) 3-Dec-15 $ (12,220.20) 31-Dec-15 $ (9,402.08) 2-Dec-15 $ (9,175.14) 28-Dec-15 $ (9,416.25) 19-Nov-15 $ (19,137.74) 17-Dec-15 $ (7,681.50) 18-Dec-15 $ (14,966.69) 4-Dec-15 $ (9,684.87) 16-Dec-15 $ (13,052.49) 21-Dec-15 $ (16,287.75) 11-Dec-15 $ (28,032.60) 1-Dec-15 $ (19,505.72) 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) 24-Dec-15 $ (19,381.14) 30-Dec-15 $ (12,287.05) 23-Dec-15 $ (20,019.02) 22-Dec-15 $ (8,321.63) 31-Dec-15 $ (15,360.55) 24-Dec-15 $ (9,939.74) 20-Nov-15 $ (13,395.98) 7-Dec-15 $ (17,765.95) 18-Dec-15 $ (5,250.38) 29-Dec-15 $ (13,669.99) 23-Dec-15 $ (14,964.64) 18-Dec-15 $ (5,740.31) 28-Dec-15 $ (9,939.74) 28-Dec-15 $ (17,328.80) Bigmart Neighborhood Athletic Supply Corner Runner Urban Runner Bigmart Southern Runners Runner's Market Goodway Bigmart Cool Threads Family Fit Value Choice Bigmart Super Runners Mark Bigmart Cool Threads Value Choice Fit N Fun Cool Threads Goodway Bigmart Fit N Fun Corner Runner Cool Threads Corner Runner Fit N Fun Runner's Market Southeast Regional Family Fit Fit N Fun Cross Country Mart Northern Lites Cool Threads Bigmart Urban Runner Cool Threads Southern Runners Fit N Fun Urban Runner Super Runners Mark Runner's Market Cool Threads Northern Lites Northern Lites Northern Lites 28-Dec-15 $ (18,400.58) 2-Nov-15 $ (11,184.75) 7-Dec-15 $ (14,955.44) 26-Oct-15 $ (1,674.00) 10-Nov-15 $ (18,479.10) 11-Dec-15 $ (843.75) 22-Dec-15 $ (9,101.70) 16-Dec-15 $ (15,329.93) 28-Dec-15 $ (7,155.00) 3-Dec-15 $ (12,220.20) 31-Dec-15 $ (9,402.08) 2-Dec-15 $ (9,175.14) 28-Dec-15 $ (9,416.25) 19-Nov-15 $ (19,137.74) 17-Dec-15 $ (7,681.50) 18-Dec-15 $ (14,966.69) 4-Dec-15 $ (9,684.87) 16-Dec-15 $ (13,052.49) 21-Dec-15 $ (16,287.75) 11-Dec-15 $ (28,032.60) 1-Dec-15 $ (19,505.72) 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) 24-Dec-15 $ (19,381.14) 30-Dec-15 $ (12,287.05) 23-Dec-15 $ (20,019.02) 22-Dec-15 $ (8,321.63) 31-Dec-15 $ (15,360.55) 24-Dec-15 $ (9,939.74) 20-Nov-15 $ (13,395.98) 7-Dec-15 $ (17,765.95) 18-Dec-15 $ (5,250.38) 29-Dec-15 $ (13,669.99) 23-Dec-15 $ (14,964.64) 18-Dec-15 $ (5,740.31) 28-Dec-15 $ (9,939.74) 28-Dec-15 $ (17,328.80) This section allows you to become familiar with the background company and the data for the order-to-cash business process (sales and cash receipts covering the start-up period of operations, which runs from March 5 through December 31, 2015). You are asked to perform some select steps in the ETL process to make certain of the integrity of the data they will be using for their analysis (note that there are more possible steps that could be done, but the requirements are limited for purposes of this case). This work is done in Excel. You are using some basic Excel skills, including (covering questions 1 through 3): View tab - freeze top row Home tab - summation Data tab - remove duplicates Data tab - data validation Part 1 - Background: TechWear is a privately-owned business that began operations in March 2015. Its sole business is the manufacture and sale of upper-end, high-tech sportswear. It only sells to large distribution outlets. Its primary product is a line of lightweight exercise clothes that contain a new, long-range RFID chip that captures the following information about the user based on personal data (age, weight, etc.) entered by the user: Heart rate Perspiration rate Calories burned Exercise efficiency (percent of capacity) The chip is able to continuously send this information to a host device as far away as 15 miles. The clothes are also GPS enabled and able to track routes, distances and elevations. Management prides itself on being on the cutting edge. The company expects to conduct an IPO within a year or two. TechWear recently retained your firm as its auditors, largely because of your commitment to conduct a highly efficient, technology-enabled audit. Data You are first responsible for performing a risk assessment of TechWear related to its order-to-cash function. Therefore, you know that your focus needs to be on sales and cash transactions. Your first task is to acquire the data for these transactions. You work with TechWear's IT group to gain access to its sales and cash receipts data for its start-up period of operations, March through December 2015. You have been provided with an Excel file with this data (Analytics_mindset_case_studies_Techwear_P1.xls) so you can begin your analysis. The data file includes the following fields: Type: this is the type of transaction, which is either a sale (Sales) or a cash receipt (CashReceipt). Transaction Number: this is the transaction number (beginning with 1001). Applied To Transaction Number: this is the sales transaction number to which a cash receipt is applied. CustNum: this is a unique customer number used to identify each customer. CustName: this is the customer's name. Transaction Date: this is the date of the sale or cash receipt. Amount: this is the amount of the sale or cash receipt. Cash receipts will show a negative amount. InvoiceDate: this is the date the sale was invoiced (billed). 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: 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. o Bigmart o Cool Threads o Corner Runner o Cross Country Mart o Family Fit o Fit N Fun o Goodway o Neighborhood Athletic Supply o Northern Lites o Runner's Market o Southeast Regional o Southern Runners o Super Runners Mark o Urban Runner o Value Choice 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. 1838 Type Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Transaction Number Applied To Transaction Number CustNum 1001 1836 1002 1168 1003 1167 1004 1841 1005 1842 1006 1168 1007 1167 1008 1814 1009 1841 1010 1842 1011 1843 1012 1861 1013 1863 1014 1864 1015 1840 1016 1841 1017 1842 1018 1167 1019 1814 1020 1021 1863 1022 1864 1023 1861 1024 1862 1025 1840 1026 1841 1027 1842 1028 1861 1029 1842 1030 1843 1031 1836 1032 1841 1033 1168 1034 1837 1035 1841 1036 1814 1037 1167 1038 1861 1039 1837 1842 1041 1843 1042 1168 1043 1814 1044 1837 1045 1168 1046 1862 1047 1863 1048 1842 1049 1843 1050 1861 1051 1839 1040 1840 1841 1861 1843 1840 1842 1839 1841 1840 Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1 102 1103 1838 1842 1167 1843 1842 1861 1861 1862 1863 1864 1168 1861 1842 1863 1862 1837 1840 1842 1843 1861 1843 1836 1862 1167 1836 1814 1840 1841 1843 1842 1864 1863 1168 1862 1837 1840 1863 1864 1842 1843 1168 1842 1839 Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales Sales 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1842 1814 1862 1863 1864 1843 1814 1842 1167 1843 1841 1861 1843 1836 1841 1842 1843 1168 1838 1843 1836 1839 1864 1862 1814 1837 1861 1843 1842 1840 1843 1168 1841 1862 1838 1168 1839 1836 1167 1168 1837 1861 1814 1168 1840 1168 1837 1814 1863 1837 1167 1168 1151 1152 1153 1154 1155 1030 1031 1032 1033 1843 1836 1841 1168 1837 1841 1814 1167 1861 1837 1842 1843 1168 1814 1837 1168 1862 1863 1842 1843 1861 1839 1840 1841 1861 1843 Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt CashReceipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt Cash Receipt CashReceipt Cash Receipt Cash Receipt Cash Receipt 11030 11031 11032 11033 11034 11035 11036 11037 11038 11039 11040 11041 11042 11043 11044 11045 11046 11047 11048 11049 11050 11051 11052 11053 11054 11055 11056 11057 11058 11059 11060 11061 11062 11063 11064 11065 11066 11067 11068 11069 11070 11071 11072 11073 11074 11075 11076 11077 11078 11079 11080 11081 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1840 1842 1839 1841 1840 1838 1842 1167 1843 1842 1861 1861 1862 1863 1864 1168 1861 1842 1863 1862 1837 1840 1842 1843 1861 1843 Super Runners Mark Neighborhood Athletic Supply Family Fit Southeast Regional Super Runners Mark Northern Lites Southern Runners Neighborhood Athletic Supply Super Runners Mark Urban Runner Northern Lites Goodway Southeast Regional Northern Lites Family Fit Family Fit Corner Runner Fit N Fun Cross Country Mart Bigmart Family Fit Northern Lites Fit N Fun Corner Runner Cool Threads Super Runners Mark Northern Lites Southeast Regional Family Fit Southeast Regional Runner's Market Corner Runner Goodway Runner's Market Value Choice Super Runners Mark Neighborhood Athletic Supply Southeast Regional Northern Lites Cross Country Mart Fit N Fun Bigmart Corner Runner Cool Threads Super Runners Mark Fit N Fun Cross Country Mart Northern Lites Southeast Regional Bigmart Northern Lites Southern Runners 15-May-15 $ 18,528.38 15-May-15 $ 3,015.60 18-May-15 $ 6,555.70 18-May-15 $ 9,537.44 22-May-15 $ 18,713.67 25-May-15 $ 7,125.23 27-May-15 $ 21,258.94 27-May-15 $ 3,071.88 27-May-15 $ 18,899.93 27-May-15 $ 18,766.27 29-May-15 $ 3,408.72 29-May-15 $ 5,066.88 29-May-15 $ 10,341.24 2-Jun-15 $ 8,391.94 2-Jun-15 $ 7,813.39 5-Jun-15 $ 7,896.37 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 22-Jun-15 $ 8,632.26 22-Jun-15 $ 11,688.63 29-Jun-15 $ 8,147.34 29-Jun-15 $ 11,805.61 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 6-Jul-15 $ 10,051.11 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 15-May-15 15-May-15 15-May-15 15-May-15 18-May-15 18-May-15 18-May-15 18-May-15 22-May-15 22-May-15 25-May-15 25-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 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 5-Jun-15 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 22-Jun-15 22-Jun-15 22-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 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 6-Jul-15 6-Jul-15 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 Super Runners Mark Neighborhood Athletic Supply Family Fit Southeast Regional Super Runners Mark Northern Lites Southern Runners Neighborhood Athletic Supply Super Runners Mark Urban Runner Northern Lites Goodway Southeast Regional Northern Lites Family Fit Family Fit Corner Runner Fit N Fun Cross Country Mart Bigmart Family Fit Northern Lites Fit N Fun Corner Runner Cool Threads Super Runners Mark Northern Lites Southeast Regional Family Fit Southeast Regional Runner's Market Corner Runner Goodway Runner's Market Value Choice Super Runners Mark Neighborhood Athletic Supply Southeast Regional Northern Lites Cross Country Mart Fit N Fun Bigmart Corner Runner Cool Threads Super Runners Mark Fit N Fun Cross Country Mart Northern Lites Southeast Regional Bigmart Northern Lites Southern Runners 15-May-15 $ 18,528.38 15-May-15 $ 3,015.60 18-May-15 $ 6,555.70 18-May-15 $ 9,537.44 22-May-15 $ 18,713.67 25-May-15 $ 7,125.23 27-May-15 $ 21,258.94 27-May-15 $ 3,071.88 27-May-15 $ 18,899.93 27-May-15 $ 18,766.27 29-May-15 $ 3,408.72 29-May-15 $ 5,066.88 29-May-15 $ 10,341.24 2-Jun-15 $ 8,391.94 2-Jun-15 $ 7,813.39 5-Jun-15 $ 7,896.37 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 22-Jun-15 $ 8,632.26 22-Jun-15 $ 11,688.63 29-Jun-15 $ 8,147.34 29-Jun-15 $ 11,805.61 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 6-Jul-15 $ 10,051.11 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 15-May-15 15-May-15 15-May-15 15-May-15 18-May-15 18-May-15 18-May-15 18-May-15 22-May-15 22-May-15 25-May-15 25-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 27-May-15 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 5-Jun-15 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 22-Jun-15 22-Jun-15 22-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 29-Jun-15 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 6-Jul-15 6-Jul-15 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 Northern Lites Value Choice Corner Runner Fit N Fun Cross Country Mart Southeast Regional Value Choice Northern Lites Goodway Southeast Regional Neighborhood Athletic Supply Family Fit Southeast Regional Runner's Market Neighborhood Athletic Supply Northern Lites Southeast Regional Bigmart Urban Runner Southeast Regional Runner's Market Southern Runners Cross Country Mart Corner Runner Value Choice Cool Threads Family Fit Southeast Regional Northern Lites Super Runners Mark Southeast Regional Bigmart Neighborhood Athletic Supply Corner Runner Urban Runner Bigmart Southern Runners Runner's Market Goodway Bigmart Cool Threads Family Fit Value Choice Bigmart Super Runners Mark Bigmart Cool Threads Value Choice Fit N Fun Cool Threads Goodway Bigmart 22-Jul-15 $ 23,758.22 24-Jul-15 $ 12,687.02 3-Aug-15 $ 12,421.74 3-Aug-15 $ 9,895.25 3-Aug-15 $ 18,357.25 6-Aug-15 $ 13,328.83 7-Aug-15 $ 13,231.73 7-Aug-15 $ 9,608.54 7-Aug-15 $ 11,152.68 7-Aug-15 $ 8,723.65 10-Aug-15 $ 4,757.86 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 20-Aug-15 $ 13,231.73 20-Aug-15 $ 9,608.54 26-Aug-15 $ 10,771.88 26-Aug-15 $ 13,231.73 31-Aug-15 $ 18,917.60 31-Aug-15 $ 12,798.02 31-Aug-15 $ 14,034.27 31-Aug-15 $ 18,241.81 7-Sep-15 $ 12,419.54 7-Sep-15 $ 17,941.92 7-Sep-15 $ 14,103.74 10-Sep-15 $ 29,830.01 10-Sep-15 $ 7,155.00 11-Sep-15 $ 18,400.58 11-Sep-15 $ 11,184.75 11-Sep-15 $ 14,955.44 11-Sep-15 $ 1,674.00 17-Sep-15 $ 18,479.10 22-Sep-15 $ 843.75 22-Sep-15 $ 9,101.70 23-Sep-15 $ 15,329.93 24-Sep-15 $ 7,155.00 25-Sep-15 $ 12,220.20 28-Sep-15 $ 9,402.08 28-Sep-15 $ 9,175.14 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 8-Oct-15 $ 19,505.72 22-Jul-15 22-Jul-15 24-Jul-15 24-Jul-15 3-Aug-15 3-Aug-15 3-Aug-15 3-Aug-15 3-Aug-15 3-Aug-15 6-Aug-15 6-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-Aug-15 7-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 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 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 31-Aug-15 7-Sep-15 7-Sep-15 7-Sep-15 7-Sep-15 7-Sep-15 7-Sep-15 10-Sep-15 10-Sep-15 10-Sep-15 10-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 11-Sep-15 17-Sep-15 17-Sep-15 22-Sep-15 22-Sep-15 22-Sep-15 22-Sep-15 23-Sep-15 23-Sep-15 24-Sep-15 24-Sep-15 25-Sep-15 25-Sep-15 28-Sep-15 28-Sep-15 28-Sep-15 28-Sep-15 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 6-Oct-15 6-Oct-15 8-Oct-15 8-Oct-15 Fit N Fun Comer Runner Northern Lites Southeast Regional Cool Threads Comer Runner Fit N Fun Runner's Market Southeast Regional Family Fit Fit N Fun Cross Country Mart Urban Runner Runner's Market Northern Lites Cross Country Mart Southern Runners Cool Threads Bigmart Urban Runner Super Runners Mark Northern Lites Family Fit Value Choice Cool Threads Southern Runners Fit N Fun Bigmart Urban Runner Goodway Southern Runners Super Runners Mark Urban Runner Northern Lites Runner's Market Super Runners Mark Cool Threads Goodway Southern Runners Bigmart Northern Lites Super Runners Mark Southern Runners Goodway Northern Lites Neighborhood Athletic Supply Urban Runner Northern Lites Bigmart Southern Runners Runner's Market Super Runners Mark 15-Oct-15 $ 13,052.49 15-Oct-15 $ 17,234.59 15-Oct-15 $ 11,061.21 15-Oct-15 $ 13,742.20 16-Oct-15 $ 14,966.69 19-Oct-15 $ 17,234.59 19-Oct-15 $ 13,052.49 20-Oct-15 $ 1,852.50 21-Oct-15 $ 23,127.75 23-Oct-15 $ 9,924.41 26-Oct-15 $ 13,052.49 26-Oct-15 $ 20,636.35 28-Oct-15$ 788.03 28-Oct-15 $ 14,658.98 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 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 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 -Dec-15 $ 17,000.53 4-Dec-15 $ 13,464.67 11-Dec-15 $ 14,306.15 14-Dec-15 $ 13,464.67 14-Dec-15 $ 17,778.84 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 15-Oct-15 16-Oct-15 16-Oct-15 19-Oct-15 19-Oct-15 19-Oct-15 19-Oct-15 20-Oct-15 20-Oct-15 21-Oct-15 21-Oct-15 23-Oct-15 23-Oct-15 26-Oct-15 26-Oct-15 26-Oct-15 26-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 28-Oct-15 29-Oct-15 29-Oct-15 4-Nov-15 4-Nov-15 5-Nov-15 5-Nov-15 5-Nov-15 5-Nov-15 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 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 -15 -15 4-Dec-15 4-Dec-15 11-Dec-15 11-Dec-15 14-Dec-15 14-Dec-15 14-Dec-15 14-Dec-15 17-Dec-15 17-Dec-15 17-Dec-15 17-Dec-15 18-Dec-15 18-Dec-15 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 23-Dec-15 4-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 23-Dec-15 24-Dec-15 24-Dec-15 24-Dec-15 24-Dec-15 28-Dec-15 6-Jan-16 28-Dec-15 6-Jan-16 28-Dec-15 6-Jan-16 28-Dec-15 28-Dec-15 30-Dec-15 30-Dec-15 31-Dec-15 6-Jan-16 Urban Runner Cool Threads Value Choice Neighborhood Athletic Supply Family Fit Fit N Fun Northern Lites Urban Runner Southeast Regional Urban Runner Runner's Market Southeast Regional Northern Lites Southeast Regional Cool Threads Northern Lites Value Choice Southeast Regional Northern Lites Bigmart Southern Runners Northern Lites Cool Threads Runner's Market Bigmart Goodway Neighborhood Athletic Supply Northern Lites Bigmart Goodway Value Choice Neighborhood Athletic Supply Northern Lites Southeast Regional Family Fit Fit N Fun Cross Country Mart Super Runners Mark Neighborhood Athletic Supply Northern Lites Goodway Value Choice Urban Runner Fit N Fun Cross Country Mart Family Fit Corner Runner Super Runners Mark Neighborhood Athletic Supply Northern Lites Family Fit Northern Lites 17-Dec-15 $ 6,264.99 17-Dec-15 $ 12,786.27 18-Dec-15 $ 9,542.40 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 23-Dec-15 $ 16,029.20 23-Dec-15 $ 20,819.88 23-Dec-15 $ 9,990.71 23-Dec-15 $ 830.84 24-Dec-15 $ 11,410.51 24-Dec-15 $ 14,176.16 28-Dec-15 $ 18,904.57 28-Dec-15 $ 14,462.35 28-Dec-15 $ 12,821.28 28-Dec-15 $ 12,786.27 30-Dec-15 $ 25,838.52 31-Dec-15 $ 7,496.02 25-Mar-15 $ (16,157.44) 8-Apr-15 $ (9,144.00) 16-Apr-15 $ (15,737.60) 9-Apr-15 $ (6,008.00) 3-Apr-15 $ (7,241.60) 22-Apr-15 $ (8,476.00) 30-Apr-15 $ (15,737.60) 4-May-15 $ (9,084.40) 19-May-15 $ (4,240.00) 28-May-15 $ (5,993.60) 12-May-15 $ (9,019.12) 2-May-15 $ (6,552.40) 25-May-15 $ (5,008.64) 7-May-15 $ (11,113.60) 14-May-15 $ (17,677.04) 18-May-15 $ (4,240.00) 22-Apr-15 $ (7,241.60) 30-Apr-15 $ (19,672.00) 7-May-15 $ (6,975.00) 19-May-15 $ (16,230.00) 29-May-15 $ (7,330.80) 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) 16-May-15 $ (9,052.00) 10-Jun-15 $ (8,190.50) 11-May-15 $ (9,052.00) Southeast Regional Runner's Market Neighborhood Athletic Supply Bigmart Cool Threads Neighborhood Athletic Supply Value Choice Goodway Family Fit Cool Threads Northern Lites Southeast Regional Bigmart Value Choice Cool Threads Bigmart Corner Runner Fit N Fun Northern Lites Southeast Regional Family Fit Southern Runners Super Runners Mark Neighborhood Athletic Supply Family Fit Southeast Regional Super Runners Mark Northern Lites Southern Runners Neighborhood Athletic Supply Super Runners Mark Urban Runner Northern Lites Goodway Southeast Regional Northern Lites Family Fit Family Fit Corner Runner Fit N Fun Cross Country Mart Bigmart Family Fit Northern Lites Fit N Fun Corner Runner Cool Threads Super Runners Mark Northern Lites Southeast Regional Family Fit Southeast Regional 15-May-15 $ (11,273.90) 23-May-15 $ (19,571.80) 29-May-15 $ (1,300.00) 4-Jun-15 $ (835.00) 18-Jul-15 $ (7,600.00) 6-Jul-15 $ (702.00) 20-Jun-15 $ (4,380.50) 10-Jun-15 $ (19,312.00) 3-Jul-15 $ (8,074.40) 25-Jun-15 $ (14,092.60) 23-Jun-15 $ (9,052.00) 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) 2-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) 7-Jul-15 $ (8,391.94) 10-Jul-15 $ (7,813.39) 3-Aug-15 $ (7,896.37) 15-Jul-15 $ (9,441.82) 9-Jul-15 $ (7,441.67) 31-Jul-15 $ (13,940.70) 13-Aug-15 $ (11,738.30) 20-Jul-15 $ (7,979.70) 23-Jul-15 $ (8,551.80) 11-Aug-15 $ (7,527.80) 22-Jul-15 $ (9,537.44) 20-Jul-15 $ (13,744.34) 3-Aug-15 $ (22,709.74) 13-Aug-15 $ (8,632.26) 17-Aug-15 $ (11,688.63) 7-Sep-15 $ (8,147.34) 15-Sep-15 $ (11,805.61) Runner's Market Corner Runner Goodway Runner's Market Value Choice Super Runners Mark Neighborhood Athletic Supply Southeast Regional Northern Lites Cross Country Mart Fit N Fun Bigmart Corner Runner Cool Threads Super Runners Mark Fit N Fun Cross Country Mart Northern Lites Southeast Regional Bigmart Northern Lites Southern Runners Northern Lites Value Choice Corner Runner Fit N Fun Cross Country Mart Southeast Regional Value Choice Northern Lites Goodway Southeast Regional Neighborhood Athletic Supply Family Fit Southeast Regional Runner's Market Neighborhood Athletic Supply Northern Lites Southeast Regional Bigmart Urban Runner Southeast Regional Runner's Market Southern Runners Cross Country Mart Corner Runner Value Choice Cool Threads Family Fit Southeast Regional Super Runners Mark Southeast Regional 31-Aug-15 $ (19,709.89) 26-Aug-15 $ (9,731.16) 21-Sep-15 $ (22,114.82) 11-Sep-15 $ (23,674.76) 9-Sep-15 $ (12,327.94) 13-Sep-15 $ (26,463.75) 14-Aug-15 $ (4,283.44) 21-Aug-15 $ (13,625.81) 28-Aug-15 $ (10,051.11) 21-Aug-15 $ (16,594.74) 28-Aug-15 $ (8,902.72) 9-Sep-15 $ (7,527.80) 1-Sep-15 $ (9,537.44) 15-Sep-15 $ (13,744.34) 25-Sep-15 $ (22,709.74) 16-Sep-15 $ (9,105.39) 8-Oct-15 $ (16,932.51) 1-Oct-15 $ (8,632.26) 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) 8-Sep-15 $ (12,687.02) 16-Oct-15 $ (12,421.74) 28-Sep-15 $ (9,895.25) 31-Aug-15 $ (18,357.25) 29-Sep-15 $ (13,328.83) 8-Oct-15 $ (13,231.73) 16-Oct-15 $ (9,608.54) 8-Oct-15 $ (11,152.68) 9-Oct-15 $ (8,723.65) 7-Nov-15 $ (4,757.86) 13-Oct-15 $ (10,516.60) 2-Oct-15 $ (15,195.80) 6-Oct-15 $ (19,040.00) 7-Nov-15 $ (2,825.06) 3-Dec-15 $ (13,513.05) 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) 4-Dec-15 $ (17,941.92) 27-Nov-15 $ (29,830.01) 19-Nov-15 $ (7,155.00) Bigmart Neighborhood Athletic Supply Corner Runner Urban Runner Bigmart Southern Runners Runner's Market Goodway Bigmart Cool Threads Family Fit Value Choice Bigmart Super Runners Mark Bigmart Cool Threads Value Choice Fit N Fun Cool Threads Goodway Bigmart Fit N Fun Corner Runner Cool Threads Corner Runner Fit N Fun Runner's Market Southeast Regional Family Fit Fit N Fun Cross Country Mart Northern Lites Cool Threads Bigmart Urban Runner Cool Threads Southern Runners Fit N Fun Urban Runner Super Runners Mark Runner's Market Cool Threads Northern Lites Northern Lites Northern Lites 28-Dec-15 $ (18,400.58) 2-Nov-15 $ (11,184.75) 7-Dec-15 $ (14,955.44) 26-Oct-15 $ (1,674.00) 10-Nov-15 $ (18,479.10) 11-Dec-15 $ (843.75) 22-Dec-15 $ (9,101.70) 16-Dec-15 $ (15,329.93) 28-Dec-15 $ (7,155.00) 3-Dec-15 $ (12,220.20) 31-Dec-15 $ (9,402.08) 2-Dec-15 $ (9,175.14) 28-Dec-15 $ (9,416.25) 19-Nov-15 $ (19,137.74) 17-Dec-15 $ (7,681.50) 18-Dec-15 $ (14,966.69) 4-Dec-15 $ (9,684.87) 16-Dec-15 $ (13,052.49) 21-Dec-15 $ (16,287.75) 11-Dec-15 $ (28,032.60) 1-Dec-15 $ (19,505.72) 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) 24-Dec-15 $ (19,381.14) 30-Dec-15 $ (12,287.05) 23-Dec-15 $ (20,019.02) 22-Dec-15 $ (8,321.63) 31-Dec-15 $ (15,360.55) 24-Dec-15 $ (9,939.74) 20-Nov-15 $ (13,395.98) 7-Dec-15 $ (17,765.95) 18-Dec-15 $ (5,250.38) 29-Dec-15 $ (13,669.99) 23-Dec-15 $ (14,964.64) 18-Dec-15 $ (5,740.31) 28-Dec-15 $ (9,939.74) 28-Dec-15 $ (17,328.80) Bigmart Neighborhood Athletic Supply Corner Runner Urban Runner Bigmart Southern Runners Runner's Market Goodway Bigmart Cool Threads Family Fit Value Choice Bigmart Super Runners Mark Bigmart Cool Threads Value Choice Fit N Fun Cool Threads Goodway Bigmart Fit N Fun Corner Runner Cool Threads Corner Runner Fit N Fun Runner's Market Southeast Regional Family Fit Fit N Fun Cross Country Mart Northern Lites Cool Threads Bigmart Urban Runner Cool Threads Southern Runners Fit N Fun Urban Runner Super Runners Mark Runner's Market Cool Threads Northern Lites Northern Lites Northern Lites 28-Dec-15 $ (18,400.58) 2-Nov-15 $ (11,184.75) 7-Dec-15 $ (14,955.44) 26-Oct-15 $ (1,674.00) 10-Nov-15 $ (18,479.10) 11-Dec-15 $ (843.75) 22-Dec-15 $ (9,101.70) 16-Dec-15 $ (15,329.93) 28-Dec-15 $ (7,155.00) 3-Dec-15 $ (12,220.20) 31-Dec-15 $ (9,402.08) 2-Dec-15 $ (9,175.14) 28-Dec-15 $ (9,416.25) 19-Nov-15 $ (19,137.74) 17-Dec-15 $ (7,681.50) 18-Dec-15 $ (14,966.69) 4-Dec-15 $ (9,684.87) 16-Dec-15 $ (13,052.49) 21-Dec-15 $ (16,287.75) 11-Dec-15 $ (28,032.60) 1-Dec-15 $ (19,505.72) 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) 24-Dec-15 $ (19,381.14) 30-Dec-15 $ (12,287.05) 23-Dec-15 $ (20,019.02) 22-Dec-15 $ (8,321.63) 31-Dec-15 $ (15,360.55) 24-Dec-15 $ (9,939.74) 20-Nov-15 $ (13,395.98) 7-Dec-15 $ (17,765.95) 18-Dec-15 $ (5,250.38) 29-Dec-15 $ (13,669.99) 23-Dec-15 $ (14,964.64) 18-Dec-15 $ (5,740.31) 28-Dec-15 $ (9,939.74) 28-Dec-15 $ (17,328.80)