Calculators
The Human Resources function is evolving and there is less emphasis on the transactional side of HR, e.g., payroll, benefits administration, and more emphasis on the strategic role HR professionals can play in the organization. Using business tools such as the calculators provided on this page can help the HR professional identify problems and solutions, and as a result increase the organization’s ability to compete.
We would appreciate your feedback on the calculators.
Let us know what you like, don’t like, and what you would like to see more of. At the end of each data entry section is a link to an e-mail page where you can send us your comments and suggestions.
Microsoft Excel Calculator Documents
Turnover is an important metric for the HR department to measure. This worksheet will calculate monthly, quarterly, and annual turnover rates based on data you input. You will then be able to print a report with the calculation and graphs showing monthly and quarterly turnover compared to national data provided by the federal Bureau of Labor Statistics (BLS).
Turnover is an important metric for the HR department to measure. This worksheet will calculate monthly, quarterly, and annual turnover rates based on data you input. You will then be able to print a report with the calculation and graphs showing monthly and quarterly turnover compared to national data provided by the federal Bureau of Labor Statistics (BLS).
Turnover is an important metric for the HR department to measure. This worksheet will calculate monthly, quarterly, and annual turnover rates based on data you input. You will then be able to print a report with the calculation and graphs showing monthly and quarterly turnover compared to national data provided by the federal Bureau of Labor Statistics (BLS).
In order to measure the effectiveness and efficiency of the recruiting function, many employers calculate the cost per hire. Cost per hire is calculated by adding up all of the expenses associated with recruiting and then dividing that amount by the number of new hires during the period.
This worksheet can be used to calculate total labor costs per employee by month and full year, and also for a 10-year period.
This confidential form should be the basis for a meaningful, two-way discussion with the employee. The ensuing performance discussion can be most successful when the report is thoughtfully and accurately completed.
This calculator can be used to calculate pretax profit per employee by month and for the full year, and also to calculate the pretax profit per employee for a 10-year period.
This calculator can be used to calculate revenue per employee by month and for the full year, and also to calculate the revenue per employee for a 10-year period.
The HR staff ratio and operating expense ratio are two commonly used metrics designed to measure the effectiveness of the human resources department. This worksheet will provide you with a report, based on your input, showing monthly and annual ratios.
One important element in measuring the efficiency and effectiveness of the recruiting function is to measure the time it takes to fill a vacancy. The longer a position remains vacant, the greater the disruption to productivity. This worksheet calculates the number of days from the time the recruiting department receives a job requisition to the date an applicant accepts an offer for the position.
Calculating the cost of turnover will help the company and individual managers understand the cost of losing and replacing key employees. This worksheet will calculate the cost of turnover for a single vacancy.
This worksheet will calculate the annual turnover rate for employees during their first year of employment. Voluntary terminations are employees who left the company by choice, while involuntary terminations are employees who were asked to leave because of poor performance, misconduct, or job elimination.
This worksheet will calculate the annual turnover rate for employees whose performance is above average. Voluntary terminations are employees who left the company by choice, while involuntary terminations are employees who were asked to leave because of poor performance, misconduct, or job elimination.
This worksheet can be used by employees to keep track of the hours they work each day. In addition, this worksheet gives employees the ability to track leave or sick time used each day and calculates an estimate of the employee's gross pay (wages before taxes and other deductions each week).