Merit Based Worksheet Need to fill out a merit based worksheet (in the attached excel document) and then answer the questions in the other document. Full i
Merit Based Worksheet Need to fill out a merit based worksheet (in the attached excel document) and then answer the questions in the other document. Full instructions are all in second attached document. Name
C. Adams
M. Cassler
J. Fromm
L. Glass
R. Nelson
D. Smith
W. Slifco
S. Miller
J. Farago
A. McDole
Position
Payroll Team Lead
Sr. Compensation Specialist
Benefit Specialist
Recruiting Specialist
Front Office Generalist
Training Administrator
HR System Analyst
Business Support Admin.
Recruiting Manager
Payroll Manager
Totals =
Pay Grade
S01
S02
M05
M05
H07
H07
M05
H05
E03
E02
Current
Control
Points
Current
Base Salary
Comparatio
$75,600 $74,000
$86,000 $72,300
$54,900 $52,300
$54,900 $60,300
$41,500 $43,000
$41,500 $36,500
$54,900 $49,500
$34,000 $33,200
$145,000 $147,000
$119,500 $138,600
97.9%
84.1%
95.3%
109.8%
103.6%
88.0%
90.2%
97.6%
101.4%
116.0%
$707,800 $706,700
99.8%
Rating
Planning Assumptions:
– Merit Budget = 3.7%
– Amount available based on the merit budget = $26,148 ($706,700 x 3.7%)
– All employees eligible for 12 month increase
– Pay Grades are a mixture of hourly, professional & management employees
H = hourly, M = professional, S = supervisory, E = executive
– Utilize Merit Guide Chart to plan increases
1
3
2
3
2
3
3
3
3
2
New
Control
Points
Proposed
Merit %
Proposed Proposed New CompaMerit
Base Salary
ratio
Amount
$79,600
$90,600
$57,800
$57,800
$42,500
$42,500
$57,800
$34,900
$152,700
$125,800
$742,000
$0
$0
0.0%
•
•
•
•
As manager of these ten employees you are to complete the following columns:
o Proposed Merit %
o Proposed Merit Amount
o Proposed Base Salary
o New Compa-ratio
At the bottom of the worksheet are the planning assumptions
o You must stay within the merit budget amount
o You must try to use all the merit budget amount
Below is the Merit Planning Guide Chart
o You must stay within the percentages provided for each quartile
Calculations required to complete this exercise:
o Proposed Merit Amount (Current Base Salary x Proposed Merit %)
o Proposed Base Salary (Current Base Salary + Proposed Merit Amount)
o New Compa-ratio (Proposed Base Salary / New Control Point)
o Totals for Proposed Merit Amount, Proposed Base Salary & New Compa-ratio
1.
2.
3.
4.
5.
6.
7.
8.
Explain how you started the exercise?
How did you approach the outstanding & exceeds employees?
Did you notice that some compa-ratios went down after the increases? Why?
What was the most difficult part of the exercise?
What would make merit planning less of a challenge?
What would happen if some employees did not get a full 12 months of merit increase?
What procedure might be used if an employee reaches the range maximum?
What are your thoughts on giving lower increases to better performers in the upper
quartiles?
Purchase answer to see full
attachment
