Optimizing ABC inventory grouping decisions

Inventory managers often group inventory items into classes to manage and control them more efficiently. The well-known ABC inventory classification approach categorizes inventory items into A, B and C classes according to their sales and usage volume. In this paper, we present an optimization model to enhance the quality of inventory grouping. Our model simultaneously optimizes the number of inventory groups, their corresponding service levels and assignment of SKUs to groups, under limited inventory spending budget. Our methodology provides inventory and purchasing managers with a decision-support tool to optimally exploit the tradeoff among service level, inventory cost and net profit. The model and solution are applied for an inventory classification project of a real-life company, and outperform the traditional ABC method. Computational experiments are performed to obtain managerial insights on optimal inventory grouping decisions.

[1]  M. Bohanec,et al.  The Analytic Hierarchy Process , 2004 .

[2]  Bob Byrne,et al.  Finally, a strategic way to cut unnecessary SKUs , 2007 .

[3]  Thomas L. Saaty,et al.  Marketing Applications of the Analytic Hierarchy Process , 1980 .

[4]  Ramakrishnan Ramanathan,et al.  ABC inventory classification with multiple-criteria using weighted linear optimization , 2006, Comput. Oper. Res..

[5]  Ronald H. Ballou,et al.  Business Logistics/Supply Chain Management -5/E , 2004 .

[6]  Abdollah Hadi-Vencheh,et al.  An improvement to multiple criteria ABC inventory classification , 2010, Eur. J. Oper. Res..

[7]  John A. Quelch,et al.  Extend Profits, Not Product Lines , 1994 .

[8]  D. Clay Whybark,et al.  Multiple Criteria ABC Analysis , 1986 .

[9]  Abdollah Hadi-Vencheh,et al.  A fuzzy AHP-DEA approach for multiple criteria ABC inventory classification , 2011, Expert Syst. Appl..

[10]  Murugan Anandarajan,et al.  Classifying inventory using an artificial neural network approach , 2002 .

[11]  Jin-Xiao Chen Peer-estimation for multiple criteria ABC inventory classification , 2011, Comput. Oper. Res..

[12]  Jonathan Burton,et al.  Using the Analytic Hierarchy Process for ABC Analysis , 1993 .

[13]  D. Clay Whybark,et al.  Implementing multiple criteria ABC analysis , 1989 .

[14]  S. Oglesby,et al.  Optimization of a Few Lot Sizes to Cover a Range of Requirements , 1978 .

[15]  Chi-Yang Tsai,et al.  A multiple objective particle swarm optimization approach for inventory classification , 2008 .

[16]  Bijan Sarkar,et al.  Distance-based consensus method for ABC analysis , 2007 .

[17]  Keith W. Hipel,et al.  A case-based distance model for multiple criteria ABC analysis , 2008, Comput. Oper. Res..

[18]  Wan Lung Ng,et al.  Production , Manufacturing and Logistics A simple classifier for multiple criteria ABC analysis , 2006 .

[19]  Hadi Vencheh Abd Elah AN IMPROVEMENT TO MULTIPLE CRITERIA ABC INVENTORY CLASSIFICATION , 2010 .

[20]  Jared L. Cohon,et al.  Multiobjective programming and planning , 2004 .

[21]  A. K. Chakravarty,et al.  Multi-Item Inventory Aggregation into Groups , 1981 .

[22]  Zvi Drezner,et al.  Facility location - applications and theory , 2001 .

[23]  Vijay Aggarwal,et al.  A closed-from approach for multi-item inventory grouping , 1983 .

[24]  Paul Farris,et al.  An Empirical Comparison of Direct Product Profit and Existing Measures of SKU Productivity , 1990 .

[25]  M. Z. Babai,et al.  ABC inventory classification : service levels and inventory costs , 2009 .

[26]  H. Altay Güvenir,et al.  Multicriteria inventory classification using a genetic algorithm , 1998, Eur. J. Oper. Res..

[27]  Morris A. Cohen,et al.  Operations related groups (ORGs): A clustering procedure for production/inventory systems , 1990 .

[28]  Peter Korevaar,et al.  Inventory budget optimization: Meeting system-wide service levels in practice , 2007, IBM J. Res. Dev..