Assortment ABC Classification Problem at the Warehouse Modelled as a Multi-Knapsack

• Autorzy: Kateryna Czerniachowska , Marcin Hernes , Sergey Subbotin
• Języki publikacji: EN

Abstrakty

EN

Purpose: Appropriate product categorisation in warehouses is an issue facing most warehouses and distribution centres around the globe today. The ABC classification scheme aids in determining the most vital values at the warehouse. ABC classification reduces the effects of excess, end-of-life, or huge volumes of phase-out products. Design/methodology/approach: ABC classification is a method for classifying products according to their relevance. Products are divided into three categories using the ABC analysis, with category "A" items being the most important, category "B" as medium important and category "C" items being the least important for the distributor. This research model the ABC classification problem as a multi-knapsack and provides an example of commercial and non- commercial solver usage that enables distributors to categorise assortment according to the ABC classification. Findings: Proposed approach enables the distributor to arrive at the best possible outcomes. Research limitations/implications: The main limitation of this research is that it does not take into consideration constraints that show that some products cannot be quickly categorised or placed on the shelves because of the availability of storage equipment or warehouse personnel at the time of classification should be considered. Further research may be done on these issues. Practical implications: Performance comparisons between the proposed approach and the traditional ABC classification method provided by the distributors are conducted. Originality/value: The main contribution is the improvement of the classification method used in warehouses these days. The proposed approach allows assigning an optimal product mix to ABC categories.

Słowa kluczowe

EN

Classification; Data classifications; Classification of products; Distribution

PL

Klasyfikacja; Klasyfikacja danych; Klasyfikacja produktów; Dystrybucja

• Czasopismo: Zeszyty Naukowe. Organizacja i Zarządzanie / Politechnika Śląska
• Rocznik: 2023
• Numer: z. 172 Współczesne zarządzanie = Contemporary Management
• Strony: 109--131

Twórcy

autor

Kateryna Czerniachowska

• Wroclaw University of Economics and Business, Poland

autor

Marcin Hernes

• Wroclaw University of Economics and Business, Poland

autor

Sergey Subbotin

• National University "Zaporizhzhia Polytechnic", Zaporizhzhia, Ukraine

Bibliografia

• 1. Ailawadi, K.L., Keller, K.L. (2004). Understanding retail branding: Conceptual insights and research priorities. Journal of Retailing, Vol. 80, Iss. 4, pp. 331-342, https://doi.org/10.1016/j.jretai.2004.10.008.
• 2. AR Racking, ABC Inventory Method in the Warehouse: Origin, Characteristics and Advantages. Retrieved from: https://www.ar-racking.com/en/news-and-blog/storage- solutions/quality-and-security/abc-inventory-method-in-the-warehouse-origin- characteristics-and-advantages.
• 3. Baby, B., Prasanth, N., Jebadurai, S.S. (2018). Implementation of lean principles to improve the operations of a sales warehouse in the manufacturing industry. International Journal of Technology, Vol. 9, Iss. 1, pp. 46-54, https://doi.org/10.14716/ijtech.v9i1.1161.
• 4. Cachon, G.P., Kök, A.G. (2007). Category management and coordination in retail assortment planning in the presence of basket shopping consumers. Management Science, Vol. 53, No. 6, pp. 934-951, https://doi.org/10.1287/mnsc.1060.0661.
• 5. Cachon, G.P., Terwiesch, C., Xu, Y. (2005). Retail assortment planning in the presence of consumer search. Manufacturing and Service Operations Management, Vol. 7, No. 4, pp. 330-346, https://doi.org/10.1287/msom.1050.0088.
• 6. Campo, K., Gijsbrechts, E., Nisol, P. (2004). Dynamics in consumer response to product unavailability: Do stock-out reactions signal response to permanent assortment reductions? Journal of Business Research, Vol. 57, No. 8, pp. 834-843, https://doi.org/10.1016/S0148- 2963(02)00486-1.
• 7. Cips, Getting to grips with ABC classification. Retrieved from: https://www.cips.org/ intelligence-hub/operations-management/abc-classification.
• 8. Corsten, H., Hopf, M., Kasper, B., Thielen, C. (2018). Assortment planning for multiple chain stores. OR Spectrum, Vol. 40, No. 4, pp. 875-912, https://doi.org/10.1007/s00291- 017-0496-9.
• 9. Danneels, E. (2003). Tight-loose coupling with customers: The enactment of customer orientation. Strategic Management Journal, Vol. 24, Iss. 6, pp. 559-576, https://doi.org/10.1002/smj.319.
• 10. De Koster, R.B.M., Johnson, A.L., Roy, D. (2017). Warehouse design and management. International Journal of Production Research, Vol. 55, Iss. 21, pp. 6327-6330, https://doi.org/10.1080/00207543.2017.1371856.
• 11. Deskera, R. What is ABC Analysis in Inventory Control? Retrieved from: https://www.deskera.com/blog/abc-analysis/.
• 12. Dujak, D., Kresoja, M., Franjkovic, J. (2016). Space Management in Category Management - a Comparative Analysis of Retailers. Strategic Management, May, pp. 409-424. Retrieved from: https://www.researchgate.net/publication/311311064_Space_Management_in_ Category_Management_-_a_Comparative_Analysis_of_Retailers.
• 13. EazyStock, Drakeley, P., How to calculate and apply ABC classification of inventory. Retrieved from: https://www.eazystock.com/blog/calculate-apply-abc-classification- inventory/.
• 14. Fisher, M.L., Vaidyanathan, R. (2009). An Algorithm and Demand Estimation Procedure for Retail Assortment Optimisation. Management, Vol. 2007, pp. 1-36.
• 15. Fisher, M., Vaidyanathan, R. (2014). A demand estimation procedure for retail assortment optimisation with results from implementations. Management Science, Vol. 60, No. 10, pp. 2401-2415, https://doi.org/10.1287/mnsc.2014.1904.
• 16. Forum Europe Ltd. (1997). Super sales - how top performers manage the seller/client interface. Managing Service Quality: An International Journal, Vol. 7, No. 2, pp. 95-101, https://doi.org/10.1108/09604529710796591.
• 17. Hanafi, R., Mardin, F., Asmal, S., Setiawan, I., Wijaya, S. (2019). Toward a green inventory controlling using the ABC classification analysis: A case of motorcycle spares parts shop. IOP Conference Series: Earth and Environmental Science, Vol. 343, No. 1, pp. 012012, https://doi.org/10.1088/1755-1315/343/1/012012.
• 18. Hariga, M.A., Al-Ahmari, A., Mohamed, A.R.A. (2007). A joint optimisation model for inventory replenishment, product assortment, shelf space and display area allocation decisions. European Journal of Operational Research, Vol. 181, No. 1, pp. 239-251, https://doi.org/10.1016/j.ejor.2006.06.025.
• 19. Hübner, A. (2017). A decision support system for retail assortment planning. International Journal of Retail and Distribution Management, Vol. 45, No. 7-8, pp. 808-825, https://doi.org/10.1108/IJRDM-09-2016-0166.
• 20. Hübner, A., Kuhn, H., Kühn, S. (2016). An efficient algorithm for capacitated assortment planning with stochastic demand and substitution. European Journal of Operational Research, Vol. 250, No. 2, pp. 505-520, https://doi.org/10.1016/j.ejor.2015.11.007.
• 21. Hübner, A., Schaal, K. (2017). An integrated assortment and shelf-space optimisation model with demand substitution and space-elasticity effects. European Journal of Operational Research, Vol. 261, No. 1, pp. 302-316, https://doi.org/10.1016/j.ejor. 2017.01.039.
• 22. Huh, Y.E., Vosgerau, J., Morewedge, C.K. (2016). More Similar but Less Satisfying: Comparing Preferences for and the Efficacy of Within- and Cross-Category Substitutes for Food. Psychological Science, Vol. 27, No. 6, https://doi.org/10.1177/0956797616640705.
• 23. Jemelka, M., Chramcov, B., Kříž, P. (2016). Redistribution of stock sections according to the materials turnover and the abcmethod. Annals of DAAAM and Proceedings of the International DAAAM Symposium, Vol. 27, No. 1, pp. 816-821, https://doi.org/10.2507/27th.daaam.proceedings.118.
• 24. Katana, ABC inventory: get the most out of your best-selling products. Retrieved from: https://katanamrp.com/abc-inventory/.
• 25. Kök, A.G., Fisher, M.L. (2007). Demand estimation and assortment optimisation under substitution: Methodology and application. Operations Research, Vol. 55, No. 6, pp. 1001- 1021, https://doi.org/10.1287/opre.1070.0409.
• 26. Koul, S., Jasrotia, S.S. (2019). Product adoption by small retailers in India. International Journal of Retail and Distribution Management, Vol. 47, No. 11, pp. 1163-1180, https://doi.org/10.1108/IJRDM-03-2018-0053.
• 27. Li, J., Moghaddam, M., Nof, S.Y. (2016). Dynamic storage assignment with product affinity and ABC classification-a case study. International Journal of Advanced Manufacturing Technology, Vol. 84, No. 9-12, pp. 2179-2194, https://doi.org/10.1007/ s00170-015-7806-7.
• 28. Lin, H.L., Ma, Y.Y. (2021). A New Method of Storage Management Based on ABC Classification: A Case Study in Chinese Supermarkets' Distribution Center. SAGE Open, Vol. 11, No. 2, https://doi.org/10.1177/21582440211023193.
• 29. Lotfi, M.M., Torabi, S.A. (2011). A fuzzy goal programming approach for mid-term assortment planning in supermarkets. European Journal of Operational Research, Vol. 213, No. 2, pp. 430-441, https://doi.org/10.1016/j.ejor.2011.04.001.
• 30. Mahajan, S., Van Ryzin, G. (2001). Stocking retail assortments under dynamic consumer substitution. Operations Research, Vol. 49, No. 3, pp. 334-351, https://doi.org/10.1287/ opre.49.3.334.11210.
• 31. McInerney, S., Yadavalli, S. (2022). Increasing warehouse throughput through the development of a dynamic class-based storage assignment algorithm. South African Journal of Industrial Engineering, Vol. 32, pp. 157-167, https://doi.org/10.7166/33-2-2651.
• 32. Messinger, P.R., Narasimhan, C. (1997). A model of retail formats based on consumers' economising on shopping time. Marketing Science, Vol. 16, No. 1, pp. 1-23, https://doi.org/10.1287/mksc.16.1.1.
• 33. Mor, R.S., Bhardwaj, A., Kharka, V., Kharub, M. (2021). Spare Parts Inventory Management in the Warehouse: A Lean Approach. International Journal of Industrial Engineering and Production Research, Vol. 32, No. 2, pp. 1-11, https://doi.org/10.22068/ijiepr.1110.
• 34. Netessine, S., Rudi, N. (2003). Centralised and competitive inventory models with demand substitution. Operations Research, Vol. 51, No. 2, pp. 329-335, https://doi.org/10.1287/opre.51.2.329.12788.
• 35. Oestreicher-Singer, G., Libai, B., Sivan, L., Carmi, E., Yassin, O. (2013). The network value of products. Journal of Marketing, Vol. 77, No. 3, pp. 1-14, https://doi.org/10.1509/jm.11.0400.
• 36. Pisinger, D. (1999). An Exact Algorithm for Large Multiple Knapsack Problems. European Journal of Operational Research, Vol. 114, No. 3, pp. 528-541, https://doi.org/10.1016/S0377-2217(98)00120-9.
• 37. Raeder, T., Chawla, N.V. (2011). Market basket analysis with networks. Social Network Analysis and Mining, Vol. 1, No. 2, 97-113, https://doi.org/10.1007/s13278-010-0003-7.
• 38. Rodríguez, I., Rabanal, P., Rubio, F. (2017). How to make a best-seller: Optimal product design problems. Applied Soft Computing Journal, Vol. 55, pp. 178-196, https://doi.org/10.1016/j.asoc.2017.01.036.
• 39. Seetharaman, P.B., Chib, S., Ainslie, A., Boatwright, P., Chan, T., Gupta, S., Mehta, N., Rao, V., Strijnev, A. (2005). Models of multi-category choice behavior. Marketing Letters, 16, No. 3-4, pp. 239-254, https://doi.org/10.1007/s11002-005-5888-y.
• 40. Simonson, I. (1999). The effect of product assortment on buyer preferences. Journal of Retailing, Vol. 75, No. 3, pp. 347-370, https://doi.org/10.1016/S0022-4359(99)00012-3.
• 41. Sloot, L.M., Verhoef, P.C., Franses, P.H. (2005). The impact of brand equity and the hedonic level of products on consumer stock-out reactions. Journal of Retailing, 81, No. 1, pp. 15-34, https://doi.org/10.1016/j.jretai.2005.01.001.
• 42. Smith, S.A., Agrawal, N. (2000). Management of multi-item retail inventory systems with demand substitution. Operations Research, 48, No. 1, pp. 50-64, https://doi.org/10.1287/opre.48.1.50.12443.
• 43. Stassen, R.E., Mittelstaedt, J.D., Mittelstaedt, R.A. (1999). Assortment overlap: Its effect on shopping patterns in a retail market when the distributions of prices and goods are known. Journal of Retailing, Vol. 75, No. 3, pp. 371-386, https://doi.org/10.1016/S0022- 4359(99)00013-5.
• 44. Urban, T.L. (1998). An inventory-theoretic approach to product assortment and shelf-space allocation. Journal of Retailing, Vol. 74, No. 1, pp. 15-35, https://doi.org/10.1016/S0022- 4359(99)80086-4.
• 45. Van Ryzin, G., Mahajan, S. (1999). On the relationship between inventory costs and variety benefits in retail assortments. Management Science, Vol. 45, No. 11, pp. 1496-1509, https://doi.org/10.1287/mnsc.45.11.1496.
• 46. Yücel, E., Karaesmen, F., Salman, F.S., Türkay, M. (2009). Optimizing product assortment under customer-driven demand substitution. European Journal of Operational Research, Vol. 199, No. 3, pp. 759-768, https://doi.org/10.1016/j.ejor.2008.08.004.

Identyfikatory

DOI

10.29119/1641-3466.2023.172.7