How To Calculate The Cost Of Turnover. - XLS Download

Use the attached Excel workbook to calculate the cost of turnover.
Bob Gately
[Login to view]

Dear Bob
Is the multiplier value of .25 based on research findings or based on calculating certain figures
If the latter then how is the value obtained
Also line 7- how can that be interpreted in terms of calculations
Expecting an enlightening reply
Thanks
Ann

Hello Ann:
>How is the multiplier derived in line 4- is it a random number or is there a formula to arrive at the multiplier figure of .25 <
The multiplier is 1.25 for employees who have annual pay rates between US$20,000 and US$40,000.
>Is the multiplier value of .25 based on research findings or based on calculating certain figures If the latter then how is the value obtained <
From users of the Bliss-Gately Tool Excel workbook which allows users to calculate the cost of replacing an employee. The Bliss-Gately Tool is not a free workbook however.
>Also line 7- how can that be interpreted in terms of calculations<
It is a rough estimate of the cost for a US employer to use our method of hiring for talent.
Bob Gately
[Login to view]

hi Bob,
the calculator is a very promising tool. the only thing thats got me is what does W2 in line 9 stand for? im based in india and im sure we have a similar factor but just not called W2.
also, will the tracker work just the same if i were to convert the values into rupees or do i have to make a few changes to the formulae as well?
regards,
Akil

Very Much Useful,,
Thank You for the Information,,,,,,
Kindly click on the following link, it will give you some required information,
https://www.citehr.com/search_new.ph...over&submit=Go

Hello Akil:

>the calculator is a very promising tool.<

Thanks, it is based on the Bliss-Gately Tool which is an Excel workbook I developed from the article by Bill Bliss, my co-author, entitled "The Cost of Turnover." We were going to give the workbook away but it took so much of my time that I decided to sell it instead. We have been told it is the best method to use to calculate the cost of replacing employees by name.

>the only thing thats got me is what does W2 in line 9 stand for? im based in india and im sure we have a similar factor but just not called W2.<

I apologize for taking so long to answer your question but I thought I had. Perhaps I did in another thread.

W2s are the forms employers in the US mail to their current and former employees that states their income and taxes paid in the preceding tax year so that the recipients can complete their tax forms. Managers are often surprised to learn how many people were on the payroll during the previous tax year. It can be an eye opener.

>also, will the tracker work just the same if i were to convert the values into rupees or do i have to make a few changes to the formulae as well?<

That is an excellent question. Please send me an email next week to give me some time to think about it.

Bob Gately

[Login to view]

hi bob,
thanks for reverting.
i tried putting in values in rupees into the calculator. i got numbers and values that look pretty realistic. all i need to do now is compare last years cost of turnover as calculated by the company using their methods and then compare the results to the results i've reached.
the calculator is an amazing tool in a number of ways. it not only simplifies the whole calculation process but is faster than the traditional methods used. i just need to know how accurate it proves to be when the values are in rupees.
ill send you a mail next week nevertheless.
regards,
akil