Optimizing a complex multi-objective personnel scheduling problem jointly complying with requests from customers and staff

•A multi-objective MILP formulation is provided for a personnel scheduling problem.•A new approach to handle multi-objective problems with soft constraints is proposed.•The objectives have different importance and are hierarchically ordered.•Single-objective problems are solved in stages, exactly an...

Full description

Saved in:
Bibliographic Details
Published in:Omega (Oxford) Vol. 114; p. 102722
Main Authors: Mansini, Renata, Zanella, Marina, Zanotti, Roberto
Format: Journal Article
Language:English
Published: Elsevier Ltd 01.01.2023
Subjects:
ISSN:0305-0483, 1873-5274
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:•A multi-objective MILP formulation is provided for a personnel scheduling problem.•A new approach to handle multi-objective problems with soft constraints is proposed.•The objectives have different importance and are hierarchically ordered.•Single-objective problems are solved in stages, exactly and heuristically, if needed.•Kernel Search is used as a heuristic procedure. This paper deals with a complex multi-objective personnel scheduling problem motivated by a real case. A multi-objective mixed integer linear programming formulation of the problem is proposed. Constraints are classified into mandatory and optional. The work introduces a solution approach, dubbed PRIMP (Prioritize & Improve), that enforces constraint satisfaction by adopting additional objective functions. All the (given and additional) objective functions are lexicographically ordered. The method sequentially solves single-objective problems, according to their priority. Each problem is first processed by an exact solver; if no optimal solution is found within a given time limit, the problem is then addressed heuristically. The proposed multi-stage method is efficient (it takes just a few minutes to produce a daily schedule) and effective, compared both to the manual approach followed by the company and to the method that optimally tackles each single-objective problem by means of a competitive mixed-integer linear programming solver. Experimental results indicate that PRIMP can produce high quality schedules, where a larger number of optional constraints are satisfied and both the global idle time of employees and the waiting time of customers is reduced. The approach is modular and easily adaptable to manage different objective functions and/or constraints.
ISSN:0305-0483
1873-5274
DOI:10.1016/j.omega.2022.102722