Convert to Excel formula

New Contributor

Good day.

 

Asking for help on how to transfer this to excel formula the Employee Turnover .

Please see attached file.

 

TURNOVER.png

 

thanks and advance

3 Replies

@Dhagz2340 Not sure that 10 employees, 50% resignations and $5/hr is enough to calculate the "annual cost of employee turnover". I assume that the calculator includes some assumptions on cost of recruitment, lost productivity etc.

 

What answers do you get when you move the slider step by step from 100% to 10%? And what happens when you leave the slider at 50% but use hourly wages from, for example, $1 to $20. Perhaps, then you can work out the underlying formula.

@Dhagz2340 

Here are two additional files fast from the internet...you could use as a template.
As Mr. Riny_van_Eekelen informed, several factors are needed to calculate the correct Employee Turnoverrate.

 

Links of the inserted files

Excel Employee Turnover Cost Calculator

SWPP STAFFSMART CALCULATOR

Standard disclaimer: there are none Microsoft sites

 

NikolinoDE

Thank you so much .. I will check