Realization of Inventory Control Simulation Based on Excel
Chen Li-da · Journal of Zhejiang University of Science and Technology · 2006
Aimed at minimizing stock cost in stock control,this paper has made computer simulation analysis of stock system that rebates for order ahead of many cycles.Making use of an Excel function that can be simply operated and easily realized,a computer simulation system for stock control has been developed.The implement of the computer simulation system has been proved through a simple example.While using computer for stock control simulation,at first the system alters continuously the model according to uncertain practical factors in order to conveniently carry out computer simulation for many stock control strategies,then obtains an optimized stock control strategy with the lowest cost through systemic optimization and analysis.