Banana sales forecasting model of an agricultural unit, in Ceará, Brazil

Detalhes bibliográficos
Autor(a) principal: Lima, Jaqueline de Jesus
Data de Publicação: 2020
Outros Autores: Oliveira, Mauro Macedo de
Tipo de documento: Artigo
Idioma: por
Título da fonte: Revista Produção Online
Texto Completo: https://www.producaoonline.org.br/rpo/article/view/4012
Resumo: The importance of planning future needs arises from the requirements of decision-making processes, since all businesses are susceptible to unforeseen events and need to be flexible. In the process of carrying out aggregate planning, it is important to know the demand to scale the productive capacity. A forecast study was carried out at a company in Ceará, Brazil, where burro and yellow cavendish bananas are produced on 330 acres. This work is an explanatory and quantitative research, in which historical sales data were initially collected and then their behavior was verified using statistical tests. The burro banana was chosen for its representativeness to the company. Growth trend and seasonality behaviors were identified. After this verification, the ARIMA and Holt-Winters methods were applied for the burro banana in order to identify the method that was best suited. This becomes essential to avoid imbalances between the production and commercial team. The method that presented the best results were ARIMA (1,1,1) with MAD, MAPE and MSD as validation criteria.
id ABEPRO-2_cd8659bcd76d3c482d06471eb6a6abec
oai_identifier_str oai:ojs.emnuvens.com.br:article/4012
network_acronym_str ABEPRO-2
network_name_str Revista Produção Online
repository_id_str
spelling Banana sales forecasting model of an agricultural unit, in Ceará, BrazilModelagem da previsão de vendas de uma unidade agrícola produtora de bananas em Missão Velha (CE)Demand forecastPlanning and production controlBanana productionPrevisão de demandaPlanejamento e controle da produçãoBananiculturaThe importance of planning future needs arises from the requirements of decision-making processes, since all businesses are susceptible to unforeseen events and need to be flexible. In the process of carrying out aggregate planning, it is important to know the demand to scale the productive capacity. A forecast study was carried out at a company in Ceará, Brazil, where burro and yellow cavendish bananas are produced on 330 acres. This work is an explanatory and quantitative research, in which historical sales data were initially collected and then their behavior was verified using statistical tests. The burro banana was chosen for its representativeness to the company. Growth trend and seasonality behaviors were identified. After this verification, the ARIMA and Holt-Winters methods were applied for the burro banana in order to identify the method that was best suited. This becomes essential to avoid imbalances between the production and commercial team. The method that presented the best results were ARIMA (1,1,1) with MAD, MAPE and MSD as validation criteria.A importância de planejar as necessidades futuras surge das exigências dos processos decisórios, uma vez que todos os negócios estão suscetíveis a imprevistos e necessitam ter flexibilidade. No processo de realização do planejamento estratégico é de grande importância incluir a previsão de demanda para dimensionar a capacidade produtiva. Um estudo de previsão demanda foi desenvolvido numa empresa de 330 hectares que cultiva bananas prata e nanica, localizada na cidade de Missão Velha, estado do Ceará. Este trabalho consiste numa pesquisa explicativa com abordagem quantitativa, onde inicialmente foram levantados os dados históricos de vendas e em seguida verificados seus comportamentos a partir de testes estatísticos. Foi escolhida a banana prata pela sua representatividade para a empresa. Identificou-se comportamentos de tendência e sazonalidade. Após essa constatação aplicou-se os métodos ARIMA e Holt-Winters a fim de identificar o método que melhor se adequava, com o intuito de evitar desequilíbrios entre a equipe de produção e comercial. O método que apresentou os melhores resultados foi o ARIMA (1,1,1), tendo como critério para a validação o MAD, MAPE e MSD.Associação Brasileira de Engenharia de Produção2020-09-30info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersionapplication/pdfvideo/mp4https://www.producaoonline.org.br/rpo/article/view/401210.14488/1676-1901.v20i3.4012Revista Produção Online; Vol. 20 No. 3 (2020); 948-967Revista Produção Online; v. 20 n. 3 (2020); 948-9671676-1901reponame:Revista Produção Onlineinstname:Associação Brasileira de Engenharia de Produção (ABEPRO)instacron:ABEPROporhttps://www.producaoonline.org.br/rpo/article/view/4012/1949https://www.producaoonline.org.br/rpo/article/view/4012/1950Copyright (c) 2020 Revista Produção Onlineinfo:eu-repo/semantics/openAccessLima, Jaqueline de JesusOliveira, Mauro Macedo de2020-09-30T09:28:39Zoai:ojs.emnuvens.com.br:article/4012Revistahttp://producaoonline.org.br/rpoPUBhttps://www.producaoonline.org.br/rpo/oai||producaoonline@gmail.com1676-19011676-1901opendoar:2020-09-30T09:28:39Revista Produção Online - Associação Brasileira de Engenharia de Produção (ABEPRO)false
dc.title.none.fl_str_mv Banana sales forecasting model of an agricultural unit, in Ceará, Brazil
Modelagem da previsão de vendas de uma unidade agrícola produtora de bananas em Missão Velha (CE)
title Banana sales forecasting model of an agricultural unit, in Ceará, Brazil
spellingShingle Banana sales forecasting model of an agricultural unit, in Ceará, Brazil
Lima, Jaqueline de Jesus
Demand forecast
Planning and production control
Banana production
Previsão de demanda
Planejamento e controle da produção
Bananicultura
title_short Banana sales forecasting model of an agricultural unit, in Ceará, Brazil
title_full Banana sales forecasting model of an agricultural unit, in Ceará, Brazil
title_fullStr Banana sales forecasting model of an agricultural unit, in Ceará, Brazil
title_full_unstemmed Banana sales forecasting model of an agricultural unit, in Ceará, Brazil
title_sort Banana sales forecasting model of an agricultural unit, in Ceará, Brazil
author Lima, Jaqueline de Jesus
author_facet Lima, Jaqueline de Jesus
Oliveira, Mauro Macedo de
author_role author
author2 Oliveira, Mauro Macedo de
author2_role author
dc.contributor.author.fl_str_mv Lima, Jaqueline de Jesus
Oliveira, Mauro Macedo de
dc.subject.por.fl_str_mv Demand forecast
Planning and production control
Banana production
Previsão de demanda
Planejamento e controle da produção
Bananicultura
topic Demand forecast
Planning and production control
Banana production
Previsão de demanda
Planejamento e controle da produção
Bananicultura
description The importance of planning future needs arises from the requirements of decision-making processes, since all businesses are susceptible to unforeseen events and need to be flexible. In the process of carrying out aggregate planning, it is important to know the demand to scale the productive capacity. A forecast study was carried out at a company in Ceará, Brazil, where burro and yellow cavendish bananas are produced on 330 acres. This work is an explanatory and quantitative research, in which historical sales data were initially collected and then their behavior was verified using statistical tests. The burro banana was chosen for its representativeness to the company. Growth trend and seasonality behaviors were identified. After this verification, the ARIMA and Holt-Winters methods were applied for the burro banana in order to identify the method that was best suited. This becomes essential to avoid imbalances between the production and commercial team. The method that presented the best results were ARIMA (1,1,1) with MAD, MAPE and MSD as validation criteria.
publishDate 2020
dc.date.none.fl_str_mv 2020-09-30
dc.type.driver.fl_str_mv info:eu-repo/semantics/article
info:eu-repo/semantics/publishedVersion
format article
status_str publishedVersion
dc.identifier.uri.fl_str_mv https://www.producaoonline.org.br/rpo/article/view/4012
10.14488/1676-1901.v20i3.4012
url https://www.producaoonline.org.br/rpo/article/view/4012
identifier_str_mv 10.14488/1676-1901.v20i3.4012
dc.language.iso.fl_str_mv por
language por
dc.relation.none.fl_str_mv https://www.producaoonline.org.br/rpo/article/view/4012/1949
https://www.producaoonline.org.br/rpo/article/view/4012/1950
dc.rights.driver.fl_str_mv Copyright (c) 2020 Revista Produção Online
info:eu-repo/semantics/openAccess
rights_invalid_str_mv Copyright (c) 2020 Revista Produção Online
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
video/mp4
dc.publisher.none.fl_str_mv Associação Brasileira de Engenharia de Produção
publisher.none.fl_str_mv Associação Brasileira de Engenharia de Produção
dc.source.none.fl_str_mv Revista Produção Online; Vol. 20 No. 3 (2020); 948-967
Revista Produção Online; v. 20 n. 3 (2020); 948-967
1676-1901
reponame:Revista Produção Online
instname:Associação Brasileira de Engenharia de Produção (ABEPRO)
instacron:ABEPRO
instname_str Associação Brasileira de Engenharia de Produção (ABEPRO)
instacron_str ABEPRO
institution ABEPRO
reponame_str Revista Produção Online
collection Revista Produção Online
repository.name.fl_str_mv Revista Produção Online - Associação Brasileira de Engenharia de Produção (ABEPRO)
repository.mail.fl_str_mv ||producaoonline@gmail.com
_version_ 1761536951642488832