基于Excel的线性规划求解

Linear Programming solution Based on Excel

介绍了实际工程和生产管理中应用广泛的线性规划问题,简要说明其在相关学科中的应用。利用Excel在优化求解中的线性规划求解功能,可以方便地得到求解结果。并给出了一个应用实例。

The paper gives an introduction to the linear programming problem widely used in engineering and production management and its application in relative disciplines. By making use of solving function of linear programming of Excel in optimizing solving process,a solution can be casity obtained. A practical example is also given.