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.