确定性联合补充库存问题的EXCEL规划求解法  

EXCEL program solution of joint replenishment problem with deterministic demand

作　　者：张光明[1] 郭俏俏[1] 王海存[1] 

机构地区：[1]江苏科技大学经济管理学院

出　　处：《江苏科技大学学报（自然科学版）》2009年第3期258-262,共5页Journal of Jiangsu University of Science and Technology:Natural Science Edition

基　　金：江苏省高校哲学社会科学研究基金资助项目(SJB08630012)

摘　　要：提出求解确定性联合补充库存问题的新方法—EXCEL规划求解法:通过数学运算将非线性混合整数规划模型转化为整数线性规划模型,然后在EXCEL中通过"规划求解"工具求最优解.通过算例验证,结果表明该方法不但能有效解决此类问题,而且更简单、更直观、更实用.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.

关 键 词：联合补充问题 确定性需求 EXCEL规划求解法 最优解 

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