A Mixed-Integer Linear Program to create the shifts in a supermarket

Nicolo Gusmeroli,Andrea Bettinelli
2024-03-27
Abstract:The shift design and the personnel scheduling problem is known to be a difficult problem. It is a real-world problem which has lots of applications in the organization of companies. Solutions are usually found by dividing the problem in two steps: first the shifts are created, then the employees are assigned to them by respecting a bunch of constraints. The assignment of different tasks increases the complexity, since we have to consider the skills of the single employee necessary to perform any activity. In this paper we present a mixed-integer linear programming formulation which models together the shift creation and the construction of rosters for employees, with the objective of minimizing the amount of uncovered demand. Finally we provide the results for three real-world instances, confirming that this approach is promising.
Optimization and Control
What problem does this paper attempt to address?
This paper aims to address the Shift-Design Personnel Task Scheduling Problem (SDPTSP). Specifically, the problem includes designing shift schedules, creating employee shifts, and assigning tasks while complying with legal and company regulations to minimize unmet demand. The paper proposes a Mixed-Integer Linear Programming (MILP) approach to solve this problem and validates its effectiveness through three real-world cases. Specifically, the main contributions of the paper are as follows: 1. **Proposing the MILP model**: For the first time, a Mixed-Integer Linear Programming model is proposed for SDPTSP, defining general constraints. 2. **Specific application case**: The study examines the actual needs of a large Italian retail company, adding constraints specific to the scenario to provide better solutions. 3. **Experimental results**: The effectiveness of the model is validated through planning instances of three different weeks, and compared with actual scheduling, the results show that the new method significantly reduces unmet demand while fully complying with all constraints. Through this work, the paper demonstrates the advantages of its method in improving demand coverage and reducing violations, and it can achieve better results in a shorter time.