Economic and mathematical modeling in logistics activities of agricultural enterprises

Abstract

Introduction. The successful functioning and competitiveness of any enterprise in the agricultural sector directly depends on the coordinated interaction of all subsystems of the enterprise, including logistics. The introduction of pandemic quarantine due to COVID-19 and military operations in Ukraine forced the economy to adapt to a different mode of operation. However, some industries cannot fully transition to remote modes. Logistics cannot yet be fully virtualized. Along with the transition to the most remote mode of operation, the delivery of consumer goods and personal orders continues, which challenges enterprises to find ways to improve logistics activities. Purpose. Based on the conducted research and analysis, develop a mathematical model for finding the best suboptimal solutions for the problem of reducing the transport costs of agricultural enterprises during the transportation (sale) of products. Methodology. In the process of the research, an economic-mathematical model was built on the example of a production-transportation problem on the optimization of the transportation plan of some homogeneous products directly from suppliers to consumers, on the example of the activity of the agricultural enterprise PPC "Agrocentr" in the Dnipropetrovsk region. The model was tested on the statistical data of the company's work for 2021, modern Microsoft Excel spreadsheet software was used, namely, the Solution Search tool and Google Sheets tools. Results. It has been proven that the results of the optimization of the product transportation plan make it possible to use the production potential of the enterprise in the most effective way and ensure the lowest costs during the sale of products. Such a model can be used to analyze the activity of any agricultural enterprise, for different periods of time, and will also reveal the features of the transportation of products not only of the enterprise, but also of its individual divisions, and in addition, it makes it possible to make management decisions at various stages of production and sales of products.