Agricultural production planning and problem solving using MS Excel

Authors

Keneshbek  Maatov 1

Zhoomart Mambetov 2

Tynybek Naraliev 3

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.

Keywords: mathematical model, costs, production, wholesale prices, set, arable land, optimization, agricultural products, MS Excel.