TY - CHAP
T1 - Demand and Inventory Management for the Creation of an Automated Information Management System
T2 - A Case Study Applied to an Ecuadorian Supermarket
AU - Cárdenas-García, Paula Lizbeth
AU - Ichau-Tabango, Denisse Mishel
AU - Pando-Sigua, Patricia Johanna
AU - Avilés-Sacoto, Sonia Valeria
N1 - Publisher Copyright:
© 2023, The Author(s), under exclusive license to Springer Nature Switzerland AG.
PY - 2023/6/3
Y1 - 2023/6/3
N2 - In 2020, due to the COVID-19 pandemic, supermarkets took over as distributors of essential products. Due to this same situation, even the behavior of consumers changed radically since food, cleaning products, and personal hygiene products increased their presence at historical levels. This situation forced several commercial sectors to evaluate their data to respond immediately to the requirements of consumers. Therefore, the need arises for efficient and optimal planning of the products on the rack that are offered, focusing on those of greatest demand and sale to consumers. The present research study was carried out in an Ecuadorian supermarket, in which methodologies for the treatment of forecasts and inventories were applied through the historical sales data provided by the company for the years 2018, 2019, and 2020. Forecast models were applied to reduce uncertainty regarding planning the supply of the different products offered in the supermarket. The models were ARIMA, Holt, Holt-Winters, Seasonal Simple, and Winters Additive, while for the treatment and efficiency planning of the existing stock within the company; that is, having enough products to satisfy the demand, different inventory models and respective EOQs (economic order quantities) were applied according to the case. The information on sales management has been compiled and standardized in a Microsoft Excel template for the optimal flow of information and the recording of internal operations, achieving efficient product planning to avoid shortages in the supply chain.
AB - In 2020, due to the COVID-19 pandemic, supermarkets took over as distributors of essential products. Due to this same situation, even the behavior of consumers changed radically since food, cleaning products, and personal hygiene products increased their presence at historical levels. This situation forced several commercial sectors to evaluate their data to respond immediately to the requirements of consumers. Therefore, the need arises for efficient and optimal planning of the products on the rack that are offered, focusing on those of greatest demand and sale to consumers. The present research study was carried out in an Ecuadorian supermarket, in which methodologies for the treatment of forecasts and inventories were applied through the historical sales data provided by the company for the years 2018, 2019, and 2020. Forecast models were applied to reduce uncertainty regarding planning the supply of the different products offered in the supermarket. The models were ARIMA, Holt, Holt-Winters, Seasonal Simple, and Winters Additive, while for the treatment and efficiency planning of the existing stock within the company; that is, having enough products to satisfy the demand, different inventory models and respective EOQs (economic order quantities) were applied according to the case. The information on sales management has been compiled and standardized in a Microsoft Excel template for the optimal flow of information and the recording of internal operations, achieving efficient product planning to avoid shortages in the supply chain.
KW - BPM
KW - Forecasts
KW - Information system
KW - Inventories
KW - Supermarkets
UR - http://www.scopus.com/inward/record.url?scp=85161808333&partnerID=8YFLogxK
U2 - 10.1007/978-3-031-32032-3_8
DO - 10.1007/978-3-031-32032-3_8
M3 - Capítulo
AN - SCOPUS:85161808333
T3 - Lecture Notes in Logistics
SP - 191
EP - 212
BT - Lecture Notes in Logistics
PB - Springer Science and Business Media B.V.
ER -