Linear programming based decision support system for grapes transport planning in CAPEL

Abstract

This research is about developing a decision support system (DSS) for the distribution of grapes and grape must in a Chilean cooperative, Cooperativa Agrícola Pisquera Elqui Limitada (CAPEL). CAPEL is dedicated to producing and distributing several beverages such as sparkling wines, beers, energy drinks, rum, and pisco. This work aims to support the grinding‐related transport stage through a linear programming based DSS, in order to find the optimal use of the transport demand in a network based on source and destination plants during the harvest season. To achieve this aim, an operational research (OR) model that feeds the DSS is developed, whose objective function seeks to minimize the total transport cost. The decision variables define the grape cargo to be transported from a source plant to a destination plant. The OR model uses constraints such as transportation demand, grinding capacity, maximum storage, and available grape in plants. The model succeeded in reducing the total transport costs by 14% for the 2017 season of the pisco‐making process, meaning approximately savings of 59 million Chilean pesos.

A socially responsible decision‐making model for firms contracting with constrained farmers

“…Escallón-Barrios et al (2020) optimize the harvesting operations of a Colombian palm oil plantation using heuristics and simulations. To plan for grape transportation for a Chilean cooperative, Monardes-Concha et al (2023) design an LP-based decision-support system. Within the realm of decision making under climatic and price variabilities, González et al (2023) put forward a multiobjective robust agricultural decision-making model, while Luna et al (2023) employ fuzzy-TOPSIS technique to choose between production strategies.…”

“…To plan for grape transportation for a Chilean cooperative, Monardes‐Concha et al. (2023) design an LP‐based decision‐support system. Within the realm of decision making under climatic and price variabilities, González et al.…”

A mixed‐integer linear programming model and a metaheuristic approach for the selection and allocation of land parcels problem

“…This investigation shows the feasibility of minimizing the costs associated with a supply chain (e.g., costs for distributing goods, administrative costs, and storage costs), establishing planning of the distribution and holding of products appropriately. In Monardes-Concha et al (2023), the authors proposed a Decision Support System (DSS) oriented to the distribution of grapes in a Chilean cooperative. The DSS system is supported by a mathematical model based on linear programming to supply the demand for transport and minimize the total transportation cost.…”

“…In Monardes‐Concha et al. (2023), the authors proposed a Decision Support System (DSS) oriented to the distribution of grapes in a Chilean cooperative. The DSS system is supported by a mathematical model based on linear programming to supply the demand for transport and minimize the total transportation cost.…”