Journals / Uluslararası Mühendislik Araştırma ve Geliştirme Dergisi / 2020 / Cilt: 12 - Sayı: 2

An Excel Solver Model For Personnel Task Scheduling Problem: Application Of Medium Voltage Fuse Production

Personel Görev Çizelgeleme Problemi İçin Bir Excel Çözücü Modeli: Orta Gerilim Sigorta Üretimi Uygulaması

Pages
729–744
Publication Date
2020-06-30
DOI
—
🏛️Bibliographic metadata and full text access for this article are provided via DergiPark.
DergiPark Record ↗
✨

AI Summary & Key Takeaways

AI Insight
⚡ TL;DR(Too Long; Didn't Read)

Thanks to the proposed worksheet solution, a significant contribution has been made to the efficient and productive use of the workforce in the firm.

📌 3 Key Takeaways

🎯
Objective & Hypothesis:Along with increasing labor costs, labor-intensive firms tend to use the labor force more effective and balanced.
📊
Key Findings & Data:In order to measure the effectiveness of the Excel solver model, mathematical model results are compared with the solver’s performance.
💡
Conclusion & Impact:Thanks to the proposed worksheet solution, a significant contribution has been made to the efficient and productive use of the workforce in the firm.
🔬Design:Modeling & Simulation
📍Scope:Comprehensive Sample
⚙️Variables:Personel görev çizelgeleme problemi · İşgücü dengeleme · Matematiksel modelleme

Abstract

Along with increasing labor costs, labor-intensive firms tend to use the labor force more effective and balanced. For this reason, firms want to employ their personnel as to possible as maximum tasks. The personnel task scheduling problem is defined as the problem of assigning tasks to the personnel while one or more objectives are optimized. In this study, a mathematical model has been proposed for personnel task scheduling problem. The model is solved by using the Excel spreadsheet and Solver tool. The real-life data obtained from a firm that produces the medium voltage fuses are used in problem-solving. The proposed mathematical model is solved by using this real data. In order to measure the effectiveness of the Excel solver model, mathematical model results are compared with the solver’s performance. Thanks to the proposed worksheet solution, a significant contribution has been made to the efficient and productive use of the workforce in the firm.

Özet

Artan işçilik maliyetleri ile birlikte, işçi yoğun çalışan işletmeler işgücünü daha etkin ve dengeli olarak kullanmaya yönelmektedir. Bu sebeple işletmeler ellerinde bulundurdukları personeli mümkün olduğu kadar maksimum görevde kullanmaya çalışmak istemektedirler. Bir veya birden fazla amacı en iyileyecek şekilde personellere görevlerin atanması problemi personel görev çizelgeleme problemi olarak tanımlanmaktadır. Bu çalışmada personel görev çizelgeleme problemi için bir matematiksel model önerilmiştir. Model Excel çalışma sayfası ve Çözücü aracı kullanılarak çözülmüştür. Problem çözümünde orta gerilim sigorta üretimi yapan bir işletmeden elde edilen gerçek veriler kullanılmıştır. Bu gerçek veriler kullanılarak önerilen matematiksel model çözülmüştür. Excel çözücü modelinin etkinliğini ölçmek için matematiksel model sonuçları ile çözücü performansı karşılaştırmalı olarak verilmiştir. Önerilen çalışma sayfası çözümü sayesinde işletmede işgücünün daha etkin ve verimli kullanılmasına önemli ölçüde katkı sağlanmıştır.

🔖

Cite This Article

PINARBAŞI, M., ALAKAŞ, H. M. (2020). An Excel Solver Model For Personnel Task Scheduling Problem: Application Of Medium Voltage Fuse Production. Uluslararası Mühendislik Araştırma ve Geliştirme Dergisi, Cilt: 12 - Sayı: 2, 729–744. https://ajindex.com/articles/889318

📄 Full Text PDF Viewer

📄

PDF görüntüleyici hazırlanıyor...

References (13)

  1. Ağralı, S., Taşkın, Z.C., & Ünal, A.T. (2017). Employee scheduling in service industries with flexible employee availability and demand. Omega, 66, 159-169.
  2. 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, 119–142.
  3. Ashley, D.W. (1995). A spreadsheet optimization system for library staff scheduling. Computers & Operations Research, 22(6), 615-624.
  4. Bhulai, S., Koole, G., & Pot, A. (2008). Simple methods for shift scheduling in multiskill call centers. Manufacturing & Service Operations Management, 10(3), 411-420.
  5. Boute, R.N., & Lambrecht, M.R. (2009). Exploring the bullwhip effect by means of spreadsheet simulation. INFORMS Transactions on Education, 10(1), 1-9.
  6. Boyer, V., Gendron, B., & Rousseau, L.M. (2014). A branch-and-price algorithm for the multi-activity multi-task shift scheduling problem. Journal of Scheduling, 17(2), 185-197.
  7. Brezulianu, A., Fira, M., & Fira, L. (2009). A genetic algorithm approach for a constrained employee scheduling problem as applied to employees at mall type shops. Proceedings of the 2009 International Conference on Hybrid Information Technology, Dong Seoul University, Korea, ACM. Brunner, J.O., Bard, J.F., & Kolisch, R. (2009). Flexible shift scheduling of physicians. Health Care Management Science, 12(3), 285-305.
  8. Cuevas, R., Ferrer, J.C., Klapp, M., & Muñoz, J.C. (2016). A mixed integer programming approach to multi-skilled workforce scheduling. Journal of Scheduling, 19(1), 91-106.
  9. Cunha, C.B., & Fernando, M. (2007). A spreadsheet-based optimization model for the integrated problem of producing and distributing a major weekly newsmagazine. European Journal of Operational Research, 176(2), 925-940.
  10. Drezet, L.E., & Billaut, J.C. (2008). Employee scheduling in an IT company. Resource‐Constrained Project Scheduling: Models, Algorithms, Extensions and Applications, 243-255.
  11. Erdoğan, G. (2017). An open source spreadsheet solver for vehicle routing problems. Computers & Operations Research, 84, 62-72.
  12. Fırat, M., & Hurkens, C.A.J. (2012). An improved MIP-based approach for a multi-skill workforce scheduling problem., Journal of Scheduling, 15(3), 363-380.
  13. Günther, M., & Nissen, V. (2010). Particle swarm optimization and an agent-based algorithm for a problem of staff scheduling. European Conference on the Applications of Evolutionary Computation. Berlin: Springer-Heidelberg. Hojati, M. (2018). A g