No Tags Found!


Dear All, I hope my attachment will help you in calculating Employee Turnover. The figures are inserted manually after a deep study of various micro factors involved in it. The Microsoft Word file with the name "Calculation of Employee Turnover" will brief you on how the factors are calculated and the final values are inserted in the Excel Sheet. I have prepared it based on my own experience as I have been working as an HR Manager in an organization for the past 2 years.

Please go through it, and your feedback and comments are most welcome as they will help update my knowledge.

Regards,
Amrita Virdi.

From India, Pune
Attached Files (Download Requires Membership)
File Type: xls EMPLOYEE TURNOVER CALCULATOR.xls (21.0 KB, 3980 views)
File Type: doc Calculation of Employee Turnover.doc (32.0 KB, 2104 views)

Acknowledge(1)
Amend(0)

Thank you so much for your valuable attachments; they assisted me a lot with my thesis. You have indicated detailed factors 

Question Regarding Estimated Revenue Lost by Vacant Position

I just have a question regarding the Estimated Revenue Lost by Vacant Position ($225,000) in the Excel sheet. Shouldn't it be included in the total costs per single employee? So that the sum must be: Total Direct Costs to Hire ($5,000) + Total Indirect Costs to Hire ($44) + Total Direct Costs to Train ($8,000) + Total Indirect Costs to Train ($24,000) + Estimated Revenue Lost by Vacant Position ($225,000) = $262,044.

Please advise on the role of Estimated Revenue Lost by Vacant Position ($225,000) in the calculation. I need your experience, and thank you in advance.

Best Regards

From Lebanon
Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.