首页 | 本学科首页   官方微博 | 高级检索  
     

确定性联合补充库存问题的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 维普 万方数据 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号