用EXCEL解决一类配送路线的制定和优化问题  

To Solve One Kind of Distributing Routing Problem with EXCEL

作　　者：姚裕华 勇刚 张卓 

机构地区：[1]中国石油上海销售分公司,上海200120

出　　处：《物流科技》2009年第9期61-65,共5页Logistics Sci-Tech

摘　　要：EXCEL在管理科学领域的应用很多,如线性规划、运输问题、指派问题、网络最优化问题、项目管理、库存管理、预测、排队论和计算机仿真,等等。运用EXCEL建立模型,求解模型,能对管理者的决策提供很好支持。配送路线的制定和优化问题在实际物流操作中有着广泛的应用,也是非常困难的问题,借助EXCEL工具来辅助制定和优化配送路线,主要是对起点和终点相同的一类路径规划问题做出分析。EXCEL has extensive use in management science, such as linear programming, transportation problem, distribute problem, network optimization, program management, inventory management, anticipate, queue theory and compute emulate etc. It＇s a good support to the decision of manager, using EXCEL to establish and solve models. The choosing and optimization of distribute route is very. useful in logistics operation and also very difficult. In this text, we mostly use EXCEL to solve the problem of routing programming with same start and end point.

关 键 词：配送路线 优化 描述法 节约法 EXCEL 

分 类 号：O227[理学—运筹学与控制论]