|
1 - Closest Step, without Decrease
<br /># of Staff Current Salary
<br />Proposed Salary
<br />Difference
<br />% Increase
<br />Totals
<br />45 $4,447,526.18
<br />$4,554,354.62
<br />$106,828.44
<br />2.4%
<br />Employees Below Minimum
<br />4 $402,563.20
<br />$416,247.22
<br />$13,684.02
<br />3.4%
<br />Employees Within Range
<br />41
<br />$4,044,962.98
<br />$4,138,107.40
<br />$93,144.42
<br />2.3%
<br />Emplovees Above Maximum
<br />0
<br />$0.00
<br />$0.00
<br />$0.00
<br />#DIV/0!
<br />Option 1 b: Steps based on current relation to midpoint
<br /># of Staff Current Salary Proposed Salary Difference % Increase
<br />Totals 45 $4,447,526.18 $4,733,883.63 $286,357.45 6.4%
<br />Employees Below Minimum
<br />4
<br />$402,563.20
<br />1 $459,250.39
<br />1 $56,687.191
<br />14.1%
<br />Employees Within Range
<br />41
<br />$4,044,962.98
<br />$4,274,633.24
<br />1 $229,670.26
<br />5.7%
<br />Employees Above Maximum
<br />0 $0.00
<br />$0.00
<br />$0.00
<br />#DIV/0!
<br />2: Steps based on Years in Position
<br /># of Staff Current Salary
<br />Proposed Salary
<br />Difference
<br />% Increase
<br />Totals
<br />45 $4,447,526.18
<br />$4,681,333.41
<br />$233,807.23
<br />5.3%
<br />Employees Below Minimum
<br />4 $402,563.20
<br />$432,859.87
<br />$30,296.67
<br />7.5%
<br />Employees Within Range
<br />411 $4,044,962.98
<br />$4,248,473.54
<br />1 $203,510.561
<br />5.0%
<br />Employees Above Maximum
<br />0 $0.00
<br />$0.00
<br />$0.00
<br />#DIV/0!
<br />3: Move to Midpoint if YIP>4
<br /># of Staff Current Salary
<br />Proposed Salary
<br />Difference
<br />% Increase
<br />Totals
<br />45 $4,447,526.18
<br />$4,584,382.50
<br />$136,856.32
<br />3.1%
<br />Employees Below Minimum
<br />4 $402,563.20
<br />$428,520.79
<br />$25,957.59
<br />6.4%
<br />(Employees Within Range
<br />41
<br />$4,044,962.98
<br />$4,155,861.71 1
<br />$110,898.731
<br />2.7%
<br />Employees Above Maximum
<br />0
<br />$0.00
<br />11 $0.00 1
<br />$0.00
<br />r #DIV/0!
<br />
|