Please read attachments

Babu Dev
FinalExam-Data.xlsx

Notes

Notes Tab for Final Exam
Question #

Validation

Validation Check Figures
Question #

2015 data

Type TransactionNumber AppliedToTransactionNumber CustNum CustName TransactionDate Amount
Sales 1001 1836 Runner's Market 5-Mar-15 $ 16,157.44
Sales 1002 1168 Bigmart 5-Mar-15 $ 9,144.00
Sales 1003 1167 Goodway 5-Mar-15 $ 15,737.60
Sales 1004 1841 Neighborhood Athletic Supply 8-Mar-15 $ 6,008.00
Sales 1005 1842 Northern Lites 8-Mar-15 $ 7,241.60
Sales 1006 1168 Bigmart 13-Mar-15 $ 8,476.00
Sales 1007 1167 Goodway 13-Mar-15 $ 15,737.60
Sales 1008 1814 ValueChoice 13-Mar-15 $ 9,084.40
Sales 1009 1841 Neighborhood Athletic Supply 16-Mar-15 $ 4,240.00
Sales 1010 1842 Northern Lites 16-Mar-15 $ 5,993.60
Sales 1011 1843 Southeast Regional 16-Mar-15 $ 9,019.12
Sales 1012 1861 Family Fit 23-Mar-15 $ 6,552.40
Sales 1013 1863 Fit N Fun 23-Mar-15 $ 5,008.64
Sales 1014 1864 Cross Country Mart 23-Mar-15 $ 11,113.60
Sales 1015 1840 Super Runners Mark 27-Mar-15 $ 17,677.04
Sales 1016 1841 Neighborhood Athletic Supply 27-Mar-15 $ 4,240.00
Sales 1017 1842 Northern Lites 30-Mar-15 $ 7,241.60
Sales 1018 1167 Goodway 2-Apr-15 $ 19,672.00
Sales 1019 1814 ValueChoice 3-Apr-15 $ 6,975.00
Sales 1020 1838 Urban Runner 3-Apr-15 $ 16,230.00
Sales 1021 1863 Fit N Fun 6-Apr-15 $ 7,330.80
Sales 1022 1864 Cross Country Mart 6-Apr-15 $ 13,892.00
Sales 1023 1861 Family Fit 6-Apr-15 $ 8,074.40
Sales 1024 1862 Corner Runner 6-Apr-15 $ 9,642.00
Sales 1025 1840 Super Runners Mark 10-Apr-15 $ 22,096.30
Sales 1026 1841 Neighborhood Athletic Supply 10-Apr-15 $ 7,510.00
Sales 1027 1842 Northern Lites 12-Apr-15 $ 9,052.00
Sales 1028 1861 Family Fit 17-Apr-15 $ 8,190.50
Sales 1029 1842 Northern Lites 17-Apr-15 $ 9,052.00
Sales 1030 1843 Southeast Regional 17-Apr-15 $ 11,273.90
Sales 1031 1836 Runner's Market 23-Apr-15 $ 19,571.80
Sales 1032 1841 Neighborhood Athletic Supply 23-Apr-15 $ 1,300.00
Sales 1033 1168 Bigmart 23-Apr-15 $ 835.00
Sales 1034 1837 Cool Threads 23-Apr-15 $ 7,600.00
Sales 1035 1841 Neighborhood Athletic Supply 23-Apr-15 $ 702.00
Sales 1036 1814 ValueChoice 23-Apr-15 $ 4,380.50
Sales 1037 1167 Goodway 23-Apr-15 $ 19,312.00
Sales 1038 1861 Family Fit 24-Apr-15 $ 8,074.40
Sales 1039 1837 Cool Threads 24-Apr-15 $ 14,092.60
Sales 1040 1842 Northern Lites 27-Apr-15 $ 9,052.00
Sales 1041 1843 Southeast Regional 27-Apr-15 $ 11,119.10
Sales 1042 1168 Bigmart 1-May-15 $ 663.60
Sales 1043 1814 ValueChoice 1-May-15 $ 8,641.08
Sales 1044 1837 Cool Threads 1-May-15 $ 11,424.67
Sales 1045 1168 Bigmart 4-May-15 $ 520.80
Sales 1046 1862 Corner Runner 4-May-15 $ 7,851.48
Sales 1047 1863 Fit N Fun 4-May-15 $ 6,159.72
Sales 1048 1842 Northern Lites 11-May-15 $ 7,603.68
Sales 1049 1843 Southeast Regional 11-May-15 $ 9,340.04
Sales 1050 1861 Family Fit 11-May-15 $ 6,880.02
Sales 1051 1839 Southern Runners 15-May-15 $ 20,832.00
Sales 1052 1840 Super Runners Mark 15-May-15 $ 18,528.38
Sales 1053 1841 Neighborhood Athletic Supply 15-May-15 $ 3,015.60
Sales 1054 1861 Family Fit 18-May-15 $ 6,555.70
Sales 1055 1843 Southeast Regional 18-May-15 $ 9,537.44
Sales 1056 1840 Super Runners Mark 22-May-15 $ 18,713.67
Sales 1057 1842 Northern Lites 25-May-15 $ 7,125.23
Sales 1058 1839 Southern Runners 27-May-15 $ 21,258.94
Sales 1059 1841 Neighborhood Athletic Supply 27-May-15 $ 3,071.88
Sales 1060 1840 Super Runners Mark 27-May-15 $ 18,899.93
Sales 1061 1838 Urban Runner 27-May-15 $ 18,766.27
Sales 1062 1842 Northern Lites 29-May-15 $ 3,408.72
Sales 1063 1167 Goodway 29-May-15 $ 5,066.88
Sales 1064 1843 Southeast Regional 29-May-15 $ 10,341.24
Sales 1065 1842 Northern Lites 2-Jun-15 $ 8,391.94
Sales 1066 1861 Family Fit 2-Jun-15 $ 7,813.39
Sales 1067 1861 Family Fit 5-Jun-15 $ 7,896.37
Sales 1068 1862 Corner Runner 8-Jun-15 $ 9,441.82
Sales 1069 1863 Fit N Fun 8-Jun-15 $ 7,441.67
Sales 1070 1864 Cross Country Mart 8-Jun-15 $ 13,940.70
Sales 1071 1168 Bigmart 11-Jun-15 $ 11,738.30
Sales 1072 1861 Family Fit 12-Jun-15 $ 7,979.70
Sales 1073 1842 Northern Lites 12-Jun-15 $ 8,551.80
Sales 1074 1863 Fit N Fun 15-Jun-15 $ 7,527.80
Sales 1075 1862 Corner Runner 15-Jun-15 $ 9,537.44
Sales 1076 1837 Cool Threads 19-Jun-15 $ 13,744.34
Sales 1077 1840 Super Runners Mark 19-Jun-15 $ 22,709.74
Sales 1078 1842 Northern Lites 22-Jun-15 $ 8,632.26
Sales 1079 1843 Southeast Regional 22-Jun-15 $ 11,688.63
Sales 1080 1861 Family Fit 29-Jun-15 $ 8,147.34
Sales 1081 1843 Southeast Regional 29-Jun-15 $ 11,805.61
Sales 1082 1836 Runner's Market 29-Jun-15 $ 19,709.89
Sales 1083 1862 Corner Runner 29-Jun-15 $ 9,731.16
Sales 1084 1167 Goodway 2-Jul-15 $ 22,114.82
Sales 1085 1836 Runner's Market 2-Jul-15 $ 23,674.76
Sales 1086 1814 ValueChoice 3-Jul-15 $ 12,327.94
Sales 1087 1840 Super Runners Mark 3-Jul-15 $ 26,463.75
Sales 1088 1841 Neighborhood Athletic Supply 3-Jul-15 $ 4,283.44
Sales 1089 1843 Southeast Regional 6-Jul-15 $ 13,625.81
Sales 1090 1842 Northern Lites 6-Jul-15 $ 10,051.11
Sales 1091 1864 Cross Country Mart 6-Jul-15 $ 16,594.74
Sales 1092 1863 Fit N Fun 6-Jul-15 $ 8,902.72
Sales 1093 1168 Bigmart 15-Jul-15 $ 7,527.80
Sales 1094 1862 Corner Runner 15-Jul-15 $ 9,537.44
Sales 1095 1837 Cool Threads 17-Jul-15 $ 13,744.34
Sales 1096 1840 Super Runners Mark 17-Jul-15 $ 22,709.74
Sales 1097 1863 Fit N Fun 20-Jul-15 $ 9,105.39
Sales 1098 1864 Cross Country Mart 20-Jul-15 $ 16,932.51
Sales 1099 1842 Northern Lites 21-Jul-15 $ 8,632.26
Sales 1100 1843 Southeast Regional 21-Jul-15 $ 11,688.63
Sales 1101 1168 Bigmart 21-Jul-15 $ 25,976.16
Sales 1102 1842 Northern Lites 22-Jul-15 $ 8,212.96
Sales 1103 1839 Southern Runners 22-Jul-15 $ 49,452.37
Sales 1104 1842 Northern Lites 22-Jul-15 $ 23,758.22
Sales 1105 1814 ValueChoice 24-Jul-15 $ 12,687.02
Sales 1106 1862 Corner Runner 3-Aug-15 $ 12,421.74
Sales 1107 1863 Fit N Fun 3-Aug-15 $ 9,895.25
Sales 1108 1864 Cross Country Mart 3-Aug-15 $ 18,357.25
Sales 1109 1843 Southeast Regional 6-Aug-15 $ 13,328.83
Sales 1110 1814 ValueChoice 7-Aug-15 $ 13,231.73
Sales 1111 1842 Northern Lites 7-Aug-15 $ 9,608.54
Sales 1112 1167 Goodway 7-Aug-15 $ 11,152.68
Sales 1113 1843 Southeast Regional 7-Aug-15 $ 8,723.65
Sales 1114 1841 Neighborhood Athletic Supply 10-Aug-15 $ 4,757.86
Sales 1115 1861 Family Fit 10-Aug-15 $ 10,516.60
Sales 1116 1843 Southeast Regional 10-Aug-15 $ 15,195.80
Sales 1117 1836 Runner's Market 10-Aug-15 $ 19,040.00
Sales 1118 1841 Neighborhood Athletic Supply 10-Aug-15 $ 2,825.06
Sales 1119 1842 Northern Lites 18-Aug-15 $ 13,513.05
Sales 1120 1843 Southeast Regional 20-Aug-15 $ 6,771.10
Sales 1121 1168 Bigmart 20-Aug-15 $ 10,771.88
Sales 1122 1838 Urban Runner 20-Aug-15 $ 13,231.73
Sales 1123 1843 Southeast Regional 20-Aug-15 $ 9,608.54
Sales 1124 1836 Runner's Market 26-Aug-15 $ 10,771.88
Sales 1125 1839 Southern Runners 26-Aug-15 $ 13,231.73
Sales 1126 1864 Cross Country Mart 31-Aug-15 $ 18,917.60
Sales 1127 1862 Corner Runner 31-Aug-15 $ 12,798.02
Sales 1128 1814 ValueChoice 31-Aug-15 $ 14,034.27
Sales 1129 1837 Cool Threads 31-Aug-15 $ 18,241.81
Sales 1130 1861 Family Fit 7-Sep-15 $ 12,419.54
Sales 1131 1843 Southeast Regional 7-Sep-15 $ 17,941.92
Sales 1132 1842 Northern Lites 7-Sep-15 $ 14,103.74
Sales 1133 1840 Super Runners Mark 10-Sep-15 $ 29,830.01
Sales 1134 1843 Southeast Regional 10-Sep-15 $ 7,155.00
Sales 1135 1168 Bigmart 11-Sep-15 $ 18,400.58
Sales 1136 1841 Neighborhood Athletic Supply 11-Sep-15 $ 11,184.75
Sales 1137 1862 Corner Runner 11-Sep-15 $ 14,955.44
Sales 1138 1838 Urban Runner 11-Sep-15 $ 1,674.00
Sales 1139 1168 Bigmart 17-Sep-15 $ 18,479.10
Sales 1140 1839 Southern Runners 22-Sep-15 $ 843.75
Sales 1141 1836 Runner's Market 22-Sep-15 $ 9,101.70
Sales 1142 1167 Goodway 23-Sep-15 $ 15,329.93
Sales 1143 1168 Bigmart 24-Sep-15 $ 7,155.00
Sales 1144 1837 Cool Threads 25-Sep-15 $ 12,220.20
Sales 1145 1861 Family Fit 28-Sep-15 $ 9,402.08
Sales 1146 1814 ValueChoice 28-Sep-15 $ 9,175.14
Sales 1147 1168 Bigmart 30-Sep-15 $ 9,416.25
Sales 1148 1840 Super Runners Mark 30-Sep-15 $ 19,137.74
Sales 1149 1168 Bigmart 1-Oct-15 $ 7,681.50
Sales 1150 1837 Cool Threads 2-Oct-15 $ 14,966.69
Sales 1151 1814 ValueChoice 2-Oct-15 $ 9,684.87
Sales 1152 1863 Fit N Fun 5-Oct-15 $ 13,052.49
Sales 1153 1837 Cool Thread 6-Oct-15 $ 16,287.75
Sales 1154 1167 Goodway 6-Oct-15 $ 28,032.60
Sales 1155 1168 Bigmart 8-Oct-15 $ 19,505.72
Sales 1156 1863 Fit N Fun 15-Oct-15 $ 13,052.49
Sales 1157 1862 Corner Runner 15-Oct-15 $ 17,234.59
Sales 1158 1842 Northern Lites 15-Oct-15 $ 11,061.21
Sales 1159 1843 Southeast Regional 15-Oct-15 $ 13,742.20
Sales 1160 1837 Cool Threads 16-Oct-15 $ 14,966.69
Sales 1161 1862 Corner Runner 19-Oct-15 $ 17,234.59
Sales 1162 1863 Fit N Fun 19-Oct-15 $ 13,052.49
Sales 1163 1836 Runner's Market 20-Oct-15 $ 1,852.50
Sales 1164 1843 Southeast Regional 21-Oct-15 $ 23,127.75
Sales 1165 1861 Family Fit 23-Oct-15 $ 9,924.41
Sales 1166 1863 Fit N Fun 26-Oct-15 $ 13,052.49
Sales 1167 1864 Cross Country Mart 26-Oct-15 $ 20,636.35
Sales 1168 1838 Urban Runner 28-Oct-15 $ 788.03
Sales 1169 1836 Runner's Market 28-Oct-15 $ 14,658.98
Sales 1170 1842 Northern Lites 28-Oct-15 $ 19,381.14
Sales 1171 1864 Cross Country Mart 28-Oct-15 $ 21,275.25
Sales 1172 1839 Southern Runners 29-Oct-15 $ 912.00
Sales 1173 1837 Cool Threads 4-Nov-15 $ 12,287.05
Sales 1174 1168 Bigmart 5-Nov-15 $ 20,019.02
Sales 1175 1838 Urban Runner 5-Nov-15 $ 8,321.63
Sales 1176 1840 Super Runners Mark 5-Nov-15 $ 1,164.15
Sales 1177 1842 Northern Lites 5-Nov-15 $ 13,454.51
Sales 1178 1861 Family Fit 5-Nov-15 $ 20,019.02
Sales 1179 1814 ValueChoice 6-Nov-15 $ 9,939.74
Sales 1180 1837 Cool Threads 6-Nov-15 $ 15,360.55
Sales 1181 1839 Southern Runners 6-Nov-15 $ 9,939.74
Sales 1182 1863 Fit N Fun 9-Nov-15 $ 13,395.98
Sales 1183 1168 Bigmart 10-Nov-15 $ 14,816.13
Sales 1184 1838 Urban Runner 10-Nov-15 $ 17,765.95
Sales 1185 1167 Goodway 11-Nov-15 $ 21,835.13
Sales 1186 1839 Southern Runners 11-Nov-15 $ 12,116.81
Sales 1187 1840 Super Runners Mark 12-Nov-15 $ 5,250.38
Sales 1188 1838 Urban Runner 12-Nov-15 $ 15,445.09
Sales 1189 1842 Northern Lites 13-Nov-15 $ 10,724.51
Sales 1190 1836 Runner's Market 13-Nov-15 $ 13,669.99
Sales 1191 1840 Super Runners Mark 16-Nov-15 $ 18,141.76
Sales 1192 1837 Cool Threads 17-Nov-15 $ 14,964.64
Sales 1193 1167 Goodway 17-Nov-15 $ 11,889.85
Sales 1194 1839 Southern Runners 18-Nov-15 $ 15,195.18
Sales 1195 1168 Bigmart 20-Nov-15 $ 23,462.23
Sales 1196 1842 Northern Lites 23-Nov-15 $ 5,740.31
Sales 1197 1840 Super Runners Mark 25-Nov-15 $ 15,345.63
Sales 1198 1839 Southern Runners 30-Nov-15 $ 13,618.43
Sales 1199 1167 Goodway 30-Nov-15 $ 12,795.24
Sales 1200 1842 Northern Lites 1-Dec-15 $ 9,939.74
Sales 1201 1841 Neighborhood Athletic Supply 2-Dec-15 $ 11,735.30
Sales 1202 1838 Urban Runner 4-Dec-15 $ 14,162.74
Sales 1203 1842 Northern Lites 4-Dec-15 $ 17,000.53
Sales 1204 1168 Bigmart 4-Dec-15 $ 13,464.67
Sales 1205 1839 Southern Runners 11-Dec-15 $ 14,306.15
Sales 1206 1836 Runner's Market 14-Dec-15 $ 13,464.67
Sales 1207 1840 Super Runners Mark 14-Dec-15 $ 17,778.84
Sales 1208 1838 Urban Runner 17-Dec-15 $ 6,264.99
Sales 1209 1837 Cool Threads 17-Dec-15 $ 12,786.27
Sales 1210 1814 ValueChoice 18-Dec-15 $ 9,542.40
Sales 1211 1841 Neighborhood Athletic Supply 18-Dec-15 $ 11,561.40
Sales 1212 1861 Family Fit 21-Dec-15 $ 9,615.96
Sales 1213 1863 Fit N Fun 21-Dec-15 $ 12,786.27
Sales 1214 1842 Northern Lites 21-Dec-15 $ 17,328.80
Sales 1215 1838 Urban Runner 21-Dec-15 $ 12,786.27
Sales 1216 1843 Southeast Regional 22-Dec-15 $ 11,039.70
Sales 1217 1838 Urban Runner 23-Dec-15 $ 830.84
Sales 1218 1836 Runner's Market 23-Dec-15 $ 23,293.06
Sales 1219 1843 Southeast Regional 23-Dec-15 $ 16,029.20
Sales 1220 1842 Northern Lites 23-Dec-15 $ 20,819.88
Sales 1221 1843 Southeast Regional 23-Dec-15 $ 9,990.71
Sales 1222 1837 Cool Threads 23-Dec-15 $ 830.84
Sales 1223 1842 Northern Lites 24-Dec-15 $ 11,410.51
Sales 1224 1814 ValueChoice 24-Dec-15 $ 14,176.16
Sales 1225 1843 Southeast Regional 28-Dec-15 $ 18,904.57
Sales 1226 1842 Northern Lites 28-Dec-15 $ 14,462.35
Sales 1227 1168 Bigmart 28-Dec-15 $ 12,821.28
Sales 1228 1839 Southern Runners 28-Dec-15 $ 12,786.27
Sales 1229 1842 Northern Lites 30-Dec-15 $ 25,838.52
Sales 1230 1837 Cool Threads 31-Dec-15 $ 7,496.02
CashReceipt 11001 1001 1836 Runner's Market 25-Mar-15 $ (16,157.44)
CashReceipt 11002 1002 1168 Bigmart 8-Apr-15 $ (9,144.00)
CashReceipt 11003 1003 1167 Goodway 16-Apr-15 $ (15,737.60)
CashReceipt 11004 1004 1841 Neighborhood Athletic Supply 9-Apr-15 $ (6,008.00)
CashReceipt 11005 1005 1842 Northern Lites 3-Apr-15 $ (7,241.60)
CashReceipt 11006 1006 1168 Bigmart 22-Apr-15 $ (8,476.00)
CashReceipt 11007 1007 1167 Goodway 30-Apr-15 $ (15,737.60)
CashReceipt 11008 1008 1814 ValueChoice 4-May-15 $ (9,084.40)
CashReceipt 11009 1009 1841 Neighborhood Athletic Supply 19-May-15 $ (4,240.00)
CashReceipt 11010 1010 1842 Northern Lites 28-May-15 $ (5,993.60)
CashReceipt 11011 1011 1843 Southeast Regional 12-May-15 $ (9,019.12)
CashReceipt 11012 1012 1861 Family Fit 2-May-15 $ (6,552.40)
CashReceipt 11013 1013 1863 Fit N Fun 25-May-15 $ (5,008.64)
CashReceipt 11014 1014 1864 Cross Country Mart 7-May-15 $ (11,113.60)
CashReceipt 11015 1015 1840 Super Runners Mark 14-May-15 $ (17,677.04)
CashReceipt 11016 1016 1841 Neighborhood Athletic Supply 18-May-15 $ (4,240.00)
CashReceipt 11017 1017 1842 Northern Lites 22-Apr-15 $ (7,241.60)
CashReceipt 11018 1018 1167 Goodway 30-Apr-15 $ (19,672.00)
CashReceipt 11019 1019 1814 ValueChoice 7-May-15 $ (6,975.00)
CashReceipt 11020 1020 1838 Urban Runner 19-May-15 $ (16,230.00)
CashReceipt 11021 1021 1863 Fit N Fun 29-May-15 $ (7,330.80)
CashReceipt 11022 1022 1864 Cross Country Mart 11-May-15 $ (13,892.00)
CashReceipt 11023 1023 1861 Family Fit 14-May-15 $ (8,074.40)
CashReceipt 11024 1024 1862 Corner Runner 25-May-15 $ (9,642.00)
CashReceipt 11025 1025 1840 Super Runners Mark 8-Jun-15 $ (22,096.30)
CashReceipt 11026 1026 1841 Neighborhood Athletic Supply 10-May-15 $ (7,510.00)
CashReceipt 11027 1027 1842 Northern Lites 16-May-15 $ (9,052.00)
CashReceipt 11028 1028 1861 Family Fit 10-Jun-15 $ (8,190.50)
CashReceipt 11029 1029 1842 Northern Lites 11-May-15 $ (9,052.00)
CashReceipt 11030 1030 1843 Southeast Regional 15-May-15 $ (11,273.90)
CashReceipt 11031 1031 1836 Runner's Market 23-May-15 $ (19,571.80)
CashReceipt 11032 1032 1841 Neighborhood Athletic Supply 29-May-15 $ (1,300.00)
CashReceipt 11033 1033 1168 Bigmart 4-Jun-15 $ (835.00)
CashReceipt 11034 1034 1837 Cool Threads 18-Jul-15 $ (7,600.00)
CashReceipt 11035 1035 1841 Neighborhood Athletic Supply 6-Jul-15 $ (702.00)
CashReceipt 11036 1036 1814 ValueChoice 20-Jun-15 $ (4,380.50)
CashReceipt 11037 1037 1167 Goodway 10-Jun-15 $ (19,312.00)
CashReceipt 11038 1038 1861 Family Fit 3-Jul-15 $ (8,074.40)
CashReceipt 11039 1039 1837 Cool Threads 25-Jun-15 $ (14,092.60)
CashReceipt 11040 1040 1842 Northern Lites 23-Jun-15 $ (9,052.00)
CashReceipt 11041 1041 1843 Southeast Regional 26-Jun-15 $ (11,119.10)
CashReceipt 11042 1042 1168 Bigmart 5-Jun-15 $ (663.60)
CashReceipt 11043 1043 1814 ValueChoice 31-May-15 $ (8,641.08)
CashReceipt 11044 1044 1837 Cool Threads 5-Jun-15 $ (11,424.67)
CashReceipt 11045 1045 1168 Bigmart 19-Jun-15 $ (520.80)
CashReceipt 11046 1046 1862 Corner Runner 26-Jun-15 $ (7,851.48)
CashReceipt 11047 1047 1863 Fit N Fun 24-Jun-15 $ (6,159.72)
CashReceipt 11048 1048 1842 Northern Lites 22-Jun-15 $ (7,603.68)
CashReceipt 11049 1049 1843 Southeast Regional 2-Jul-15 $ (9,340.04)
CashReceipt 11050 1050 1861 Family Fit 10-Jul-15 $ (6,880.02)
CashReceipt 11051 1051 1839 Southern Runners 7-Jul-15 $ (20,832.00)
CashReceipt 11052 1052 1840 Super Runners Mark 29-Jul-15 $ (18,528.38)
CashReceipt 11053 1053 1841 Neighborhood Athletic Supply 21-Jul-15 $ (3,015.60)
CashReceipt 11054 1054 1861 Family Fit 20-Jul-15 $ (6,555.70)
CashReceipt 11055 1055 1843 Southeast Regional 23-Jul-15 $ (9,537.44)
CashReceipt 11056 1056 1840 Super Runners Mark 30-Jun-15 $ (18,713.67)
CashReceipt 11057 1057 1842 Northern Lites 6-Jul-15 $ (7,125.23)
CashReceipt 11058 1058 1839 Southern Runners 18-Jul-15 $ (21,258.94)
CashReceipt 11059 1059 1841 Neighborhood Athletic Supply 30-Jul-15 $ (3,071.88)
CashReceipt 11060 1060 1840 Super Runners Mark 7-Aug-15 $ (18,899.93)
CashReceipt 11061 1061 1838 Urban Runner 20-Jul-15 $ (18,766.27)
CashReceipt 11062 1062 1842 Northern Lites 13-Jul-15 $ (3,408.72)
CashReceipt 11063 1063 1167 Goodway 23-Jul-15 $ (5,066.88)
CashReceipt 11064 1064 1843 Southeast Regional 18-Jul-15 $ (10,341.24)
CashReceipt 11065 1065 1842 Northern Lites 7-Jul-15 $ (8,391.94)
CashReceipt 11066 1066 1861 Family Fit 10-Jul-15 $ (7,813.39)
CashReceipt 11067 1067 1861 Family Fit 3-Aug-15 $ (7,896.37)
CashReceipt 11068 1068 1862 Corner Runner 15-Jul-15 $ (9,441.82)
CashReceipt 11069 1069 1863 Fit N Fun 9-Jul-15 $ (7,441.67)
CashReceipt 11070 1070 1864 Cross Country Mart 31-Jul-15 $ (13,940.70)
CashReceipt 11071 1071 1168 Bigmart 13-Aug-15 $ (11,738.30)
CashReceipt 11072 1072 1861 Family Fit 20-Jul-15 $ (7,979.70)
CashReceipt 11073 1073 1842 Northern Lites 23-Jul-15 $ (8,551.80)
CashReceipt 11074 1074 1863 Fit N Fun 11-Aug-15 $ (7,527.80)
CashReceipt 11075 1075 1862 Corner Runner 22-Jul-15 $ (9,537.44)
CashReceipt 11076 1076 1837 Cool Threads 20-Jul-15 $ (13,744.34)
CashReceipt 11077 1077 1840 Super Runners Mark 3-Aug-15 $ (22,709.74)
CashReceipt 11078 1078 1842 Northern Lites 13-Aug-15 $ (8,632.26)
CashReceipt 11079 1079 1843 Southeast Regional 17-Aug-15 $ (11,688.63)
CashReceipt 11080 1080 1861 Family Fit 7-Sep-15 $ (8,147.34)
CashReceipt 11081 1081 1843 Southeast Regional 15-Sep-15 $ (11,805.61)
CashReceipt 11082 1082 1836 Runner's Market 31-Aug-15 $ (19,709.89)
CashReceipt 11083 1083 1862 Corner Runner 26-Aug-15 $ (9,731.16)
CashReceipt 11084 1084 1167 Goodway 21-Sep-15 $ (22,114.82)
CashReceipt 11085 1085 1836 Runner's Market 11-Sep-15 $ (23,674.76)
CashReceipt 11086 1086 1814 ValueChoice 9-Sep-15 $ (12,327.94)
CashReceipt 11087 1087 1840 Super Runners Mark 13-Sep-15 $ (26,463.75)
CashReceipt 11088 1088 1841 Neighborhood Athletic Supply 14-Aug-15 $ (4,283.44)
CashReceipt 11089 1089 1843 Southeast Regional 21-Aug-15 $ (13,625.81)
CashReceipt 11090 1090 1842 Northern Lites 28-Aug-15 $ (10,051.11)
CashReceipt 11091 1091 1864 Cross Country Mart 21-Aug-15 $ (16,594.74)
CashReceipt 11092 1092 1863 Fit N Fun 28-Aug-15 $ (8,902.72)
CashReceipt 11093 1093 1168 Bigmart 9-Sep-15 $ (7,527.80)
CashReceipt 11094 1094 1862 Corner Runner 1-Sep-15 $ (9,537.44)
CashReceipt 11095 1095 1837 Cool Threads 15-Sep-15 $ (13,744.34)
CashReceipt 11096 1096 1840 Super Runners Mark 25-Sep-15 $ (22,709.74)
CashReceipt 11097 1097 1863 Fit N Fun 16-Sep-15 $ (9,105.39)
CashReceipt 11098 1098 1864 Cross Country Mart 8-Oct-15 $ (16,932.51)
CashReceipt 11099 1099 1842 Northern Lites 1-Oct-15 $ (8,632.26)
CashReceipt 11100 1100 1843 Southeast Regional 7-Sep-15 $ (11,688.63)
CashReceipt 11101 1101 1168 Bigmart 11-Sep-15 $ (25,976.16)
CashReceipt 11102 1102 1842 Northern Lites 4-Sep-15 $ (8,212.96)
CashReceipt 11103 1103 1839 Southern Runners 8-Sep-15 $ (49,452.37)
CashReceipt 11104 1104 1842 Northern Lites 25-Aug-15 $ (23,758.22)
CashReceipt 11105 1105 1814 ValueChoice 8-Sep-15 $ (12,687.02)
CashReceipt 11106 1106 1862 Corner Runner 16-Oct-15 $ (12,421.74)
CashReceipt 11107 1107 1863 Fit N Fun 28-Sep-15 $ (9,895.25)
CashReceipt 11108 1108 1864 Cross Country Mart 31-Aug-15 $ (18,357.25)
CashReceipt 11109 1109 1843 Southeast Regional 29-Sep-15 $ (13,328.83)
CashReceipt 11110 1110 1814 ValueChoice 8-Oct-15 $ (13,231.73)
CashReceipt 11111 1111 1842 Northern Lites 16-Oct-15 $ (9,608.54)
CashReceipt 11112 1112 1167 Goodway 8-Oct-15 $ (11,152.68)
CashReceipt 11113 1113 1843 Southeast Regional 9-Oct-15 $ (8,723.65)
CashReceipt 11114 1114 1841 Neighborhood Athletic Supply 7-Nov-15 $ (4,757.86)
CashReceipt 11115 1115 1861 Family Fit 13-Oct-15 $ (10,516.60)
CashReceipt 11116 1116 1843 Southeast Regional 2-Oct-15 $ (15,195.80)
CashReceipt 11117 1117 1836 Runner's Market 6-Oct-15 $ (19,040.00)
CashReceipt 11118 1118 1841 Neighborhood Athletic Supply 7-Nov-15 $ (2,825.06)
CashReceipt 11119 1119 1842 Northern Lites 3-Dec-15 $ (13,513.05)
CashReceipt 11120 1120 1843 Southeast Regional 20-Nov-15 $ (6,771.10)
CashReceipt 11121 1121 1168 Bigmart 5-Oct-15 $ (10,771.88)
CashReceipt 11122 1122 1838 Urban Runner 11-Dec-15 $ (13,231.73)
CashReceipt 11123 1123 1843 Southeast Regional 17-Nov-15 $ (9,608.54)
CashReceipt 11124 1124 1836 Runner's Market 20-Nov-15 $ (10,771.88)
CashReceipt 11125 1125 1839 Southern Runners 15-Oct-15 $ (13,231.73)
CashReceipt 11126 1126 1864 Cross Country Mart 16-Nov-15 $ (18,917.60)
CashReceipt 11127 1127 1862 Corner Runner 18-Nov-15 $ (12,798.02)
CashReceipt 11128 1128 1814 ValueChoice 3-Nov-15 $ (14,034.27)
CashReceipt 11129 1129 1837 Cool Threads 1-Dec-15 $ (18,241.81)
CashReceipt 11130 1130 1861 Family Fit 22-Oct-15 $ (12,419.54)
CashReceipt 11131 1131 1843 Southeast Regional 4-Dec-15 $ (17,941.92)
CashReceipt 11133 1133 1840 Super Runners Mark 27-Nov-15 $ (29,830.01)
CashReceipt 11134 1134 1843 Southeast Regional 19-Nov-15 $ (7,155.00)
CashReceipt 11135 1135 1168 Bigmart 28-Dec-15 $ (18,400.58)
CashReceipt 11136 1136 1841 Neighborhood Athletic Supply 2-Nov-15 $ (11,184.75)
CashReceipt 11137 1137 1862 Corner Runner 7-Dec-15 $ (14,955.44)
CashReceipt 11138 1138 1838 Urban Runner 26-Oct-15 $ (1,674.00)
CashReceipt 11139 1139 1168 Bigmart 10-Nov-15 $ (18,479.10)
CashReceipt 11140 1140 1839 Southern Runners 11-Dec-15 $ (843.75)
CashReceipt 11141 1141 1836 Runner's Market 22-Dec-15 $ (9,101.70)
CashReceipt 11142 1142 1167 Goodway 16-Dec-15 $ (15,329.93)
CashReceipt 11143 1143 1168 Bigmart 28-Dec-15 $ (7,155.00)
CashReceipt 11144 1144 1837 Cool Threads 3-Dec-15 $ (12,220.20)
CashReceipt 11145 1145 1861 Family Fit 31-Dec-15 $ (9,402.08)
CashReceipt 11146 1146 1814 ValueChoice 2-Dec-15 $ (9,175.14)
CashReceipt 11147 1147 1168 Bigmart 28-Dec-15 $ (9,416.25)
CashReceipt 11148 1148 1840 Super Runners Mark 19-Nov-15 $ (19,137.74)
CashReceipt 11149 1149 1168 Bigmart 17-Dec-15 $ (7,681.50)
CashReceipt 11150 1150 1837 Cool Threads 18-Dec-15 $ (14,966.69)
CashReceipt 11151 1151 1814 ValueChoice 4-Dec-15 $ (9,684.87)
CashReceipt 11152 1152 1863 Fit N Fun 16-Dec-15 $ (13,052.49)
CashReceipt 11153 1153 1837 Cool Threads 21-Dec-15 $ (16,287.75)
CashReceipt 11154 1154 1167 Goodway 11-Dec-15 $ (28,032.60)
CashReceipt 11155 1155 1168 Bigmart 1-Dec-15 $ (19,505.72)
CashReceipt 11156 1156 1863 Fit N Fun 25-Nov-15 $ (13,052.49)
CashReceipt 11157 1157 1862 Corner Runner 4-Dec-15 $ (17,234.59)
CashReceipt 11160 1160 1837 Cool Threads 24-Dec-15 $ (14,966.69)
CashReceipt 11161 1161 1862 Corner Runner 30-Nov-15 $ (17,234.59)
CashReceipt 11162 1162 1863 Fit N Fun 26-Dec-15 $ (13,052.49)
CashReceipt 11163 1163 1836 Runner's Market 23-Dec-15 $ (1,852.50)
CashReceipt 11164 1164 1843 Southeast Regional 28-Dec-15 $ (23,127.75)
CashReceipt 11165 1165 1861 Family Fit 28-Dec-15 $ (9,924.41)
CashReceipt 11166 1166 1863 Fit N Fun 31-Dec-15 $ (13,052.49)
CashReceipt 11167 1167 1864 Cross Country Mart 21-Dec-15 $ (20,636.35)
CashReceipt 11170 1170 1842 Northern Lites 24-Dec-15 $ (19,381.14)
CashReceipt 11173 1173 1837 Cool Threads 30-Dec-15 $ (12,287.05)
CashReceipt 11174 1174 1168 Bigmart 23-Dec-15 $ (20,019.02)
CashReceipt 11175 1175 1838 Urban Runner 22-Dec-15 $ (8,321.63)
CashReceipt 11180 1180 1837 Cool Threads 31-Dec-15 $ (15,360.55)
CashReceipt 11181 1181 1839 Southern Runners 24-Dec-15 $ (9,939.74)
CashReceipt 11182 1182 1863 Fit N Fun 20-Nov-15 $ (13,395.98)
CashReceipt 11184 1184 1838 Urban Runner 7-Dec-15 $ (17,765.95)
CashReceipt 11187 1187 1840 Super Runners Mark 18-Dec-15 $ (5,250.38)
CashReceipt 11190 1190 1836 Runner's Market 29-Dec-15 $ (13,669.99)
CashReceipt 11192 1192 1837 Cool Threads 23-Dec-15 $ (14,964.64)
CashReceipt 11196 1196 1842 Northern Lites 18-Dec-15 $ (5,740.31)
CashReceipt 11200 1200 1842 Northern Lites 28-Dec-15 $ (9,939.74)
CashReceipt 11214 1214 1842 Northern Lites 28-Dec-15 $ (17,328.80)

Cash Flow

CASH FLOW MODEL
As of date
12/31/15
Monthly Date (Last Day of Month) 3/31/15
Actual/Forecast
Cash Flow
Gross Cash Revenue (Cash Receipts)
Expenses
Net Operating Cash Flow
Cumulative Cash Flow - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

Expenses

Actual Expenses for 2015
3/31/15 4/30/15 5/31/15 6/30/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15
COGS 100,624.55 74,381.11 100,898.54 52,093.77 99,736.82 101,719.18 123,006.71 84,344.83 179,640.33 323,131.50
Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
G&A 30,554.64 10,711.01 50,175.93 22,658.66 12,467.10 52,031.51 84,004.58 43,432.76 31,856.13 176,191.24
Taxes and Fees 0.00 45,000.00 0.00 0.00 45,000.00 0.00 0.00 45,000.00 0.00 0.00
Professional Costs 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00
Expenses 181,179.19 180,092.12 201,074.47 124,752.43 207,203.92 203,750.69 257,011.29 222,777.59 261,496.46 549,322.74