Your job now is to pull together all the inform ation you’ve com pleted so far in class and m ake salary decisions for your team . You have com pleted Cathy’s evaluation and received assignm ent feedback. This is the first year that you’ve m ade salary decisions for this team . Be sure to carefully review the inform ation provided. You m ay sim ply type in the cells as the text will autom atically wrap . You are required to:
1. Enter Cathy’s appraisal rating (she is last on the list);
2. W ithin your budget dollars, m ake your salary decisions based on perform ance for your team taking into consideration their Salary Grade and the Pay
3.
Ranges identified for the Salary Grades (fill in the Salary Decision Colum n);
W ithin your budget dollars award bonus m oney (fill in the Bonus Dollars Colum n);
4.
5.
In the green line areas, provide your substantiation and risk analysis for the salary decisions m ade; and
Identify any item s from this scenario in whole you m ay want to address.
Evaluation ratings are 1 = Needs Im provem ent to 5 = Exceeds Expectations
Salary Budget: $9,000
Bonus Budget: $5,000
Com pany Designated Salary Pay Ranges
A2 = $12,750 – 17,000
A3 = 16,500 – 22,000
A4 = 21,000 – 28,000
Em ployee Inform ation
Salary
Grade
A4
Current
Salary
$27,900
% at Pay
Scale*
99.6%
Appraisal
Rating
5
Salary
Decision
$28,000
Bonus
Dollars
$1,000.00
John is a white m ale, 58YO, with 31 years’ service. John is a good worker and you like him . You don’t want to lose his skills and experience as he’s been talking about retiring, but you realize his skills are too valuable to lose.
Substantiation and Risk Analysis: Although retirem ent is around the corner it is still a consideration and as an asset to the com pany I will com pletely m ax him to show that we appreciate his hard work. The risk is he still m ay consider retirem ent but we want to show that he is a valued em ployee.