Stochastic production planning with internal and external storage and ordering costs

Detalhes bibliográficos
Autor(a) principal: de Biazzi,Jorge Luiz
Data de Publicação: 2021
Tipo de documento: Artigo
Idioma: eng
Título da fonte: Gestão & Produção
Texto Completo: http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0104-530X2021000400205
Resumo: Abstract: This paper aims to compare different models to support decision making in production planning (and, consequently, in sales and inventory), in an environment where product demands are variable and uncertain, it is possible to produce at normal hours and overtime, loss of sales is consequence of stockouts, there is limit to internal storage, with possible and more expensive external storage, and ordering costs are non-negligible. At first, we present a linear and deterministic model, with known demand and without shortage. In the second model, safety stocks are calculated to meet a probabilistic demand, but it is not yet considered the possibility of shortage. The third model includes shortage calculation as a consequence from demand uncertainty. The last two models use an iterative process to re-estimate the unit cost of storage, needed to calculate safety stocks in each period of the planning horizon. The models were implemented in MSExcel, making use of linear programming and search functions available in the software. As the original problem, data of the examples are based on real companies. The study allows concluding that, in the problem analyzed, linear models, simpler and faster to execute, may be sufficient to support good decisions.
id UFSCAR-3_6925a4f9602cb1d3e5da314069cb7690
oai_identifier_str oai:scielo:S0104-530X2021000400205
network_acronym_str UFSCAR-3
network_name_str Gestão & Produção
repository_id_str
spelling Stochastic production planning with internal and external storage and ordering costsSales and operations planningDynamic and probabilistic demandAggregate production planningNon-negligible ordering costsAbstract: This paper aims to compare different models to support decision making in production planning (and, consequently, in sales and inventory), in an environment where product demands are variable and uncertain, it is possible to produce at normal hours and overtime, loss of sales is consequence of stockouts, there is limit to internal storage, with possible and more expensive external storage, and ordering costs are non-negligible. At first, we present a linear and deterministic model, with known demand and without shortage. In the second model, safety stocks are calculated to meet a probabilistic demand, but it is not yet considered the possibility of shortage. The third model includes shortage calculation as a consequence from demand uncertainty. The last two models use an iterative process to re-estimate the unit cost of storage, needed to calculate safety stocks in each period of the planning horizon. The models were implemented in MSExcel, making use of linear programming and search functions available in the software. As the original problem, data of the examples are based on real companies. The study allows concluding that, in the problem analyzed, linear models, simpler and faster to execute, may be sufficient to support good decisions.Universidade Federal de São Carlos2021-01-01info:eu-repo/semantics/articleinfo:eu-repo/semantics/publishedVersiontext/htmlhttp://old.scielo.br/scielo.php?script=sci_arttext&pid=S0104-530X2021000400205Gestão & Produção v.28 n.4 2021reponame:Gestão & Produçãoinstname:Universidade Federal de São Carlos (UFSCAR)instacron:UFSCAR10.1590/1806-9649-2021v28e5790info:eu-repo/semantics/openAccessde Biazzi,Jorge Luizeng2021-10-19T00:00:00Zoai:scielo:S0104-530X2021000400205Revistahttps://www.gestaoeproducao.com/PUBhttps://old.scielo.br/oai/scielo-oai.phpgp@dep.ufscar.br||revistagestaoemanalise@unichristus.edu.br1806-96490104-530Xopendoar:2021-10-19T00:00Gestão & Produção - Universidade Federal de São Carlos (UFSCAR)false
dc.title.none.fl_str_mv Stochastic production planning with internal and external storage and ordering costs
title Stochastic production planning with internal and external storage and ordering costs
spellingShingle Stochastic production planning with internal and external storage and ordering costs
de Biazzi,Jorge Luiz
Sales and operations planning
Dynamic and probabilistic demand
Aggregate production planning
Non-negligible ordering costs
title_short Stochastic production planning with internal and external storage and ordering costs
title_full Stochastic production planning with internal and external storage and ordering costs
title_fullStr Stochastic production planning with internal and external storage and ordering costs
title_full_unstemmed Stochastic production planning with internal and external storage and ordering costs
title_sort Stochastic production planning with internal and external storage and ordering costs
author de Biazzi,Jorge Luiz
author_facet de Biazzi,Jorge Luiz
author_role author
dc.contributor.author.fl_str_mv de Biazzi,Jorge Luiz
dc.subject.por.fl_str_mv Sales and operations planning
Dynamic and probabilistic demand
Aggregate production planning
Non-negligible ordering costs
topic Sales and operations planning
Dynamic and probabilistic demand
Aggregate production planning
Non-negligible ordering costs
description Abstract: This paper aims to compare different models to support decision making in production planning (and, consequently, in sales and inventory), in an environment where product demands are variable and uncertain, it is possible to produce at normal hours and overtime, loss of sales is consequence of stockouts, there is limit to internal storage, with possible and more expensive external storage, and ordering costs are non-negligible. At first, we present a linear and deterministic model, with known demand and without shortage. In the second model, safety stocks are calculated to meet a probabilistic demand, but it is not yet considered the possibility of shortage. The third model includes shortage calculation as a consequence from demand uncertainty. The last two models use an iterative process to re-estimate the unit cost of storage, needed to calculate safety stocks in each period of the planning horizon. The models were implemented in MSExcel, making use of linear programming and search functions available in the software. As the original problem, data of the examples are based on real companies. The study allows concluding that, in the problem analyzed, linear models, simpler and faster to execute, may be sufficient to support good decisions.
publishDate 2021
dc.date.none.fl_str_mv 2021-01-01
dc.type.driver.fl_str_mv info:eu-repo/semantics/article
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
format article
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0104-530X2021000400205
url http://old.scielo.br/scielo.php?script=sci_arttext&pid=S0104-530X2021000400205
dc.language.iso.fl_str_mv eng
language eng
dc.relation.none.fl_str_mv 10.1590/1806-9649-2021v28e5790
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv text/html
dc.publisher.none.fl_str_mv Universidade Federal de São Carlos
publisher.none.fl_str_mv Universidade Federal de São Carlos
dc.source.none.fl_str_mv Gestão & Produção v.28 n.4 2021
reponame:Gestão & Produção
instname:Universidade Federal de São Carlos (UFSCAR)
instacron:UFSCAR
instname_str Universidade Federal de São Carlos (UFSCAR)
instacron_str UFSCAR
institution UFSCAR
reponame_str Gestão & Produção
collection Gestão & Produção
repository.name.fl_str_mv Gestão & Produção - Universidade Federal de São Carlos (UFSCAR)
repository.mail.fl_str_mv gp@dep.ufscar.br||revistagestaoemanalise@unichristus.edu.br
_version_ 1750118207981617152