CustomerID CustomerName SupplierID CategoryID

24 Abby Johnson 10 1
23 Aidan Quionski 9 5
34 Alysa Ronalze 16 1
2 Barbara Bartholomew 1 1
22 Beth Cuzens 9 5
11 Caroline Hanover 5 4
12 Enrique Jaen 5 4
10 Maria Unger 4 8
30 Abrille Aravia 13 8
28 Adolp Lee 12 7
77 Carl Weiss 12 2
33 Consuelo Clarisse 15 4
14 Chika Innoue 6 7
39 Dorothy Badders 18 1
67 Frank Price 16 1
50 Linda Greenburg 23 3
61 Maureen Ryan 29 2
44 Sylvia Foulston 20 2
26 Adame Clarke 11 3
59 Alana Monder 28 4
47 Annie Cyprus 22 3
37 Carl Jackson 17 8
48 Carl Ludwig 22 3
18 Cathy Booth 7 8
41 Claudia Miner 19 8
68 Delfina Latchford 8 3
20 Elizabeth Smith 8 3
66 Henry Goldwyn 2 2
65 Jim Diehl 2 2
45 Jim Radford 21 8
16 John Clark 7 3
52 Michael Mc Tague 24 5
73 Muhammed MacIntyre 17 8
42 Neola Schneider 20 5
69 Roy Skaria 15 4
43 Allen Rosenblatt 20 1
7 Antonio Quayle 3 7
36 Barry French 17 8
9 Oscar Stark 4 6
29 Alexis Quayle 12 6
49 Alice Childs 23 3
17 Amanda Rapp 7 6
46 Don Miller 21 8
70 Jack O'Briant 7 1
21 Katie Merkley 8 3
51 Sam Lundquist 24 7
1 Simon Arman 1 1
76 Monica Federle 23 1
54 Orlando Rivena 25 6
31 Alamar Bazalde 14 4
25 Alice Trembleye 11 3
27 Alysa Jones 11 3
32 Camiria Trembleye 14 4
40 Carlos Daly 19 8
 QuantityPerUnit UnitPrice Region OrderAmount
12 - 355 ml cans 4.5 China 20
12 - 250 g pkgs. 9 China 61
24 - 12 oz bottles 14 China 111
24 - 12 oz bottles 19 China 17
24 - 500 g pkgs. 21 China 104
1 kg pkg. 21 China 22
10 - 500 g pkgs. 38 China 86
12 - 200 ml jars 31 China 31
10 - 200 g glasses 25.89 Taiwan 10
25 - 825 g cans 45.6 Taiwan 26
12 boxes 13 Taiwan 32
500 g 2.5 Taiwan 112
40 - 100 g pkgs. 23.25 Taiwan 35
750 cc per bottle 18 Taiwan 69
24 - 12 oz bottles 14 Taiwan 52
12 - 100 g bars 16.25 Taiwan 65
24 - 500 ml bottles 28.5 Taiwan 113
20 - 2 kg bags 19.45 Taiwan 27
100 - 250 g bags 31.23 Hongkong 15
5 kg pkg. 55 Hongkong 79
10 - 4 oz boxes 9.5 Hongkong 36
12 - 500 g pkgs. 26 Hongkong 11
10 pkgs. 12.75 Hongkong 15
16 kg pkg. 62.5 Hongkong 42
12 - 12 oz cans 9.65 Hongkong 85
10 boxes x 8 pieces 12.5 Hongkong 6
30 gift boxes 81 Hongkong 40
24 - 8 oz jars 17 Hongkong 4
32 - 8 oz bottles 21.05 Hongkong 76
1k pkg. 9.5 Hongkong 5
32 - 500 g boxes 17.45 Hongkong 29
16 - 2 kg boxes 7 Hongkong 38
24 - 150 g jars 15 Hongkong 101
32 - 1 kg pkgs. 14 Hongkong 26
10 kg pkg. 36 Hongkong 26
16 - 500 g tins 46 Japan 17
12 - 1 lb pkgs. 30 Japan 15
24 - 250 g jars 19 Japan 112
18 - 500 g pkgs. 97 Japan 29
50 bags x 30 sausgs. 123.79 Korea 0
24 - 50 g pkgs. 20 Korea 10
20 - 1 kg tins 39 Korea 0
4 - 450 g glasses 12 Korea 95
24 - 355 ml bottles 15 Korea 15
24 pkgs. x 4 pieces 10 Korea 3
50 - 300 g pkgs. 53 Korea 20
10 boxes x 20 bags 18 Korea 39
500 ml 18 Thailand 57
16 pies 7.45 Thailand 21
12 - 100 g pkgs 12.5 Vietnam 0
20 - 450 g glasses 14 Vietnam 76
100 - 100 g pieces 43.9 Vietnam 49
24 - 200 g pkgs. 32 Vietnam 9
24 - 4 oz tins 18.4 Vietnam 123
OrderDate Total Order Amount Average
3/9/2017 90 Average 20
3/12/2018 549
10/10/2017 1554 Maximum Total
10/1/2016 323 Maximum 4345
3/12/2018 2184
11/23/2018 462
11/23/2018 3268
2/26/2018 961
10/21/2016 258.9
12/23/2018 1185.6
9/29/2017 416
10/10/2017 280
6/8/2016 813.75
10/9/2015 1242
6/4/2018 728
7/8/2017 1056.25
3/20/2015 3220.5
5/28/2017 525.15
8/4/2016 468.45
11/12/2017 4345
8/31/2017 342
10/9/2015 286
8/31/2017 191.25
2/14/2016 2625
10/8/2016 820.25
2/18/2018 75
4/15/2016 3240
1/15/2015 68
1/15/2015 1599.8
9/19/2018 47.5
5/30/2017 506.05
1/8/2016 266
6/8/2018 1515
5/2/2016 364
11/16/2017 936
3/8/2018 782
6/17/2017 450
7/19/2017 2128
3/24/2017 2813
11/8/2018 0
8/31/2017 200
11/25/2015 0
8/31/2017 1140
11/16/2017 225
4/15/2016 30
1/30/2015 1060
10/13/2018 702
9/29/2017 1026
4/29/2018 156.45
1/1/2017 0
3/9/2017 1064
5/6/2017 2151.1
1/1/2017 288
12/9/2018 2263.2
 Page 7 of 9

Toys Ordered Price Each Q. Ordered Price

BBQ Barbie Doll 12.990 2 25.98
Prince Eric Doll 8.990 3 26.97
Princess Jasmine Doll 9.990 1 9.99
Cinderella’s Coach 19.990 1 19.99
Spiderman gloves 14.990 3 44.97
Hama Bead Starter Kit 12.500 2 25
Pink Heart Light Set 14.500 1 14.5
Harry Potter Magic Set 19.990 1 19.99
Total
 Page 8 of 9

Discount Final Price

1.8186 24.1614
1.8879 25.0821
0.6993 9.2907
1.3993 18.5907
3.1479 41.8221
1.75 23.25
1.015 13.485
1.3993 18.5907
174.2727
Item Cost Credit Period Payment
Fridge 200 8 25
DVD Player 150 12 12.5
Washing Machine 300 12 25
Dish Washer 250 12 20.833333333
TV 500 12 41.666666667
Car 15000 36 416.66666667
TOTAL 16400 92 541.66666667