Mechanism Design and Modeling Study for Purchasing and Inventory Optimization of China Daqing Oilfield Materials

Abstract

Abstract: Combined with the practical problems in material purchasing of China Daqing Oilfield, considering the uncertainty and complexity in market, inventory, and demand of material procurement, this paper studies three kinds of inventory optimal methods respectively, including price time-varying, demand time-varying and inventory model under different capacity constraints. Furthermore, a mechanism in purchasing and inventory optimization is designed. Then, four kinds of materials are selected for simulation. The result shows that, based on the high forecasting accuracy of price, using the 0-1 mixed integer programming method, the optimal joint purchasing strategy for multi-item can reduce the procurement cost by 7.66%, and the forecasting result obtain a high evaluation form users. The mechanism can provide reference for the decision support system in the oilfield material purchasing and inventory optimization project. However, some improvements are still needed in the mechanism and models.

Key words: operational research, purchasing and inventory optimization, 0-1 Mixed integer programming, price time-varying, demand time-varying, capacity constraint

摘要： 本文结合大庆油田物资采购中的实际问题, 考虑物资市场、需求、库存三方之间的不确定性和复杂性,分别讨论了物资采购价格时变、物资需求时变、以及不同仓储容量限制下的库存优化模型的研究进展。进一步,设计了针对大庆油田物资的采购及库存优化机制,并选取大庆油田实际采购中的4种A类物资,基于时间序列方法和0-1混合整数规划,分别对机制中的价格预测部分和策略优化部分进行了数值试算,结果表明,基于准确度较高的预测价格,运用混合0-1整数规划模型制定的多品种物资的最优联合采购策略,可以实现采购成本的节省,相比于4种物资2009年的实际采购成本,节约比率高达7.66%,同时价格预测的精度也得到了用户的认可。该机制为油田物资采购和库存优化管理项目中的辅助决策支持系统原型设计提供了参照。但考虑到大庆油田实际采购中的各种复杂因素的影响,还需进一步完善该优化机制,并对相关模型进行改进。

关键词: 运筹学, 采购及库存优化, 0-1混合整数规划, 价格时变, 需求时变, 仓储有限

CLC Number:

CHEN Jin-xia, LI Wen-dong, FAN Lin-xian, YU Fang. Mechanism Design and Modeling Study for Purchasing and Inventory Optimization of China Daqing Oilfield Materials[J]. Operations Research and Management Science, 2013, 22(6): 132-139.

陈金霞, 李文东, 范林贤, 于芳. 大庆油田物资采购及库存优化机制设计与模型研究[J]. 运筹与管理, 2013, 22(6): 132-139.

References

[1] 孙猛.大庆油田钻井套管供应商联盟模式研究[D].天津大学,2005.37-46.
[2] Edward A S. Inventory management: an overview, canadian publications, practical applications and suggestions for future research[J]. INFOR, 2008, 46(1): 15-28.
[3] Donaldson W A. Inventory replenishment policy for a linear trend in demand-an analytical solution[J].Operational Research Quarterly(1970-1977), 1977, 28(3): 663-670.
[4] Silver E A. A simple inventory decision rule for a linear trend in demand[J]. Journal of the Operational Research Society, 1979, 30: 71-75.
[5] Ritchie E. The EOQ for linear increasing demand: a simple optimal solution[J].The Journal of the Operational Research Society, 1984, 35: 949-952.
[6] Henery R J. Inventory replenishment policy for cyclic demand[J].The Journal of the Operational Research Society, 1990, 41: 639-643.
[7] 周永务.带有时变需求和滞后支付的库存系统的最优经济批量模型[J].系统工程与电子技术,1997,6:40-44.
[8] 唐加福,刘士新,汪定伟.时变需求订货批量问题的相关策略[J].东北大学学报(自然科学版) ,2002,23(5):417-420.
[9] Naddor E. Inventory systems[M]. New York: John Wiley, 1966.
[10] Taylor S G, Bradley C E. Optimal ordering strategies for announced price increases[J].Operations Research, 1985, 33(2): 312-325.
[11] Lev B, Weiss H J. Inventory models with cost changes[J].Operations Research, 1989, 38(1): 53-63.
[12] Zhang Jian, Lev B. Three equal period inventory model with cost changes[J].Proceedings of TIMS-XXX, Providence, USA, 1990. 203-211.
[13] 张坚.一种多时段费用变动型存贮策略的优化[J].江苏理工大学学报,1996,17(2): 94-99.
[14] 程承运.一类变价格的物资库存优化模型[J].应用数学,1997,10(4):30-32.
[15] 郑惠莉,达庆利.一种需求和采购价均为时变的EOQ模型[J].中国管理科学,2003,11:26-30.
[16] 黄波,孟卫东,熊中楷.需求、价格和变质系数均为时变的EOQ模型[J].工业工程与管理,2008,(4):93-98.
[17] 李温红.仓库容量有限条件下的不允许缺货存贮模型[J].系统工程理论方法应用,1997,6(3):68-80.
[18] 陈有禄,罗秋兰.仓库容量有限条件下的一类存贮管理模型[J].数学的实践与认识,2004,34(6):1-5.
[19] 刘德权,徐毓,孙知建.仓库容量有限条件下的允许缺货存贮模型[J].空军雷达学院学报,2002,16(1):22-23.
[20] 李成严,徐晓飞,战德臣.有库存约束的有保质期产品经济批量模型[J].计算机应用与软件,2008,25(4):138-148.
[21] 万可,余玉刚.关于存贮模型的一个问题[J].中国管理科学,2001,9(4):16-24.
[22] 冯颖,蔡小强,涂奉生.资金和库存空间约束下多种易变质产品的联合订购策略[J].兰州大学学报,2009,45(6):136-142.
[23] Maria E M, Ahn H S. Joint management of capacity and inventory in make-to-stock production systems with multi-class demand[J].European Journal of Operational Research, 2011, 212: 312-324.
[24] Barany I, Tony J V R, Laurence A W. Strong formulations for multi-ltem capacitated lot sizing[J].Management Science, 1984, 30(10): 1255-1261.
[25] Paul S D, Choon L P. Heuristic procedures for multi-item inventory planning with limited storage[J]. IIE Transactions, 1990, 22(2): 112-123.
[26] Rosenblatt M J, Rothblum U G. On the single resource capacity problem for multi-Item inventory systems[J]. Operations Research, 1990, 38(4): 686-693.
[27] 高铁梅.计量经济分析方法与建模:EViews应用及实例[M].北京:清华大学出版社,2006.147-188.