Date Region Salesperson Product

2024-05-28 South Bob Monitor

2024-03-23 South Bob Laptop
2024-02-10 South Alice Laptop
2024-06-10 East Charlie Monitor
2024-04-07 East Bob Laptop
2024-02-25 South Alice Smartphone
2024-03-13 South Alice Monitor
2024-06-15 South Charlie Monitor
2024-01-17 South Alice Tablet
2024-06-04 East Charlie Monitor
2024-05-11 West Charlie Smartphone
2024-03-31 South Charlie Laptop
2024-02-22 North Alice Monitor
2024-04-12 East Charlie Smartphone
2024-05-07 North David Tablet
2024-01-30 South Bob Tablet
2024-03-28 North Charlie Tablet
2024-04-16 North Bob Monitor
2024-04-16 South Alice Monitor
2024-05-23 North Alice Tablet
2024-05-15 North Alice Smartphone
2024-06-10 East David Laptop
2024-05-18 West Charlie Monitor
2024-03-02 East Bob Tablet
2024-01-03 South Alice Laptop
2024-04-13 East Charlie Monitor
2024-03-01 South Alice Laptop
2024-03-31 North Charlie Tablet
2024-04-07 South Alice Smartphone
2024-06-26 North Bob Tablet
2024-06-11 North Charlie Tablet
2024-05-28 West Alice Smartphone
2024-04-08 North Alice Smartphone
2024-02-03 East Alice Laptop
2024-01-10 West Alice Monitor
2024-02-06 North Alice Monitor
2024-06-26 South David Monitor
2024-01-01 West Alice Smartphone
2024-03-21 South Bob Smartphone
2024-05-04 South Bob Smartphone
2024-04-15 East Bob Tablet
2024-05-24 East Charlie Smartphone
2024-06-10 South Alice Tablet
2024-04-28 North Alice Tablet
2024-02-02 West Charlie Monitor
2024-05-03 North Charlie Monitor
2024-05-19 North Charlie Monitor
2024-05-30 South David Tablet
2024-04-10 West Alice Monitor
2024-01-31 North Charlie Laptop
Units Sold Unit Price Total Sales SALESMAN
7 5282 36974 Bob
7 14507 101549 Alice
20 7415 148300 Charlie
10 23000 230000 David
9 10742 96678
14 12282 171948
11 17295 190245
4 11318 45272
4 7450 29800
11 13888 152768
16 20698 331168
9 23678 213102
14 20748 290472
14 17911 250754
11 11697 128667
13 12072 156936
9 5720 51480
11 22586 248446
3 8883 26649
4 14194 56776
1 20506 20506
4 21082 84328
2 13040 26080
20 17927 358540
10 20652 206520
1 20179 20179
9 7347 66123
13 24158 314054
3 14453 43359
19 23592 448248
13 16262 211406
18 5843 105174
11 17634 193974
8 19581 156648
9 20879 187911
7 17744 124208
19 20160 383040
17 19857 337569
1 7452 7452
3 13563 40689
9 22033 198297
10 19941 199410
12 7876 94512
17 22149 376533
14 23223 325122
19 11635 221065
9 5072 45648
6 8789 52734
6 19123 114738
3 23627 70881
TOTAL UNITS SOLD BY SALESMAN AVERAGE UNIT PRICE REGION TOTAL SALES PER REGION
99 15734.9 NORTH 2802364
198 HIGHEST TOTAL SALES SOUTH 2015204
157 448248 WEST 1427762
40 LOWEST TOTAL SALES EAST 1747602
7452

TOTAL SALES PER REGION

2802364
2750000
2250000 2015204
1747602
1750000 1427762

TOTAL SALES
1250000
750000
250000
NORTH SOUTH WEST EAST
TOTAL SALES PER RE- 2802364 2015204 1427762 1747602
GION

REGIO

TOTAL SALES
1144129
2477983

2668817

1702003

laptop monitor smartphone tablet

Total Sales Trend (Sum)

900,000
831,2
800,000

700,000

600,000
527,156
500,000
 831,2
800,000

700,000

600,000
527,156
500,000

TOTAL SALES
409,840
400,000 376,533
358,540
337,569 325,122 331,168
290,472 275,095
300,000
250,754
221,065
206,520 190,245 198,297
193,974 199,410 211,406
200,000 187,911 171,948
156,936
156,648
148,300 152,768
142,148
124,208 128,667
101,549 114,738
100,000 70,881 66,123 69,008
51,480 56,776
45,648
40,689 26,08052,734 45,272
29,800 20,179 20,506
7,452
0

DATE
 PRODUCTS TOTAL SALES DATE Total Sales Trend (Sum)
laptop 1144129 1/1/2024 337,569
monitor 2668817 1/3/2024 206,520
smartphone 1702003 1/10/2024 187,911
tablet 2477983 1/17/2024 29,800
1/30/2024 156,936
1/31/2024 70,881
2/2/2024 325,122
2/3/2024 156,648
GION 2/6/2024 124,208
2/10/2024 148,300
4 2/22/2024 290,472
1747602 2/25/2024 171,948
1427762
3/1/2024 66,123
3/2/2024 358,540
3/13/2024 190,245
WEST EAST 3/21/2024 7,452
4 1427762 1747602 3/23/2024 101,549
3/28/2024 51,480
3/31/2024 527,156
REGION 4/7/2024 69,008
4/8/2024 193,974
4/10/2024 114,738
4/12/2024 250,754
4/13/2024 20,179
129 4/15/2024 198,297
4/16/2024 275,095
4/28/2024 376,533
5/3/2024 221,065
5/4/2024 40,689
2668817 5/7/2024 128,667
5/11/2024 331,168
5/15/2024 20,506
5/18/2024 26,080
5/19/2024 45,648
tablet 5/23/2024 56,776
5/24/2024 199,410
5/28/2024 142,148
5/30/2024 52,734
6/4/2024 152,768
6/10/2024 409,840
6/11/2024 211,406
6/15/2024 45,272
6/26/2024 831,288
831,288
 831,288

409,840
76,533
331,168

221,065
199,410 211,406
152,768
142,148
128,667

56,776
45,648
40,689 26,08052,734 45,272
20,506
 Date Region Salesperson Product Units Sold
2024-04-13 East Charlie Monitor 1
2024-05-15 North Alice Smartphone 1
2024-05-18 West Charlie Monitor 2
2024-04-16 South Alice Monitor 3
2024-01-17 South Alice Tablet 4
2024-05-28 South Bob Monitor 7
2024-05-04 South Bob Smartphone 3
2024-04-07 South Alice Smartphone 3
2024-06-15 South Charlie Monitor 4
2024-05-19 North Charlie Monitor 9
2024-03-28 North Charlie Tablet 9
2024-05-30 South David Tablet 6
2024-05-23 North Alice Tablet 4
2024-03-01 South Alice Laptop 9
2024-01-31 North Charlie Laptop 3
2024-06-10 East David Laptop 4
2024-06-10 South Alice Tablet 12
2024-04-07 East Bob Laptop 9
2024-03-23 South Bob Laptop 7
2024-05-28 West Alice Smartphone 18
2024-04-10 West Alice Monitor 6
2024-02-06 North Alice Monitor 7
2024-05-07 North David Tablet 11
2024-02-10 South Alice Laptop 20
2024-06-04 East Charlie Monitor 11
2024-02-03 East Alice Laptop 8
2024-01-30 South Bob Tablet 13
2024-02-25 South Alice Smartphone 14
2024-01-10 West Alice Monitor 9
2024-03-13 South Alice Monitor 11
2024-04-08 North Alice Smartphone 11
2024-04-15 East Bob Tablet 9
2024-05-24 East Charlie Smartphone 10
2024-01-03 South Alice Laptop 10
2024-06-11 North Charlie Tablet 13
2024-03-31 South Charlie Laptop 9
2024-05-03 North Charlie Monitor 19
2024-06-10 East Charlie Monitor 10
2024-03-21 South Bob Smartphone 1
2024-04-16 North Bob Monitor 11
2024-04-12 East Charlie Smartphone 14
2024-02-22 North Alice Monitor 14
2024-03-31 North Charlie Tablet 13
2024-02-02 West Charlie Monitor 14
2024-05-11 West Charlie Smartphone 16
2024-01-01 West Alice Smartphone 17
2024-03-02 East Bob Tablet 20
2024-04-28 North Alice Tablet 17
2024-06-26 South David Monitor 19
2024-06-26 North Bob Tablet 19
Unit Price Total Sales Sum of Total Sales Product
20179 20179 Salesperson Region Laptop Monitor
20506 20506 Alice 577591 934223
13040 26080 East 156648
8883 26649 North 414680
7450 29800 South 420943 216894
5282 36974 West 302649
13563 40689 Bob 198227 285420
14453 43359 East 96678
11318 45272 North 248446
5072 45648 South 101549 36974
5720 51480 Charlie 283983 1066134
8789 52734 East 402947
14194 56776 North 70881 266713
7347 66123 South 213102 45272
23627 70881 West 351202
21082 84328 David 84328 383040
7876 94512 East 84328
10742 96678 North
14507 101549 South 383040
5843 105174 Total Result 1144129 2668817
19123 114738
17744 124208
11697 128667
7415 148300
13888 152768
19581 156648
12072 156936
12282 171948
20879 187911
17295 190245
17634 193974
22033 198297
19941 199410
20652 206520
16262 211406
23678 213102
11635 221065
23000 230000
7452 7452
22586 248446
17911 250754
20748 290472
24158 314054
23223 325122
20698 331168
19857 337569
17927 358540
22149 376533
20160 383040
23592 448248
Smartpho Tablet Total Result
872530 557621 2941965
156648
214480 433309 1062469
215307 124312 977456
442743 745392
48141 1162021 1693809
556837 653515
448248 696694
48141 156936 343600
781332 576940 2708389
450164 853111
576940 914534
258374
331168 682370
181401 648769
84328
128667 128667
52734 435774
1702003 2477983 7992932
 Date Region Salesperson Product Units Sold Unit Price
2024-05-28 South Bob Monitor 7 5282
2024-03-23 South Bob Laptop 7 14507
2024-02-10 South Alice Laptop 20 7415
2024-06-10 East Charlie Monitor 10 23000
2024-04-07 East Bob Laptop 9 10742
2024-02-25 South Alice Smartphone 14 12282
2024-03-13 South Alice Monitor 11 17295
2024-06-15 South Charlie Monitor 4 11318
2024-01-17 South Alice Tablet 4 7450
2024-06-04 East Charlie Monitor 11 13888
2024-05-11 West Charlie Smartphone 16 20698
2024-03-31 South Charlie Laptop 9 23678
2024-02-22 North Alice Monitor 14 20748
2024-04-12 East Charlie Smartphone 14 17911
2024-05-07 North David Tablet 11 11697
2024-01-30 South Bob Tablet 13 12072
2024-03-28 North Charlie Tablet 9 5720
2024-04-16 North Bob Monitor 11 22586
2024-04-16 South Alice Monitor 3 8883
2024-05-23 North Alice Tablet 4 14194
2024-05-15 North Alice Smartphone 1 20506
2024-06-10 East David Laptop 4 21082
2024-05-18 West Charlie Monitor 2 13040
2024-03-02 East Bob Tablet 20 17927
2024-01-03 South Alice Laptop 10 20652
2024-04-13 East Charlie Monitor 1 20179
2024-03-01 South Alice Laptop 9 7347
2024-03-31 North Charlie Tablet 13 24158
2024-04-07 South Alice Smartphone 3 14453
2024-06-26 North Bob Tablet 19 23592
2024-06-11 North Charlie Tablet 13 16262
2024-05-28 West Alice Smartphone 18 5843
2024-04-08 North Alice Smartphone 11 17634
2024-02-03 East Alice Laptop 8 19581
2024-01-10 West Alice Monitor 9 20879
2024-02-06 North Alice Monitor 7 17744
2024-06-26 South David Monitor 19 20160
2024-01-01 West Alice Smartphone 17 19857
2024-03-21 South Bob Smartphone 1 7452
2024-05-04 South Bob Smartphone 3 13563
2024-04-15 East Bob Tablet 9 22033
2024-05-24 East Charlie Smartphone 10 19941
2024-06-10 South Alice Tablet 12 7876
2024-04-28 North Alice Tablet 17 22149
2024-02-02 West Charlie Monitor 14 23223
2024-05-03 North Charlie Monitor 19 11635
2024-05-19 North Charlie Monitor 9 5072
2024-05-30 South David Tablet 6 8789
2024-04-10 West Alice Monitor 6 19123
2024-01-31 North Charlie Laptop 3 23627
Total Sales
36974
101549
148300
230000
96678
171948
190245
45272
29800
152768
331168
213102
290472
250754
128667
156936
51480
248446
26649
56776
20506
84328
26080
358540
206520
20179
66123
314054
43359
448248
211406
105174
193974
156648
187911
124208
383040
337569
7452
40689
198297
199410
94512
376533
325122
221065
45648
 52734
114738
70881
 Date Region Salesperson Product Units Sold Unit Price Total Sales
2024-05-28 South Bob Monitor 7 5282 36974
2024-03-23 South Bob Laptop 7 14507 101549
2024-02-10 South Alice Laptop 20 7415 148300
2024-06-10 East Charlie Monitor 10 23000 230000
2024-04-07 East Bob Laptop 9 10742 96678
2024-02-25 South Alice Smartphone 14 12282 171948
2024-03-13 South Alice Monitor 11 17295 190245
2024-06-15 South Charlie Monitor 4 11318 45272
2024-01-17 South Alice Tablet 4 7450 29800
2024-06-04 East Charlie Monitor 11 13888 152768
2024-05-11 West Charlie Smartphone 16 20698 331168
2024-03-31 South Charlie Laptop 9 23678 213102
2024-02-22 North Alice Monitor 14 20748 290472
2024-04-12 East Charlie Smartphone 14 17911 250754
2024-05-07 North David Tablet 11 11697 128667
2024-01-30 South Bob Tablet 13 12072 156936
2024-03-28 North Charlie Tablet 9 5720 51480
2024-04-16 North Bob Monitor 11 22586 248446
2024-04-16 South Alice Monitor 3 8883 26649
2024-05-23 North Alice Tablet 4 14194 56776
2024-05-15 North Alice Smartphone 1 20506 20506
2024-06-10 East David Laptop 4 21082 84328
2024-05-18 West Charlie Monitor 2 13040 26080
2024-03-02 East Bob Tablet 20 17927 358540
2024-01-03 South Alice Laptop 10 20652 206520
2024-04-13 East Charlie Monitor 1 20179 20179
2024-03-01 South Alice Laptop 9 7347 66123
2024-03-31 North Charlie Tablet 13 24158 314054
2024-04-07 South Alice Smartphone 3 14453 43359
2024-06-26 North Bob Tablet 19 23592 448248
2024-06-11 North Charlie Tablet 13 16262 211406
2024-05-28 West Alice Smartphone 18 5843 105174
2024-04-08 North Alice Smartphone 11 17634 193974
2024-02-03 East Alice Laptop 8 19581 156648
2024-01-10 West Alice Monitor 9 20879 187911
2024-02-06 North Alice Monitor 7 17744 124208
2024-06-26 South David Monitor 19 20160 383040
2024-01-01 West Alice Smartphone 17 19857 337569
2024-05-04 South Bob Smartphone 3 13563 40689
2024-04-15 East Bob Tablet 9 22033 198297
2024-05-24 East Charlie Smartphone 10 19941 199410
2024-06-10 South Alice Tablet 12 7876 94512
2024-04-28 North Alice Tablet 17 22149 376533
2024-02-02 West Charlie Monitor 14 23223 325122
2024-05-03 North Charlie Monitor 19 11635 221065
2024-05-19 North Charlie Monitor 9 5072 45648
2024-05-30 South David Tablet 6 8789 52734
2024-04-10 West Alice Monitor 6 19123 114738
2024-01-31 North Charlie Laptop 3 23627 70881