Це відео не доступне.
Перепрошуємо.
How to Build a Salary Structure with Simple Regressed Midpoints
- Додати в
- Мій плейлист
- Переглянути пізніше
- Поділитися
Поділитися
Вставка
Розмір відео:
- Опубліковано 16 сер 2024
КОМЕНТАРІ • 28
Наступне
Автоматичне відтворення
Worksheet ExplanationASEAN Total Rewards Institute (ATRI)
Переглядів 2,7 тис.
How to Build a Salary Structure with simple Market MidpointsASEAN Total Rewards Institute (ATRI)
Переглядів 36 тис.
How to Create a Merit Matrix for Salary Increase with Goal Seek FunctionCaripros HR Analytics
Переглядів 45 тис.
Обман ради папы #юмор #топКостя Павлов
Переглядів 3,8 млн
Шеф, все пропало. У пропагандистів РФ істерика через F-16Факти тижня
Переглядів 578 тис.
СТАСЯ МАКЄЄВА: СЕРДЮЧКА на гендер паті. Тато ЗРАДЖУВАВ, коли мама хворіла на РАК. Коли українською?Okay Eva
Переглядів 471 тис.
🤯 ЗДУРІТИ!🔺КУРСЬК: куди дійшли ЗСУ? 🦾 Наступ на Росію ЗВІЛЬНИТЬ Донбас? Новини від ЯніниYanina Sokolova
Переглядів 590 тис.
Job Evaluation And Grading: How Many Grades?The HR Hub
Переглядів 9 тис.
Salary Structure Explained with Example - Create your own in less than 5 minutesIndzara - Simple and Effective Templates
Переглядів 39 тис.
This is how I ACTUALLY analyze data using ExcelMo Chen
Переглядів 143 тис.
Excel for HR: Salary Structure Floating Bar Chart with Employee DataCaripros HR Analytics
Переглядів 61 тис.
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)MyOnlineTrainingHub
Переглядів 245 тис.
Conducting Job Evaluation: Job SIZEThe HR Hub
Переглядів 5 тис.
How to Build a Dynamic Calendar in Google SheetsSpreadsheet Life
Переглядів 35 тис.
How to Make a Monthly Budget Excel Spreadsheet | Cashflow, Income, Fixed and Variable ExpensesJopa Excel
Переглядів 258 тис.
How To Create A Pay Structure From ScratchSegun Akiode
Переглядів 20 тис.
🤯 ЗДУРІТИ!🔺КУРСЬК: куди дійшли ЗСУ? 🦾 Наступ на Росію ЗВІЛЬНИТЬ Донбас? Новини від ЯніниYanina Sokolova
Переглядів 590 тис.
Я тоже так могуDouble Bubble
Переглядів 2,3 млн
В ДЕТСТВЕ ОТПРАШИВАЕШЬСЯ НА РЕЧКУ У МАМЫSIDELNIKOVVV
Переглядів 3,7 млн
"СВО” довела РОССИЮ! УРА-патриоты ПРИУНЫЛИ! Гражданская оборона 2024 - 30 полный выпускТелеканал ICTV
Переглядів 1,9 млн
Running With Bigger And Bigger FeastablesMrBeast
Переглядів 54 млн
РЕЙНДЖЕРС - ДИНАМО | Ліга Чемпіонів. Кваліфікація Q3 | 13.08.2024ФК «Динамо» Київ
Переглядів 334 тис.
Перші думки батьків, коли дізнались про важке поранення сина #війна #україна #зсу #люди #shortsСуспільне Чернігів
Переглядів 160 тис.
This is awesome - simple and easy to understand. I just learnt a new way to regress midpoints in a pay structure design. Thanks!
Cool. Yes it's really simple.
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?
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
Go to www.my-ATRI.com and look at the competency framework.
Thank you very very much!!!
Hi Bui, you are most welcome!
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 UA-cam..). 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?
thank you very much!
You are welcome sir!
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?
That is a good first step. Look for natural levels as you group together similar jobs
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
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.
@@ATRI_Total_Rewards Thank you and God bless
Can we get the working sample excel file? Looks good
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!
How do you manage the midpoint differential, i.e. increase or reduce
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%.
Should the midpoint regression be equal at all grades/levels or it can be progressive?
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.
Hey there. I think I missed something. Could you please tell me where the 0.8 and 1.2 came from?
Never mind I figured it out. This is the 40% range for the known midpoint. I got it now.
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?
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.
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.