Hands on Assignment 4

jams_r1
SlsByRep.xlsx
Home>Business & Finance homework help>Operations Management homework help>Hands on Assignment 4

Sls

Date Rep Sales
6/1/11 Bill 148
6/1/11 Amber 107
6/1/11 Amber 232
6/1/11 Amber 73
6/1/11 Bill 136
6/1/11 Dale 88
6/1/11 Chris 49
6/1/11 Amber 134
6/1/11 Bill 62
6/1/11 Amber 202
6/1/11 Amber 299
6/1/11 Amber 36
6/2/11 Dale 82
6/2/11 Bill 107
6/2/11 Bill 278
6/2/11 Bill 37
6/2/11 Bill 134
6/2/11 Chris 145
6/2/11 Eddy 190
6/2/11 Amber 217
6/2/11 Eddy 250
6/2/11 Amber 752
6/2/11 Dale 218
6/2/11 Bill 32
6/2/11 Eddy 109
6/2/11 Bill 66
6/2/11 Bill 117
6/2/11 Eddy 122
6/2/11 Amber 60
6/2/11 Amber 65
6/2/11 Dale 59
6/2/11 Chris 200
6/2/11 Bill 80
6/2/11 Chris 84
6/3/11 Chris 93
6/3/11 Amber 185
6/3/11 Chris 218
6/3/11 Eddy 149
6/3/11 Chris 54
6/3/11 Amber 86
6/3/11 Chris 251
6/3/11 Dale 62
6/3/11 Amber 473
6/3/11 Bill 115
6/3/11 Amber 99
6/3/11 Bill 104
6/3/11 Amber 86
6/3/11 Bill 34
6/3/11 Dale 126
6/3/11 Bill 285
6/3/11 Bill 149
6/3/11 Amber 265
6/3/11 Bill 78
6/3/11 Dale 48
6/3/11 Eddy 146
6/3/11 Amber 114
6/3/11 Chris 91
6/3/11 Amber 136
6/3/11 Chris 321
6/4/11 Bill 105
6/4/11 Amber 99
6/4/11 Eddy 149
6/4/11 Amber 198
6/4/11 Bill 41
6/4/11 Bill 79
6/4/11 Chris 212
6/4/11 Chris 217
6/4/11 Bill 150
6/4/11 Chris 37
6/4/11 Bill 25
6/4/11 Chris 70
6/4/11 Bill 45
6/4/11 Chris 62
6/4/11 Amber 631
6/4/11 Bill 87
6/4/11 Bill 127
6/4/11 Amber 26
6/4/11 Chris 253
6/5/11 Bill 225
6/5/11 Amber 112
6/5/11 Dale 137
6/5/11 Chris 72
6/5/11 Eddy 44
6/5/11 Amber 44
6/5/11 Bill 236
6/5/11 Chris 410
6/5/11 Bill 66
6/5/11 Bill 78
6/5/11 Chris 40
6/5/11 Bill 267
6/5/11 Amber 64
6/5/11 Bill 25
6/5/11 Bill 123
6/5/11 Eddy 54
6/5/11 Amber 142
6/5/11 Amber 265
6/5/11 Amber 140
6/5/11 Amber 61
6/5/11 Amber 72
6/5/11 Bill 284
6/5/11 Eddy 38
6/5/11 Chris 56
6/6/11 Amber 77
6/6/11 Amber 132
6/6/11 Dale 90
6/6/11 Dale 63
6/6/11 Amber 261
6/6/11 Eddy 290
6/6/11 Amber 63
6/6/11 Chris 37
6/6/11 Chris 96
6/6/11 Chris 274
6/6/11 Bill 111
6/6/11 Bill 247
6/6/11 Bill 232
6/6/11 Bill 396
6/6/11 Chris 26
6/6/11 Bill 215
6/6/11 Eddy 57
6/6/11 Chris 93
6/7/11 Chris 146
6/7/11 Bill 225
6/7/11 Amber 133
6/7/11 Chris 243
6/7/11 Chris 37
6/7/11 Amber 802
6/7/11 Bill 38
6/7/11 Amber 63
6/7/11 Bill 145
6/7/11 Dale 73
6/7/11 Chris 132
6/7/11 Eddy 37
6/7/11 Bill 288
6/7/11 Dale 70
6/7/11 Bill 26
6/7/11 Bill 254
6/7/11 Amber 186
6/8/11 Chris 646
6/8/11 Dale 28
6/8/11 Amber 46
6/8/11 Amber 101
6/8/11 Chris 66
6/8/11 Dale 52
6/8/11 Amber 227
6/8/11 Amber 949
6/8/11 Bill 100
6/8/11 Amber 81
6/8/11 Eddy 211
6/8/11 Eddy 130
6/8/11 Amber 230
6/8/11 Bill 50
6/8/11 Amber 198
6/8/11 Chris 53
6/8/11 Eddy 36
6/8/11 Eddy 136
6/8/11 Amber 186
6/8/11 Bill 188
6/9/11 Bill 27
6/9/11 Bill 31
6/9/11 Amber 223
6/9/11 Eddy 37
6/9/11 Amber 101
6/9/11 Bill 37
6/9/11 Chris 39
6/9/11 Amber 208
6/9/11 Amber 138
6/9/11 Bill 116
6/9/11 Dale 172
6/9/11 Bill 139
6/9/11 Chris 160
6/9/11 Bill 81
6/9/11 Amber 190
6/9/11 Eddy 290
6/9/11 Bill 213
6/9/11 Chris 44
6/9/11 Eddy 207
6/9/11 Amber 25
6/9/11 Amber 114
6/9/11 Bill 144
6/9/11 Amber 39
6/9/11 Chris 139
6/9/11 Dale 150
6/9/11 Bill 70
6/9/11 Chris 81
6/10/11 Amber 203
6/10/11 Amber 68
6/10/11 Chris 190
6/10/11 Bill 100
6/10/11 Amber 80
6/10/11 Chris 131
6/10/11 Amber 33
6/10/11 Dale 59
6/10/11 Dale 88
6/10/11 Amber 169
6/10/11 Amber 94
6/10/11 Amber 263
6/10/11 Eddy 238
6/10/11 Dale 219
6/10/11 Amber 84
6/10/11 Eddy 26
6/10/11 Dale 141
6/10/11 Amber 50
6/10/11 Eddy 143
6/10/11 Chris 115
6/10/11 Bill 69
6/10/11 Bill 32
6/10/11 Amber 61
6/11/11 Bill 142
6/11/11 Amber 69
6/11/11 Chris 216
6/11/11 Amber 263
6/11/11 Bill 103
6/11/11 Bill 85
6/11/11 Dale 156
6/11/11 Amber 61
6/11/11 Eddy 54
6/11/11 Amber 162
6/11/11 Bill 570
6/11/11 Chris 124
6/11/11 Amber 150
6/11/11 Amber 122
6/11/11 Chris 122
6/11/11 Amber 101
6/11/11 Dale 212
6/11/11 Amber 124
6/11/11 Bill 267
6/11/11 Chris 26
6/11/11 Amber 35
6/11/11 Bill 30
6/11/11 Amber 209
6/11/11 Dale 300
6/11/11 Chris 112
6/11/11 Amber 297
6/11/11 Amber 264
6/11/11 Chris 102
6/11/11 Amber 275
6/11/11 Eddy 253
6/11/11 Amber 258
6/11/11 Amber 105
6/12/11 Eddy 191
6/12/11 Bill 136
6/12/11 Amber 129
6/12/11 Bill 185
6/12/11 Amber 286
6/12/11 Amber 140
6/12/11 Amber 185
6/12/11 Dale 214
6/12/11 Amber 300
6/12/11 Dale 109
6/12/11 Chris 29
6/12/11 Bill 114
6/12/11 Amber 31
6/12/11 Amber 42
6/12/11 Eddy 137
6/12/11 Dale 144
6/12/11 Dale 285
6/13/11 Bill 141
6/13/11 Bill 959
6/13/11 Dale 217
6/13/11 Amber 35
6/13/11 Chris 89
6/13/11 Chris 125
6/13/11 Chris 95
6/13/11 Chris 208
6/13/11 Dale 201
6/13/11 Chris 139
6/13/11 Chris 68
6/13/11 Dale 150
6/13/11 Eddy 93
6/13/11 Bill 196
6/13/11 Amber 140
6/13/11 Dale 168
6/13/11 Amber 63
6/13/11 Eddy 30
6/13/11 Bill 118
6/13/11 Bill 102
6/13/11 Amber 68
6/13/11 Bill 27
6/13/11 Amber 192
6/13/11 Amber 78
6/13/11 Amber 950
6/13/11 Bill 29
6/13/11 Dale 283
6/13/11 Amber 102
6/13/11 Chris 826
6/13/11 Amber 217
6/14/11 Amber 162
6/14/11 Bill 97
6/14/11 Chris 206
6/14/11 Amber 107
6/14/11 Dale 281
6/14/11 Dale 213
6/14/11 Bill 115
6/14/11 Amber 112
6/14/11 Amber 259
6/14/11 Amber 284
6/14/11 Chris 68
6/14/11 Amber 169
6/14/11 Dale 49
6/14/11 Chris 130
6/14/11 Bill 127
6/14/11 Bill 47
6/14/11 Chris 130
6/14/11 Amber 136
6/14/11 Dale 61
6/14/11 Amber 90
6/14/11 Eddy 165
6/14/11 Eddy 73
6/14/11 Dale 143
6/14/11 Amber 71
6/14/11 Bill 134
6/14/11 Amber 277
6/15/11 Amber 88
6/15/11 Chris 188
6/15/11 Amber 32
6/15/11 Amber 250
6/15/11 Amber 78
6/15/11 Amber 202
6/15/11 Amber 177
6/15/11 Amber 50
6/15/11 Bill 57
6/15/11 Chris 124
6/15/11 Amber 103
6/15/11 Bill 129
6/15/11 Chris 249
6/15/11 Amber 38
6/15/11 Amber 119
6/15/11 Amber 104
6/15/11 Chris 119
6/15/11 Dale 123
6/15/11 Amber 125
6/15/11 Chris 56
6/15/11 Dale 105
6/15/11 Amber 112
6/15/11 Amber 201
6/15/11 Dale 300
6/15/11 Amber 272
6/15/11 Dale 26
6/16/11 Amber 260
6/16/11 Dale 64
6/16/11 Chris 212
6/16/11 Bill 68
6/16/11 Amber 132
6/16/11 Bill 154
6/16/11 Chris 88
6/16/11 Chris 264
6/16/11 Chris 220
6/16/11 Chris 294
6/16/11 Dale 141
6/16/11 Bill 62
6/16/11 Bill 40
6/16/11 Amber 49
6/16/11 Bill 71
6/16/11 Bill 186
6/16/11 Chris 65
6/16/11 Bill 192
6/17/11 Amber 117
6/17/11 Bill 202
6/17/11 Bill 276
6/17/11 Bill 31
6/17/11 Eddy 274
6/17/11 Dale 141
6/17/11 Dale 214
6/17/11 Bill 233
6/17/11 Dale 85
6/17/11 Dale 57
6/17/11 Dale 289
6/17/11 Dale 131
6/17/11 Bill 208
6/17/11 Amber 298
6/17/11 Bill 30
6/17/11 Amber 100
6/17/11 Chris 38
6/17/11 Bill 145
6/17/11 Chris 85
6/17/11 Amber 41
6/17/11 Chris 62
6/17/11 Bill 32
6/17/11 Chris 148
6/17/11 Chris 145
6/18/11 Bill 264
6/18/11 Eddy 61
6/18/11 Bill 210
6/18/11 Dale 129
6/18/11 Bill 255
6/18/11 Amber 252
6/18/11 Chris 106
6/18/11 Bill 100
6/18/11 Eddy 67
6/18/11 Eddy 31
6/18/11 Bill 269
6/18/11 Bill 210
6/18/11 Amber 141
6/18/11 Bill 47
6/18/11 Dale 239
6/18/11 Chris 133
6/18/11 Amber 148
6/18/11 Chris 80
6/18/11 Bill 103
6/18/11 Chris 199
6/18/11 Amber 119
6/18/11 Dale 48
6/18/11 Chris 59
6/18/11 Chris 254
6/18/11 Dale 99
6/19/11 Amber 75
6/19/11 Bill 54
6/19/11 Chris 84
6/19/11 Dale 120
6/19/11 Amber 34
6/19/11 Amber 219
6/19/11 Bill 246
6/19/11 Chris 71
6/19/11 Amber 38
6/19/11 Chris 410
6/19/11 Chris 829
6/19/11 Amber 118
6/19/11 Amber 274
6/19/11 Dale 228
6/19/11 Bill 218
6/19/11 Dale 126
6/19/11 Chris 28
6/20/11 Bill 62
6/20/11 Bill 109
6/20/11 Amber 73
6/20/11 Bill 42
6/20/11 Dale 294
6/20/11 Chris 72
6/20/11 Bill 117
6/20/11 Eddy 65
6/20/11 Chris 109
6/20/11 Bill 66
6/20/11 Bill 163
6/20/11 Amber 263
6/20/11 Amber 274
6/20/11 Bill 29
6/20/11 Bill 94
6/20/11 Dale 94
6/20/11 Bill 91
6/20/11 Chris 57
6/20/11 Amber 229
6/20/11 Amber 130
6/20/11 Chris 34
6/21/11 Chris 53
6/21/11 Amber 296
6/21/11 Eddy 132
6/21/11 Eddy 183
6/21/11 Bill 164
6/21/11 Bill 28
6/21/11 Chris 34
6/21/11 Amber 53
6/21/11 Eddy 57
6/21/11 Chris 73
6/21/11 Chris 275
6/21/11 Amber 118
6/21/11 Dale 259
6/21/11 Eddy 141
6/21/11 Dale 42
6/21/11 Chris 33
6/21/11 Amber 217
6/21/11 Amber 202
6/22/11 Chris 134
6/22/11 Amber 111
6/22/11 Amber 27
6/22/11 Amber 149
6/22/11 Eddy 230
6/22/11 Bill 135
6/22/11 Amber 137
6/22/11 Bill 682
6/22/11 Bill 59
6/22/11 Dale 233
6/22/11 Chris 229
6/22/11 Bill 165
6/22/11 Bill 149
6/22/11 Amber 112
6/22/11 Bill 126
6/22/11 Amber 193
6/22/11 Dale 108
6/22/11 Chris 163
6/22/11 Amber 58
6/22/11 Chris 64
6/22/11 Eddy 264
6/22/11 Dale 209
6/22/11 Dale 210
6/22/11 Eddy 266
6/22/11 Chris 166
6/23/11 Bill 79
6/23/11 Bill 162
6/23/11 Bill 211
6/23/11 Dale 30
6/23/11 Dale 50
6/23/11 Bill 150
6/23/11 Bill 33
6/23/11 Dale 155
6/23/11 Bill 211
6/23/11 Dale 124
6/23/11 Chris 150
6/23/11 Amber 142
6/23/11 Eddy 151
6/23/11 Chris 80
6/23/11 Chris 73
6/23/11 Amber 103
6/23/11 Eddy 239
6/23/11 Chris 134
6/23/11 Bill 110
6/24/11 Bill 142
6/24/11 Amber 110
6/24/11 Bill 104
6/24/11 Amber 70
6/24/11 Chris 89
6/24/11 Dale 134
6/24/11 Bill 585
6/24/11 Bill 51
6/24/11 Eddy 112
6/24/11 Chris 44
6/24/11 Dale 257
6/24/11 Amber 34
6/24/11 Chris 746
6/24/11 Bill 258
6/24/11 Dale 67
6/24/11 Dale 222
6/24/11 Bill 69
6/24/11 Bill 176
6/24/11 Amber 125
6/25/11 Bill 31
6/25/11 Dale 143
6/25/11 Amber 77
6/25/11 Amber 95
6/25/11 Bill 104
6/25/11 Dale 39
6/25/11 Bill 85
6/25/11 Amber 125
6/25/11 Amber 53
6/25/11 Bill 50
6/25/11 Amber 262
6/25/11 Amber 691
6/25/11 Amber 122
6/25/11 Dale 104
6/25/11 Amber 57
6/25/11 Dale 173
6/25/11 Chris 132
6/25/11 Chris 221
6/26/11 Dale 99
6/26/11 Bill 103
6/26/11 Bill 279
6/26/11 Amber 46
6/26/11 Dale 159
6/26/11 Dale 49
6/26/11 Bill 71
6/26/11 Dale 203
6/26/11 Amber 174
6/26/11 Bill 92
6/26/11 Chris 284
6/26/11 Bill 904
6/26/11 Chris 143
6/26/11 Dale 37
6/26/11 Bill 40
6/26/11 Eddy 56
6/26/11 Chris 145
6/26/11 Bill 138
6/26/11 Dale 160
6/26/11 Bill 256
6/26/11 Dale 223
6/26/11 Amber 54
6/26/11 Amber 135
6/26/11 Chris 61
6/26/11 Bill 245
6/27/11 Chris 50
6/27/11 Dale 89
6/27/11 Amber 180
6/27/11 Amber 113
6/27/11 Amber 84
6/27/11 Chris 257
6/27/11 Bill 690
6/27/11 Bill 30
6/27/11 Chris 291
6/27/11 Dale 109
6/27/11 Bill 92
6/27/11 Dale 191
6/27/11 Bill 154
6/27/11 Chris 101
6/27/11 Amber 248
6/27/11 Amber 269
6/27/11 Amber 773
6/27/11 Bill 255
6/27/11 Amber 72
6/28/11 Bill 151
6/28/11 Amber 125
6/28/11 Bill 69
6/28/11 Eddy 292
6/28/11 Chris 116
6/28/11 Amber 292
6/28/11 Bill 37
6/28/11 Amber 107
6/28/11 Dale 149
6/28/11 Dale 164
6/28/11 Amber 51
6/28/11 Bill 34
6/28/11 Amber 240
6/28/11 Chris 288
6/28/11 Amber 115
6/28/11 Dale 136
6/28/11 Amber 290
6/28/11 Amber 42
6/28/11 Eddy 137
6/28/11 Amber 31
6/29/11 Amber 71
6/29/11 Bill 55
6/29/11 Dale 142
6/29/11 Chris 216
6/29/11 Chris 196
6/29/11 Chris 44
6/29/11 Bill 51
6/29/11 Chris 178
6/29/11 Bill 117
6/29/11 Bill 25
6/29/11 Dale 83
6/29/11 Dale 46
6/29/11 Amber 229
6/29/11 Bill 73
6/29/11 Amber 216
6/29/11 Chris 134
6/29/11 Chris 99
6/29/11 Dale 128
6/29/11 Bill 53
6/29/11 Chris 74
6/29/11 Bill 136
6/29/11 Bill 51
6/30/11 Dale 105
6/30/11 Bill 190
6/30/11 Bill 148
6/30/11 Dale 281
6/30/11 Amber 210
6/30/11 Bill 42
6/30/11 Bill 197
6/30/11 Bill 99
6/30/11 Amber 120
6/30/11 Amber 88
6/30/11 Chris 74
6/30/11 Dale 36
6/30/11 Bill 52
6/30/11 Dale 297
6/30/11 Dale 169
6/30/11 Amber 201
6/30/11 Dale 97
6/30/11 Amber 55
6/30/11 Bill 129
6/30/11 Bill 89
6/30/11 Chris 138
6/30/11 Bill 93
6/30/11 Chris 126

Sheet2

Sheet3