Outubro 2023 vol. 10 num. 5 - IX Simpósio Internacional de Inovação e Tecnologia
Full article - Open Access.
DECISION SUPPORT TOOL FOR THE POLYMER INDUSTRY USING MICROSOFT EXCEL SOLVER
DECISION SUPPORT TOOL FOR THE POLYMER INDUSTRY USING MICROSOFT EXCEL SOLVER
Silva, Breno Freitas da ; Pessoa, Fernando Luiz Pellegrini ; Santos, Gustavo de Souza dos ; Santos, Ana Laise do Nascimento dos ; Pereira, Hernane Borges de Barros ;
Full article:
The products of the chemical industry, which includes the polymer industry, are present in today's society, and the demand for these products continues to grow throughout the year. However, the sector is not keeping up with the demands and is suffering from a lack of investment and decision support tools. The objective of this project was to evaluate Excel as a decision support tool in the polymer industry. A database was optimized using the GRG nonlinear model in Solver. The results showed that Solver alone is not the suitable tool for the type of optimization studied, as it selects scenarios that do not meet the defined constraints. Therefore, the use of VBA or other more popular software should be evaluated
Full article:
The products of the chemical industry, which includes the polymer industry, are present in today's society, and the demand for these products continues to grow throughout the year. However, the sector is not keeping up with the demands and is suffering from a lack of investment and decision support tools. The objective of this project was to evaluate Excel as a decision support tool in the polymer industry. A database was optimized using the GRG nonlinear model in Solver. The results showed that Solver alone is not the suitable tool for the type of optimization studied, as it selects scenarios that do not meet the defined constraints. Therefore, the use of VBA or other more popular software should be evaluated
Palavras-chave: Polymer industry, Petrochemical industry, Decision support tool, Excel,
Palavras-chave: Polymer industry, Petrochemical industry, Decision support tool, Excel,
DOI: 10.5151/siintec2023-306330
Referências bibliográficas
- [1] Desempenho da indústria química brasileira 202 Associação brasileira da indústria química, 202 Available at: Accessed on: 02 jul. 2023. [2] AFSHAR, S; et al. Advances in petrochemical technology assessment. Chemical Engineering Science. v. 36, n. 9, p. 1487-1511, 198 [3] JUNIOR, F. Avaliação da Indústria Petroquímica no Brasil: Desenvolvimento de Modelo via Programação Matemática. Rio de Janeiro, 2016. [4] BOAVENTURA, K. Modelo para planejamento futuro aplicado à indústria petroquímica. Rio de Janeiro, 2018. [5] GOMES, Gabriel. Indústria petroquímica brasileira: situação atual e perspectivas. BNDES. Available at: https://web.bndes.gov.br/bib/jspui/bitstream/1408/2485/1/BS%2021%20Ind%C3%BA stria%20petroqu%C3%ADmica%20brasileira_P.pdf Accessed on: 03 jul. 2023.
Como citar:
Silva, Breno Freitas da ; Pessoa, Fernando Luiz Pellegrini ; Santos, Gustavo de Souza dos; Santos, Ana Laise do Nascimento dos ; Pereira, Hernane Borges de Barros ; "DECISION SUPPORT TOOL FOR THE POLYMER INDUSTRY USING MICROSOFT EXCEL SOLVER", p. 501-508 . In: .
São Paulo: Blucher,
2023.
ISSN 2357-7592,
DOI 10.5151/siintec2023-306330
últimos 30 dias | último ano | desde a publicação
downloads
visualizações
indexações