Zgadzam się
Nasza strona zapisuje niewielkie pliki tekstowe, nazywane ciasteczkami (ang. cookies) na Twoim urządzeniu w celu lepszego dostosowania treści oraz dla celów statystycznych. Możesz wyłączyć możliwość ich zapisu, zmieniając ustawienia Twojej przeglądarki. Korzystanie z naszej strony bez zmiany ustawień oznacza zgodę na przechowywanie cookies w Twoim urządzeniu.
Proper sequencing of tasks on technological machines remains a crucial element in each manufacturing company. Designing an optimal schedule may seem to be a fairly simple problem. Nevertheless, scheduling is a subject to numerous constraints which limit and prevent the use of effective scheduling methods in a real production environment. Although there is a considerable amount of academic literature in the field of scheduling production jobs, the proposed solutions have a limited educational value. Because of NP-hard character of schedule’s optimization problem, it is usually necessary to use specific and often very expensive software to teach students or process engineers the idea of scheduling, and how different scheduling rules presented in the literature influence production effectiveness. Therefore, we decided to develop a universal and simple IT tool that supports an education process in the area of operation management and allows to present a general idea of schedule design, to compare different scheduling algorithms and to find an optimal production schedule by means of complete search algorithm. The paper presents an original solution dedicated to educational purposes that allows to teach students or future process engineers how to design manufacturing schedules, what the priority rules are and how the schedules can be optimized. In order to develop the presented solution, the MS Excel spreadsheet was used. Moreover, the integrated optimizer and VBA language were used to make the necessary calculations and optimization process. The mode of action of the developed solution was illustrated with an example including 10 production tasks with 10 different operations.
