This is awesome - simple and easy to understand. I just learnt a new way to regress midpoints in a pay structure design. Thanks!

@ATRI_Total_Rewards

Жыл бұрын

Cool. Yes it's really simple.

thank you very much!

@ATRI_Total_Rewards

2 ай бұрын

You are welcome sir!

Thank you very very much!!!

@ATRI_Total_Rewards

2 ай бұрын

Hi Bui, you are most welcome!

@ATRI_Total_Rewards

26 күн бұрын

Nhu, thank you for your interest in the ATRI community. I am going live with it tomorrow or Wednesday. You joined just a bit early (i forgot I had put the link here in KZread..). My whatsapp is +6590889481. Let's chat there. I want you in the TR Community, but we need to first remove you, then I will send you an invite link. ok?

This is so helpful! Thank you so much! I'm just curious as to the .8 and 1.2 values. What are these numbers and why .8 and 1.2 specifically?

@ATRI_Total_Rewards

2 ай бұрын

The .8 and the 1.2 are used to set the. Salary range width. Salary range x .8 will determine the range minimum. Midpoint x 1.2 will be the range maximum. Companies will manage salaries to stay between minimum and maximum. There is no “correct” salary range width. In some countries, ranges must be wider, such as +/- 30% or more. This model example ises +/- 20%. I hope this helps!

I find your explanations very easy. I would love to build a career in compensation and benefits. Please can you advise on specific excel skills that i can learn? Thanks

@ATRI_Total_Rewards

Ай бұрын

Go to www.my-ATRI.com and look at the competency framework.

How do you manage the midpoint differential, i.e. increase or reduce

@ATRI_Total_Rewards

Ай бұрын

Good question. There is no single correct answer. In the US you can have a consistent midpoint differential (grade to grade change) whereas in hierarchical cultures and developing countries, I generally find it necessary to segment my regression, with a flatter midpoint differential (e.g. 10% grade to grade) in lower grades and a steeper progression in higher grades, such as 20-30%.

What if the company hasn't set up grades/levels yet for their employees/jobs, but you have employee salary and market data? Do you have to create the levels by combining jobs with similar market midpoints?

@ATRI_Total_Rewards

27 күн бұрын

That is a good first step. Look for natural levels as you group together similar jobs

Should the midpoint regression be equal at all grades/levels or it can be progressive?

@ATRI_Total_Rewards

2 ай бұрын

Hello, and apologies for the late reply.. the midpoint regression can vary. I sometimes must create a hockey stick-shaped midpoint progression with 10-15% mid-to-mid differentials in lower grades and higher (like 20-30%) differentials for the upper half. There is some art to structure design.

very interesting. I will need your help. don't really know how to do alot. teach me more please or refer me to an institute where i can learn practical application of HR functions

@ATRI_Total_Rewards

2 ай бұрын

Hello sir. See www.my-atri.com which is the total rewards institute I created. Follow and subscribe because in June I will also introduce a site with online learning content and community for you to meet others eager to learn comp & benefits.

@ifeanyiohaka8097

2 ай бұрын

@@ATRI_Total_Rewards Thank you and God bless

Hey there. I think I missed something. Could you please tell me where the 0.8 and 1.2 came from?

@DMediaInc

2 жыл бұрын

Never mind I figured it out. This is the 40% range for the known midpoint. I got it now.

@ATRI_Total_Rewards

Жыл бұрын

These set the range width. Using .8, the salary range minimum would be 20% below the midpoint, and with 1.2 the max would be 20% above midpoint.

what formula did you use for the job matching?

@ATRI_Total_Rewards

Жыл бұрын

human judgment is needed to select the best match between a company job and a survey job. And it's possible there is no good match. Look for a survey job that is at least 70% the same as a company job, in terms of the nature and level of work.

@Stephanieslinkard

9 ай бұрын

When I've needed to do job matching for positions with no 100% survey equivalent I've combined the two most closely matching to create a hybrid comparison position and taken the average salary data from that new hybrid. All companies may not prefer to do it that way but mine did. When I did that, I made sure to include a footnote that the survey position was a hybrid and that no 100% comparison existed.

Can we get the working sample excel file? Looks good

@ATRI_Total_Rewards

2 ай бұрын

I will make the working sample available very soon through a new ATRI Total Rewards Community site loaded with resources. If you subscribe you will be notified here with the link/QR to the new site. Thanks for your interest!