HR & Compensation Consultant | Pay Negotiation Coach | Board Member | Speaker
Aging Salary Survey Data When you purchase salary survey data, the data is a snapshot in time and has an effective date. But you want to use the data to create salary ranges for the next year. So, that means you need to age the data to align it to the next year. In other words, aging the survey results accounts for the time between when the data was collected and the date you want to apply the data. These days we have software that does this for us. But I have had conversations with employer clients lately about how you do this in Excel. So, here is an example: STEP 1 – Determine the effective date of the salary survey data. STEP 2 – Determine what date you want to age the data to in the next year. STEP 3 – Calculate how many months are between these two dates. STEP 4 – Determine what annual aging factor percentage to use. There are several factors to consider. See the image associated with this post. STEP 5 – Calculate the aging factor for the number of months between the two dates. STEP 6 & 7 – Use the aging factor to calculate the aged base salary and total cash compensation (TCC). Then you use the aged data to update your base salary ranges associated with pay grades. And you use it to update your target bonus percentages and target sales commissions. And if you need help, send me a message. What if you don’t age your salary survey data? You will be using numbers that aren’t aligned to the next year. You will be providing base salary ranges and target incentives that are lower than what is considered competitive. https://lnkd.in/gdSEFcVP #pay #rewards #compensation #hr #humanresources #payequity #paytransparency #paygrades #agingsurveydata #surveydata #salarysurveys #salaryranges #basepay #incentives #variablepay
Jerry Ong
11mo
Thank you for Denise Liebetrau, MBA, CDI.D, CCP, GRP for sharing. The days of lead-lag philosophy always spark a good discussion. Most companies would have a 6 months lead, 6 months lag in terms of aging - a happy medium between costs and staying competitive.
Olivia Steelman, STA
11mo
Denise Liebetrau, MBA, CDI.D, CCP, GRP you have the best posts! I love your approach to educating others and am grateful for your thoughts in these posts - thank you!
Rachel Gibbs
11mo
Denise Liebetrau, MBA, CDI.D, CCP, GRP Great tip, thanks for sharing.
Helping you find Salary Data for your Pay Transparency needs!
11moI think people aging data can be beneficial for short-term guidance, it always makes me nervous when people tell me they've been aging a survey for years though. I personally feel like 1 year is ok, more than that... I'd start adding additional resources and checking around.