Your job now is to pull together all the information you’ve completed so far in class and make salary decisions for your team. You have completed Cathy’s evaluation and received assignment feedback. This is the first year that you’ve made salary decisions for this team. Be sure to carefully review the information provided. You may simply type in the cells as the text will automatically wrap. You are required to: 1. Enter Cathy’s appraisal rating (she is last on the list); 2. Within your budget dollars, make your salary decisions based on performance for your team taking into consideration their Salary Grade and the Pay Ranges identified for the Salary Grades (fill in the Salary Decision Column); 3. Within your budget dollars award bonus money (fill in the Bonus Dollars Column); 4. In the green line areas, provide your substantiation and risk analysis for the salary decisions made; and 5. Identify any items from this scenario in whole you may want to address.
Evaluation ratings are 1 = Needs Improvement to 5 = Exceeds Expectations
Salary Budget: $9,000
Bonus Budget: $5,000
Company Designated Salary Pay Ranges
A2 = $12,750 – 17,000
A3 = 16,500 – 22,000
A4 = 21,000 – 28,000
|Employee Information |Salary |Current Salary |% at Pay Scale* |Appraisal Rating |Salary Decision |Bonus Dollars |
| |Grade | | | | | |
|Substantiation and Risk Analysis: John is a major asset to the company and the appraisal rating justifies that. His skills and experience may be hard to replace if he decides to retire early. He was given the |
|highest salary decision of 8% which exceeds the company designed salary