Prescriptive Analytics for a Multi-Shift Staffing Problem

43 Pages Posted: 2 Feb 2020 Last revised: 29 Jul 2020

See all articles by Pascal M. Notz

Pascal M. Notz

University of Würzburg - Business Administration & Economics

Peter K. Wolf

University of Würzburg - Business Administration & Economics

Richard Pibernik

University of Würzburg - Business Administration & Economics

Date Written: July 27, 2020

Abstract

Motivated by the work with a leading maintenance service provider in the aviation
industry, this paper examines novel data-driven approaches to solving a certain
type of capacity-sizing problem—the multi-shift staffing problem—with uncertain,
time varying arrival rates and patient "customers" that do not abandon the queue
while waiting for a service, but who must be served by a pre-defined time. Drawing
on established methods in both capacity management and prescriptive analytics, we
propose to use fluid and stationary approximations to apply tailored prescriptive
analytics approaches to determine staffing levels for multiple interrelated shifts. The
prescriptive analytics approaches rely on machine learning techniques that incorporate
a detailed representation of the non-stationary structure of arrivals and leverage
extensive auxiliary data that may be predictive of demand. In particular, we adapt
established prescriptive analytics approaches—weighted sample average approximation
and kernelized empirical risk minimization—and propose a new optimization
prediction approach to solving the multi-shift staffing problem. Using a case study
that is based on extensive data from our project partner, the maintenance service
provider, we demonstrate the applicability of these approaches, highlight their benefits
over traditional "estimate then optimize" approaches, and shed light on their
structural properties and performance drivers. In the context of our real-world application,
we derive a clear recommendation for the choice of method with which to
solve the multi-shift staffing problem.

Keywords: Prescriptive Analytics, Machine Learning, Data-driven OM, Queuing System

Suggested Citation

Notz, Pascal M. and Wolf, Peter K. and Pibernik, Richard, Prescriptive Analytics for a Multi-Shift Staffing Problem (July 27, 2020). Available at SSRN: https://ssrn.com/abstract=3516708 or http://dx.doi.org/10.2139/ssrn.3516708

Pascal M. Notz (Contact Author)

University of Würzburg - Business Administration & Economics ( email )

Sanderring 2
Wuerzburg, D-97070
Germany

Peter K. Wolf

University of Würzburg - Business Administration & Economics ( email )

Sanderring 2
Wuerzburg, D-97070
Germany

Richard Pibernik

University of Würzburg - Business Administration & Economics ( email )

Sanderring 2
Wuerzburg, D-97070
Germany

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
177
Abstract Views
989
Rank
323,526
PlumX Metrics