0 Replies Latest reply on Sep 6, 2017 7:32 AM by Dan Gordon

    Forecasting Headcount needs based on Unit Volumes

    Dan Gordon

      Hey everyone,

      Has anyone developed a model to forecast nursing coverage needs based on historical patient volumes?  Also taking into account known FMLA, PTO, SICK etc?

      We capture "heads in beds" (volume) every 4 hours.  I have this data by Nursing Unit going back to Jan 2014.  The goal is to predict future staffing needs based on historical patient volume trends.

      Volume fields:
      Occupancy DT
      Dept
      TimeStamp (every 4 hours)
      Volume (patients in bed)

      Then I have the budgeted FY18 Nurse Staffing Ratios.  For sake of this discussion, lets say all units are 5:1 Patients to Nurse.

      Just wondering how others have attacked.