Record Details

Use of Excel worksheets with user-friendly interface in batch process (PSBP) to minimize the makespan

Independent Journal of Management & Production

View Archive Info
 
 
Field Value
 
Title Use of Excel worksheets with user-friendly interface in batch process (PSBP) to minimize the makespan
 
Creator Rocha, Rony Peterson da
Rocha, Fabrício Wesley da
Ravagnani, Mauro Antônio S. S.
Paraíso, Paulo Roberto
Andrade, Cid Marcos Gonçalves
 
Subject Pesquisa Operacional; Planejamento e Programação da Produção; Otimização.
Excel; Permutation Flow Shop; Mixed Integer Linear Programming - MILP
 
Description In the chemical industry, the necessity for scheduling is becoming more pronounced, especially in batch production mode. Nowadays, planning industrial activities is a necessity for survival. Intense competition requires diversified products and delivery in accordance with the requirements of consumers. These activities require quick decision making and the lowest possible cost, through an efficient Production Scheduling. So, this work addresses the Permutation Flow Shop scheduling problem, characterized as Production Scheduling in Batch Process (PSBP), with the objective of minimizing the 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 using commercial mathematical programming packages. In this study an electronic spreadsheet with user-friendly interface (ESUFI) was developed in Microsoft Excel. The ease of manipulation of the ESUFI is quite evident, as with the use of VBA language a user-friendly interface could be created between the user and the spreadsheet itself. The results showed that it is possible to use the ESUFI for small problems.
 
Publisher Instituto Federal de Educação, Ciência e Tecnologia de São Paulo
 
Contributor —
 
Date 2014-01-01
 
Type info:eu-repo/semantics/article
info:eu-repo/semantics/publishedVersion
—
 
Format application/pdf
text/html
 
Identifier http://www.ijmp.jor.br/index.php/ijmp/article/view/78
10.14807/ijmp.v5i1.78
 
Source Independent Journal of Management & Production; Vol 5, No 1 (2014): Independent Journal of Management & Production; 142-165
2236-269X
 
Language eng
 
Relation http://www.ijmp.jor.br/index.php/ijmp/article/view/78/92
http://www.ijmp.jor.br/index.php/ijmp/article/view/78/363