A Global Protech Case Study

GlobalProtechTurnoverCalculations.xlsx

Formulas

Global Protech Turnover Calculations
Formulas:	1	Divide # terminations by # employees (if given for a year)
	2	If annual cash compensation not given, multiply hourly rate by 2,080; weekly by 52; monthly by 12. If paid every 2 weeks, multiply by 26; if paid twice a month, multiply by 24.
	3	Multiply Cost of Benefits % by annual salary
	4	Add Annual salary and Benefit Cost to get Total Compensation
	5	Multiply Total Compensation by "Turnover Cost as a %
	6	Multiply Turnover Cost Per Employee by # of Terminations

CALL CENTER REPRESENTATIVES			Turnover % 1	Annual Cash Compensation per Employee 2	Benefit Cost Per Employee 3	Total Compensation Per Employee 4	Turnover Cost Per Employee 5	Total Turnover $ 6
Employees	250
Terminations	85
Average Wage Rate	$15.50	hour
Cost of Benefits as a %	28%
Turnover Cost as a %	33%
ACCOUNTANTS			Turnover % 1	Annual Salary per Employee 2	Benefit Cost Per Employee 3	Total Compensation Per Employee 4	Turnover Cost Per Employee 5	Total Turnover $ 6
Employees	50
Terminations	18
Average Wage Rate	$5,500	month
Cost of Benefits as a %	30%
Turnover Cost as a %	100%
VP OF MARKETING			Turnover % 1	Annual Salary per Employee 2	Benefit Cost Per Employee 3	Total Compensation Per Employee 4	Turnover Cost Per Employee 5	Total Turnover $ 6
Employees	5
Terminations	2
Average Wage Rate	$9,500	month
Cost of Benefits as a %	40%
Turnover Cost as a %	350%
TOTAL - Total turnover amount for the three rows of calculations, above.