Case Article—Developing Data-Driven 24/7 Nurse Staffing and Shift Scheduling Plans

This case study offers a comprehensive hands-on approach to addressing hospital workforce planning challenges by integrating demand forecasting errors into mathematical programming. Structured around two interconnected projects—refined over a decade of experience—students develop data-driven 24/7 nurse staffing and shift scheduling plans that ensure continuous coverage while balancing cost, service quality, operational constraints, and nurse satisfaction. By employing time-series models to predict hourly patient volumes and integrating these forecasts into integer programming models, the case demonstrates how to construct 24/7 coverage matrices and incorporate auxiliary variables that allow for controlled deviations in staffing levels and service delays due to forecasting errors. Emphasizing multiobjective optimization and Pareto frontier analysis, the case effectively evaluates tradeoffs between overstaffing and understaffing. Designed for both undergraduate and graduate courses in healthcare management science or operations research, this case bridges theoretical concepts with real-world applications, thereby enhancing educators’ ability to deliver effective decision-making training in healthcare operations. Funding: This work was supported by the Division of Civil, Mechanical and Manufacturing Innovation [Grant CMMI-0928936]. Supplemental Material: The Teaching Note and supplemental material are available at https://www.informs.org/Publications/Subscribe/Access-Restricted-Materials .

Authors

Institutions

Publication Details

Journal
INFORMS Transactions on Education
Published
2026-04-29
DOI
https://doi.org/10.1287/ited.2025.0139ca
Primary Topic
Scheduling and Timetabling Solutions
Type
article
Field-Weighted Citation Impact
0.00
Controls
|||
ALL TIME
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
article

Case Article—Developing Data-Driven 24/7 Nurse Staffing and Shift Scheduling Plans

Sanjay Mehrotra, Akhil Singla, Jiaqi Lei
INFORMS Transactions on Education
Scheduling and Timetabling Solutions
article

Case Article—Developing Data-Driven 24/7 Nurse Staffing and Shift Scheduling Plans

Sanjay Mehrotra, Akhil Singla, Jiaqi Lei
article en

Abstract

This case study offers a comprehensive hands-on approach to addressing hospital workforce planning challenges by integrating demand forecasting errors into mathematical programming. Structured around two interconnected projects—refined over a decade of experience—students develop data-driven 24/7 nurse staffing and shift scheduling plans that ensure continuous coverage while balancing cost, service quality, operational constraints, and nurse satisfaction. By employing time-series models to predict hourly patient volumes and integrating these forecasts into integer programming models, the case demonstrates how to construct 24/7 coverage matrices and incorporate auxiliary variables that allow for controlled deviations in staffing levels and service delays due to forecasting errors. Emphasizing multiobjective optimization and Pareto frontier analysis, the case effectively evaluates tradeoffs between overstaffing and understaffing. Designed for both undergraduate and graduate courses in healthcare management science or operations research, this case bridges theoretical concepts with real-world applications, thereby enhancing educators’ ability to deliver effective decision-making training in healthcare operations. Funding: This work was supported by the Division of Civil, Mechanical and Manufacturing Innovation [Grant CMMI-0928936]. Supplemental Material: The Teaching Note and supplemental material are available at https://www.informs.org/Publications/Subscribe/Access-Restricted-Materials .

INFORMS Transactions on Education
Northwestern University (US)
Industry, innovation and infrastructure
Openalex Percentile: Top 6%
Scheduling and Timetabling Solutions
AI Navigator

Ask Laika to Summarize, Analyze, and Connect papers live on the map.

Summarize Papers & Methodologies

Extract key findings, datasets, and comparative methods across publications.

Benchmark Rankings & Visual Analytics

Rank top research institutions, authors, funders, topics, and journals by Field-Weighted Citation Impact (FWCI) and paper volume with instant charts.

Connect Distant Disciplines

Bridge topological clusters on the map to find hidden collaborative intersections.