Agricultural production planning and problem solving using MS Excel

Abstract. The article examines the issue of meeting the agricultural production needs of a hypothetical enterprise for the planned period through internal production and the import of products from other enterprises. A mathematical model of optimizing agricultural production and its importation at minimal total costs is formulated. To verify the effectiveness of the formulated model, a specific example is presented and solved using the Solver add-in in Excel.