| 确定性联合补充库存问题的EXCEL规划求解法 |
| |
| 引用本文： | 张光明,郭俏俏,王海存. 确定性联合补充库存问题的EXCEL规划求解法[J]. 江苏科技大学学报(社会科学版), 2009, 23(3): 258-262 |
| |
| 作者姓名： | 张光明 郭俏俏 王海存 |
| |
| 作者单位： | 江苏科技大学,经济管理学院,江苏,镇江,212003;江苏科技大学,经济管理学院,江苏,镇江,212003;江苏科技大学,经济管理学院,江苏,镇江,212003 |
| |
| 基金项目： | 江苏省高校哲学社会科学研究基金资助项目 |
| |
| 摘 要： | 提出求解确定性联合补充库存问题的新方法——EXCEL规划求解法：通过数学运算将非线性混合整数规划模型转化为整数线性规划模型,然后在EXCEL中通过“规划求解”工具求最优解．通过算例验证,结果表明该方法不但能有效解决此类问题,而且更简单、更直观、更实用．
|
| 关 键 词： | 联合补充问题 确定性需求 EXCEL规划求解法 最优解 |
EXCEL program solution of joint replenishment problem with deterministic demand |
| |
| Zhang Guangming,Guo Qiaoqiao,Wang Haicun. EXCEL program solution of joint replenishment problem with deterministic demand[J]. Journal of Jiangsu University of Science and Technology(Natural Science Edition), 2009, 23(3): 258-262 |
| |
| Authors: | Zhang Guangming Guo Qiaoqiao Wang Haicun |
| |
| Affiliation: | School of Economics and Management;Jiangsu University of Science and Technology;Zhenjiang Jiangsu 212003;China |
| |
| Abstract: | We put forward a new method--EXCEL program solution to solve the joint replenishment problem with deterministic demand. At first, the method converted the nonlinear mixed integer-programming problem to the integer linear programming by mathematics operation; and then solved it by EXCLE solver. The EXCEL program solution was illustrated with some examples. The results indicate that it can not only effectively solve the deterministic JRP, hut also be simple, direct, and practical. |
| |
| Keywords: | joint replenishment problem deterministic demand program solution of EXCEL optimum solution |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
