Abstract
It is recommended to implement forecasting management models in the area of land use and protection by applying linear programming methods to optimize the size of farms, which land is located in different natural and economic zones. Analysis and assessment of land use in natural-economic zones is a type of management activity for deep understanding of the dialectic of a managed object development and true assessment of its moving forces. This enables to simulate the situation of land use, to identify a specific goal, to choose the means to achieve it and to obtain the optimum result. The implementation of the proposed forecast models of the optimal farm size is carried out by linear programming in three ways (northwest corner method, minimum cost method and What-If analysis method, that uses Solver, a Microsoft Excel add-in program). The implementation of the above approaches is based on the example of four farms and five natural-economic zones. The obtained solutions show that the best result is attained by using Solver for What-If analysis method, a Microsoft Excel add-in program. The northwest corner method gives the worst result, but this is the simplest solution. The minimum cost method depends on the researcher qualification and produces the result that is most often found between the results obtained by the northwest corner method and the "Solver" procedure. When using the method of the northwest corner a program of consideration of different options for the distribution of land resources and the choice of the optimal solution was developed. This allows to find an optimal result of land allocation according to the result, which is similar to the result of the procedure "Solver", but it is more adapted for the direct participation of the researcher in the process of solving problems. There is an opportunity to improve the result by changing the original data, which simulates the forecast of the distribution of farm land in natural-economic zones, while minimizing production costs. In the absence of access to computers, the solutions obtained by the northwest corner and the minimum cost methods can be improved by the potential method.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.