Scheduling in A Single-Stage, Multi-Item Compatible Process Using Multiple ARC Network Model and Excel Solver
Aljasser, Ibrahim Abdullah . 2018
In the present competitive business environment, a more customer driven approach to production scheduling is required. The criteria considered for production scheduling objectives are generally derived from some desired production performance factors of a manufacturing system. Generally, the customers’ orders are categorized as either normal or prioritized based on the delivery requirements. The production is planned against customers’ orders, keeping in mind the customers’ priorities. The problem of scheduling a given set of machines in a single-stage, multi-item compatible environment, with the objective of maximizing capacity utilization has been formulated (Bokkasam, 2016) as a maximal flow problem in a Multiple Arc Network (MAN). The model provides optimal production schedule with an objective of maximizing capacity utilization, so that the customer-wise delivery schedules are fulfilled, keeping in view the priorities of the customers. The results of a working implementation of the MAN model using excel solver are presented in this paper. The same has been validated with results obtained using two examples. In future the managers will be able to use the worksheet for obtaining the results immediately, for scaled-up scenarios. Keywords: Scheduling, Maximal Flow Problem, Multiple Arc Network Model, Optimization, Excel Solver.
The importance of scheduling in the industrial world is growing rapidly. Customer-driven production scheduling is the need of the hour in the present business environment.
Fixed charge transportation problem (FCTP), which can be considered as a
distribution problem, is considered to be an NP-hard problem. One of its versions is the Step Fixed
charge…
Service quality is a competitive weapon in the banking industry. Better understanding of customer’s perception
of service quality in the banking industry and the drivers of such perceptions…