Performance Based Pay Differential

Performance RatCount of Performance Rating Performance Rat

3 45.00% 4
1 20.00% 3
4 20.00% 2
2 15.00% 1
Total Result 100.00% Total Result
Performance Based Pay Differential Employee Satisfaction with Leadership
Average of Performance Based Pay Employee SatisfcSum of EmpID
42.5 1 10.01%
32.2222222222222 2 25.10%
21.6666666666667 3 39.94%
13 4 15.01%
28.85 5 9.94%
Total Result 100.00%

Peer Review Rate

Reviewed By Count of Performance Rating
Manager 45.00%
Peer 25.00%
Self 30.00%
Total Result 100.00%
nt of Performance Rating
Timeline: Works in Excel 2013 or higher. Do not move or resize.

Performance Rating Perfoormance Based

Distributi on
45.00%
Total Result
Pay Differentials
28.85
3
100.00% 1 1 13
4
20.00% 21.666666666
2 2
6667
Total Result 32.222222222
20.00% 3
2222
4 42.5
15.00%
0.00 5.00 10.0015.0020.0025.0030.0035.0040.0045.00
 This shape represents a This shape represents a
slicer. Slicers are supported slicer. Slicers are supported
in Excel 2010 or later. in Excel 2010 or later.

If the shape was modified in If the shape was modified in

an earlier version of Excel, an earlier version of Excel,
or if the workbook was saved or if the workbook was saved
in Excel 2003 or earlier, the in Excel 2003 or earlier, the
slicer cannot be used. slicer cannot be used.

Based Total Peer/Self Review Rate

tials 100.00% 100.00%
80.00%
60.00%
40.00%
39.94% 100.00%
45.00%
20.00%
25.10%
15.01% 25.00% 30.00%
0.00%
10.01% 9.94%
42.5 Manager
1 2 3 4 5 Total Peer
Self
35.0040.0045.00 Result Total Result
EmpID Age Sex Marital Desc Tenure Reviewed By Performance Performance
Rating Based Pay

10026 39 M Single 11 Self 4 42

10084 47 M Married 7 Peer 3 33
10196 34 F Married 11 Peer 1 12
10088 33 F Married 14 Peer 2 20
10069 33 F Divorced 11 Self 3 32
10002 45 F Single 10 Manager 4 43
10194 43 F Single 7 Manager 3 32
10062 39 M Widowed 8 Manager 2 22
10114 52 F Single 13 Self 2 23
10250 34 M Divorced 7 Manager 3 31
10252 48 F Married 11 Manager 3 34
10242 48 M Married 10 Peer 3 35
10012 34 M Divorced 7 Self 4 41
10265 39 M Single 10 Self 3 30
10066 45 M Divorced 9 Manager 1 14
10061 40 M Single 11 Manager 3 32
10023 56 F Married 6 Manager 4 44
10055 51 F Single 11 Self 3 31
10245 36 F Single 8 Peer 1 11
10277 43 M Single 9 Manager 1 15
Total 2.65
 Employee
Satisfcation
with
Leadership
3
4
3
2
5
3
2
4
3
1
3
2
3
4
3
5
1
2
3
2
2.9
 HR Metrics (Performance Management)

1 Average Performance Appraisal Rating 2.65

2 Performance Rating Distribution
3 Performance Based Pay Differential
4 Peer Review Rate
5 Self Review Rate
6 Employee Satisfaction with Leadership