Attrition Formula | Monthly Attrition | YTD Attrition | Annualized Attrition | Turnover

[@m.danish4996]

Thank you very much. It's very helpful to understand easily these formulas.

[@MrSaichandp]

Thank you so much for making this video and it is very helpful. Could you let me know how to differentiate the voluntary and involuntary attritions.

[@harishbabubm]

Really great help and very simple explanation. Which helped me to understand better

[@yf9anoopvi]

What is the different between YTD and annualized attrition

[@vsujanichowdary5893]

Please show the Attendance calculation

[@AtulKumar-hp1ip]

Excellent as per me

[@radhakrishna12377]

So helpful is this

[@yagneshwarsoma2974]

Why in YTD Attrition the Calculation of Avg Eemployees is Different from Monthly?

[@radhakrishna12377]

Tis is helpful

[@shamimalam100]

What is rolling attrition?

[@Cutiefunnyvid]

Annualised attrition is for the whole year but you hve calculated till May only... Pls clarify

[@pawangola166]

Hi ma'am for calculating opening head count of January 23 do we have to consider those employees also who are a part of organisation from suppose 2017?

[@8228bobby]

Active head count as on 1st is the opening headcount

[@aryanarayanan8379]

Ty so much

[@yf9anoopvi]

Do you have any hr report or ppt to showing management..pla make vdo on this...

[@radhakrishna12377]

Sure, I will make one video on HR Dashboard which you can present to management on monthly basis.

[@mehboobshaikh9997]

What is the use of 100

[@mukeshrhoni7557]

😎thanks

[@shrinivaspagadkattlu7407]

Multipying by 100 ?

[@yf9anoopvi]

And what is different between ytd and annualized

[@radhakrishna12377]

YTD attrition means attrition till date e.g if you are calculating attrition in the month of Sept so YTD attrition means attrition from Jan to sept and annualised means if you go by same rate of attrition what will be the attrition at the end of year i.e Dec

[@nguyentruongphuoc2060]

@@radhakrishna12377 So it means the annualized number is the forecast ?

[@radhakrishna12377]

@@nguyentruongphuoc2060 Yes, annualized number is forecast

[@shabarivasan4566]

is it wrong if we calculate like the head count on January 1st and take the head count as of December 31 st and average it. Annual attrition%= Total number of employees left in the year ________________________ Avg HC of the employee*100 can we use this

[@radhakrishna12377]

Yes

[@bluejeans706]

Thank you for the video. On the YTD Attrition can you please explain what the purpose of multiplying by 100 does? If I take 180/2980 that equals .0604 (6.4%). But using your formula 180*100 / 2980 I would get 604%.

[@radhakrishna12377]

Dear Blue Jeans, if we multiple attrition formula with 100. it give us value in percentage. And if calculate (180*100)/2980 = 6.04% not 604%

[@bluejeans706]

@@radhakrishna12377 Thanks for the reply. I guess you are looking at it from a display aspect versus actual formatted number. While yes, unformatted your formula results in 6.04. But that to translates 604% when formatted as %. However, if you don't multiply by 100, you get 0.0604, which formatted as % is 6.04% (oop-had typo in original post).

[@radhakrishna12377]

@@bluejeans706 Dear Blue Jeans, When you are formatted as % then no need to multiple it with 100.

[@shrinivaspagadkattlu7407]

Oh got it mam

[@rupindermalhotra912]

Hi, Will it be correct to consider closing HC of the previous month as opening HC of the new month?

[@radhakrishna12377]

Best practice is to consider the 1st date of month as the start head count reason being if there is a new hire on 1st date of month u'll not miss the information.

[@poojajain8312]

Why there is need of calculation of annualised attrition when we are calculating yearly attrition. Like both are the same thing?

[@oh_and_mee]

Not same. Annualised means you extrapolate the result of a particular period to a year's period for reporting purpose and comparison. Annualised attrition is not an actual attrition for that year, it is rather a guesswork based on a shorter period. Whereas Yearly Attrition is taken on actual figures.

[@Reply1990]

Start head count as on 1 will include 1st May joiner ? Also 31st May will include the exit of 31st May ??

[@radhakrishna12377]

Yes, Start Head count as on 1st May will include 1st May joiners and 31st may will exclude the exit cases of 31st may. In short , we need Head report as on date. i hope it clarify your doubt.please let know if you need any further clarification and sorry for late reply actually there is some issue with my account.

[@aryanarayanan8379]

@@radhakrishna12377 If we retained people'on 31st then

[@radhakrishna12377]

@@aryanarayanan8379 considered it as a headcount

[@aparnapradeep8094]

lets say i have 5 attrition's from October 2019 to July 2020 and my average employee size is 20 if i calculate YTD = (5*100)/20=25% Is this correct am not sure???

[@radhakrishna12377]

Sorry to say but this is incorrect way of calculating YTD attrition. Reference point is very important when you calculate YTD attrition. so, in this case you have to take Jan'19 to Dec'19 vs Jan'20 to till date. i'll post video for YOY attrition....we can refer that for details.

[@hiteshdangodra6440]

Please help how to calculate attrtion in pivot table

[@pawangola166]

You can use the calculated fields

[@xzonia1]

I'm so lost watching this because you don't explain where you get your numbers from. You say on monthly attrition for May that you start with 3000 employees and end with 3010, so clearly you lost 10 employees, yet you say your number of employees left in May is 40 and never explain how you got 40. Where does that 40 come from? Then for YTD you say your number of employees left till date is 180, but you never explain how to calculate that 180 or where you got it from (what does that number mean?). You just keep saying it's the total number of employees left from Jan 1 to May 31, but how do you calculate that? You don't show your math, and I'm just lost on watching this. It seems like these formulas would be good, but you leave out so much. Please explain more.