Description
3 exams. I am looking for a tutor who is capable of completing this assignment. If you don’t know anything about excel please do not look at this question. Thanks. This assignment is 7 parts. I have only attached the first 2 parts. Again please look at the attachment and if you are familiar with this assignment I would love to work with you
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
20180417231447amber.thomas_exam4.xlsx
Summary
amber.thomas
Exam 4 Summary
Worksheets
Revenue
Analysis
Filtered
Totals
4/18/2018
Value
357,944
387,944
49,983
357,944
Range
Revenue_Total
Analysis_Total
Filtered_Total
Grand_Total
1:14 AM
1
Thomas Revenue
Last
Name
Ling
Ling
Thomas
Davolio
Thomas
Thomas
Thomas
Thomas
Conner
Conner
Conner
Conner
Conner
Thomas
Thomas
Thomas
Thomas
Thomas
Conner
Callahan
Conner
Callahan
Callahan
Thomas
Callahan
Thomas
Thomas
Callahan
Callahan
Davolio
Davolio
Thomas
Thomas
Thomas
Callahan
Callahan
Callahan
Callahan
Callahan
Callahan
Fuller
King
Category
Name
Dairy Products
Dairy Products
Produce
Grains/Cereals
Beverages
Confections
Meat/Poultry
Condiments
Confections
Meat/Poultry
Confections
Beverages
Seafood
Confections
Condiments
Dairy Products
Confections
Seafood
Seafood
Grains/Cereals
Confections
Seafood
Meat/Poultry
Meat/Poultry
Grains/Cereals
Condiments
Condiments
Produce
Condiments
Confections
Beverages
Confections
Dairy Products
Seafood
Beverages
Meat/Poultry
Condiments
Dairy Products
Confections
Confections
Dairy Products
Confections
Quantity
14
20
35
4
45
49
24
90
50
10
15
8
30
40
35
2
6
20
14
6
35
20
6
120
8
28
55
15
100
15
25
20
20
10
20
50
25
30
40
21
36
30
Shipped
Date
5/18/16
5/18/16
5/25/16
6/22/16
5/22/16
5/22/16
5/22/16
5/22/16
6/5/16
5/15/16
5/15/16
5/15/16
5/15/16
5/29/16
5/29/16
5/29/16
5/18/16
5/18/16
5/21/16
6/20/16
5/21/16
6/2/16
6/2/16
6/3/16
6/17/16
6/3/16
6/3/16
5/20/16
5/20/16
5/20/16
5/20/16
5/19/16
5/19/16
5/19/16
5/25/16
5/25/16
5/25/16
5/25/16
5/22/16
5/22/16
5/25/16
5/26/16
Shipping
Cost
0.50
1.10
0.70
0.83
0.76
0.70
1.86
0.86
1.10
0.98
0.78
0.72
0.48
0.46
0.63
0.65
0.78
0.74
0.78
0.35
1.23
0.78
0.37
0.72
0.83
0.63
0.52
1.14
0.78
0.51
0.60
0.70
0.25
0.48
0.72
0.82
0.86
0.65
0.40
0.60
1.10
0.78
Unit
Price
12.50
55.00
23.25
33.25
19.00
17.45
123.79
28.50
43.90
39.00
31.23
18.00
9.65
9.20
21.05
21.50
31.23
18.40
31.00
7.00
49.30
31.00
7.45
24.00
33.25
21.05
13.00
45.60
19.45
12.75
15.00
17.45
2.50
12.00
18.00
32.80
28.50
21.50
10.00
20.00
55.00
31.23
Markup
Order
Total
175
1,100
814
133
855
855
2,971
2,565
2,195
390
468
144
290
368
737
43
187
368
434
42
1,726
620
45
2,880
266
589
715
684
1,945
191
375
349
50
120
360
1,640
713
645
400
420
1,980
937
King
King
King
King
Thomas
Thomas
Thomas
Callahan
Callahan
Davolio
Davolio
Davolio
Fuller
Conner
Buchanan
Conner
Thomas
Thomas
King
Thomas
Davolio
Davolio
Davolio
Davolio
Davolio
Thomas
Thomas
Callahan
Callahan
Conner
Conner
Davolio
Davolio
Davolio
Thomas
King
Fuller
Fuller
King
Callahan
Callahan
Davolio
Davolio
Buchanan
Buchanan
Buchanan
Buchanan
Produce
Beverages
Grains/Cereals
Dairy Products
Produce
Seafood
Grains/Cereals
Confections
Beverages
Confections
Seafood
Meat/Poultry
Seafood
Grains/Cereals
Confections
Grains/Cereals
Condiments
Beverages
Grains/Cereals
Dairy Products
Beverages
Meat/Poultry
Seafood
Seafood
Confections
Dairy Products
Seafood
Beverages
Confections
Seafood
Beverages
Beverages
Confections
Condiments
Seafood
Grains/Cereals
Grains/Cereals
Produce
Grains/Cereals
Beverages
Produce
Dairy Products
Dairy Products
Produce
Produce
Seafood
Beverages
30
20
10
50
16
20
33
21
4
40
128
160
1
10
21
12
16
3
14
20
25
18
20
30
25
10
5
28
12
8
15
40
35
2
30
15
15
30
16
80
18
12
12
12
18
21
10
5/26/16
5/26/16
6/3/16
5/26/16
5/22/16
5/22/16
5/22/16
5/25/16
5/25/16
5/27/16
5/27/16
5/27/16
6/9/16
6/29/16
5/28/16
6/3/16
6/5/16
6/5/16
6/29/16
6/5/16
6/5/16
6/5/16
6/5/16
6/5/16
6/5/16
6/4/16
6/4/16
6/2/16
6/2/16
6/3/16
6/3/16
6/5/16
6/5/16
6/5/16
6/5/16
5/26/16
6/27/16
6/9/16
5/20/16
6/10/16
6/10/16
6/12/16
6/12/16
6/12/16
6/12/16
6/12/16
6/12/16
1.14
1.15
0.56
0.65
0.75
0.48
0.44
0.50
0.39
0.40
0.78
0.72
0.30
0.35
0.46
0.35
0.66
1.15
0.95
0.85
0.45
1.86
0.74
0.48
0.65
0.63
0.48
0.45
0.56
0.78
1.15
0.76
0.70
0.78
1.25
0.95
0.78
0.75
0.95
0.45
1.06
0.25
0.65
0.70
1.14
0.74
0.39
45.60
46.00
14.00
21.50
30.00
12.00
34.80
12.50
7.75
10.00
25.89
24.00
6.00
7.00
9.20
7.00
22.00
46.00
38.00
34.00
4.50
123.79
18.40
9.50
16.25
21.00
12.00
4.50
14.00
25.89
46.00
19.00
17.45
19.45
62.50
38.00
19.50
30.00
38.00
4.50
53.00
2.50
21.50
23.25
45.60
18.40
7.75
1,368
920
140
1,075
480
240
1,148
263
31
400
3,314
3,840
6
70
193
84
352
138
532
680
113
2,228
368
285
406
210
60
126
168
207
690
760
611
39
1,875
570
293
900
608
360
954
30
258
279
821
386
78
Dodsworth
Dodsworth
Dodsworth
Callahan
Callahan
Buchanan
Buchanan
Buchanan
Fuller
Conner
Conner
Conner
Ling
Ling
Ling
Callahan
Callahan
Conner
Conner
Conner
Thomas
Thomas
Thomas
Thomas
Davolio
Davolio
Davolio
Fuller
Fuller
Fuller
Callahan
Callahan
King
King
King
King
Conner
King
King
Davolio
Davolio
Conner
Conner
Fuller
Conner
Conner
Thomas
Dairy Products
Condiments
Beverages
Meat/Poultry
Beverages
Beverages
Confections
Beverages
Seafood
Beverages
Meat/Poultry
Dairy Products
Grains/Cereals
Confections
Dairy Products
Confections
Dairy Products
Confections
Seafood
Produce
Beverages
Condiments
Meat/Poultry
Beverages
Dairy Products
Produce
Produce
Confections
Confections
Meat/Poultry
Dairy Products
Seafood
Dairy Products
Confections
Beverages
Dairy Products
Grains/Cereals
Dairy Products
Condiments
Seafood
Beverages
Confections
Produce
Grains/Cereals
Condiments
Beverages
Beverages
35
60
42
2
12
15
21
20
20
30
28
60
18
30
12
24
40
14
10
3
20
20
30
60
5
25
16
5
30
24
30
20
60
30
36
20
20
25
25
10
10
39
35
20
39
50
40
6/26/16
6/26/16
6/26/16
6/15/16
6/15/16
6/16/16
6/16/16
6/16/16
6/17/16
6/12/16
6/12/16
6/12/16
6/3/16
6/15/16
6/15/16
6/16/16
6/16/16
6/23/16
6/23/16
6/23/16
6/22/16
6/22/16
6/22/16
6/22/16
6/24/16
6/24/16
6/24/16
6/19/16
6/19/16
6/19/16
6/24/16
6/24/16
6/25/16
6/25/16
6/25/16
6/29/16
5/21/16
6/29/16
6/29/16
8/3/16
8/3/16
8/6/16
8/6/16
6/9/16
8/6/16
8/6/16
7/27/16
0.50
0.68
0.72
0.72
0.60
0.72
0.40
0.72
0.78
3.95
0.82
1.10
0.95
0.48
1.10
0.60
0.85
0.40
0.74
1.06
0.76
0.40
0.72
0.60
0.63
1.06
0.40
0.46
0.78
0.37
1.10
0.60
1.10
0.50
0.39
0.50
0.35
0.87
0.52
0.30
0.72
1.22
1.14
0.95
0.63
0.39
0.72
12.50
17.00
18.00
24.00
15.00
18.00
10.00
18.00
31.00
263.50
32.80
55.00
38.00
9.50
55.00
20.00
34.00
10.00
18.40
53.00
19.00
10.00
24.00
15.00
21.00
53.00
10.00
9.20
31.23
7.45
55.00
15.00
55.00
12.50
7.75
12.50
7.00
34.80
13.00
6.00
18.00
81.00
45.60
38.00
21.05
7.75
18.00
438
1,020
756
48
180
270
210
360
620
7,905
918
3,300
684
285
660
480
1,360
140
184
159
380
200
720
900
105
1,325
160
46
937
179
1,650
300
3,300
375
279
250
140
870
325
60
180
3,159
1,596
760
821
388
720
Thomas
Thomas
Thomas
Davolio
Davolio
Davolio
Davolio
Thomas
Thomas
Davolio
King
King
Ling
Ling
Ling
Buchanan
Buchanan
Buchanan
Conner
Conner
Conner
Conner
King
King
King
Callahan
Callahan
Callahan
Callahan
Callahan
Callahan
Thomas
Thomas
Fuller
Thomas
Davolio
Davolio
Davolio
Davolio
Davolio
Dodsworth
Dodsworth
King
King
King
Thomas
Thomas
Condiments
Seafood
Seafood
Seafood
Seafood
Beverages
Meat/Poultry
Beverages
Seafood
Grains/Cereals
Condiments
Seafood
Dairy Products
Dairy Products
Dairy Products
Meat/Poultry
Confections
Dairy Products
Meat/Poultry
Beverages
Condiments
Beverages
Dairy Products
Seafood
Condiments
Condiments
Dairy Products
Seafood
Seafood
Seafood
Meat/Poultry
Dairy Products
Seafood
Grains/Cereals
Dairy Products
Dairy Products
Produce
Seafood
Dairy Products
Seafood
Beverages
Dairy Products
Confections
Beverages
Confections
Confections
Confections
24
20
25
2
10
60
15
8
10
20
50
30
3
8
9
14
20
10
40
25
20
50
2
15
24
50
24
24
10
10
10
50
10
21
15
30
6
20
21
9
7
1
20
30
42
25
21
7/27/16
7/27/16
7/27/16
7/28/16
7/28/16
7/28/16
7/28/16
8/5/16
8/5/16
5/30/16
7/28/16
7/28/16
7/30/16
7/30/16
7/30/16
7/30/16
7/30/16
7/30/16
8/2/16
8/2/16
8/2/16
8/2/16
8/9/16
8/2/16
8/2/16
8/12/16
8/12/16
8/12/16
8/4/16
8/4/16
8/4/16
8/11/16
8/11/16
6/9/16
8/11/16
8/9/16
8/9/16
8/9/16
8/9/16
8/9/16
8/6/16
8/6/16
5/16/16
5/16/16
5/16/16
5/24/16
5/24/16
1.00
0.78
0.74
0.78
0.78
1.15
0.37
0.72
0.30
0.78
0.66
0.76
0.63
0.25
0.87
0.72
0.50
0.90
0.98
1.15
0.86
0.72
1.10
0.78
0.68
0.66
0.87
0.60
0.78
0.74
0.37
0.63
0.74
0.45
1.10
0.50
1.06
0.53
0.87
0.60
0.60
0.87
0.78
0.72
0.60
0.46
0.48
40.00
25.89
18.40
31.00
25.89
46.00
7.45
18.00
6.00
19.50
22.00
19.00
21.00
2.50
34.80
24.00
12.50
36.00
39.00
46.00
28.50
18.00
55.00
25.89
17.00
22.00
34.80
15.00
25.89
18.40
7.45
21.00
18.40
9.00
55.00
12.50
53.00
13.25
34.80
15.00
15.00
34.80
31.23
18.00
20.00
9.20
9.50
960
518
460
62
259
2,760
112
144
60
390
1,100
570
63
20
313
336
250
360
1,560
1,150
570
900
110
388
408
1,100
835
360
259
184
75
1,050
184
189
825
375
318
265
731
135
105
35
625
540
840
230
200
Thomas
Davolio
Davolio
Davolio
Davolio
Davolio
Dodsworth
Dodsworth
Conner
Conner
Conner
Conner
King
Buchanan
Conner
Conner
Thomas
Buchanan
Davolio
Thomas
Thomas
Davolio
Davolio
Conner
Conner
Conner
Conner
Conner
Dodsworth
Thomas
Ling
Thomas
Conner
Davolio
Davolio
Davolio
Davolio
Davolio
Davolio
Conner
Conner
Conner
Fuller
Fuller
Thomas
Thomas
Thomas
Confections
Seafood
Dairy Products
Condiments
Beverages
Confections
Dairy Products
Beverages
Beverages
Beverages
Seafood
Dairy Products
Seafood
Grains/Cereals
Meat/Poultry
Seafood
Seafood
Beverages
Beverages
Seafood
Dairy Products
Meat/Poultry
Confections
Seafood
Condiments
Confections
Seafood
Confections
Beverages
Condiments
Beverages
Produce
Grains/Cereals
Produce
Confections
Seafood
Confections
Confections
Condiments
Beverages
Meat/Poultry
Beverages
Dairy Products
Meat/Poultry
Condiments
Dairy Products
Seafood
15
70
35
40
20
18
40
40
110
45
91
100
15
25
80
36
5
8
3
30
30
30
6
40
21
20
15
35
20
15
14
20
28
12
15
5
12
10
5
10
12
15
40
60
30
40
15
5/24/16
5/23/16
5/23/16
5/23/16
5/16/16
5/16/16
5/16/16
5/16/16
5/16/16
5/16/16
5/16/16
5/16/16
5/20/16
5/28/16
5/18/16
5/18/16
5/27/16
5/19/16
5/25/16
5/19/16
5/19/16
5/24/16
5/24/16
5/25/16
5/25/16
5/25/16
5/20/16
5/20/16
5/27/16
5/24/16
5/20/16
5/27/16
5/26/16
5/31/16
5/31/16
5/31/16
5/25/16
5/25/16
5/25/16
5/26/16
5/26/16
5/26/16
6/8/16
6/8/16
5/25/16
5/25/16
5/25/16
0.60
0.78
0.50
0.52
0.76
0.50
0.63
3.95
0.45
0.72
0.74
0.85
0.48
0.56
1.86
0.78
0.30
0.72
0.60
0.48
0.65
0.72
1.23
0.30
0.63
0.50
0.53
1.23
0.72
0.86
0.39
0.75
0.95
0.75
0.70
0.48
0.46
0.60
0.86
0.72
0.98
0.56
0.63
1.86
0.66
0.25
0.53
20.00
31.00
12.50
13.00
19.00
12.50
21.00
263.50
4.50
18.00
18.40
34.00
9.50
14.00
123.79
25.89
6.00
18.00
15.00
9.65
21.50
24.00
49.30
6.00
21.05
12.50
13.25
49.30
18.00
28.50
7.75
30.00
38.00
30.00
17.45
9.65
9.20
20.00
28.50
18.00
39.00
14.00
21.00
123.79
22.00
2.50
13.25
300
2,170
438
520
380
225
840
10,540
495
810
1,674
3,400
143
350
9,903
932
30
144
45
290
645
720
296
240
442
250
199
1,726
360
428
109
600
1,064
360
262
48
110
200
143
180
468
210
840
7,427
660
100
199
Ling
Fuller
Fuller
Fuller
Davolio
Davolio
Conner
Thomas
Thomas
Conner
Conner
Fuller
Fuller
Fuller
Thomas
Davolio
Davolio
Buchanan
Buchanan
Conner
King
King
Conner
Conner
Conner
Conner
Thomas
Thomas
Thomas
Thomas
Thomas
Thomas
Thomas
Thomas
Davolio
Davolio
Ling
Ling
Ling
Thomas
Thomas
Thomas
Thomas
Thomas
Thomas
Callahan
Callahan
Dairy Products
Meat/Poultry
Dairy Products
Meat/Poultry
Confections
Dairy Products
Grains/Cereals
Seafood
Dairy Products
Beverages
Dairy Products
Confections
Confections
Seafood
Confections
Beverages
Condiments
Meat/Poultry
Beverages
Grains/Cereals
Beverages
Beverages
Seafood
Produce
Beverages
Seafood
Grains/Cereals
Dairy Products
Seafood
Confections
Dairy Products
Confections
Grains/Cereals
Beverages
Confections
Beverages
Confections
Beverages
Condiments
Confections
Confections
Meat/Poultry
Seafood
Seafood
Grains/Cereals
Confections
Confections
25
10
30
10
6
6
29
1
10
60
25
24
24
20
24
10
40
15
35
30
10
24
20
30
6
25
35
2
10
7
10
5
36
20
5
5
60
49
15
36
25
25
30
42
45
30
14
5/23/16
5/23/16
5/23/16
5/23/16
5/30/16
5/30/16
8/6/16
6/1/16
6/1/16
6/1/16
6/1/16
5/25/16
5/25/16
5/25/16
5/30/16
5/30/16
5/30/16
5/26/16
5/26/16
6/12/16
6/3/16
6/3/16
6/29/16
6/29/16
6/29/16
6/3/16
6/3/16
6/1/16
6/1/16
6/1/16
6/1/16
6/29/16
6/5/16
6/29/16
6/8/16
6/8/16
6/2/16
6/2/16
6/2/16
6/8/16
6/8/16
6/8/16
6/8/16
6/9/16
6/5/16
6/14/16
6/14/16
0.65
0.98
0.25
0.37
0.70
0.80
0.95
0.78
0.85
0.72
0.85
0.70
0.56
0.74
0.65
0.72
1.10
0.98
0.45
0.83
1.15
0.56
0.78
1.14
0.39
0.76
0.30
0.63
0.30
0.46
0.87
1.22
0.21
0.72
0.48
0.72
0.40
0.39
0.52
0.40
1.10
0.72
0.53
0.30
0.17
0.70
1.23
21.50
39.00
2.50
7.45
17.45
32.00
38.00
25.89
34.00
18.00
34.00
17.45
14.00
18.40
16.25
18.00
43.90
39.00
4.50
33.25
46.00
14.00
31.00
45.60
7.75
19.00
33.25
21.00
6.00
9.20
34.80
81.00
38.00
18.00
9.50
18.00
10.00
7.75
13.00
10.00
43.90
24.00
13.25
6.00
9.00
17.45
49.30
538
390
75
75
105
192
1,102
26
340
1,080
850
419
336
368
390
180
1,756
585
158
998
460
336
620
1,368
47
475
1,164
42
60
64
348
405
1,368
360
48
90
600
380
195
360
1,098
600
398
252
405
524
690
Callahan
Callahan
Ling
Ling
Conner
Thomas
Thomas
Thomas
Conner
King
King
Conner
Conner
Conner
Conner
Fuller
Fuller
Callahan
Callahan
King
King
King
King
Dodsworth
Thomas
Thomas
Thomas
Ling
Ling
Thomas
Thomas
Thomas
Davolio
Davolio
Davolio
Conner
Conner
Conner
Conner
Fuller
Fuller
Fuller
Fuller
Davolio
Dodsworth
Dodsworth
Dodsworth
Dairy Products
Beverages
Meat/Poultry
Condiments
Condiments
Beverages
Seafood
Grains/Cereals
Seafood
Produce
Beverages
Seafood
Beverages
Dairy Products
Dairy Products
Beverages
Beverages
Produce
Seafood
Dairy Products
Confections
Confections
Dairy Products
Confections
Seafood
Grains/Cereals
Seafood
Dairy Products
Condiments
Grains/Cereals
Seafood
Dairy Products
Seafood
Beverages
Condiments
Dairy Products
Confections
Produce
Meat/Poultry
Condiments
Seafood
Meat/Poultry
Confections
Condiments
Dairy Products
Seafood
Beverages
16
20
2
30
20
21
4
48
30
8
20
20
24
49
35
10
40
8
20
44
30
80
50
28
15
50
15
5
18
55
20
10
25
25
40
4
9
40
4
12
30
6
60
5
15
6
50
6/14/16
6/14/16
6/6/16
6/6/16
6/2/16
6/8/16
6/8/16
6/5/16
6/8/16
6/3/16
6/3/16
6/6/16
6/6/16
6/6/16
6/6/16
6/3/16
6/3/16
6/13/16
6/13/16
6/10/16
6/10/16
6/10/16
6/10/16
6/8/16
6/9/16
8/5/16
6/9/16
6/3/16
6/3/16
8/11/16
6/8/16
6/8/16
6/9/16
6/9/16
6/9/16
6/6/16
6/9/16
6/9/16
6/9/16
6/7/16
6/7/16
6/7/16
6/7/16
6/13/16
6/28/16
6/28/16
6/28/16
0.87
0.39
0.82
0.86
0.75
0.72
1.25
0.10
0.76
1.14
0.56
0.30
1.15
0.85
0.65
0.76
0.56
0.75
0.30
0.50
1.23
0.50
0.87
0.60
0.30
0.27
0.48
0.63
0.78
0.32
0.30
0.50
0.78
0.45
0.52
1.10
0.65
1.06
0.72
0.75
0.78
0.98
1.23
0.66
0.25
0.48
0.39
34.80
7.75
32.80
28.50
25.00
18.00
62.50
33.25
19.00
45.60
14.00
6.00
46.00
34.00
21.50
19.00
14.00
30.00
6.00
12.50
49.30
12.50
34.80
20.00
6.00
38.00
12.00
21.00
19.45
19.50
6.00
12.50
31.00
4.50
13.00
55.00
16.25
53.00
24.00
25.00
31.00
39.00
49.30
22.00
2.50
9.65
7.75
557
155
66
855
500
378
250
1,596
570
365
280
120
1,104
1,666
753
190
560
240
120
550
1,479
1,000
1,740
560
90
1,900
180
105
350
1,073
120
125
775
113
520
220
146
2,120
96
300
930
234
2,958
110
38
58
388
Davolio
Davolio
Dodsworth
Dodsworth
Buchanan
Buchanan
Buchanan
Buchanan
Callahan
Ling
Ling
Ling
Callahan
Callahan
Thomas
King
King
King
Ling
Conner
Conner
Thomas
Callahan
Callahan
Callahan
Callahan
Callahan
Callahan
Dodsworth
Conner
Conner
Conner
Ling
Thomas
Thomas
Thomas
Fuller
Fuller
Davolio
Davolio
Thomas
Davolio
Fuller
Thomas
Thomas
Ling
Ling
Condiments
Produce
Confections
Dairy Products
Confections
Dairy Products
Seafood
Dairy Products
Beverages
Confections
Confections
Produce
Seafood
Beverages
Grains/Cereals
Condiments
Produce
Dairy Products
Beverages
Beverages
Seafood
Grains/Cereals
Beverages
Produce
Seafood
Meat/Poultry
Dairy Products
Beverages
Dairy Products
Seafood
Beverages
Dairy Products
Produce
Seafood
Grains/Cereals
Confections
Confections
Confections
Dairy Products
Beverages
Grains/Cereals
Seafood
Meat/Poultry
Meat/Poultry
Dairy Products
Confections
Seafood
16
2
50
50
28
25
30
24
12
12
14
8
30
40
64
20
6
5
20
10
24
75
60
45
77
20
9
44
2
6
5
10
16
8
80
12
12
40
30
30
88
9
14
6
7
5
6
6/14/16
6/14/16
6/15/16
6/15/16
6/10/16
6/10/16
6/10/16
6/10/16
6/10/16
6/10/16
6/10/16
6/10/16
6/17/16
6/17/16
5/27/16
6/17/16
6/17/16
6/17/16
6/13/16
6/29/16
6/29/16
6/29/16
6/20/16
6/13/16
6/13/16
6/13/16
6/13/16
6/13/16
6/16/16
6/14/16
6/14/16
6/14/16
6/20/16
6/29/16
6/9/16
6/29/16
6/23/16
6/23/16
6/22/16
6/22/16
6/8/16
6/20/16
6/23/16
6/16/16
6/16/16
6/17/16
6/17/16
0.75
1.14
1.22
0.50
0.70
0.50
0.48
0.85
0.39
0.40
0.48
1.06
0.78
0.72
0.48
0.64
0.75
0.87
0.39
0.45
0.48
0.54
0.72
0.75
0.30
0.82
0.90
0.72
0.85
1.25
3.95
0.90
1.06
0.78
0.68
1.23
0.46
0.60
0.95
0.45
0.78
0.48
1.86
0.98
0.25
0.78
0.48
25.00
45.60
81.00
12.50
17.45
12.50
9.50
34.00
7.75
10.00
9.50
53.00
25.89
18.00
7.00
21.35
30.00
34.80
7.75
4.50
9.65
7.00
18.00
30.00
6.00
32.80
36.00
18.00
34.00
62.50
263.50
36.00
53.00
26.00
19.50
49.30
9.20
20.00
38.00
4.50
9.00
12.00
123.79
39.00
2.50
31.23
9.65
400
91
4,050
625
489
313
285
816
93
120
133
424
777
720
448
427
180
174
155
45
232
525
1,080
1,350
462
656
324
792
68
375
1,318
360
848
208
1,560
592
110
800
1,140
135
792
108
1,733
234
18
156
58
Ling
Conner
Davolio
Davolio
Davolio
Callahan
Callahan
Callahan
Callahan
Callahan
Callahan
Davolio
Fuller
Fuller
Fuller
Thomas
Davolio
Davolio
Davolio
Fuller
Fuller
Fuller
Callahan
Callahan
Callahan
Fuller
Fuller
Fuller
Fuller
Fuller
Fuller
Fuller
Davolio
Davolio
Davolio
Davolio
Davolio
Davolio
Conner
Conner
Thomas
Conner
Conner
Conner
Davolio
Beverages
Condiments
Condiments
Beverages
Produce
Produce
Dairy Products
Beverages
Confections
Dairy Products
Condiments
Beverages
Produce
Beverages
Seafood
Grains/Cereals
Confections
Beverages
Seafood
Confections
Seafood
Dairy Products
Produce
Beverages
Dairy Products
Condiments
Dairy Products
Seafood
Confections
Beverages
Meat/Poultry
Condiments
Beverages
Beverages
Beverages
Dairy Products
Produce
Dairy Products
Beverages
Seafood
Grains/Cereals
Beverages
Seafood
Seafood
Beverages
10
10
16
10
20
18
20
80
30
24
35
60
20
9
84
91
55
20
40
36
8
35
60
6
20
40
15
4
65
60
65
66
50
20
90
2
20
4
4
10
92
30
40
30
20
6/17/16
6/24/16
6/17/16
6/17/16
6/24/16
6/21/16
6/21/16
6/21/16
6/21/16
6/21/16
6/21/16
6/23/16
6/29/16
6/29/16
6/27/16
6/9/16
6/24/16
6/24/16
6/24/16
6/23/16
6/23/16
6/23/16
6/27/16
6/27/16
6/27/16
6/23/16
6/23/16
6/23/16
6/28/16
6/28/16
6/28/16
6/28/16
6/28/16
6/28/16
6/28/16
6/24/16
6/27/16
6/27/16
6/29/16
6/29/16
6/29/16
7/26/16
7/26/16
7/26/16
7/26/16
0.39
1.10
1.00
0.39
1.14
0.75
0.95
0.45
1.10
0.50
1.10
3.95
0.75
1.15
0.30
0.61
0.70
0.45
0.76
0.70
1.25
0.80
0.75
1.15
0.87
0.75
0.63
0.48
0.40
0.56
0.72
0.86
0.76
0.60
0.72
0.87
1.06
0.85
0.72
0.74
0.18
0.56
0.74
0.48
0.72
7.75
43.90
40.00
7.75
45.60
30.00
38.00
4.50
43.90
12.50
43.90
263.50
30.00
46.00
6.00
21.00
17.45
4.50
19.00
17.45
62.50
32.00
30.00
46.00
34.80
25.00
21.00
9.65
10.00
14.00
24.00
28.50
19.00
15.00
18.00
34.80
53.00
34.00
18.00
18.40
38.00
14.00
18.40
9.65
18.00
Totals
78
439
640
78
912
540
760
360
1,317
300
1,537
15,810
600
414
504
1,911
960
90
760
628
500
1,120
1,800
276
696
1,000
315
39
650
840
1,560
1,881
950
300
1,620
70
1,060
136
72
184
3,496
420
736
290
360
304,151
15%
Sales
Price
208
1,287
960
156
1,017
1,018
3,461
3,027
2,579
458
550
171
347
442
869
51
220
438
510
50
2,027
729
54
3,398
313
695
851
804
2,315
228
446
415
63
143
428
1,927
841
761
476
496
2,317
1,101
1,607
1,081
167
1,269
564
286
1,335
312
37
476
3,911
4,531
7
84
232
101
415
162
625
799
141
2,596
438
342
483
248
71
158
200
244
811
904
727
46
2,194
670
348
1,058
714
450
1,116
38
305
329
964
460
93
521
1,214
900
57
214
321
250
428
729
9,209
1,079
3,861
804
342
772
566
1,598
167
219
186
452
238
850
1,071
124
1,550
190
55
1,101
215
1,931
357
3,861
446
335
298
168
1,022
387
72
214
3,680
1,875
893
969
465
857
1,128
611
548
73
306
3,243
134
171
72
464
1,298
678
74
25
368
396
298
423
1,833
1,351
673
1,071
129
458
486
1,298
981
428
306
219
89
1,239
219
227
965
446
372
315
859
161
125
41
734
643
991
276
240
354
2,550
521
619
452
268
991
12,279
619
964
1,993
3,995
171
417
11,537
1,100
36
171
54
347
761
850
348
288
522
298
237
2,027
428
505
130
705
1,250
423
312
58
132
236
168
214
550
250
991
8,653
779
125
237
634
458
94
89
125
226
1,295
31
400
1,285
999
498
400
438
464
214
2,063
687
197
1,172
541
400
729
1,607
56
565
1,349
50
72
77
409
472
1,581
428
57
107
714
456
232
428
1,290
708
473
302
473
623
811
654
186
77
1,009
590
450
293
1,840
678
429
333
144
1,297
1,958
888
226
666
282
144
655
1,738
1,190
2,045
661
108
2,199
214
124
417
1,251
144
149
911
141
619
257
174
2,480
113
354
1,093
275
3,476
130
47
69
465
472
107
4,719
744
581
372
342
959
112
143
160
496
917
857
546
504
212
204
186
56
278
644
1,285
1,586
554
771
381
942
80
439
1,535
423
992
245
1,848
695
132
944
1,340
169
979
129
2,019
275
22
183
69
93
516
752
93
1,072
635
893
450
1,548
357
1,805
18,419
705
486
605
2,253
1,142
113
904
748
585
1,316
2,115
324
818
1,180
372
46
774
1,000
1,841
2,220
1,131
357
1,928
82
1,240
160
86
219
4,037
500
876
347
428
357,944
Analysis
Last
Name
Ling
Ling
Thomas
Davolio
Thomas
Thomas
Thomas
Thomas
Conner
Conner
Conner
Conner
Conner
Thomas
Thomas
Thomas
Thomas
Thomas
Conner
Callahan
Conner
Callahan
Callahan
Thomas
Callahan
Thomas
Thomas
Callahan
Callahan
Davolio
Davolio
Thomas
Thomas
Thomas
Callahan
Callahan
Callahan
Callahan
Callahan
Callahan
Fuller
King
Category
Name
Dairy Products
Dairy Products
Produce
Grains/Cereals
Beverages
Confections
Meat/Poultry
Condiments
Confections
Meat/Poultry
Confections
Beverages
Seafood
Confections
Condiments
Dairy Products
Confections
Seafood
Seafood
Grains/Cereals
Confections
Seafood
Meat/Poultry
Meat/Poultry
Grains/Cereals
Condiments
Condiments
Produce
Condiments
Confections
Beverages
Confections
Dairy Products
Seafood
Beverages
Meat/Poultry
Condiments
Dairy Products
Confections
Confections
Dairy Products
Confections
Quantity
14
20
35
4
45
49
24
90
50
10
15
8
30
40
35
2
6
20
14
6
35
20
6
120
8
28
55
15
100
15
25
20
20
10
20
50
25
30
40
21
36
30
Shipped
Date
5/18/16
5/18/16
5/25/16
6/22/16
5/22/16
5/22/16
5/22/16
5/22/16
6/5/16
5/15/16
5/15/16
5/15/16
5/15/16
5/29/16
5/29/16
5/29/16
5/18/16
5/18/16
5/21/16
6/20/16
5/21/16
6/2/16
6/2/16
6/3/16
6/17/16
6/3/16
6/3/16
5/20/16
5/20/16
5/20/16
5/20/16
5/19/16
5/19/16
5/19/16
5/25/16
5/25/16
5/25/16
5/25/16
5/22/16
5/22/16
5/25/16
5/26/16
Shipping
Cost
0.50
1.10
0.70
0.83
0.76
0.70
1.86
0.86
1.10
0.98
0.78
0.72
0.48
0.46
0.63
0.65
0.78
0.74
0.78
0.35
1.23
0.78
0.37
0.72
0.83
0.63
0.52
1.14
0.78
0.51
0.60
0.70
0.25
0.48
0.72
0.82
0.86
0.65
0.40
0.60
1.10
0.78
Unit
Price
12.50
55.00
23.25
33.25
19.00
17.45
123.79
28.50
43.90
39.00
31.23
18.00
9.65
9.20
21.05
21.50
31.23
18.40
31.00
7.00
49.30
31.00
7.45
24.00
33.25
21.05
13.00
45.60
19.45
12.75
15.00
17.45
2.50
12.00
18.00
32.80
28.50
21.50
10.00
20.00
55.00
31.23
Markup
Order
Total
175
1,100
814
133
855
855
2,971
2,565
2,195
390
468
144
290
368
737
43
187
368
434
42
1,726
620
45
2,880
266
589
715
684
1,945
191
375
349
50
120
360
1,640
713
645
400
420
1,980
937
King
King
King
King
Thomas
Thomas
Thomas
Callahan
Callahan
Davolio
Davolio
Davolio
Fuller
Conner
Buchanan
Conner
Thomas
Thomas
King
Thomas
Davolio
Davolio
Davolio
Davolio
Davolio
Thomas
Thomas
Callahan
Callahan
Conner
Conner
Davolio
Davolio
Davolio
Thomas
King
Fuller
Fuller
King
Callahan
Callahan
Davolio
Davolio
Buchanan
Buchanan
Buchanan
Buchanan
Produce
Beverages
Grains/Cereals
Dairy Products
Produce
Seafood
Grains/Cereals
Confections
Beverages
Confections
Seafood
Meat/Poultry
Seafood
Grains/Cereals
Confections
Grains/Cereals
Condiments
Beverages
Grains/Cereals
Dairy Products
Beverages
Meat/Poultry
Seafood
Seafood
Confections
Dairy Products
Seafood
Beverages
Confections
Seafood
Beverages
Beverages
Confections
Condiments
Seafood
Grains/Cereals
Grains/Cereals
Produce
Grains/Cereals
Beverages
Produce
Dairy Products
Dairy Products
Produce
Produce
Seafood
Beverages
30
20
10
50
16
20
33
21
4
40
128
160
1
10
21
12
16
3
14
20
25
18
20
30
25
10
5
28
12
8
15
40
35
2
30
15
15
30
16
80
18
12
12
12
18
21
10
5/26/16
5/26/16
6/3/16
5/26/16
5/22/16
5/22/16
5/22/16
5/25/16
5/25/16
5/27/16
5/27/16
5/27/16
6/9/16
6/29/16
5/28/16
6/3/16
6/5/16
6/5/16
6/29/16
6/5/16
6/5/16
6/5/16
6/5/16
6/5/16
6/5/16
6/4/16
6/4/16
6/2/16
6/2/16
6/3/16
6/3/16
6/5/16
6/5/16
6/5/16
6/5/16
5/26/16
6/27/16
6/9/16
5/20/16
6/10/16
6/10/16
6/12/16
6/12/16
6/12/16
6/12/16
6/12/16
6/12/16
1.14
1.15
0.56
0.65
0.75
0.48
0.44
0.50
0.39
0.40
0.78
0.72
0.30
0.35
0.46
0.35
0.66
1.15
0.95
0.85
0.45
1.86
0.74
0.48
0.65
0.63
0.48
0.45
0.56
0.78
1.15
0.76
0.70
0.78
1.25
0.95
0.78
0.75
0.95
0.45
1.06
0.25
0.65
0.70
1.14
0.74
0.39
45.60
46.00
14.00
21.50
30.00
12.00
34.80
12.50
7.75
10.00
25.89
24.00
6.00
7.00
9.20
7.00
22.00
46.00
38.00
34.00
4.50
123.79
18.40
9.50
16.25
21.00
12.00
4.50
14.00
25.89
46.00
19.00
17.45
19.45
62.50
38.00
19.50
30.00
38.00
4.50
53.00
2.50
21.50
23.25
45.60
18.40
7.75
1,368
920
140
1,075
480
240
1,148
263
31
400
3,314
3,840
6
70
193
84
352
138
532
680
113
2,228
368
285
406
210
60
126
168
207
690
760
611
39
1,875
570
293
900
608
360
954
30
258
279
821
386
78
Dodsworth
Dodsworth
Dodsworth
Callahan
Callahan
Buchanan
Buchanan
Buchanan
Fuller
Conner
Conner
Conner
Ling
Ling
Ling
Callahan
Callahan
Conner
Conner
Conner
Thomas
Thomas
Thomas
Thomas
Davolio
Davolio
Davolio
Fuller
Fuller
Fuller
Callahan
Callahan
King
King
King
King
Conner
King
King
Davolio
Davolio
Conner
Conner
Fuller
Conner
Conner
Thomas
Dairy Products
Condiments
Beverages
Meat/Poultry
Beverages
Beverages
Confections
Beverages
Seafood
Beverages
Meat/Poultry
Dairy Products
Grains/Cereals
Confections
Dairy Products
Confections
Dairy Products
Confections
Seafood
Produce
Beverages
Condiments
Meat/Poultry
Beverages
Dairy Products
Produce
Produce
Confections
Confections
Meat/Poultry
Dairy Products
Seafood
Dairy Products
Confections
Beverages
Dairy Products
Grains/Cereals
Dairy Products
Condiments
Seafood
Beverages
Confections
Produce
Grains/Cereals
Condiments
Beverages
Beverages
35
60
42
2
12
15
21
20
20
30
28
60
18
30
12
24
40
14
10
3
20
20
30
60
5
25
16
5
30
24
30
20
60
30
36
20
20
25
25
10
10
39
35
20
39
50
40
6/26/16
6/26/16
6/26/16
6/15/16
6/15/16
6/16/16
6/16/16
6/16/16
6/17/16
6/12/16
6/12/16
6/12/16
6/3/16
6/15/16
6/15/16
6/16/16
6/16/16
6/23/16
6/23/16
6/23/16
6/22/16
6/22/16
6/22/16
6/22/16
6/24/16
6/24/16
6/24/16
6/19/16
6/19/16
6/19/16
6/24/16
6/24/16
6/25/16
6/25/16
6/25/16
6/29/16
5/21/16
6/29/16
6/29/16
8/3/16
8/3/16
8/6/16
8/6/16
6/9/16
8/6/16
8/6/16
7/27/16
0.50
0.68
0.72
0.72
0.60
0.72
0.40
0.72
0.78
3.95
0.82
1.10
0.95
0.48
1.10
0.60
0.85
0.40
0.74
1.06
0.76
0.40
0.72
0.60
0.63
1.06
0.40
0.46
0.78
0.37
1.10
0.60
1.10
0.50
0.39
0.50
0.35
0.87
0.52
0.30
0.72
1.22
1.14
0.95
0.63
0.39
0.72
12.50
17.00
18.00
24.00
15.00
18.00
10.00
18.00
31.00
263.50
32.80
55.00
38.00
9.50
55.00
20.00
34.00
10.00
18.40
53.00
19.00
10.00
24.00
15.00
21.00
53.00
10.00
9.20
31.23
7.45
55.00
15.00
55.00
12.50
7.75
12.50
7.00
34.80
13.00
6.00
18.00
81.00
45.60
38.00
21.05
7.75
18.00
438
1,020
756
48
180
270
210
360
620
7,905
918
3,300
684
285
660
480
1,360
140
184
159
380
200
720
900
105
1,325
160
46
937
179
1,650
300
3,300
375
279
250
140
870
325
60
180
3,159
1,596
760
821
388
720
Thomas
Thomas
Thomas
Davolio
Davolio
Davolio
Davolio
Thomas
Thomas
Davolio
King
King
Ling
Ling
Ling
Buchanan
Buchanan
Bucha...