Preliminary work towards development of a dynamic job shop scheduling model

Abstract

This paper presents a preliminary work on a development of dynamic job shop scheduling model. The motivation of the study comes from an urgent need for practical procedures to enable easier and accurate feedback at operational level particularly related to job shop in small and medium-sized companies. A spreadsheet-based scheduling template is formulated and modeled using Microsoft Excel. A job shop benchmark case study available in OR-Library has been chosen to demonstrate the applicability of the basic model. The preliminary result indicating that the proposed spreadsheet model needs further refinement through incorporation of dynamic factors to be obtained from industrial practitioners.