| 用Excel解决成品油二次配送路线优化问题 |
| |
| 引用本文： | 陈进殿,李宏波. 用Excel解决成品油二次配送路线优化问题[J]. 石油商技, 2004, 22(3): 29-31 |
| |
| 作者姓名： | 陈进殿 李宏波 |
| |
| 作者单位： | 1. 西南石油学院,成都,610500
2. 中油销售山东省分公司,青岛,266008 |
| |
| 摘 要： | 提出了路况系数和最优路径的概念,并以此为基础,建立了油库至加油站成品油二次配送的最短路和最小费用流模型,用Excel中的Solver软件作了优化和求解。
|
| 关 键 词： | Excel建模 成品油 配送 线路优化 |
| 修稿时间： | 2003-11-14 |
Solve Secondary Distribution Route Optimizing Problem of Oil Products by Excel |
| |
| Chen Jindian. Solve Secondary Distribution Route Optimizing Problem of Oil Products by Excel[J]. Petroleum Products Application Research, 2004, 22(3): 29-31 |
| |
| Authors: | Chen Jindian |
| |
| Abstract: | 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. |
| |
| Keywords: | Excel modeling oil products distribution route optimizing |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
