CustomerID CustomerName SupplierID CategoryID

1 Simon Arman 1 1
2 Barbara Bartholomew 1 1
3 Alice Childs 1 2
4 Linda Greenburg 2 2
5 Sam Lundquist 2 2
6 Michael Mc Tague 3 2
7 Antonio Quayle 3 7
8 Orlando Rivena 3 2
9 Oscar Stark 4 6
10 Maria Unger 4 8
11 Caroline Hanover 5 4
12 Enrique Jaen 5 4
13 Alana Monder 6 8
14 Chika Innoue 6 7
15 Maureen Ryan 6 2
16 John Clark 7 3
17 Amanda Rapp 7 6
18 Cathy Booth 7 8
19 Jim Diehl 8 3
20 Elizabeth Smith 8 3

Region Order Amount

120

80

40

0
a a
re in am an d a
Ko Ch tn ap ilan ore pan am an na a a
e J a K a n p
Vi J et Ja hi hin hin am an ng g a g
Th Vi
C C C tn iw o on re n m g
e a k k o o a n
Vi T ng ng K gk etn ko
o o g
H H on Vi on
H H
 theYOUNG Supermarket
QuantityPerUnit UnitPrice Region OrderAmount
10 boxes x 20 bags 18 Korea 39
24 - 12 oz bottles 19 China 17
12 - 550 ml bottles 10 Vietnam 13
48 - 6 oz jars 22 Japan 53
36 boxes 21.35 Thailand 66
12 - 8 oz jars 25 Korea 120
12 - 1 lb pkgs. 30 Japan 15
12 - 12 oz jars 40 Vietnam 6
18 - 500 g pkgs. 97 Japan 29
12 - 200 ml jars 31 China 31
1 kg pkg. 21 China 22
10 - 500 g pkgs. 38 China 86
2 kg box 6 Vietnam 24
40 - 100 g pkgs. 23.25 Taiwan 35
24 - 250 ml bottles 15.5 Hongkong 39
32 - 500 g boxes 17.45 Hongkong 29
20 - 1 kg tins 39 Korea 86
16 kg pkg. 62.5 Hongkong 42
10 boxes x 12 pieces 9.2 Vietnam 25
30 gift boxes 81 Hongkong 40

ng am ng
t n ko
ie ng
o
H
rket
OrderDate Total Order Amount Average
10/13/2018 702 Average
10/1/2016 323
10/1/2016 130 Maximum Total
7/10/2017 1166 Maximum
8/28/2018 1409.1
8/28/2018 3000
6/17/2017 450
6/17/2017 240
3/24/2017 2813
2/26/2018 961
11/23/2018 462
11/23/2018 3268
6/8/2016 144
6/8/2016 813.75
8/4/2016 604.5
5/30/2017 506.05
11/25/2015 3354
2/14/2016 2625
2/14/2016 230
4/15/2016 3240
Toys Ordered Price Each Q. Ordered Price
BBQ Barbie Doll 12.99 2 25.98
Prince Eric Doll 8.99 3 26.97
Princess Jasmine Doll 9.99 1 9.99
Cinderella’s Coach 19.99 1 19.99
Spiderman gloves 14.99 3 44.97
Hama Bead Starter Kit 12.5 2 25.00
Pink Heart Light Set 14.5 1 14.50
Harry Potter Magic Set 19.99 1 19.99

Price

40.00
30.00
20.00
10.00
0.00
l l l t t t
ol ol ol h es Ki Se Se
D D D oac ov r
bi
e ric in
e C g l te ht ic
r E ’s an ar Li
g ag
Ba ce sm lla St rt
M
Q in Ja r e rm ad ea er
BB
r ss de de tt
P
ce n p i Be H Po
in Ci S a nk y
Pr am Pi ar
r
H H
 Discount Final Price
1.82 47.25
1.89
0.70
1.40
3.15
1.75
1.02
1.40

t
Se
ic
ag
 Order Details for Oc
Order ID Order Date Customer ID Customer Name Address
1433 10/27/23 27 Company AA 789 27th Street
1434 10/27/23 27 Company AA 789 27th Street
1435 10/04/23 4 Company D 123 4th Street
1436 10/04/23 4 Company D 123 4th Street
1437 10/04/23 4 Company D 123 4th Street
1438 10/12/23 12 Company L 123 12th Street
1439 10/12/23 12 Company L 123 12th Street
1440 10/08/23 8 Company H 123 8th Street
1441 10/04/23 4 Company D 123 4th Street
1442 10/29/23 29 Company CC 789 29th Street
1443 10/03/23 3 Company C 123 3rd Street
1444 10/06/23 6 Company F 123 6th Street
1445 10/28/23 28 Company BB 789 28th Street
1446 10/08/23 8 Company H 123 8th Street
1447 10/10/23 10 Company J 123 10th Street

Unit Price $26

for October 2023
City State Salesperson Region Shipped Date
Las Vegas NV Mariya Sergienko West 10/29/23
Las Vegas NV Mariya Sergienko West 10/29/23
New York NY Andrew Cencini East 10/06/23
Chicago NY Andrew Cencini East 10/06/23
New York NY Andrew Cencini East 10/06/23
Las Vegas NV Mariya Sergienko West 10/14/23
Las Vegas NV Mariya Sergienko West 10/14/23
Portland OR Nancy Freehafer North 10/10/23
New York NY Andrew Cencini East 10/06/23
Denver CO Jan Kotas West 10/31/23
Los Angelas CA Mariya Sergienko West 10/05/23
Milwaukee WI Michael Neipper North 10/08/23
Memphis TN Anne Larsen South 10/30/23
Portland OR Nancy Freehafer North 10/10/23
Chicago IL Laura Giussani East 10/12/23
Product Name Quantity Total
Beer 49
Dried Plums 47
Dried Pears 69
Dried Apples 89
Dried Plums 11
Chai 81
Coffee 44
Chocolate Biscuits Mix 38
Chocolate Biscuits Mix 88
Chocolate 94
Clam Chowder 91
Curry Sauce 32
Coffee 55
Chocolate 47
Green Tea 90
 theYOUNG Supermarket
Item Cost Credit Period Payment
Fridge 200 8 25.0
DVD Player 150 12 12.5
Washing Machine 300 12 25.0
Dish Washer 250 12 20.8
TV 500 12 41.7
Car 15000 36 416.7
Fridge 200 6 33.3
Washing Machine 300 12 25.0
Dish Washer 250 24 10.4
Fridge 200 12 16.7
Washing Machine 300 12 25.0
Dish Washer 250 12 20.8
Fridge 200 12 16.7
Fridge 200 6 33.3
Washing Machine 300 12 25.0
Fridge 200 6 33.3
Washing Machine 300 24 12.5
Dish Washer 250 12 20.8
Dish Washer 250 24 10.4
TV 500 12 41.7
Car 15000 12 1250.0
TV 500 12 41.7
Car 15000 24 625.0
Washing Machine 300 12 25.0
Dish Washer 250 36 6.9
TV 500 6 83.3
TV 500 24 20.8
Car 15000 12 1250.0
Car 15000 12 1250.0
 Cost
16000
14000
12000
10000
8000
6000
4000
2000
0
e r r r r r r
g ne TV g e
he in
e ge in
e
in
e
he Ca Ca he TV Ca
rid hi rid s h id h h s s
F ac F W
a ac Fr ac ac W
a
W
a
M h M M M h h
ng is ng ng ng is is
shi D
shi shi shi D D
a a a a
W W W W
 r
TV Ca