Name Region Q1 Q2 Q3 Q4 Total Average Highest Lowest

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 5

Name

Region
Q1
Prentice East
2514
Chirillo
Northeast 23456
Wong
West
19954
Baker
South
17564
Richards North
28543
Hite
East
19534
de Moret West
20585
McWilliamsSouth
24957
Howard North
30332
Kerstetter Southwest 27595
Morris
East
25395
Lewis
South
35822
Jefferson Southwest 20949
Patrino
West
30113
Trowns-HaleMid Atlantic18432
Nguyen
Southeast 20995
Johnsen East
19668
OBrien
North
26046
Tantalo
Southwest 18366
Parker
West
32007
Blaisedell Midwest 29332
Capuano East
16494
Nihil
Northeast 21084
Arthur
Southeast 18456
Specter
North
29566
Klump
West
30543
George
Northeast 15776
Fredricks South
26427
Spittler
Southeast 22066
Hernandez Southwest 19967
Little
East
31740
Iwamoto North
28755
Davies
Midwest 21665
Fowler
South
32496
Graciele West
19953
Sandoval Northwest 27749
Amberson Southeast 19089
Edward
North
24445
Brooks
Southwest 38953
Humbert East
17066
Marino
Northeast 24286
Patterson Southeast 22779
Truscott West
16579
MacMurtrieMidwest 28365
Bowser
South
22749
Marianetti North
19955

Q2
17855
29550
22600
25439
28540
30558
29667
31322
27407
22933
27700
31854
23100
19554
24960
18850
24845
23846
28095
26489
21374
24217
23654
24637
27237
21759
23869
25313
30528
27475
29952
20638
23426
31364
26489
22474
37534
17449
26409
25396
18803
23946
16887
26358
28542

Q3
Q4
Total
24855
21377
85310
24294
25335
102635
19448
26450
88452
32944
24000
99947
24400
28550
110033
21844
19605
91541
27595
13605
91452
15330
27550
99159
26440
24007
108186
22422
21445
94395
16500
27500
97095
24384
31005
123065
21774
27550
93373
25300
16455
91422
27500
24399
70331
21950
24855
92760
21355
20540
80413
28575
22555
102021
26587
28456
97255
27497
21687
109286
25656
28057
109534
24294
26487
88649
32804
27044
105149
28560
27475
98145
25831
32564
112598
18934
26945
103659
24370
29316
91221
28503
26190
104989
26440
37438
111257
27047
29411
106953
27994
36895
124104
25349
28485
112541
27368
14787
84458
27648
27365
110935
20143
38564
110024
18897
31659
104794
26579
31854
99996
28543
22749
113271
26538
25967
108907
24769
37557
105801
27456
17463
94601
25317
29426
96325
38166
26703
105394
31957
23894
101103
27485
17940
94532
29577
24500
102574

Average Highest
Lowest
21327.5
24855
17855
25658.75
29550
23456
22113
26450
19448
24986.75
32944
17564
27508.25
28550
24400
22885.25
30558
19534
22863
29667
13605
24789.75
31322
15330
27046.5
30332
24007
23598.75
27595
21445
24273.75
27700
16500
30766.25
35822
24384
23343.25
27550
20949
22855.5
30113
16455
23443.67
27500
18432
23190
24960
20995
20103.25
21355
18850
25505.25
28575
22555
24313.75
28456
18366
27321.5
32007
21687
27383.5
29332
25656
22162.25
26487
16494
26287.25
32804
21084
24536.25
28560
18456
28149.5
32564
24637
25914.75
30543
18934
22805.25
29316
15776
26247.25
28503
23869
27814.25
37438
22066
26738.25
30528
19967
31026
36895
27475
28135.25
29952
25349
21114.5
27368
14787
27733.75
32496
23426
27506
38564
19953
26198.5
31659
18897
24999
31854
19089
28317.75
37534
22749
27226.75
38953
17449
26450.25
37557
17066
23650.25
27456
17463
24081.25
29426
18803
26348.5
38166
16579
25275.75
31957
16887
23633
27485
17940
25643.5
29577
19955

Everett
Rebondot
Shelton
Yang
Quincy
Bradford

Mideast
West
Northwest
South
Mideast
East

28640
33266
39543
18232
22654
26835

19945
17603
26489
29869
27543
22557

28865
26345
18609
30253
36475
14568

18552
16879
27470
32776
15377
25432

96002 24000.5
94093 23523.25
112111 28027.75
111130 27782.5
102049 25512.25
89392
22348

28865
33266
39543
32776
36475
26835

18552
16879
18609
18232
15377
14568

Commission
3412.4
4105.4
3538.08
3997.88
4401.32
3661.64
3658.08
3966.36
4327.44
3775.8
3883.8
4922.6
3734.92
3656.88
2813.24
3710.4
3216.52
4080.84
3890.2
4371.44
4381.36
3545.96
4205.96
3925.8
4503.92
4146.36
3648.84
4199.56
4450.28
4278.12
4964.16
4501.64
3378.32
4437.4
4400.96
4191.76
3999.84
4530.84
4356.28
4232.04
3784.04
3853
4215.76
4044.12
3781.28
4102.96

Employee ID
S1001
S1001
S1002
Chirillo
S1003
Wong
S1004
Baker
S1005
S1005
S1006
Hite
de Moret
S1008
McWilliams
S1009
S1009
S1010
S1010
S1011
S1011
S1012
S1012
S1013
Jefferson
S1014
S1014
S1015
Trowns-Hale
S1016
Nguyen
S1017
Johnsen
S1018
S1018
S1019
Tantalo
S1020
S1020
S1021
S1021
S1022
Capuano
S1023
Nihil
S1024
Arthur
S1025
S1025
S1026
S1026
S1027
George
S1028
S1028
S1029
Spittler
S1030
Hernandez
S1031
S1031
S1032
S1032
S1033
Davies
S1034
S1034
S1035
Graciele
S1036
S1036
S1037
Amberson
S1038
Edward
S1039
S1039
S1040
Humbert
S1041
Marino
S1042
Patterson
S1043
Truscott
S1044
S1044
S1045
Bowser
S1046
Marianetti

3840.08
3763.72
4484.44
4445.2
4081.96
3575.68

S1047
S1048
S1049
S1050
S1051
S1052

S1047
S1048
S1049
Yang
Quincy
S1052

Name
Prentice
Chirillo
Wong
Baker
Richards
Hite
de Moret
McWilliams
Howard
Kerstetter
Morris
Lewis
Jefferson
Patrino
Trowns-Hale
Nguyen
Johnsen
OBrien
Tantalo
Parker
Blaisedell
Capuano
Nihil
Arthur

Employee ID
S1001
S1002
S1003
S1004
S1005
S1006
S1008
S1009
S1010
S1011
S1012
S1013
S1014
S1015
S1016
S1017
S1018
S1019
S1020
S1021
S1022
S1023
S1024

Region
East
Northeast
West
South
North
East
0 West
South
North
Southwest
East
South
Southwest
West
Mid Atlantic
Southeast
East
North
Southwest
West
Midwest
East
Northeast
Southeast

averge
Highest lowest
21327.5 24855 17855
25658.75 29550 23456
22113 26450 19448
24986.75 32944 17564
27508.25 28550 24400
22885.25 30558 19534
22863 29667 13605
24789.75 31322 15330
27046.5 30332 24007
23598.75 27595 21445
24273.75 27700 16500
30766.25 35822 24384
23343.25 27550 20949
22855.5 30113 16455
23443.66667 27500 18432
23190 24960 20995
20103.25 21355 18850
25505.25 28575 22555
24313.75 28456 18366
27321.5 32007 21687
27383.5 29332 25656
22162.25 26487 16494
26287.25 32804 21084
24536.25 28560 18456

You might also like