Use of Excel worksheets with user-friendly interface in batch process (PSBP) to minimize the makespan
Article Sidebar
Main Article Content
صندلی اداریAbstract
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.
Downloads
Article Details
1. Proposal of Policy for Free Access Periodics
Authors whom publish in this magazine should agree to the following terms:
a. Authors should keep the copyrights and grant to the magazine the right of the first publication, with the work simultaneously permitted under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 that allows the sharing of the work with recognition of the authorship of the work and initial publication in this magazine.
b. Authors should have authorization for assuming additional contracts separately, for non-exclusive distribution of the version of the work published in this magazine (e.g.: to publish in an institutional repository or as book chapter), with recognition of authorship and initial publication in this magazine.
c. Authors should have permission and should be stimulated to publish and to distribute its work online (e.g.: in institutional repositories or its personal page) to any point before or during the publishing process, since this can generate productive alterations, as well as increasing the impact and the citation of the published work (See The Effect of Free Access).
Proposal of Policy for Periodic that offer Postponed Free Access
Authors whom publish in this magazine should agree to the following terms:
a. Authors should keep the copyrights and grant to the magazine the right of the first publication, with the work simultaneously permitted under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 [SPECIFY TIME HERE] after the publication, allowing the sharing of the work with recognition of the authorship of the work and initial publication in this magazine.
b. Authors should have authorization for assuming additional contracts separately, for non-exclusive distribution of the version of the work published in this magazine (e.g.: to publish in institutional repository or as book chapter), with recognition of authorship and initial publication in this magazine.
c. Authors should have permission and should be stimulated to publish and to distribute its work online (e.g.: in institutional repositories or its personal page) to any point before or during the publishing process, since this can generate productive alterations, as well as increasing the impact and the citation of the published work (See The Effect of Free Access).
d. They allow some kind of open dissemination. Authors can disseminate their articles in open access, but with specific conditions imposed by the editor that are related to:
Version of the article that can be deposited in the repository:
Pre-print: before being reviewed by pairs.
Post-print: once reviewed by pairs, which can be:
The version of the author that has been accepted for publication.
The editor's version, that is, the article published in the magazine.
At which point the article can be made accessible in an open manner: before it is published in the magazine, immediately afterwards or if a period of seizure is required, which can range from six months to several years.
Where to leave open: on the author's personal web page, only departmental websites, the repository of the institution, the file of the research funding agency, among others.
References
BAKER, K. R. (1974) Introduction to Sequencing and Scheduling. NEW York: John Wiley & Sons, Inc.
BOIKO, T. J. P. (2008) Métodos heurísticos para a programação em flow shop permutacional com tempos de setup separados dos tempos de processamento e independentes da seqüência de tarefas. 207 f. Dissertation (Master Degree in Production Engineering)- São Carlos Engineering School, São Paulo University - USP, São Carlos. Available at: http://www.dominiopublico.gov.br/download/texto/cp058596.pdf. Accessible in: 10/03/2013
MACCARTHY, B. L.; LIU, J. Y. (1993) Addressing the Gap in Scheduling Research: A Review of Optimization and Heuristic Methods in Production Scheduling. International journal of Production Research, London, n. 31, p. 59-79.
MENDÉZ, C. A. et al. (2006) State-of-the-art Review of Optimization Methods for Short-term Scheduling of Batch Processes. Computers and Chemical Engineering, n. 30, p. 913-946.
MOCCELLIN, J. V. (1995) A New Heuristic Method for the Permutation Flow Shop Scheduling Problem. Journal of the Operational research Society. Oxford, n. 46, p. 883-886.
POLON, P. E.; ANDRADE, C. M. G.; PARAÍSO, P. R.; JORGE, L. M. M. (2006) Utilização de Planilha Eletrônica na Resolução de Problemas de Planejamento e Programação da Produção. XXXIV COBENGE, Passo Fundo: Ed. Passo Fundo University, September. Available at: http://www.dee.ufma.br/~fsouza/anais/arquivos/1_207_804.pdf. Accessible in: 01/08/2012
POLON, P. E. (2010) Otimização da Produção da Indústria de Embutidos, PEQ/UEM, Maringá- PR (Thesis), 115 p. (Doctorate in Chemical Engineering) – Chemical Engineering Graduate Program, State University of Maringá.
REKLAITIS, G. V. (1995) Scheduling Approaches for the Batch Process Industries. ISA Transactions, n. 34, p. 349–358.
SEVERO, L. S. (2007) Aplicação de Modelo de Programação da Produção na Indústria de Couros, PEQ/UFRGS, Porto Alegre- RS (Dissertation), 96p. (Master Degree in Chemical Engineering) – Chemical Engineering Graduate Program, Federal University of Rio Grande do Sul.
TAILLARD, E. (1993) Benchmarks for Basic Scheduling Problems. European Journal of Operational Research, Amsterdam, n. 64, p. 278-285.