Blogs

Determining an Accurate Labor Cost Projection Budget

MedWrench Guru, Tony Cody, Technology Management Director at Banner Health, shares his approach at giving your finance department an accurate labor cost projection budget.

Wed Jul 03 2019By Tony Cody

I used the previous historical data pulled from Kronos Workforce Central in order to estimate the FTE requirements and ultimately, the labor costs. 

Here is a high-level look:
  • Estimate your salary employees (easy and it is a good way to check a box) by adding the average raise and prorating as appropriate to when it would be active.
  • Calculate each employee’s hours earned at regular time (PTO included).  Any excess over 2080 hours, add the ratio of hours to 2080.  Jury duty and bereavement are difficult to account as repeatable, but if you see a trend overall, then account for it. 
 E.g.  Employee X was compensated 2120 hours at regular pay.  1(full time employee starts at 1) + (40/2080) = 1.02 FTE so far 

  • Add all overtime hours.  Use to (ratio of overtime to 2080) * 1.5 (Overtime compensation rate).  Add to previously derived number.
 E.g. Employee X performed 120 hours of overtime. (120/2080) * 1.5 = .06.   1.02 + .06 = 1.08 FTE 

  • If you need to calculate likely salary cost, then multiply by (1 + the prorated expected raise percentage.  Multiply this by the expected FTE calculations.  The answer will give you multiplier for the current year’s base salary
 E.g. Employee X is exceeding expectations.  Historical data suggests a 3% raise.  It will be effective starting the beginning of the second quarter of the year.  1 + (.75 * .03) = 1.0225 * 1.08 = 1.1 the base salary of current year 

  • Complete the previous steps for all hourly employees.
  • Estimate any promotions that may take into effect the next year
  • Carry over on-call pay from previous year

Every system is different.  Some have double time considerations, and some calculate FTE requirements with adjustment for overtime rates. Using these principles and considering all of the factors, you should be able to accurately predict your next year’s salary budget. This may also be helpful if you are studying for the Certified Healthcare Technology Management test.


This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Please review our Privacy Policy for more details.
I Agree