Optimizing Vehicle Repairs Scheduling Using Mixed Integer Linear Programming: A Case Study in the Portuguese Automobile Sector
Abstract
:1. Introduction
2. Literature Review
- Single-machine shop (SMS): there is only a single machine in the shop, and each job has a single operation to be performed on that machine. Therefore, the scheduling task is to find the ideal sequence for all jobs to be processed;
- Parallel machine shop (PMS): there are m machines that work in parallel, and each job has a single operation to be processed, where one job can be processed on several or any of the machines;
- Flow-shop (FSP): there are m machines, and each job consists of a strictly ordered sequence of operations, where the order of the machines for all jobs is identical;
- Job shop (JSP): there are m machines and n jobs, where each job has its own processing order through the machines, and may have no resemblance to that of any other job;
- Open shop (OSP): an extension of the JSP, and here there is no restriction of order within each job.
3. Firm and Challenge Description
4. Methodology
- The sequence of interventions assigned to each vehicle is determined based on the actual repair order established at the repair shop, and this sequence is assumed to be known. Additionally, the order of interventions is fixed and cannot be altered.
- The time required by each mechanic to perform a particular intervention remains consistent across all mechanics. These time durations are specified using standardized barème times defined by each car brand. It should be noted that, for the purpose of this analysis, the barème times associated with the same intervention were adjusted to ensure consistency.
- The interventions can be interrupted and resumed at any point in time, allowing for flexibility in the execution process.
- The interventions performed in the repair shop, are different from the interventions considered in this analysis, since for the firm, the repairs are composed of a set of lines, which will be considered in this analysis as the interventions actually performed, since it is on them that the barème times are associated.
- Each vehicle can only have one mechanic working on it at any given time.
- Only one intervention can be carried out at a time on each vehicle.
- The firm employs mechanics with two levels of qualification. As a result, multiple mechanics possess the necessary skills to perform the same interventions. However, not all mechanics are capable of executing all interventions due to variations in their qualifications. The qualifications are: (i) senior specialized mechanics, who can perform any intervention, including diagnosis; and (ii) senior mechanics, who can perform any intervention, with the exception of diagnostics;
- There are vehicles that present interventions that are not executed in the mechanical area, but these are interventions that have to be considered in this analysis since they are interventions that actually happened in the repair shop, and it required time for the vehicle to be in the repair shop.
- In most cases, when the vehicle arrives at the repair shop, the delivery date is negotiated between the receptionist and the customer. However, this delivery date is not negotiated for all vehicles.
- The working day is divided into two periods: a 4 h duration in the morning and another 4 h duration in the afternoon. There is a designated lunch break lasting for 1 h. Additionally, two flexible breaks of 10 min each are provided, with one break scheduled in the morning and another in the afternoon. In the developed model, time will be treated as a continuous variable, allowing for more precise analysis and scheduling.
5. Results
5.1. Selection of the Real Instances
5.2. Results of the 12 Real Instances
6. Conclusions and Future Work
Author Contributions
Funding
Data Availability Statement
Acknowledgments
Conflicts of Interest
Abbreviations
OR | Operational Research |
JSP | Job Shop Problem |
FJSP | Flexible Job Shop Problem |
MILP | Mixed-Integer Linear Programming |
IP/LP | Integer/Linear programming |
SMS | Single Machine Shop |
PMS | Parallel Machine Shop |
FSP | Flow-Shop |
OSP | Open-Shop |
HFS | Hybrid flow shop |
DES | Discrete Event System |
TA | timed automata |
DFJSP | distributed flexible job shop scheduling problem |
CP | constraint programming |
PNV | Preparation of New Vehicles |
ROs | Repair Orders |
References
- Leung, J. Handbook of Scheduling: Algorithms, Models, and Performance Analysis; CRC Press: Boca Raton, FL, USA, 2004. [Google Scholar]
- Fukunaga, A.; Rabideau, G.; Chien, S.; Yan, D. Towards an application framework for automated planning and scheduling. In Proceedings of the Aerospace Conference, Piscataway, NJ, USA, 13 February 1997; IEEE: New York, NY, USA, 1997; Volume 1, pp. 375–386. [Google Scholar]
- Maccarthy, B.; Liu, J. Addressing the gap in scheduling research: A review of optimization and heuristic methods in production scheduling. Int. J. Prod. Res. 1993, 31, 59–79. [Google Scholar] [CrossRef]
- Demir, Y.; İşleyen, S. Evaluation of mathematical models for flexible job-shop scheduling problems. Appl. Math. Model. 2013, 37, 977–988. [Google Scholar] [CrossRef]
- Pinedo, M. Scheduling; Springer: Berlin, Germany, 2008. [Google Scholar]
- Lin, H.; Fan, Y.; Loiacono, E. A practical scheduling method based on workflow management technology. Int. J. Adv. Manuf. Technol. 2004, 24, 919–924. [Google Scholar] [CrossRef] [Green Version]
- Baker, K.; Trietsch, D. Principles of Sequencing and Scheduling; John Wiley & Sons: Hoboken, NJ, USA, 2009. [Google Scholar]
- de Fátima Pilar, M.; Costa e Silva, E.; Borges, A. Scheduling in an automobile repair shop. Lect. Notes Electr. Eng. 2019, 505, 840–846. [Google Scholar]
- Pilar, M.; Costa e Silva, E.; Borges, A. Improving customer satisfaction in an automobile repair shop. In V Workshop on Computational Data Analysis and Numerical Methods: Book of Abstracts; INE—Instituto Nacional de Estatística: Lisbon, Portugal, 2018; pp. 68–69. [Google Scholar]
- Pilar, M.F.; Costa e Silva, E.; Borges, A. A Case Study on Scheduling of Repairs in an Automobile Shop. In Innovations in Mechanical Engineering; Springer: Berlin, Germany, 2021; pp. 226–236. [Google Scholar]
- Melo, M.T.; Nickel, S.; Saldanha-Da-Gama, F. Facility location and supply chain management–A review. Eur. J. Oper. Res. 2009, 196, 401–412. [Google Scholar] [CrossRef]
- Sarker, R.; Newton, C. Optimization Modelling: A Practical Approach; CRC Press: Boca Raton, FL, USA, 2007. [Google Scholar]
- Brandenburg, M.; Govindan, K.; Sarkis, J.; Seuring, S. Quantitative models for sustainable supply chain management: Developments and directions. Eur. J. Oper. Res. 2014, 233, 299–312. [Google Scholar] [CrossRef]
- Chaudhry, I.A.; Khan, A. A research survey: Review of flexible job shop scheduling techniques. Int. Trans. Oper. Res. 2016, 23, 551–591. [Google Scholar] [CrossRef]
- Fattahi, P.; Mehrabad, M.; Jolai, F. Mathematical modeling and heuristic approaches to flexible job shop scheduling problems. J. Intell. Manuf. 2007, 18, 331–342. [Google Scholar] [CrossRef]
- Unlu, Y.; Mason, S. Evaluation of mixed integer programming formulations for non-preemptive parallel machine scheduling problems. Comput. Ind. Eng. 2010, 58, 785–800. [Google Scholar] [CrossRef]
- Muth, J.; Thompson, G. Industrial Scheduling; Prentice-Hall: Hoboken, NJ, USA, 1963. [Google Scholar]
- Conway, R.; Maxwell, W.; Miller, L. Theory of Scheduling; Dover: Mineola, NY, USA, 1967. [Google Scholar]
- Özgüven, C.; Özbakır, L.; Yavuz, Y. Mathematical models for job-shop scheduling problems with routing and process plan flexibility. Appl. Math. Model. 2010, 34, 1539–1548. [Google Scholar] [CrossRef]
- Baker, K. Introduction to Sequencing and Scheduling; John Wiley & Sons: Hoboken, NJ, USA, 1974. [Google Scholar]
- Kan, A. Machine Scheduling Problems: Classification, Complexity and Computations; Martinus Nijhoff: Leiden, Belgium, 1976. [Google Scholar]
- French, S. Sequencing and Scheduling: An Introduction to the Mathematics of the Job-Shop; John Wiley & Sons: Hoboken, NJ, USA, 1982. [Google Scholar]
- Mellor, P. A review of job shop scheduling. J. Oper. Res. Soc. 1966, 17, 161–171. [Google Scholar] [CrossRef]
- Lenstra, J.; Kan, A.; Brucker, P. Complexity of machine scheduling problems. Ann. Discret. Math. 1977, 1, 343–362. [Google Scholar]
- Graham, R.; Lawler, E.; Lenstra, J.; Kan, A. Optimization and approximation in deterministic sequencing and scheduling: A survey. Ann. Discret. Math. 1979, 5, 287–326. [Google Scholar]
- Graves, S. A review of production scheduling. Oper. Res. 1981, 29, 646–675. [Google Scholar] [CrossRef]
- Brown, D.; Marin, J.; Scherer, W. A survey of intelligent scheduling systems. Intell. Sched. Syst. 1995, 2, 1–40. [Google Scholar]
- Hart, E.; Ross, P.; Corne, D. Evolutionary scheduling: A review. Genet. Program. Evolvable Mach. 2005, 6, 191–220. [Google Scholar] [CrossRef]
- Xia, W.; Wu, Z. An effective hybrid optimization approach for multi-objective flexible job-shop scheduling problems. Comput. Ind. Eng. 2005, 48, 409–425. [Google Scholar] [CrossRef]
- Shen, L.; Dauzère-Pérès, S.; Neufeld, J.S. Solving the flexible job shop scheduling problem with sequence-dependent setup times. Eur. J. Oper. Res. 2018, 265, 503–516. [Google Scholar] [CrossRef]
- Garey, M.; Johnson, D.; Sethi, R. The complexity of flowshop and jobshop scheduling. Math. Oper. Res. 1976, 1, 117–129. [Google Scholar] [CrossRef]
- Talbi, E. Metaheuristics: From Design to Implementation; John Wiley & Sons: Hoboken, NJ, USA, 2009; Volume 74. [Google Scholar]
- Brucker, P.; Schlie, R. Job-shop scheduling with multi-purpose machines. Computing 1990, 45, 369–375. [Google Scholar] [CrossRef]
- Brah, S.; Hunsucker, J.; Shah, J. Mathematical modeling of scheduling problems. J. Inf. Optim. Sci. 1991, 12, 113–137. [Google Scholar] [CrossRef]
- Oyetunji, E. Some common performance measures in scheduling problems. Res. J. Appl. Sci. Eng. Technol. 2009, 1, 6–9. [Google Scholar]
- Holsapple, C.; Lee-Post, A.; Pakath, R. A unified foundation for business analytics. Decis. Support Syst. 2014, 64, 130–141. [Google Scholar] [CrossRef]
- Ruiz, R.; Vázquez-Rodríguez, J.A. The hybrid flow shop scheduling problem. Eur. J. Oper. Res. 2010, 205, 1–18. [Google Scholar] [CrossRef] [Green Version]
- Goel, A. The Canadian minimum duration truck driver scheduling problem. Comput. Oper. Res. 2012, 39, 2359–2367. [Google Scholar] [CrossRef]
- Bülbül, K.; Kaminsky, P. A linear programming-based method for job shop scheduling. J. Sched. 2013, 16, 161–183. [Google Scholar] [CrossRef] [Green Version]
- Allahverdi, A.; Gupta, J.; Aldowaisan, T. A review of scheduling research involving setup considerations. Omega 1999, 27, 219–239. [Google Scholar] [CrossRef]
- Allahverdi, A.; Ng, C.; Cheng, T.; Kovalyov, M. A survey of scheduling problems with setup times or costs. Eur. J. Oper. Res. 2008, 187, 985–1032. [Google Scholar] [CrossRef] [Green Version]
- Allahverdi, A. The third comprehensive survey on scheduling problems with setup times/costs. Eur. J. Oper. Res. 2015, 246, 345–378. [Google Scholar] [CrossRef]
- Wari, E.; Zhu, W. Multi-week MILP scheduling for an ice cream processing facility. Comput. Chem. Eng. 2016, 94, 141–156. [Google Scholar] [CrossRef] [Green Version]
- Zhang, H.; Liang, Y.; Ma, J.; Qian, C.; Yan, X. A MILP method for optimal offshore oilfield gathering system. Ocean Eng. 2017, 141, 25–34. [Google Scholar] [CrossRef]
- Himmiche, S.; Aubry, A.; Marangé, P.; Pétin, J. Modeling Flexible Workshops Scheduling problems: Evaluating a Timed Automata based approach vs. MILP. IFAC-PapersOnLine 2017, 50, 1225–1230. [Google Scholar] [CrossRef]
- Bajestani, M.; Beck, J. Scheduling a Dynamic Aircraft Repair Shop. In Proceedings of the ICAPS 2011—International Conference on Automated Planning and Scheduling, Freiburg, Germany, 11–16 June 2011; pp. 10–17. [Google Scholar]
- Tsadikovich, D.; Levner, E.; Tell, H.; Werner, F. Integrated demand-responsive scheduling of maintenance and transportation operations in military supply chains. Int. J. Prod. Res. 2016, 54, 5798–5810. [Google Scholar] [CrossRef]
- Cerdeira, J.; Lopes, I.; Costa e Silva, E. Scheduling the Repairment of Aircrafts. In Proceedings of the 2017 International Conference on Control, Artificial Intelligence, Robotics & Optimization (ICCAIRO), Crete, Greece, 7–9 May 2017; IEEE: New York, NY, USA, 2017; pp. 259–267. [Google Scholar]
- Kiefer, A.; Schilde, M.; Doerner, K. Scheduling of maintenance work of a large-scale tramway network. Eur. J. Oper. Res. 2018, 270, 1158–1170. [Google Scholar] [CrossRef]
- De Bruecker, P.; Beliën, J.; Van den Bergh, J.; Demeulemeester, E. A three-stage mixed integer programming approach for optimizing the skill mix and training schedules for aircraft maintenance. Eur. J. Oper. Res. 2018, 267, 439–452. [Google Scholar] [CrossRef]
- Abed, F.; Chen, L.; Disser, Y.; Groß, M.; Megow, N.; Meißner, J.; Richter, A.; Rischke, R. Scheduling maintenance jobs in networks. Theor. Comput. Sci. 2018, 754, 107–121. [Google Scholar] [CrossRef] [Green Version]
- Xie, J.; Gao, L.; Peng, K.; Li, X.; Li, H. Review on flexible job shop scheduling. IET Collab. Intell. Manuf. 2019, 1, 67–77. [Google Scholar] [CrossRef]
- Meng, L.; Zhang, C.; Ren, Y.; Zhang, B.; Lv, C. Mixed-integer linear programming and constraint programming formulations for solving distributed flexible job shop scheduling problem. Comput. Ind. Eng. 2020, 142, 106347. [Google Scholar] [CrossRef]
- Marecos, D. Código do Trabalho, 3rd ed.; Almedina: Coimbra, Portugal, 2017. [Google Scholar]
- Fourer, R.; Gay, D.M.; Kernighan, B. A modeling language for mathematical programming. Manag. Sci. 1990, 36, 519–554. [Google Scholar] [CrossRef] [Green Version]
- Fourer, R.; Gay, D.; Kernighan, B. AMPL: A Modeling Language for Mathematical Programming; Brooks/Cole–Thomson Learning: Pacific Grove, CA, USA, 2003. [Google Scholar]
- NEOS Server. NEOS Solver Statistics. 2018. Available online: https://neos-server.org/neos/report.html (accessed on 15 October 2018).
- Gurobi Optimization. Gurobi Optimizer Reference Manual; Gurobi Optimization: Houston, TX, USA, 2018. [Google Scholar]
- Chen, X.; Wu, S.; Shi, C.; Huang, Y.; Yang, Y.; Ke, R.; Zhao, J. Sensing data supported traffic flow prediction via denoising schemes and ANN: A comparison. IEEE Sens. J. 2020, 20, 14317–14328. [Google Scholar] [CrossRef]
- Xiao, G.; Xiao, Y.; Ni, A.; Zhang, C.; Zong, F. Exploring influence mechanism of bikesharing on the use of public transportation—A case of Shanghai. Transp. Lett. 2023, 15, 269–277. [Google Scholar] [CrossRef]
Name | Description |
---|---|
ROs (i.e., vehicles to be repaired). | |
Mechanics employed. | |
All possible mechanical interventions. | |
Predetermined and ordered interventions to be performed on a specific vehicle. | |
Specific pair of interventions that are to be performed in a predetermined sequence on a particular vehicle . | |
Mechanics that are qualified to perform the required interventions on vehicle o, i.e., . |
Name | Description |
---|---|
Processing time of intervention , in minutes. | |
Deadline or delivery time of vehicle , defined as the time from the moment that vehicle o arrives at the repair shop until the expected delivery date, in minutes. | |
Release date of vehicle , defined as the time of arrival of vehicle o into the repair shop, in minutes. | |
Describes whether vehicle has an established expected delivery date, such that if vehicle has an expected delivery time and 0 otherwise. | |
L | A sufficiently large positive number. |
Name | Description |
---|---|
Binary variables that define the precedence relations between interventions and , with and or . It is equal to 1 if intervention is performed before intervention . Otherwise, it is equal to 0. | |
Binary variables that define the assigning of each mechanical intervention i on vehicle o to a mechanic m. It is equal to 1 if intervention is assigned to mechanic m. Otherwise, it is equal to 0. | |
Non-negative variables that define the starting time of intervention i on vehicle o, in minutes. | |
Non-negative variables that define the tardiness of vehicle o. |
Year | Month | Total # of Opened ROs | Total # of Time Clocked ROs | Total Downtime (in min.) |
---|---|---|---|---|
2016 | August | 441 | 540 | 387,709.2 |
September | 455 | 646 | 354,881.2 | |
October | 498 | 687 | 392,858.0 | |
November | 473 | 664 | 306,310.0 | |
December | 454 | 620 | 253,616.0 | |
2017 | January | 516 | 707 | 278,735.8 |
February | 430 | 592 | 368,473.4 | |
March | 519 | 748 | 369,077.0 | |
April | 450 | 596 | 192,531.4 | |
May | 547 | 754 | 255,557.8 | |
June | 532 | 737 | 257,939.0 | |
July | 533 | 713 | 264,060.6 |
Instance | #O | # | #var | #constr | Objective | Downtime | % |
---|---|---|---|---|---|---|---|
9 May | 29 | 71 | 9360 | 84,892 | 70 | 30,655.5 | 98.8% |
16 May | 28 | 95 | 13,410 | 123,592 | 2275.2 | 9877.8 | 46.4% |
19 May | 18 | 53 | 3181 | 27,071 | 26.7 | 271.6 | 8.9% |
26 May | 21 | 53 | 4174 | 36,099 | 0 | 2204.6 | 43.4% |
2 June | 13 | 31 | 1186 | 9056 | 51.9 | 103.9 | 4.9% |
5 June | 33 | 112 | 12,244 | 112,567 | 0 | 13,355.9 | 46.5% |
23 June | 27 | 63 | 4322 | 36,846 | 31.5 | 3301.5 | 12.4% |
30 June | 20 | 63 | 4060 | 34,972 | 167 | 599.4 | 21.0% |
4 July | 29 | 84 | 8821 | 79,648 | 0 | 10,955.6 | 34.2% |
11 July | 29 | 47 | 4391 | 37,734 | 114,174 | 3471.8 | 10.4% |
14 July | 19 | 56 | 3535 | 3286 | 0 | 1251.4 | 29.9% |
27 July | 26 | 45 | 4558 | 39,802 | 2,634,170 | 1656.0 | 39.1% |
Mean | 23.8 | 64.4 | 6103.5 | 54,380.4 | 252,952.2 | 6475.4 | 33.0% |
StDev | 6.0 | 23.7 | 3943.1 | 37,175.7 | 78,178.5 | 9072.7 | 25.8% |
Day | Min | Mean | Median | Max | Total | |
---|---|---|---|---|---|---|
May 9 | Model | 0.0 | 1057.1 | 328.7 | 9604.2 | 30,655.5 |
Firm | 3.0 | 1069.7 | 300.6 | 11,622.8 | 31,021.0 | |
May 19 | Model | 0.0 | 15.1 | 2.8 | 92.9 | 271.6 |
Firm | 2.8 | 168.9 | 107.3 | 1011.0 | 3040.2 | |
June 2 | Model | 0.0 | 8.0 | 0.0 | 60.0 | 103.9 |
Firm | 0.0 | 162.4 | 72.4 | 938.6 | 2111.6 | |
June 5 | Model | 0.0 | 404.7 | 195.7 | 1669.8 | 13,355.9 |
Firm | 0.0 | 870.8 | 299.0 | 5674.0 | 28,735.8 |
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. |
© 2023 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (https://creativecommons.org/licenses/by/4.0/).
Share and Cite
Pilar, F.; Costa e Silva, E.; Borges, A. Optimizing Vehicle Repairs Scheduling Using Mixed Integer Linear Programming: A Case Study in the Portuguese Automobile Sector. Mathematics 2023, 11, 2575. https://doi.org/10.3390/math11112575
Pilar F, Costa e Silva E, Borges A. Optimizing Vehicle Repairs Scheduling Using Mixed Integer Linear Programming: A Case Study in the Portuguese Automobile Sector. Mathematics. 2023; 11(11):2575. https://doi.org/10.3390/math11112575
Chicago/Turabian StylePilar, Fátima, Eliana Costa e Silva, and Ana Borges. 2023. "Optimizing Vehicle Repairs Scheduling Using Mixed Integer Linear Programming: A Case Study in the Portuguese Automobile Sector" Mathematics 11, no. 11: 2575. https://doi.org/10.3390/math11112575
APA StylePilar, F., Costa e Silva, E., & Borges, A. (2023). Optimizing Vehicle Repairs Scheduling Using Mixed Integer Linear Programming: A Case Study in the Portuguese Automobile Sector. Mathematics, 11(11), 2575. https://doi.org/10.3390/math11112575