Quantitative Models for Workforce Management in a Large Service Operation

Siddhanth Shetty, Vittaldas Prabhu

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

This paper develops quantitative models for optimizing employee scheduling in large labor-intense service operations that face complexities such high employee turnover, contractual service-level agreements (SLA), non-billable overtime cost, and rising minimum wages. The workforce analytics part of the model uses payroll data to characterize employee features such as consistency, overtime affinity, and retention. The business analytics part of the model ensures that adequate employees are assigned to a shift to comply with SLA while minimizing anticipated overtime cost based on the prevailing overtime salary. A Mixed Integer-Linear Program is formulated with the objective of balancing total overtime cost reduction, employee preferences, and employee features. Additionally, employees can be clustered to identify distinct patterns based on their features of consistency, overtime, and retention. The proposed approach has been applied at a North American service provider with over 4,000 employees across more than 100 sites. K-means clustering based on employee features identified four distinct clusters. Deeper analytics using mixed-effects analysis can show the contribution to profitability from reliable employees, which are limited in availability. Boosted tree importance scoring can establish the influence of moderately reliable employees on overtime cost. Furthermore, decision tree model highlighted that tactical hiring and scheduling must account for collective workforce variability rather than individual attributes in isolation. A partial dependence plot helps visualize the relationship between employee reliability and overtime, thereby helping to characterize the impact of workforce mix on cost. Key impact from this work is that the company management is working to improve its recruitment, retention, and scheduling policies to better align business needs and human capital.

Original languageEnglish (US)
Title of host publicationAdvances in Production Management Systems. Production Management Systems for Volatile, Uncertain, Complex, and Ambiguous Environments - 43rd IFIP WG 5.7 International Conference, APMS 2024, Proceedings
EditorsMatthias Thürer, Ralph Riedel, Gregor von Cieminski, David Romero
PublisherSpringer Science and Business Media Deutschland GmbH
Pages367-381
Number of pages15
ISBN (Print)9783031658938
DOIs
StatePublished - 2024
Event43rd IFIP WG 5.7 International Conference on Advances in Production Management Systems, APMS 2024 - Chemnitz, Germany
Duration: Sep 8 2024Sep 12 2024

Publication series

NameIFIP Advances in Information and Communication Technology
Volume729 IFIP
ISSN (Print)1868-4238
ISSN (Electronic)1868-422X

Conference

Conference43rd IFIP WG 5.7 International Conference on Advances in Production Management Systems, APMS 2024
Country/TerritoryGermany
CityChemnitz
Period9/8/249/12/24

All Science Journal Classification (ASJC) codes

  • Information Systems and Management

Fingerprint

Dive into the research topics of 'Quantitative Models for Workforce Management in a Large Service Operation'. Together they form a unique fingerprint.

Cite this