Resource constrained routing and scheduling: Review and research prospects

In the service industry, it is crucial to efficiently allocate scarce resources to perform tasks and meet particular service requirements. What considerably complicates matters is when these resources, for example skilled technicians, nurses, and home carers have to visit different customer locations. This paper provides a comprehensive survey on resource constrained routing and scheduling that unveils the problem characteristics with respect to resource qualifications, service requirements and problem objectives. It also identifies the most effective exact and heuristic algorithms for this class of problems. The paper closes with several research prospects

Enhanced Iterated local search for the technician routing and scheduling problem

Most public facilities in the European countries, including France, Germany, and the UK, were built during the reconstruction projects between 1950 and 1980. Owing to the deteriorating state of such vital infrastructure has become relatively expensive in the recent decades. A significant part of the maintenance operation costs is spent on the technical staff. Therefore, the optimal use of the available workforce is essential to optimize the operation costs. This includes planning technical interventions, workload balancing, productivity improvement, etc. In this paper, we focus on the routing of technicians and scheduling of their tasks. We address for this purpose a variant of the workforce scheduling problem called the technician routing and scheduling problem (TRSP). This problem has applications in different fields, such as transportation infrastructure (rail and road networks), telecommunications, and sewage facilities. To solve the TRSP, we propose an enhanced iterated local search (eILS) approach. The enhancement of the ILS firstly includes an intensification procedure that incorporates a set of local search operators and removal-repair heuristics crafted for the TRSP. Next, four different mechanisms are used in the perturbation phase. Finally, an elite set of solutions is used to extensively explore the neighborhood of local optima as well as to enhance diversification during search space exploration. To measure the performance of the proposed method, experiments were conducted based on benchmark instances from the literature, and the results obtained were compared with those of an existing method. Our method achieved very good results, since it reached the best overall gap, which is three times lower than that of the literature. Furthermore, eILS improved the best-known solution for $34$ instances among a total of $56$ while maintaining reasonable computational times.Comment: Submitted manuscript to Computers and Operations Research journal. 34 pages, 7 figures, 6 table

Solution of a practical Vehicle Routing Problem for monitoring Water Distribution Networks

In this work, we introduce a generalisation of the Vehicle Routing Problem for a specific application in the monitoring of a Water Distribution Network (WDN). In this problem, multiple technicians must visit a sequence of nodes in the WDN and perform a series of tests to check the quality of water. Some special nodes (i.e., wells) require technicians to first collect a key from a key centre. The key must then be returned to the same key centre after the test has been performed, thus introducing precedence constraints and multiple visits in the routes. To solve the problem, a Mixed Integer Linear Programming model and an Iterated Local Search have been implemented. The efficiency of the proposed methods is demonstrated by means of extensive computational tests on randomly created and real-world instances

Integrated Production and Distribution planning of perishable goods

Tese de doutoramento. Programa Doutoral em Engenharia Industrial e Gestão. Faculdade de Engenharia. Universidade do Porto. 201

Personaneinsatz- und Tourenplanung für Mitarbeiter mit Mehrfachqualifikationen

In workforce routing and scheduling there are many applications in which differently skilled workers must perform jobs that occur at different locations, where each job requires a particular combination of skills. In many such applications, a group of workers must be sent out to provide all skills required by a job. Examples are found in maintenance operations, the construction sector, health care operations, or consultancies. In this thesis, we analyze the combined problem of composing worker groups (teams) and routing these teams under goals expressing service-, fairness-, and cost-objectives. We develop mathematical optimization models and heuristic solution methods for an integrated solution and a sequential solution of the teaming- and routing-subproblems . Computational experiments are conducted to identify the tradeoff of better solution quality and computational effort

Shift Scheduling with the Goal Programming Approach in Fast-Food Restaurant: McDonald’s in Kelantan

A major fast-food restaurant chain, such as McDonald's, must perform well to maintain its credibility with customers and dominance over other competitors. A fair and balanced shift schedule of workers must be generated to ensure that the workers provide the best service and production for the restaurant. Consequently, this study proposed a fair and efficient workforce schedule at a McDonald's restaurant in Kelantan, Malaysia. Furthermore, the goal programming method and the LINGO software are used in this study to develop the best schedule for the workers over a 28-day period. Five hard constraints and three soft constraints are identified. The primary goal of this study, which demanded the same total workload for each worker, was met. However, the other two goals are not fully achieved but have little impact on the workers due to the 18-hour operation and rotation of schedules among workers. Finally, the generated schedule pattern has been shown to provide a better schedule in terms of having the same total number of shifts for each worker and giving each worker the same total number of off days. Â

Service scheduling and vehicle routing problem to minimise the risk of missing appointments

This research studies a workforce scheduling and vehicle routing problem where technicians drive a vehicle to customer locations to perform service tasks. The service times and travel times are subject to stochastic events. There is an agreed time window for starting each service task. The risk of missing the time window for a task is defined as the probability that the technician assigned to the task arrives at the customer site later than the time window. The problem is to generate a schedule that minimises the maximum of risks and the sum of risks of all the tasks considering the effect of skill levels and task priorities. A new approach is taken to build schedules that minimise the risks of missing appointments as well as the risks of technicians not being able to complete their daily tours on time.We first analyse the probability distribution of the arrival time to any customer location considering the distributions of activities prior to this arrival. Based on the analysis, an efficient estimation method for calculating the risks is proposed, which is highly accurate and this is verified by comparing the results of the estimation method with a numerical integral method.We then develop three new workforce scheduling and vehicle routing models that minimise the risks with different considerations such as an identical standard deviation of the duration for all uncertain tasks in the linear risk minimisation model, and task priorities in the priority task risk minimisation model. A simulated annealing algorithm is implemented for solving the models at the start of the day and for re-optimisation during the day. Computational experiments are carried out to compare the results of the risk minimisation models with those of the traditional travel cost model. The performance is measured using risks and robustness. Simulation is used to compare the numbers of missed appointments and test the effect of re-optimisation.The results of the experiments demonstrate that the new models significantly reduce the risks and generate schedules with more contingency time allowances. Simulation results also show that re-optimisation reduces the number of missed appointments significantly. The risk calculation methods and risk minimisation algorithm are applied to a real-world problem in the telecommunication sector.</div

Optimising airline maintenance scheduling decisions

Airline maintenance scheduling (AMS) studies how plans or schedules are constructed to ensure that a fleet is efficiently maintained and that airline operational demands are met. Additionally, such schedules must take into consideration the different regulations airlines are subject to, while minimising maintenance costs. In this thesis, we study different formulations, solution methods, and modelling considerations, for the AMS and related problems to propose two main contributions. First, we present a new type of multi-objective mixed integer linear programming formulation which challenges traditional time discretisation. Employing the concept of time intervals, we efficiently model the airline maintenance scheduling problem with tail assignment considerations. With a focus on workshop resource allocation and individual aircraft flight operations, and the use of a custom iterative algorithm, we solve large and long-term real-world instances (16000 flights, 529 aircraft, 8 maintenance workshops) in reasonable computational time. Moreover, we provide evidence to suggest, that our framework provides near-optimal solutions, and that inter-airline cooperation is beneficial for workshops. Second, we propose a new hybrid solution procedure to solve the aircraft recovery problem. Here, we study how to re-schedule flights and re-assign aircraft to these, to resume airline operations after an unforeseen disruption. We do so while taking operational restrictions into account. Specifically, restrictions on aircraft, maintenance, crew duty, and passenger delay are accounted for. The flexibility of the approach allows for further operational restrictions to be easily introduced. The hybrid solution procedure involves the combination of column generation with learning-based hyperheuristics. The latter, adaptively selects exact or metaheuristic algorithms to generate columns. The five different algorithms implemented, two of which we developed, were collected and released as a Python package (Torres Sanchez, 2020). Findings suggest that the framework produces fast and insightful recovery solutions

A Multi-Skilled Approach to Property Maintenance Considering Temporal, Spatial and Resource Constraints

With the continued increase in age of the United States housing and building stock, as well as the continued need to maintain properties across the U.S., the need for timely, cost-optimal maintenance is ever more critical. This paper proposes the application of a mathematical model to aid in the scheduling and assignment of construction and maintenance tasks, considering the multi-skilled workforce. The benefit of this approach is to take advantage of the economies of scale that can be developed using cross-functional skilled workers with varying levels of competence and efficiency. This approach schedules and assigns tasks using data from maintenance task software datasets, using the least-cost, competent worker available for the job while also considering the trade-off between skilled labor cost and travel costs, both in terms of travel wage and vehicle wear and tear. The model is enhanced to include pairing between a mentor and an apprentice, where combined efficiency and pairing costs are considered at the same time as travel costs. Due to the practical nature of this research, a case organization was used and data from that firm was analyzed so that operational insights into the necessity of such a model could be considered. The mathematical backbone of the optimization approach to multi-skilled resource allocation considers the temporal and spatial demands of a geographically dispersed property management program. Actual, as opposed to sample, data allows us to evaluate the real financial implications on the case firm, if such an approach to scheduling is used. The generalization of this data provides excellent fit for a model that can be used to assign the best capable worker to the most cost-efficient task, considering deadlines, priorities and availability. Results of this scheduling approach provide significant cost and resource reductions over the historical firm performance, though practical considerations should temper that expectation. The above approach offers exceptional scalability and adaptability with the continued advancement of algorithm approaches to network-distribution and peer-to-peer work platforms