HR Management Spreadsheets and Calculators
The calculators provided on this page help you identify problems and solutions, and as a result your organization’s ability to compete.

  • "Compensation mix" is defined as all the components that make up total compensation expressed as a percentage of total compensation. Looking at the mix of compensation helps managers understand what drives total compensation including fixed costs such as salary versus variable costs such as overtime and benefits. Understanding the components can help managers develop strategies for reducing costs.
  • The annual turnover rate calculator has now been replaced with a new, evergreen version that can be used for 2019 and all years thereafter. This new calculator is titled 20XX Turnover Calculator and can be downloaded here or from the 20XX Turnover Calculator page.
  • 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. It will also teach you to enter and compare national turnover data provided by the federal Bureau of Labor Statistics (BLS).
  • Analyzing the mix of benefits helps managers see the big picture of an individual employee's compensation, including fixed costs such as salary and mandated benefits versus variable costs like medical, dental, and other voluntary benefits. Understanding the components can help managers develop strategies for reducing costs.
  • 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 FMLA Intermittent Leave Tracker can be used to assist with tracking employee use of FMLA leave on an intermittent basis. The tracker is based on a rolling calendar year, with an initial leave entitlement based on 12 workweeks of leave for an employee who regularly works a 40 hour week. The beginning balance should be adjusted for employees whose workweeks are not based on a 40-hour schedule.
  • 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.
  • This worksheet can be used by employees and employers to keep track of the days they take off for vacation, sick time, and personal days. Just input the annual number of days for which the employee is eligible in each category at the beginning of each year, then update the worksheet monthly to reflect days taken. The worksheet calculates total days taken on a year-to-date basis, days remaining in the "bank," and flags employees when they have taken more than their allotment.
  • This calculator can help you conduct a cost analysis to determine whether to increase an exempt worker's salary to meet the DOL's applicable minimum salary threshold or to reclassify the exempt worker as non-exempt and, therefore, eligible for overtime wages. With the Department of Labor's recent proposal to increase the salary threshold for overtime exemptions for white collar and highly compensated employees, this tool can help you assess whether to reclassify workers or to increase salaries to the minimum applicable threshold.
  • 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.
  • Turnover is an important metric for human resource professionals. Tracking turnover helps provides information that can be used to address issues before key employees leave the organization.
  • A valuable metric for human resources and management alike, turnover provides information that can be used to identify retention issues before key employees seek other employment.
  • Tracking turnover provides HR with valuable information that can be used to address issues such as compensation, management practices, and workload before key employees seek other employment. Use this worksheet to calculate your monthly, quarterly, and annual turnover rates and compare them to national data. Note: Beginning with 2019, the new 20XX Turnover Calculator can be used for all calculations going forward.
  • 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).
CT-WEB01
Copyright � 2019 Business & Legal Resources. All rights reserved. 800-727-5257
This document was published on http://HR.BLR.com
Document URL: http://hr.blr.com/calculators.aspx