利用EXCEL求解农业机器系统优化配备量

数学中线性规划问题的求解一直是很繁琐的,功能强大的Excel软件提供了一种很好的求解方法.为此,以兵团某中心团场为例,建立了农业机器系统优化配备的线性规划模型,论述了利用Excel进行求解的过程.通过Excel对建立的模型进行求解,得到了该中心团场优化的农业机器系统配备量,优化的结果与现实系统相比,全年作业成本降低了10.31%,农业机器系统配备量减少了21.39%.这表明,利用Excel进行求解具有操作方法简单、方便和快捷的特点.

Use of Excel to Solve Optimal Equipment of Farming Machinery System

It is very cockamamie to solve the linear programming problem. Microsoft Excel which function is very formidable offers one convenient method which is ignored by many people. As one center farm in BINGTUAN for example, this paper establishes the linear programming model of optimal equipment of farming machinery system, and discusses the solving process by Excel. The optimal equipment quantity of farming machinery system of the center farm is calculated through solving the model by Excel. Compared the result of the optimized model to the realistic system, the result shows that the productive cost of the whole year is reduced 10.31% and the optimal equipment quantity of farming machinery system is decreased 21.39%. Meanwhile, the operation of using Excel to solve problems is extremely simple, convenient and fast.