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

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: - -

DOI: 10.5151/siintec2023-306330

Referências bibliográficas

• [1] Desempenho da indústria química brasileira 2021. Associação brasileira da indústria química, 2021. 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, 1981. [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 23577592, DOI 10.5151/siintec2023-306330