用Excel解决成品油二次配送路线优化问题  

Solve Secondary Distribution Route Optimizing Problem of Oil Products by Excel

作　　者：陈进殿[1] 李宏波 

机构地区：[1]西南石油学院,成都610500 [2]中油销售山东省分公司,青岛266008

出　　处：《石油商技》2004年第3期29-31,共3页Petroleum Products Application Research

摘　　要：提出了路况系数和最优路径的概念,并以此为基础,建立了油库至加油站成品油二次配送的最短路和最小费用流模型,用Excel中的Solver软件作了优化和求解。Traffic coefficient and optimal routing are introduced as new concepts. Based on these concepts, distribution routing models for distance and cost minimization are established and solved with the Solver software in Excel.

关 键 词：配送 成品油 路线优化 问题 加油站 概念 模型 路况 最优路径 基础 

分 类 号：F224[经济管理—国民经济]