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 DTDeptTimeStamp (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.
Retrieving data ...