3 Microsoft Excel exams, creating a workbook

User Generated

Avpb1998

Other

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

Part 1 - Create your file and Import your data 1. Start by creating your own original new file using Excel 2013 or 2016 with the name Dominic.Zetouna_Exam4.xlsx Files not created in Excel 2013 may not earn full credit! 2. Enter the appropriate Excel header and footer elements in the locations below. The only part you should type manually is your name. Worksheet Header Elements File Name Your Name Sheet Name Worksheet Current Date Current Time Worksheet Footer Elements Page Number 3. Each student has a unique data file for this assignment. Left Click the link below to create your file. A download link will appear after you click the link and your file has been created. By clicking Create My Data File the button below you agree to follow the guidelines for this assignment. I agree - Create My Data Files Click once 4. Import the data file that you downloaded The file is a comma Delimited file so be sure to select that option during the import import the data into cell A3 in the current worksheet at this point your file should look something like this with 417 rows of data 5. Add the following 3 document properties via the Document Properties panel. Author: dominic.zetouna Title: Exam 4 spring 2018 Comments: location where you completed the exam examples if you completed it at home then list - "home computer" if you complete it on campus then list the room and computer number examples - "Cuyamaca E206 system 32" or "Grossmont 541 system 32" Tech Mall examples - "Cuyamaca Tech Mall system 16" or "Grossmont Tech Mall system 41" 6. Save the file with the name Dominic.Zetouna_Exam4.xlsx Part 2 - Layout, Format and Enter Formulas - Revenue Worksheet This part of the exam modifies the worksheet to format and calculate the revenue with a discount 7. Worksheet data entry, the following cells should contain information as follows: cell G2 contains the text Markup. cell G3 contains the text Order Total. cell H2 contains the value 15% formatted as percent with 0 decimal places. cell H3 contains the text Sale Price. 8. Add the title your last name Revenue in cell Al. (e.g. Zetouna Revenue). 9. Change the title font size in cell A1 to 18 points. 10. Calculate Order Total in column G for all 416 items. The Order Total is the Quantity times the Unit Price. 11. Calculate Sales Price in column H for all 416 items. The Sales Price is the Order Total times (1 + Markup) + Quantity times Shipping. 12. Merge and Center the title in cell A1 across only the data columns of the worksheet. 13. Add like breaks between words in all column titles with 2 words by using a line break. Do not use wrap lines. 14. Change all column widths to 20 to verify that the text still wraps correctly. Then set columns A, C, D, E, and Fto a width of 10 and adjust columns B, G, and to the width of 13. 15. Bold all column headings in row 3. 16. Align all the column titles vertically at the top and horizontally centered. 17. Theme make sure you are using the standard Office theme and set the background color of cell A1 to Green, Accent 6 Darker 25% and the text color to White. 18. Change the background color of cells A3:H3 to Green, Accent 6 Lighter 60%. View Formatted Example of rows 1 - 3 to this point 19. Rename the worksheet tab to Revenue. 20. Change the tab color to Green, Accent 6, Lighter 60%. 21. Freeze panes - only Column A and Rows 1-3 should always visible when you scroll the worksheet either horizontally or vertically 22. Enter formulas at the bottom of the Order Totaland Sales Price columns to calculate the total all items each of those columns and bold the cells. 23. Enter the text Totals in column F next to the formulas you added and bold the cell. 24. Add the range name Revenue_Total for the Sales Price total cell at the bottom of the Sales Price column. The scope of the range name should be the workbook and not restricted to a worksheet. Check the scope using the Name Manager. 25. Format as follows: o columns, Unit Price, Shipping - set as comma style columns Order Total, Sales Price - set as comma style with 0 decimal places o column D - Short Date o cell H2 - Percent
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags