Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system
DOI:
https://doi.org/10.4025/actascitechnol.v36i3.14928Keywords:
excel, linear program, permutation flow shopAbstract
Current research addresses the Permutation Flow Shop scheduling problem, characterized as Production Scheduling in Batch Process (PSBP) to minimize total time to complete the schedule (Makespan). A method to approach the problem of production scheduling is to turn it into Mixed Integer Linear Programming (MILP) and to solve it by using commercial mathematical programming packages. An electronic spreadsheet with user-friendly interface (ESUFI) was developed in Microsoft Excel. Results showed that it is possible to use ESUFI to solve small problems.
Â
Downloads
Downloads
Published
Issue
Section
License
DECLARATION OF ORIGINALITY AND COPYRIGHTS
I Declare that current article is original and has not been submitted for publication, in part or in whole, to any other national or international journal.
The copyrights belong exclusively to the authors. Published content is licensed under Creative Commons Attribution 4.0 (CC BY 4.0) guidelines, which allows sharing (copy and distribution of the material in any medium or format) and adaptation (remix, transform, and build upon the material) for any purpose, even commercially, under the terms of attribution.
Read this link for further information on how to use CC BY 4.0 properly.
8.png){kind=logo}
