Skip to main content
Erschienen in: Journal of Scheduling 1/2016

01.02.2016

A mixed integer programming approach to multi-skilled workforce scheduling

verfasst von: Rodolfo Cuevas, Juan-Carlos Ferrer, Mathias Klapp, Juan-Carlos Muñoz

Erschienen in: Journal of Scheduling | Ausgabe 1/2016

Einloggen

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config
loading …

Abstract

The potential benefits of using human resources efficiently in the service sector constitute an incentive for decision makers in this industry to intelligently manage the work shifts of their employees, especially those dealing directly with customers. In the long term, they should attempt to find the right balance between employing as few labor resources as possible and keeping a high level of service. In the short run (e.g., 1 week), however, contracted staff levels cannot be adjusted, and management efforts thus focus on the efficient assignment of shifts and activities to each employee. This article proposes a mixed integer program model that solves the short-term multi-skilled workforce tour scheduling problem, enabling decision makers to simultaneously design workers’ shifts and days off, assign activities to shifts and assign those to employees so as to maximize and balance coverage of a firm’s demand for on-duty staff across multiple activities. Our model is simple enough to be solved with a commercial MIP solver calibrated by default without recurring to complex methodologies, such as extended reformulations and exact and/or heuristic column generation subroutines. A wide computational testing over 1000 randomly generated instances suggests that the model’s solution times are compatible with daily use and that multi-skilling is a significant source of labor flexibility to improve coverage of labor requirements, in particular when such requirements are negatively correlated and part-time workers are a scarce resource.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Anhänge
Nur mit Berechtigung zugänglich
Literatur
Zurück zum Zitat Addou, I., & Soumis, F. (2007). Bechtold-jacobs generalized model for shift scheduling with extraordinary overlap. Annals of Operations Research, 155(1), 177–205.CrossRef Addou, I., & Soumis, F. (2007). Bechtold-jacobs generalized model for shift scheduling with extraordinary overlap. Annals of Operations Research, 155(1), 177–205.CrossRef
Zurück zum Zitat Al-Yakoob, S. M., & Sherali, H. D. (2007). Mixed-integer programming models for an employee scheduling problem with multiple shifts and work locations. Annals of Operations Research, 155(1), 119–142.CrossRef Al-Yakoob, S. M., & Sherali, H. D. (2007). Mixed-integer programming models for an employee scheduling problem with multiple shifts and work locations. Annals of Operations Research, 155(1), 119–142.CrossRef
Zurück zum Zitat Alfares, H. K. (2004). Survey, categorization, and comparison of recent tour scheduling literature. Annals of Operations Research, 127(1–4), 145–175.CrossRef Alfares, H. K. (2004). Survey, categorization, and comparison of recent tour scheduling literature. Annals of Operations Research, 127(1–4), 145–175.CrossRef
Zurück zum Zitat Aykin, T. (1996). Optimal shift scheduling with multiple break windows. Management Science, 42(4), 591–602.CrossRef Aykin, T. (1996). Optimal shift scheduling with multiple break windows. Management Science, 42(4), 591–602.CrossRef
Zurück zum Zitat Bailey, J. (1985). Integrated days off and shift personnel scheduling. Computers & Industrial Engineering, 9(4), 395–404.CrossRef Bailey, J. (1985). Integrated days off and shift personnel scheduling. Computers & Industrial Engineering, 9(4), 395–404.CrossRef
Zurück zum Zitat Baker, K. R. (1974). Scheduling a full-time workforce to meet cyclic staffing requirements. Management Science, 20(12), 1561–1568.CrossRef Baker, K. R. (1974). Scheduling a full-time workforce to meet cyclic staffing requirements. Management Science, 20(12), 1561–1568.CrossRef
Zurück zum Zitat Barnhart, C., Johnson, E. L., Nemhauser, G. L., Savelsbergh, M. W. P., & Vance, P. H. (1998). Branch-and-price: Column generation for solving huge integer programs. Operations Research, 46(3), 316–329.CrossRef Barnhart, C., Johnson, E. L., Nemhauser, G. L., Savelsbergh, M. W. P., & Vance, P. H. (1998). Branch-and-price: Column generation for solving huge integer programs. Operations Research, 46(3), 316–329.CrossRef
Zurück zum Zitat Bechtold, S. E., Brusco, M. J., & Showalter, M. J. (1991). A comparative evaluation of labor tour scheduling methods. Decision Sciences, 22(4), 683–699.CrossRef Bechtold, S. E., Brusco, M. J., & Showalter, M. J. (1991). A comparative evaluation of labor tour scheduling methods. Decision Sciences, 22(4), 683–699.CrossRef
Zurück zum Zitat Bechtold, S. E., & Jacobs, L. W. (1990). Implicit modeling of flexible break assignments in optimal shift scheduling. Management Science, 36(11), 1339–1351.CrossRef Bechtold, S. E., & Jacobs, L. W. (1990). Implicit modeling of flexible break assignments in optimal shift scheduling. Management Science, 36(11), 1339–1351.CrossRef
Zurück zum Zitat Brusco, M. J., & Jacobs, L. W. (1998). Personnel tour scheduling when starting-time restrictions are present. Management Science, 44(4), 534–547.CrossRef Brusco, M. J., & Jacobs, L. W. (1998). Personnel tour scheduling when starting-time restrictions are present. Management Science, 44(4), 534–547.CrossRef
Zurück zum Zitat Brusco, M. J., & Jacobs, L. W. (2000). Optimal models for meal-break and start-time flexibility in continuous tour scheduling. Management Science, 46(12), 1630–1641.CrossRef Brusco, M. J., & Jacobs, L. W. (2000). Optimal models for meal-break and start-time flexibility in continuous tour scheduling. Management Science, 46(12), 1630–1641.CrossRef
Zurück zum Zitat Brusco, M. J., & Johns, T. R. (1998). Staffing a multiskilled workforce with varying levels of productivity: An analysis of cross-training policies*. Decision Sciences, 29(2), 499–515.CrossRef Brusco, M. J., & Johns, T. R. (1998). Staffing a multiskilled workforce with varying levels of productivity: An analysis of cross-training policies*. Decision Sciences, 29(2), 499–515.CrossRef
Zurück zum Zitat Buffa, E. S., Cosgrove, M. J., & Luce, B. J. (1976). An integrated work shift scheduling system. Decision Sciences, 7(4), 620–630.CrossRef Buffa, E. S., Cosgrove, M. J., & Luce, B. J. (1976). An integrated work shift scheduling system. Decision Sciences, 7(4), 620–630.CrossRef
Zurück zum Zitat Cai, X., & Li, K. (2000). A genetic algorithm for scheduling staff of mixed skills under multi-criteria. European Journal of Operational Research, 125(2), 359–369.CrossRef Cai, X., & Li, K. (2000). A genetic algorithm for scheduling staff of mixed skills under multi-criteria. European Journal of Operational Research, 125(2), 359–369.CrossRef
Zurück zum Zitat Campbell, G. M. (1999). Cross-utilization of workers whose capabilities differ. Management Science, 45(5), 722–732.CrossRef Campbell, G. M. (1999). Cross-utilization of workers whose capabilities differ. Management Science, 45(5), 722–732.CrossRef
Zurück zum Zitat Campbell, G. M. (2010). A two-stage stochastic program for scheduling and allocating cross-trained workers. Journal of the Operational Research Society, 62(6), 1038–1047.CrossRef Campbell, G. M. (2010). A two-stage stochastic program for scheduling and allocating cross-trained workers. Journal of the Operational Research Society, 62(6), 1038–1047.CrossRef
Zurück zum Zitat Chapados, N., Joliveau, M., & Rousseau, L. M. (2011). Retail store workforce scheduling by expected operating income maximization. In T. Achterberg & J. Beck (Eds.), Integration of AI and OR techniques in constraint programming for combinatorial optimization problems. Lecture notes in computer science (Vol. 6697, pp. 53–58). Berlin/Heidelberg: Springer.CrossRef Chapados, N., Joliveau, M., & Rousseau, L. M. (2011). Retail store workforce scheduling by expected operating income maximization. In T. Achterberg & J. Beck (Eds.), Integration of AI and OR techniques in constraint programming for combinatorial optimization problems. Lecture notes in computer science (Vol. 6697, pp. 53–58). Berlin/Heidelberg: Springer.CrossRef
Zurück zum Zitat Côté, M. C., Gendron, B., & Rousseau, L. M. (2011). Grammar-based integer programming models for multiactivity shift scheduling. Management Science, 57(1), 151–163.CrossRef Côté, M. C., Gendron, B., & Rousseau, L. M. (2011). Grammar-based integer programming models for multiactivity shift scheduling. Management Science, 57(1), 151–163.CrossRef
Zurück zum Zitat Côté, M. C., Gendron, B., & Rousseau, L. M. (2013). Grammar-based column generation for personalized multi-activity shift scheduling. INFORMS Journal on Computing, 25(3), 461–474.CrossRef Côté, M. C., Gendron, B., & Rousseau, L. M. (2013). Grammar-based column generation for personalized multi-activity shift scheduling. INFORMS Journal on Computing, 25(3), 461–474.CrossRef
Zurück zum Zitat Dantzig, G. B. (1954). Letter to the editora comment on Edie’s traffic delays at toll booths. Journal of the Operations Research Society of America, 2(3), 339–341.CrossRef Dantzig, G. B. (1954). Letter to the editora comment on Edie’s traffic delays at toll booths. Journal of the Operations Research Society of America, 2(3), 339–341.CrossRef
Zurück zum Zitat Demassey, S., Pesant, G., & Rousseau, L. M. (2006). A cost-regular based hybrid column generation approach. Constraints, 11(4), 315–333.CrossRef Demassey, S., Pesant, G., & Rousseau, L. M. (2006). A cost-regular based hybrid column generation approach. Constraints, 11(4), 315–333.CrossRef
Zurück zum Zitat Easton, F. F. (2011). Cross-training performance in flexible labor scheduling environments. IIE Transactions, 43(8), 589–603.CrossRef Easton, F. F. (2011). Cross-training performance in flexible labor scheduling environments. IIE Transactions, 43(8), 589–603.CrossRef
Zurück zum Zitat Easton, F. F., & Rossin, D. F. (1991). Sufficient working subsets for the tour scheduling problem. Management Science, 37(11), 1441–1451.CrossRef Easton, F. F., & Rossin, D. F. (1991). Sufficient working subsets for the tour scheduling problem. Management Science, 37(11), 1441–1451.CrossRef
Zurück zum Zitat Eitzen, G., Panton, D., & Mills, G. (2004). Multi-skilled workforce optimisation. Annals of Operations Research, 127(1–4), 359–372.CrossRef Eitzen, G., Panton, D., & Mills, G. (2004). Multi-skilled workforce optimisation. Annals of Operations Research, 127(1–4), 359–372.CrossRef
Zurück zum Zitat Ernst, A., Jiang, H., Krishnamoorthy, M., Owens, B., & Sier, D. (2004). An annotated bibliography of personnel scheduling and rostering. Annals of Operations Research, 127(1–4), 21–144.CrossRef Ernst, A., Jiang, H., Krishnamoorthy, M., Owens, B., & Sier, D. (2004). An annotated bibliography of personnel scheduling and rostering. Annals of Operations Research, 127(1–4), 21–144.CrossRef
Zurück zum Zitat Gomar, J., Haas, C., & Morton, D. (2002). Assignment and allocation optimization of partially multiskilled workforce. Journal of construction Engineering and Management, 128(2), 103–109.CrossRef Gomar, J., Haas, C., & Morton, D. (2002). Assignment and allocation optimization of partially multiskilled workforce. Journal of construction Engineering and Management, 128(2), 103–109.CrossRef
Zurück zum Zitat Isken, M. W. (2004). An implicit tour scheduling model with applications in healthcare. Annals of Operations Research, 128(1–4), 91–109.CrossRef Isken, M. W. (2004). An implicit tour scheduling model with applications in healthcare. Annals of Operations Research, 128(1–4), 91–109.CrossRef
Zurück zum Zitat Lequy, Q., Bouchard, M., Desaulniers, G., Soumis, F., & Tachefine, B. (2012). Assigning multiple activities to work shifts. Journal of Scheduling, 15(2), 239–251.CrossRef Lequy, Q., Bouchard, M., Desaulniers, G., Soumis, F., & Tachefine, B. (2012). Assigning multiple activities to work shifts. Journal of Scheduling, 15(2), 239–251.CrossRef
Zurück zum Zitat Lequy, Q., Desaulniers, G., & Solomon, M. M. (2012). A two-stage heuristic for multi-activity and task assignment to work shifts. Computers & Industrial Engineering, 63(4), 831–841.CrossRef Lequy, Q., Desaulniers, G., & Solomon, M. M. (2012). A two-stage heuristic for multi-activity and task assignment to work shifts. Computers & Industrial Engineering, 63(4), 831–841.CrossRef
Zurück zum Zitat Li, C., Robinson, E. P., & Mabert, V. A. (1991). An evaluation of tour scheduling heuristics with differences in employee productivity and cost. Decision Sciences, 22(4), 700–718.CrossRef Li, C., Robinson, E. P., & Mabert, V. A. (1991). An evaluation of tour scheduling heuristics with differences in employee productivity and cost. Decision Sciences, 22(4), 700–718.CrossRef
Zurück zum Zitat Mooney, E., Davidson, T. (2004). Tour scheduling with skill based costs. In 5th International Conference on Practice and Theory of Automated Timetabling PATAT Pittsburgh: Citeseer. Mooney, E., Davidson, T. (2004). Tour scheduling with skill based costs. In 5th International Conference on Practice and Theory of Automated Timetabling PATAT Pittsburgh: Citeseer.
Zurück zum Zitat Nemhauser, G. L., & Wolsey, L. A. (1988). Integer and combinatorial optimization (Vol. 18). New York: Wiley. Nemhauser, G. L., & Wolsey, L. A. (1988). Integer and combinatorial optimization (Vol. 18). New York: Wiley.
Zurück zum Zitat Park, P. S. (1991). The examination of worker cross-training in a dual resource constrained job shop. European Journal of Operational Research, 52(3), 291–299.CrossRef Park, P. S. (1991). The examination of worker cross-training in a dual resource constrained job shop. European Journal of Operational Research, 52(3), 291–299.CrossRef
Zurück zum Zitat Rekik, M., Cordeau, J. F., & Soumis, F. (2008). Solution approaches to large shift scheduling problems. RAIRO Operations Research, 42(02), 229–258.CrossRef Rekik, M., Cordeau, J. F., & Soumis, F. (2008). Solution approaches to large shift scheduling problems. RAIRO Operations Research, 42(02), 229–258.CrossRef
Zurück zum Zitat Restrepo, M. I., Lozano, L., & Medaglia, A. L. (2012). Constrained network-based column generation for the multi-activity shift scheduling problem. International Journal of Production Economics, 140(1), 466–472.CrossRef Restrepo, M. I., Lozano, L., & Medaglia, A. L. (2012). Constrained network-based column generation for the multi-activity shift scheduling problem. International Journal of Production Economics, 140(1), 466–472.CrossRef
Zurück zum Zitat Ritzman, L. P., Krajewski, L. J., & Showalter, M. J. (1976). The disaggregation of aggregate manpower plans. Management Science, 22(11), 1204–1214.CrossRef Ritzman, L. P., Krajewski, L. J., & Showalter, M. J. (1976). The disaggregation of aggregate manpower plans. Management Science, 22(11), 1204–1214.CrossRef
Zurück zum Zitat Rong, A. (2010). Monthly tour scheduling models with mixed skills considering weekend off requirements. Computers & Industrial Engineering, 59(2), 334–343.CrossRef Rong, A. (2010). Monthly tour scheduling models with mixed skills considering weekend off requirements. Computers & Industrial Engineering, 59(2), 334–343.CrossRef
Zurück zum Zitat Salvagnin, D., & Walsh, T. (2012). A hybrid MIP/CP approach for multi-activity shift scheduling. In M. Milano (Ed.), Principles and practice of constraint programming. Lecture notes in computer science (pp. 633–646). Berlin/Heidelberg: Springer.CrossRef Salvagnin, D., & Walsh, T. (2012). A hybrid MIP/CP approach for multi-activity shift scheduling. In M. Milano (Ed.), Principles and practice of constraint programming. Lecture notes in computer science (pp. 633–646). Berlin/Heidelberg: Springer.CrossRef
Zurück zum Zitat Showalter, M. J., & Mabert, V. A. (1988). An evaluation of a full-/part-time tour scheduling methodology. International Journal of Operations & Production Management, 8(7), 54–71.CrossRef Showalter, M. J., & Mabert, V. A. (1988). An evaluation of a full-/part-time tour scheduling methodology. International Journal of Operations & Production Management, 8(7), 54–71.CrossRef
Zurück zum Zitat Thompson, G. M. (2003). Labor scheduling a commentary. Cornell Hotel and Restaurant Administration Quarterly, 44(5–6), 149–155. Thompson, G. M. (2003). Labor scheduling a commentary. Cornell Hotel and Restaurant Administration Quarterly, 44(5–6), 149–155.
Zurück zum Zitat Tien, J. M., & Kamiyama, A. (1982). On manpower scheduling algorithms. Siam Review, 24(3), 275–287.CrossRef Tien, J. M., & Kamiyama, A. (1982). On manpower scheduling algorithms. Siam Review, 24(3), 275–287.CrossRef
Zurück zum Zitat Topaloglu, S., & Ozkarahan, I. (2004). An implicit goal programming model for the tour scheduling problem considering the employee work preferences. Annals of Operations Research, 128(1–4), 135–158.CrossRef Topaloglu, S., & Ozkarahan, I. (2004). An implicit goal programming model for the tour scheduling problem considering the employee work preferences. Annals of Operations Research, 128(1–4), 135–158.CrossRef
Zurück zum Zitat Trivedi, V. M. (1981). A mixed-integer goal programming model for nursing service budgeting. Operations Research, 29(5), 1019–1034.CrossRef Trivedi, V. M. (1981). A mixed-integer goal programming model for nursing service budgeting. Operations Research, 29(5), 1019–1034.CrossRef
Zurück zum Zitat Troncoso, G., Muñoz, J. C., Ferrer, J. C., & de Grange, L. (2014). Assessing salesforce marginal productivity. Applied Economics, 46(13), 1465–1475.CrossRef Troncoso, G., Muñoz, J. C., Ferrer, J. C., & de Grange, L. (2014). Assessing salesforce marginal productivity. Applied Economics, 46(13), 1465–1475.CrossRef
Zurück zum Zitat Van den Bergh, J., Beliën, J., Bruecker, P. D., Demeulemeester, E., & Boeck, L. D. (2013). Personnel scheduling: A literature review. European Journal of Operational Research, 226(3), 367–385.CrossRef Van den Bergh, J., Beliën, J., Bruecker, P. D., Demeulemeester, E., & Boeck, L. D. (2013). Personnel scheduling: A literature review. European Journal of Operational Research, 226(3), 367–385.CrossRef
Metadaten
Titel
A mixed integer programming approach to multi-skilled workforce scheduling
verfasst von
Rodolfo Cuevas
Juan-Carlos Ferrer
Mathias Klapp
Juan-Carlos Muñoz
Publikationsdatum
01.02.2016
Verlag
Springer US
Erschienen in
Journal of Scheduling / Ausgabe 1/2016
Print ISSN: 1094-6136
Elektronische ISSN: 1099-1425
DOI
https://doi.org/10.1007/s10951-015-0450-0

Weitere Artikel der Ausgabe 1/2016

Journal of Scheduling 1/2016 Zur Ausgabe

Premium Partner