Excel Solver for Deterministic Inventory Model: INSOLVER

An excel solver is proposed for optimized result of deterministic inventory models. Seven inventory models including price break models can be solved by using this Excel Solver. This solver is designed by using yes-no algorithm. INSOLVER has benefit of solving even quantity discount inventory models with different price breaks, which makes it unique.

[1]  Sameer Prasad,et al.  Classification of inventory models and systems , 1994 .

[2]  T.C.E. Cheng,et al.  An Economic Order Quantity Model with Demand-Dependent Unit Production Cost and Imperfect Production Processes , 1991 .

[3]  T. Jose,et al.  Analysis of Inventory Control Techniques; A Comparative Study , 2013 .

[4]  Prakash L. Abad,et al.  Optimal price and order size for a reseller under partial backordering , 2001, Comput. Oper. Res..

[5]  H. Wee.  Deteriorating inventory model with quantity discount, pricing and partial backordering , 1999 .

[6]  Cengiz Haksever,et al.  A model for optimizing multi-product inventory systems with multiple constraints , 2005 .

[7]  Pinar Keskinocak,et al.  Dynamic pricing in the presence of inventory considerations: research overview, current practices, and future directions , 2003, IEEE Engineering Management Review.

[8]  A. Goswami,et al.  An EOQ Model for Deteriorating Items with Linear Time-dependent Demand Rate and Shortages under Inflation and Time Discounting , 1995 .

[9]  K. S. Chaudhuri,et al.  Deterministic models of perishable inventory with stock-dependent demand rate and nonlinear holding cost , 1998, Eur. J. Oper. Res..

[10]  Raida Abuizam.  Optimization Of (s, S) Periodic Review Inventory Model With Uncertain Demand And Lead Time Using Simulation , 2011, BIOINFORMATICS 2011.

[11]  Carl R. Schultz.  Forecasting and Inventory Control for Sporadic Demand Under Periodic Review , 1987 .

[12]  Z. Drezner,et al.  An EOQ Model with Substitutions Between Products , 1995 .

[13]  Parviz Fattahi,et al.  Integrated vendor–buyer cooperative inventory model with controllable lead time, ordering cost reduction, and service-level constraint , 2013 .

[14]  Amir Ahmadi-Javid,et al.  A location-routing-inventory model for designing multisource distribution networks , 2012 .

[15]  S. K. Goyal,et al.  Recent trends in modeling of deteriorating inventory , 2001, Eur. J. Oper. Res..