Planificación de la producción y gestión de inventarios mediante el desarrollo de una herramienta software para la empresa "balanceados nutritivos" de la Ciudad de Riobamba

Abstract

This study focused on developing a specialized software tool for optimizing production planning and storage management at Balanceados Nutritivos. Forecasted data were used as the foundation for creating the software tool. For storage management, a storage footprint analysis was conducted in conjunction with a fixed utilization rate to calculate the cost per unit of stored production. This was done to evaluate the production quantity (PQ) and determine the optimal monthly production quantity and the required average inventory level. Storage management also involved an ABC categorization of products based on demand and turnover, resulting in a 2.65% improvement in storage time efficiency and a 3.26% reduction in travel distance. Regarding production planning, different forecasting techniques were compared using performance metrics, with the Winters method standing out with a mean absolute percentage error (MAPE) of 10.60%, indicating the presence of seasonality and trend in demand. This forecast was used to evaluate various aggregate production planning approaches, with the mixed leveling method being selected as the most cost-efficient, resulting in an 8.6% cost savings. Finally, a comprehensive software tool was developed that encompasses all these aspects, resulting in more efficient production area management and more informed data-driven decision-making, which meets the operational needs of Balanceados Nutritivos.