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

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

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 Progra...

Full description

Bibliographic Details
Main Authors: Rony Peterson da Rocha, Mauro Antônio Silva Sá Ravagnani, Cid Marcos Gonçalves Andrade, Paulo Roberto Paraíso
Format: Article
Language:English
Published: Universidade Estadual de Maringá 2014-02-01
Series:Acta Scientiarum: Technology
Subjects:
excel
linear program
permutation flow shop
Online Access:http://186.233.154.254/ojs/index.php/ActaSciTechnol/article/view/14928
id doaj-ee46e8283b4d45cd803370c4292d3dc2
record_format Article
spelling doaj-ee46e8283b4d45cd803370c4292d3dc22020-11-25T01:29:47ZengUniversidade Estadual de MaringáActa Scientiarum: Technology1806-25631807-86642014-02-0136345346110.4025/actascitechnol.v36i3.1492810819<b>Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production systemRony Peterson da Rocha0Mauro Antônio Silva Sá Ravagnani1Cid Marcos Gonçalves Andrade2Paulo Roberto Paraíso3Universidade Estadual do ParanáUniversidade Estadual de MaringáUniversidade Estadual de MaringáUniversidade Estadual de Maringá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.http://186.233.154.254/ojs/index.php/ActaSciTechnol/article/view/14928excellinear programpermutation flow shop
collection DOAJ
language English
format Article
sources DOAJ
author Rony Peterson da Rocha
Mauro Antônio Silva Sá Ravagnani
Cid Marcos Gonçalves Andrade
Paulo Roberto Paraíso
spellingShingle Rony Peterson da Rocha
Mauro Antônio Silva Sá Ravagnani
Cid Marcos Gonçalves Andrade
Paulo Roberto Paraíso
<b>Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system
Acta Scientiarum: Technology
excel
linear program
permutation flow shop
author_facet Rony Peterson da Rocha
Mauro Antônio Silva Sá Ravagnani
Cid Marcos Gonçalves Andrade
Paulo Roberto Paraíso
author_sort Rony Peterson da Rocha
title <b>Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system
title_short <b>Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system
title_full <b>Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system
title_fullStr <b>Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system
title_full_unstemmed <b>Use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system
title_sort <b>use of excel worksheets with user-friendly interface to minimize the makespan in a permutation flow shop production system
publisher Universidade Estadual de Maringá
series Acta Scientiarum: Technology
issn 1806-2563
1807-8664
publishDate 2014-02-01
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.
topic excel
linear program
permutation flow shop
url http://186.233.154.254/ojs/index.php/ActaSciTechnol/article/view/14928
work_keys_str_mv AT ronypetersondarocha buseofexcelworksheetswithuserfriendlyinterfacetominimizethemakespaninapermutationflowshopproductionsystem
AT mauroantoniosilvasaravagnani buseofexcelworksheetswithuserfriendlyinterfacetominimizethemakespaninapermutationflowshopproductionsystem
AT cidmarcosgoncalvesandrade buseofexcelworksheetswithuserfriendlyinterfacetominimizethemakespaninapermutationflowshopproductionsystem
AT paulorobertoparaiso buseofexcelworksheetswithuserfriendlyinterfacetominimizethemakespaninapermutationflowshopproductionsystem
_version_ 1725094703008841728

Similar Items