Base Salary
Factor 1.05
COLA 1.02
New Base
LAST NAME FIRST DEPT POSITION DOH GENDER PERF POINTS GRADE STEP SALARY SALARY+COLA
Adler David Oper Prog 11/14/2012 M 2 407 16 4 $ $
Benishay Edward Mech Eng Sr Engr 3/16/2008 M 5 580 17 6 $ $
Branch Nicole Chem Eng Engr II 7/12/2011 M 4 464 17 5 $ $ STEP 14 15 16 17 18 19 20 21
Brittain John Elec Eng Cnsltant 5/14/2012 M 4 540 16 5 $ $ 1 $ $ $ $ $ $ $ $
Brosky Beth Chem Eng Qual Cntr 2/1/2006 F 3 477 16 5 $ $ 2 $ $ $ $ $ $ $ $
Brown Jennifer Elec Eng Cnsltant 11/16/2006 M 4 540 16 2 $ $ 3 $ $ $ $ $ $ $ $
Brown John Chem Eng Engr II 2/17/2012 M 4 464 15 5 $ $ 4 $ $ $ $ $ $ $ $
Cage Danielle MIS Sr. Anal 3/27/2009 M 4 459 15 1 $ $ 5 $ $ $ $ $ $ $ $
Capelli Francesca Oper Manager 1/17/2007 M 4 635 18 2 $ $ 6 $ $ $ $ $ $ $ $
Cyert Andrew Elec Eng Engr I 8/21/2012 M 3 453 15 4 $ $ 7 $ $ $ $ $ $ $ $
Dabrowski Richard Elec Eng Cnsltant 7/12/2008 M 4 540 16 3 $ $ 8 $ $ $ $ $ $ $ $
Dabrowski Michael Mech Eng Engr II 12/23/2012 M 5 464 16 3 $ $ GRADE
Deasy Richard Contr Analyst 8/17/2011 M 2 485 15 5 $ $ MIDPOINTS
Dyl David Chem Eng Engr II 6/14/2012 M 5 464 15 4 $ $
Edmister Brenda Elec Eng Sr Engr 9/27/2009 F 3 580 16 1 $ $
Eisenbeis Daniel Chem Eng Engr II 2/2/2007 M 5 464 16 5 $ $
Elton Robert Oper Manager 3/17/2007 M 4 635 18 1 $ $ 14 15 16 17 18 19 20 21
Fischer Paul Elec Eng Manager 12/23/2008 M 4 625 18 5 $ $ POINTS FROM JOB EVALUATION:
Freeman Anne MIS Prog 4/12/2010 F 4 407 14 6 $ $ MIN ======> 400 450 500 550 600 650 700 750
Glynn Janet MIS Manager 6/23/2011 F 3 642 18 3 $ $ MAX ======> 449 499 549 599 649 699 749 799
TOTAL SALARY $0.00
SALARY+COLA $0.00
COLA COSTS
r = (CORRELATION COEFFICIENT)
COSTS OF SALARY INCREASES
CORRELATION BETWEEN POINTS AND GRADES
SALARY GRADE
SALARY GRADE
VLOOKUP TABLE FOR SALARY GRADES AND STEPS
MANAGING COMPENSATION COSTS AT ORCHID ENGINEERING
EMPLOYEES – GRADES 14-21
BASE SALARY, FACTOR, AND COLA