Question: Use the worksheet from the website to construct a merit matrix. The objective is to reward outstanding performers more than those who exceed expectations and


Use the worksheet from the website to construct a merit matrix. The objective is to reward outstanding performers more than those who exceed expectations and both of these groups more than those employees who meet expectations. Overall merit pool for the company this year is 3%. Use a bottom third, middle third, and top third of position into range to develop the matrix. For example: POSITION INTO RANGE + Outstanding-4% Exceeds- 21% Meets- 74% Does Not meet- 1% Bottom 1/3-22% Recommended % Recommended % Recommended % Recommended % Middle 1/3-52% Recommended % Recommended % Recommended % Recommended % Top 1/3-26% Recommended % Recommended % Recommended % Recommended % Use a single percentage for each of the cells in the matrix rather than a range. Remember that you will need to determine the % of employees in each of the performance rating categories as well as the range penetration. You may need to manipulate the recommended percentages to reach the merit pool of 3%. If someone is below their range count them in the bottom third, if someone is above their range, for purpose of this exercise, count them in the top 1/3. !st third 2nd third 3rd third thirds Salary Salary range 45,000.00 32000 - 52000 45,192.00 32000 - 52000 45,336.00 32000 - 52000 45,408.00 32000 - 52000 45,420.00 32000 - 52000 46,008.00 32000 - 52000 46,008.00 32000 - 52000 46,200.00 32000 - 52000 46,200.00 32000 - 52000 46,200.00 32000 - 52000 46,356.00 32000 - 52000 54,000.00 32000 - 52000 44,004.00 37000 - 61500 44,868.00 37000 - 61500 45,144.00 37000 - 61500 45,360.00 37000 - 61500 45,780.00 37000 - 61500 45,900.00 37000 - 61500 46,116.00 37000 - 61500 46,200.00 37000 - 61500 46,200.00 37000 - 61500 Salary Band 42 42 42 42 42 42 42 42 42 42 42 42 44 44 44 44 44 44 44 44 44 Perf Appraisal 09 Job Title outstanding Engineering Associate meets Engineering Associate needs development Engineering Associate meets Engineering Associate meets Engineering Associate meets Engineering Associate meets Engineering Associate meets Methods Engrg Assoc meets Methods Engrg Assoc outstanding Methods Engrg Assoc meets Engineering Associate meets Engineering Associate meets Engineer meets Engineer meets Engineer meets Engineer meets Engineer meets Engineer meets Engineer meets Methods Engineer meets Methods Engineer Use the worksheet from the website to construct a merit matrix. The objective is to reward outstanding performers more than those who exceed expectations and both of these groups more than those employees who meet expectations. Overall merit pool for the company this year is 3%. Use a bottom third, middle third, and top third of position into range to develop the matrix. For example: POSITION INTO RANGE + Outstanding-4% Exceeds- 21% Meets- 74% Does Not meet- 1% Bottom 1/3-22% Recommended % Recommended % Recommended % Recommended % Middle 1/3-52% Recommended % Recommended % Recommended % Recommended % Top 1/3-26% Recommended % Recommended % Recommended % Recommended % Use a single percentage for each of the cells in the matrix rather than a range. Remember that you will need to determine the % of employees in each of the performance rating categories as well as the range penetration. You may need to manipulate the recommended percentages to reach the merit pool of 3%. If someone is below their range count them in the bottom third, if someone is above their range, for purpose of this exercise, count them in the top 1/3. !st third 2nd third 3rd third thirds Salary Salary range 45,000.00 32000 - 52000 45,192.00 32000 - 52000 45,336.00 32000 - 52000 45,408.00 32000 - 52000 45,420.00 32000 - 52000 46,008.00 32000 - 52000 46,008.00 32000 - 52000 46,200.00 32000 - 52000 46,200.00 32000 - 52000 46,200.00 32000 - 52000 46,356.00 32000 - 52000 54,000.00 32000 - 52000 44,004.00 37000 - 61500 44,868.00 37000 - 61500 45,144.00 37000 - 61500 45,360.00 37000 - 61500 45,780.00 37000 - 61500 45,900.00 37000 - 61500 46,116.00 37000 - 61500 46,200.00 37000 - 61500 46,200.00 37000 - 61500 Salary Band 42 42 42 42 42 42 42 42 42 42 42 42 44 44 44 44 44 44 44 44 44 Perf Appraisal 09 Job Title outstanding Engineering Associate meets Engineering Associate needs development Engineering Associate meets Engineering Associate meets Engineering Associate meets Engineering Associate meets Engineering Associate meets Methods Engrg Assoc meets Methods Engrg Assoc outstanding Methods Engrg Assoc meets Engineering Associate meets Engineering Associate meets Engineer meets Engineer meets Engineer meets Engineer meets Engineer meets Engineer meets Engineer meets Methods Engineer meets Methods Engineer
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
