Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system

Rony Peterson da Rocha, Mauro Antônio Silva Sá Ravagnani, Cid Marcos Gonçalves Andrade, Paulo Roberto Paraíso


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.



excel; linear program; permutation flow shop

Texto completo:

PDF (English) (baixado


ISSN 1806-2563 (impresso) e ISSN 1807-8664 (on-line) e-mail:


Resultado de imagem para CC BY