Otimização computacional da elaboração de propostas de misturas de suco concentrado na indústria de suco de laranja
Carregando...
Data
2022-08-05
Autores
Bula, Eduardo Silveira
Título da Revista
ISSN da Revista
Título de Volume
Editor
Universidade Estadual Paulista (Unesp)
Resumo
A indústria de suco de laranja concentrado possui a necessidade de
realizar misturas de seus produtos para atender especificações de clientes,
tendo em vista que as propriedades do suco dependem de fatores como a
quantidade de chuva, a região de plantio e a época da colheita. O processo de
elaboração de misturas é um elo importante que une o planejamento comercial
e industrial ao inventário disponível. Este processo é realizado de forma manual
e demanda demasiado tempo para ser realizado (em média 8 horas). Sendo
assim, a aplicação de metodologias computacionais busca aumentar a eficiência
e gerar resultados mais assertivos. Para isso, foi desenvolvido um modelo
computacional que resolve o problema por meio do método Simplex, utilizando
as ferramentas Microsoft ExcelTM e a programação em Python®, buscando tornar
a elaboração de propostas de mistura um processo mais rápido, assertivo e de
fácil uso, que após a implementação, aumentou a capacidade de atender
demandas, reduzindo o tempo de elaboração de proposta para uma média de
30 a 40 minutos, com um aumento de 40% na taxa de aprovação de propostas.
The concentrated orange juice industry has the need to mix its products to meet customer specifications, given that the properties of the juice depend on factors such as the amount of rain, the region of planting and the time of harvest. The blending process is an important link that links commercial and industrial planning to available inventory. This process is performed manually and takes a long time to be carried out (an average of 8 hours). Therefore, the application of computational methodologies seeks to increase efficiency and generate more assertive results. For this, a computational model was developed that solves the problem through the Simplex method, using Microsoft ExcelTM tools and Python® programming, seeking to make the elaboration of mixing proposals a faster, assertive and easy-to-use process, which after implementation, increased capacity to meet demands, reducing proposal preparation time to an average of 30-40 minutes, with a 40% increase in proposal approval rate.
The concentrated orange juice industry has the need to mix its products to meet customer specifications, given that the properties of the juice depend on factors such as the amount of rain, the region of planting and the time of harvest. The blending process is an important link that links commercial and industrial planning to available inventory. This process is performed manually and takes a long time to be carried out (an average of 8 hours). Therefore, the application of computational methodologies seeks to increase efficiency and generate more assertive results. For this, a computational model was developed that solves the problem through the Simplex method, using Microsoft ExcelTM tools and Python® programming, seeking to make the elaboration of mixing proposals a faster, assertive and easy-to-use process, which after implementation, increased capacity to meet demands, reducing proposal preparation time to an average of 30-40 minutes, with a 40% increase in proposal approval rate.
Descrição
Palavras-chave
Programação linear, Otimização, Suco de laranja