Date Region Salesperson Product Units Sold

2024-05-28 South Bob Monitor 7

2024-03-23 South Bob Laptop 7
2024-02-10 South Alice Laptop 20
2024-06-10 East Charlie Monitor 10
2024-04-07 East Bob Laptop 9
2024-02-25 South Alice Smartphone 14
2024-03-13 South Alice Monitor 11
2024-06-15 South Charlie Monitor 4
2024-01-17 South Alice Tablet 4
2024-06-04 East Charlie Monitor 11
2024-05-11 West Charlie Smartphone 16
2024-03-31 South Charlie Laptop 9
2024-02-22 North Alice Monitor 14
2024-04-12 East Charlie Smartphone 14
2024-05-07 North David Tablet 11
2024-01-30 South Bob Tablet 13
2024-03-28 North Charlie Tablet 9
2024-04-16 North Bob Monitor 11
2024-04-16 South Alice Monitor 3
2024-05-23 North Alice Tablet 4
2024-05-15 North Alice Smartphone 1
2024-06-10 East David Laptop 4
2024-05-18 West Charlie Monitor 2
2024-03-02 East Bob Tablet 20
2024-01-03 South Alice Laptop 10
2024-04-13 East Charlie Monitor 1
2024-03-01 South Alice Laptop 9
2024-03-31 North Charlie Tablet 13
2024-04-07 South Alice Smartphone 3
2024-06-26 North Bob Tablet 19
2024-06-11 North Charlie Tablet 13
2024-05-28 West Alice Smartphone 18
2024-04-08 North Alice Smartphone 11
2024-02-03 East Alice Laptop 8
2024-01-10 West Alice Monitor 9
2024-02-06 North Alice Monitor 7
2024-06-26 South David Monitor 19
2024-01-01 West Alice Smartphone 17
2024-03-21 South Bob Smartphone 1
2024-05-04 South Bob Smartphone 3
2024-04-15 East Bob Tablet 9
2024-05-24 East Charlie Smartphone 10
2024-06-10 South Alice Tablet 12
2024-04-28 North Alice Tablet 17
2024-02-02 West Charlie Monitor 14
2024-05-03 North Charlie Monitor 19
2024-05-19 North Charlie Monitor 9
2024-05-30 South David Tablet 6
2024-04-10 West Alice Monitor 6
2024-01-31 North Charlie Laptop 3
Unit Price Total Sales
SALESMAN TOTAL UNITS SOLD BY SALEMAN AVERAGE UNIT PRICE
5282 36974 Bob 99 15734.9
14507 101549 Alice 198 HIGHEST TOTAL SALES
7415 148300 Charlie 157 448248
23000 230000 David 40 LOWEST TOTAL SALES
10742 96678 7452
12282 171948
TOTAL SALES PER REGION
17295 190245
11318 45272 2750000 2802364

7450 29800
2250000
13888 152768 2015204
20698 331168 1750000 1747602

23678 213102 1427762

TOTAL SALES

1250000
20748 290472
17911 250754 750000
11697 128667
12072 156936 250000

5720 51480 NORTH SOUTH WEST EAST

TOTAL SALES PER REGION 2802364 2015204 1427762 1747602
22586 248446
8883 26649 REGION

14194 56776
20506 20506 TOTAL SALES
21082 84328
13040 26080
1144129
17927 358540 2477983

20652 206520
20179 20179
7347 66123
24158 314054
14453 43359 2668817

23592 448248
1702003
16262 211406
 2668817

1702003

5843 105174
17634 193974
19581 156648
LAPTOP MONITOR SMARTPHONE TABLET
20879 187911
17744 124208
20160 383040
19857 337569
7452 7452
13563 40689
22033 198297
19941 199410
7876 94512
22149 376533
23223 325122
11635 221065
5072 45648
8789 52734
900,000
19123 114738
23627 70881

800,000

700,000

600,000

500,000
TOTAL SALE

400,000

337,569
 500,000

TOTAL SALE
400,000

337,569
325,122

300,000

206,520
200,000 187,911

156,936
156,648
14
124,208

100,000
70,881

29,800

0
24 24 24 24 24 24 24 24 24 24 24 24 24 2
/ 20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20
1 4 7 0 3 6 9 2 5 8 1 3 6 9
1/ 1/ 1/ 1/1 1/1 1/1 1/1 1/2 1/2 1/2 1/3 2/ 2/ 2/ 2/1
 REGION TOTAL SALES PER REGION PRODUCTS TOTAL SALES
NORTH 2802364 LAPTOP 1144129
SOUTH 2015204 MONITOR 2668817
WEST 1427762 SMARTPHONE 1702003
EAST 1747602 TABLET 2477983

1747602

EAST
1747602

2668817
2668817

TOTAL SALES TREND

527,156

376,533
358,540
 376,533
358,540

325,122

290,472
275,095
250,754

193,974 198,297
190,245
171,948
156,936
156,648
148,300
124,208
114,738
101,549

70,881 66,123 69,008

51,480

20,179
7,452

24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24 24
/ 20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20 /20
2 25 28 31 /3 /6 /9 12 15 18 21 24 27 /1 /4 /7 10 13 16 19 22 25 28 31 /3 /6 /9 12 15 18 21 24 27 30 /
1/ 1/ 1/ 2 2 2 2/ 2/ 2/ 2/ 2/ 2/ 3 3 3 3/ 3/ 3/ 3/ 3/ 3/ 3/ 3/ 4 4 4 4/ 4/ 4/ 4/ 4/ 4/ 4/ 5

DATE
 Date
DATE TOTAL SALES TREND
1/1/2024 337,569 2024-04-13
1/3/2024 206,520 2024-05-15
1/10/2024 187,911 2024-05-18
1/17/2024 29,800 2024-04-16
1/30/2024 156,936 2024-01-17
1/31/2024 70,881 2024-05-28
2/2/2024 325,122 2024-05-04
2/3/2024 156,648 2024-04-07
2/6/2024 124,208 2024-06-15
2/10/2024 148,300 2024-05-19
2/22/2024 290,472 2024-03-28
2/25/2024 171,948 2024-05-30
3/1/2024 66,123 2024-05-23
3/2/2024 358,540 2024-03-01
3/13/2024 190,245 2024-01-31
3/21/2024 7,452 2024-06-10
3/23/2024 101,549 2024-06-10
3/28/2024 51,480 2024-04-07
3/31/2024 527,156 2024-03-23
4/7/2024 69,008 2024-05-28
4/8/2024 193,974 2024-04-10
4/10/2024 114,738 2024-02-06
4/12/2024 250,754 2024-05-07
4/13/2024 20,179 2024-02-10
4/15/2024 198,297 2024-06-04
4/16/2024 275,095 2024-02-03
4/28/2024 376,533 2024-01-30
5/3/2024 221,065 2024-02-25
5/4/2024 40,689 2024-01-10
5/7/2024 128,667 2024-03-13
5/11/2024 331,168 2024-04-08
 5/15/2024 20,506 2024-04-15
5/18/2024 26,080 2024-05-24
5/19/2024 45,648 2024-01-03
5/23/2024 56,776 2024-06-11
5/24/2024 199,410 2024-03-31
5/28/2024 142,148 2024-05-03
5/30/2024 52,734 2024-06-10
6/4/2024 152,768 2024-03-21
6/10/2024 409,840 2024-04-16
6/11/2024 211,406 2024-04-12
6/15/2024 45,272 2024-02-22
6/26/2024 831,288 2024-03-31
2024-02-02
2024-05-11
2024-01-01
2024-03-02
S TREND
2024-04-28
2024-06-26
2024-06-26
831,288

527,156

409,840

376,533

331,168
 409,840

376,533

331,168

275,095
250,754

221,065
211,406
193,974 198,297 199,410

152,768
142,148
128,667
114,738

69,008
1,480 56,776 52,734
40,689 45,648 45,272
20,179 26,080
20,506

4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4
02 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202 202
/ / / / / / / / / / / / / / / / / / / / / / / / / / / / / /
31 4/3 4/6 4/9 /12 /15 /18 /21 /24 /27 /30 5/3 5/6 5/9 /12 /15 /18 /21 /24 /27 /30 6/2 6/5 6/8 /11 /14 /17 /20 /23 /26
3/ 4 4 4 4 4 4 4 5 5 5 5 5 5 5 6 6 6 6 6 6

ATE
Region Salesperson Product Units Sold Unit Price

East Charlie Monitor 1 20179

North Alice Smartphone 1 20506
West Charlie Monitor 2 13040
South Alice Monitor 3 8883
South Alice Tablet 4 7450
South Bob Monitor 7 5282
South Bob Smartphone 3 13563
South Alice Smartphone 3 14453
South Charlie Monitor 4 11318
North Charlie Monitor 9 5072
North Charlie Tablet 9 5720
South David Tablet 6 8789
North Alice Tablet 4 14194
South Alice Laptop 9 7347
North Charlie Laptop 3 23627
East David Laptop 4 21082
South Alice Tablet 12 7876
East Bob Laptop 9 10742
South Bob Laptop 7 14507
West Alice Smartphone 18 5843
West Alice Monitor 6 19123
North Alice Monitor 7 17744
North David Tablet 11 11697
South Alice Laptop 20 7415
East Charlie Monitor 11 13888
East Alice Laptop 8 19581
South Bob Tablet 13 12072
South Alice Smartphone 14 12282
West Alice Monitor 9 20879
South Alice Monitor 11 17295
North Alice Smartphone 11 17634
 East Bob Tablet 9 22033
East Charlie Smartphone 10 19941
South Alice Laptop 10 20652
North Charlie Tablet 13 16262
South Charlie Laptop 9 23678
North Charlie Monitor 19 11635
East Charlie Monitor 10 23000
South Bob Smartphone 1 7452
North Bob Monitor 11 22586
East Charlie Smartphone 14 17911
North Alice Monitor 14 20748
North Charlie Tablet 13 24158
West Charlie Monitor 14 23223
West Charlie Smartphone 16 20698
West Alice Smartphone 17 19857
East Bob Tablet 20 17927
North Alice Tablet 17 22149
South David Monitor 19 20160
North Bob Tablet 19 23592
831,288
272

24 24 24 24
20 /20 /20 /20
20 23 26
6/ 6/ 6/
Total Sales
Sum of Total Sales Product
20179 Region Salesperson Laptop Monitor Smartpho
20506 East 337654 402947 450164
26080 Alice 156648
26649 Bob 96678
29800 Charlie 402947 450164
36974 David 84328
40689 North 70881 929839 214480
43359 Alice 414680 214480
45272 Bob 248446
45648 Charlie 70881 266713
51480 David
52734 South 735594 682180 263448
56776 Alice 420943 216894 215307
66123 Bob 101549 36974 48141
70881 Charlie 213102 45272
84328 David 383040
94512 West 653851 773911
96678 Alice 302649 442743
101549 Charlie 351202 331168
105174 Total Result 1144129 2668817 1702003
114738
124208
128667
148300
152768
156648
156936
171948
187911
190245
193974
198297
199410
206520
211406
213102
221065
230000
7452
248446
250754
290472
314054
325122
331168
337569
358540
376533
383040
448248
Tablet Total Result
556837 1747602
156648
556837 653515
853111
84328
1587164 2802364
433309 1062469
448248 696694
576940 914534
128667 128667
333982 2015204
124312 977456
156936 343600
258374
52734 435774
1427762
745392
682370
2477983 7992932