Excel规划求解在设施选址中的应用

The Application of Excel Programming Solver to Facilities Location

设施选址对于企业的生产运营非常重要,应采用科学的方法进行选址评价。线性规划常用于复合设施选址的成本因素评价,针对其常用求解方法——表上作业法计算繁琐的问题,提出利用Excel软件进行求解的一种方便快捷、易于操作的实用方法。通过具体选址实例详细阐述了采用该方法对模型求解的具体步骤和结果。

Facility location is very important for the operation of manufacturing enterprises.Scientific methods should be used in the evaluation of facilities location.Linear programming is often used in the cost factor evaluation for complex facility location problem.In view of the complexity of tabular method often used to solve the linear programming problems,a convenient,maneuverable,and practical method by using Excel is proposed.An example is given to show the application and results of the proposed method.