Scribd
Upload
133 views5 pages

Orderdate Region Rep Item Units Unitcost Total

The document contains sales data from January 2016 to December 2017 including order date, region, representative, item, units, unit cost and total for each order. A total of 75 orders are listed with items including pencils, binders, pens, pen sets, and desks. The orders were placed across different regions worked by various representatives. The Central region had the most orders at 38 while the East region had 24 orders.

Uploaded by

vinka karen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
133 views5 pages

Orderdate Region Rep Item Units Unitcost Total

The document contains sales data from January 2016 to December 2017 including order date, region, representative, item, units, unit cost and total for each order. A total of 75 orders are listed with items including pencils, binders, pens, pen sets, and desks. The orders were placed across different regions worked by various representatives. The Central region had the most orders at 38 while the East region had 24 orders.

Uploaded by

vinka karen
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

OrderDate Region Rep Item Units UnitCost Total

6-Jan-16 East Jones Pencil 95 1.99 189.05


23-Jan-16 Central Kivell Binder 50 19.99 999.5
9-Feb-16 Central Jardine Pencil 36 4.99 179.64
26-Feb-16 Central Gill Pen 27 19.99 539.73
15-Mar-16 West Sorvino Pencil 56 2.99 167.44
1-Apr-16 East Jones Binder 60 4.99 299.4
18-Apr-16 Central Andrews Pencil 75 1.99 149.25
5-May-16 Central Jardine Pencil 90 4.99 449.1
22-May-16 West Thompson Pencil 32 1.99 63.68

8-Jun-16 East Jones Binder 60 8.99 539.4


25-Jun-16 Central Morgan Pencil 90 4.99 449.1
12-Jul-16 East Howard Binder 29 1.99 57.71
29-Jul-16 East Parent Binder 81 19.99 1619.19
15-Aug-16 East Jones Pencil 35 4.99 174.65
1-Sep-16 Central Smith Desk 2 125 250
18-Sep-16 East Jones Pen Set 16 15.99 255.84
5-Oct-16 Central Morgan Binder 28 8.99 251.72
22-Oct-16 East Jones Pen 64 8.99 575.36
8-Nov-16 East Parent Pen 15 19.99 299.85
25-Nov-16 Central Kivell Pen Set 96 4.99 479.04
12-Dec-16 Central Smith Pencil 67 1.29 86.43
29-Dec-16 East Parent Pen Set 74 15.99 1183.26
15-Jan-17 Central Gill Binder 46 8.99 413.54
1-Feb-17 Central Smith Binder 87 15 1305
18-Feb-17 East Jones Binder 4 4.99 19.96
7-Mar-17 West Sorvino Binder 7 19.99 139.93
24-Mar-17 Central Jardine Pen Set 50 4.99 249.5
10-Apr-17 Central Andrews Pencil 66 1.99 131.34

27-Apr-17 East Howard Pen 96 4.99 479.04

14-May-17 Central Gill Pencil 53 1.29 68.37


31-May-17 Central Gill Binder 80 8.99 719.2
17-Jun-17 Central Kivell Desk 5 125 625
4-Jul-17 East Jones Pen Set 62 4.99 309.38
21-Jul-17 Central Morgan Pen Set 55 12.49 686.95
7-Aug-17 Central Kivell Pen Set 42 23.95 1005.9
24-Aug-17 West Sorvino Desk 3 275 825
10-Sep-17 Central Gill Pencil 7 1.29 9.03
27-Sep-17 West Sorvino Pen 76 1.99 151.24
14-Oct-17 West Thompson Binder 57 19.99 1139.43

31-Oct-17 Central Andrews Pencil 14 1.29 18.06

17-Nov-17 Central Jardine Binder 11 4.99 54.89


OrderDate Region Rep Item Units UnitCost Total
4-Dec-17 Central Jardine Binder 94 19.99 1879.06
21-Dec-17 Central Andrews Binder 28 4.99 139.72
37595_Erick Ferdyan_Tugas Bab 9B, Tugas 2, 08-03-2021

OrderDate Region Rep Item Units UnitCost Total


6-Jan-16 East Jones Pencil 95 1.99 189.05
23-Jan-16 Central Kivell Binder 50 19.99 999.5
9-Feb-16 Central Jardine Pencil 36 4.99 179.64
26-Feb-16 Central Gill Pen 27 19.99 539.73
15-Mar-16 West Sorvino Pencil 56 2.99 167.44
1-Apr-16 East Jones Binder 60 4.99 299.4
18-Apr-16 Central Andrews Pencil 75 1.99 149.25
5-May-16 Central Jardine Pencil 90 4.99 449.1
22-May-16 West Thompson Pencil 32 1.99 63.68
8-Jun-16 East Jones Binder 60 8.99 539.4
25-Jun-16 Central Morgan Pencil 90 4.99 449.1
12-Jul-16 East Howard Binder 29 1.99 57.71
29-Jul-16 East Parent Binder 81 19.99 1619.19
15-Aug-16 East Jones Pencil 35 4.99 174.65
1-Sep-16 Central Smith Desk 2 125 250
18-Sep-16 East Jones Pen Set 16 15.99 255.84
5-Oct-16 Central Morgan Binder 28 8.99 251.72
22-Oct-16 East Jones Pen 64 8.99 575.36
8-Nov-16 East Parent Pen 15 19.99 299.85
25-Nov-16 Central Kivell Pen Set 96 4.99 479.04
12-Dec-16 Central Smith Pencil 67 1.29 86.43
29-Dec-16 East Parent Pen Set 74 15.99 1183.26
15-Jan-17 Central Gill Binder 46 8.99 413.54
1-Feb-17 Central Smith Binder 87 15 1305
18-Feb-17 East Jones Binder 4 4.99 19.96
7-Mar-17 West Sorvino Binder 7 19.99 139.93
24-Mar-17 Central Jardine Pen Set 50 4.99 249.5
10-Apr-17 Central Andrews Pencil 66 1.99 131.34
27-Apr-17 East Howard Pen 96 4.99 479.04
14-May-17 Central Gill Pencil 53 1.29 68.37
31-May-17 Central Gill Binder 80 8.99 719.2
17-Jun-17 Central Kivell Desk 5 125 625
4-Jul-17 East Jones Pen Set 62 4.99 309.38
21-Jul-17 Central Morgan Pen Set 55 12.49 686.95
7-Aug-17 Central Kivell Pen Set 42 23.95 1005.9
24-Aug-17 West Sorvino Desk 3 275 825
10-Sep-17 Central Gill Pencil 7 1.29 9.03
27-Sep-17 West Sorvino Pen 76 1.99 151.24
14-Oct-17 West Thompson Binder 57 19.99 1139.43
31-Oct-17 Central Andrews Pencil 14 1.29 18.06
17-Nov-17 Central Jardine Binder 11 4.99 54.89
4-Dec-17 Central Jardine Binder 94 19.99 1879.06
21-Dec-17 Central Andrews Binder 28 4.99 139.72
6-Jan-16 East Jones Pencil 95 1.99 189.05

Page 3 of 5
37595_Erick Ferdyan_Tugas Bab 9B, Tugas 2, 08-03-2021

OrderDate Region Rep Item Units UnitCost Total


23-Jan-16 Central Kivell Binder 50 19.99 999.5
9-Feb-16 Central Jardine Pencil 36 4.99 179.64
26-Feb-16 Central Gill Pen 27 19.99 539.73
15-Mar-16 West Sorvino Pencil 56 2.99 167.44
1-Apr-16 East Jones Binder 60 4.99 299.4
18-Apr-16 Central Andrews Pencil 75 1.99 149.25
5-May-16 Central Jardine Pencil 90 4.99 449.1
22-May-16 West Thompson Pencil 32 1.99 63.68
8-Jun-16 East Jones Binder 60 8.99 539.4
25-Jun-16 Central Morgan Pencil 90 4.99 449.1
12-Jul-16 East Howard Binder 29 1.99 57.71
29-Jul-16 East Parent Binder 81 19.99 1619.19
15-Aug-16 East Jones Pencil 35 4.99 174.65
1-Sep-16 Central Smith Desk 2 125 250
18-Sep-16 East Jones Pen Set 16 15.99 255.84

Page 4 of 5
37595_Erick Ferdyan_Tugas Bab 9B, Tugas 2, 08-03-2021

OrderDate Region Rep Item Units UnitCost Total


29-Jul-16 East Parent Binder 81 19.99 1619.19
15-Aug-16 East Jones Pencil 35 4.99 174.65
1-Sep-16 Central Smith Desk 2 125 250
18-Sep-16 East Jones Pen Set 16 15.99 255.84
5-Oct-16 Central Morgan Binder 28 8.99 251.72
22-Oct-16 East Jones Pen 64 8.99 575.36
8-Nov-16 East Parent Pen 15 19.99 299.85
25-Nov-16 Central Kivell Pen Set 96 4.99 479.04
12-Dec-16 Central Smith Pencil 67 1.29 86.43
29-Dec-16 East Parent Pen Set 74 15.99 1183.26
15-Jan-17 Central Gill Binder 46 8.99 413.54
1-Feb-17 Central Smith Binder 87 15 1305
18-Feb-17 East Jones Binder 4 4.99 19.96
7-Mar-17 West Sorvino Binder 7 19.99 139.93
24-Mar-17 Central Jardine Pen Set 50 4.99 249.5
10-Apr-17 Central Andrews Pencil 66 1.99 131.34
27-Apr-17 East Howard Pen 96 4.99 479.04
14-May-17 Central Gill Pencil 53 1.29 68.37
31-May-17 Central Gill Binder 80 8.99 719.2
17-Jun-17 Central Kivell Desk 5 125 625
4-Jul-17 East Jones Pen Set 62 4.99 309.38
21-Jul-17 Central Morgan Pen Set 55 12.49 686.95
7-Aug-17 Central Kivell Pen Set 42 23.95 1005.9
24-Aug-17 West Sorvino Desk 3 275 825
10-Sep-17 Central Gill Pencil 7 1.29 9.03
27-Sep-17 West Sorvino Pen 76 1.99 151.24
14-Oct-17 West Thompson Binder 57 19.99 1139.43
31-Oct-17 Central Andrews Pencil 14 1.29 18.06
17-Nov-17 Central Jardine Binder 11 4.99 54.89
4-Dec-17 Central Jardine Binder 94 19.99 1879.06
21-Dec-17 Central Andrews Binder 28 4.99 139.72

Page 5 of 5

You might also like