Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system
Autor(a) principal: | |
---|---|
Data de Publicação: | 2014 |
Outros Autores: | , , |
Tipo de documento: | Artigo |
Idioma: | eng |
Título da fonte: | Acta scientiarum. Technology (Online) |
Texto Completo: | http://www.periodicos.uem.br/ojs/index.php/ActaSciTechnol/article/view/14928 |
Resumo: | 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. |
id |
UEM-6_0c107af3eac5c26caf460e0d83b16356 |
---|---|
oai_identifier_str |
oai:periodicos.uem.br/ojs:article/14928 |
network_acronym_str |
UEM-6 |
network_name_str |
Acta scientiarum. Technology (Online) |
repository_id_str |
|
spelling |
Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production systemexcellinear programpermutation flow shopProgramação Linear MistaCurrent 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. Universidade Estadual De Maringá2014-02-26info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionModelagem matemática; Visual Basicapplication/pdfhttp://www.periodicos.uem.br/ojs/index.php/ActaSciTechnol/article/view/1492810.4025/actascitechnol.v36i3.14928Acta Scientiarum. Technology; Vol 36 No 3 (2014); 453-461Acta Scientiarum. Technology; v. 36 n. 3 (2014); 453-4611806-25631807-8664reponame:Acta scientiarum. Technology (Online)instname:Universidade Estadual de Maringá (UEM)instacron:UEMenghttp://www.periodicos.uem.br/ojs/index.php/ActaSciTechnol/article/view/14928/pdf_12Rocha, Rony Peterson daRavagnani, Mauro Antônio Silva SáAndrade, Cid Marcos GonçalvesParaíso, Paulo Robertoinfo:eu-repo/semantics/openAccess2014-06-27T15:05:00Zoai:periodicos.uem.br/ojs:article/14928Revistahttps://www.periodicos.uem.br/ojs/index.php/ActaSciTechnol/indexPUBhttps://www.periodicos.uem.br/ojs/index.php/ActaSciTechnol/oai||actatech@uem.br1807-86641806-2563opendoar:2014-06-27T15:05Acta scientiarum. Technology (Online) - Universidade Estadual de Maringá (UEM)false |
dc.title.none.fl_str_mv |
Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system |
title |
Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system |
spellingShingle |
Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system Rocha, Rony Peterson da excel linear program permutation flow shop Programação Linear Mista |
title_short |
Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system |
title_full |
Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system |
title_fullStr |
Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system |
title_full_unstemmed |
Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system |
title_sort |
Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system |
author |
Rocha, Rony Peterson da |
author_facet |
Rocha, Rony Peterson da Ravagnani, Mauro Antônio Silva Sá Andrade, Cid Marcos Gonçalves Paraíso, Paulo Roberto |
author_role |
author |
author2 |
Ravagnani, Mauro Antônio Silva Sá Andrade, Cid Marcos Gonçalves Paraíso, Paulo Roberto |
author2_role |
author author author |
dc.contributor.author.fl_str_mv |
Rocha, Rony Peterson da Ravagnani, Mauro Antônio Silva Sá Andrade, Cid Marcos Gonçalves Paraíso, Paulo Roberto |
dc.subject.por.fl_str_mv |
excel linear program permutation flow shop Programação Linear Mista |
topic |
excel linear program permutation flow shop Programação Linear Mista |
description |
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. |
publishDate |
2014 |
dc.date.none.fl_str_mv |
2014-02-26 |
dc.type.driver.fl_str_mv |
info:eu-repo/semantics/article info:eu-repo/semantics/publishedVersion Modelagem matemática; Visual Basic |
format |
article |
status_str |
publishedVersion |
dc.identifier.uri.fl_str_mv |
http://www.periodicos.uem.br/ojs/index.php/ActaSciTechnol/article/view/14928 10.4025/actascitechnol.v36i3.14928 |
url |
http://www.periodicos.uem.br/ojs/index.php/ActaSciTechnol/article/view/14928 |
identifier_str_mv |
10.4025/actascitechnol.v36i3.14928 |
dc.language.iso.fl_str_mv |
eng |
language |
eng |
dc.relation.none.fl_str_mv |
http://www.periodicos.uem.br/ojs/index.php/ActaSciTechnol/article/view/14928/pdf_12 |
dc.rights.driver.fl_str_mv |
info:eu-repo/semantics/openAccess |
eu_rights_str_mv |
openAccess |
dc.format.none.fl_str_mv |
application/pdf |
dc.publisher.none.fl_str_mv |
Universidade Estadual De Maringá |
publisher.none.fl_str_mv |
Universidade Estadual De Maringá |
dc.source.none.fl_str_mv |
Acta Scientiarum. Technology; Vol 36 No 3 (2014); 453-461 Acta Scientiarum. Technology; v. 36 n. 3 (2014); 453-461 1806-2563 1807-8664 reponame:Acta scientiarum. Technology (Online) instname:Universidade Estadual de Maringá (UEM) instacron:UEM |
instname_str |
Universidade Estadual de Maringá (UEM) |
instacron_str |
UEM |
institution |
UEM |
reponame_str |
Acta scientiarum. Technology (Online) |
collection |
Acta scientiarum. Technology (Online) |
repository.name.fl_str_mv |
Acta scientiarum. Technology (Online) - Universidade Estadual de Maringá (UEM) |
repository.mail.fl_str_mv |
||actatech@uem.br |
_version_ |
1799315334408175616 |