Share:


Decision support algorithm development for assortment optimization in the retail chain

    Olga Iurasova Affiliation

Abstract

As the consumer market changes rapidly, retail networks require a system to optimize the quantity and assortment of goods. The authors develop and test theoretical and practical assortment optimization and distribution principles. The study aims to improve retail assortment management by creating a decision support system for optimizing commodity composition, quantity, and location. The system’s primary objective is to enhance the trading margin obtained from the sale while considering constraints related to commodity resources and shelf space. This entails optimizing the procurement and inventory management processes to maximize the profit margin. By generating freight invoices, distributing, and redistributing commodities within the network under inbound logistics orders, the system optimizes the allocation of commodities using information from the company’s existing software. The authors present an optimization method for commodities that relies on mathematical modeling and the calculation of the consolidated profitability ratio. It ensures the necessary accuracy and provides assortment management within time and cost limits, without substantial investments in equipment and updating qualifications of employees. The research outcomes are applicable to apparel retail. The practical outcome is maximizing the return on investment for goods sold per day. The algorithm’s benefits and effectiveness were calculated based on real data after implementation.

Keyword : retail chain, assortment optimization, assortment management, commodity management, decision support system, apparel retail, sales analytics, business processing

How to Cite
Iurasova, O. (2025). Decision support algorithm development for assortment optimization in the retail chain. Journal of Business Economics and Management, 26(1), 127–144. https://doi.org/10.3846/jbem.2025.22952
Published in Issue
Feb 20, 2025
Abstract Views
19
PDF Downloads
10
Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

References

Ala-Risku, T., Collin, J., Holmström, J., & Vuorinen, J.-P. (2010). Site inventory tracking in the project supply chain: Problem description and solution proposal in a very large telecom project. Supply Chain Management: An International Journal, 15(3), 252–260. https://doi.org/10.1108/13598541011040008

Aouad, A., Feldman, J., & Segev, D. (2023). The exponomial choice model for assortment optimization: An alternative to the MNL model? Management Science, 69(5), 2814–2832. https://doi.org/10.1287/mnsc.2022.4492

Arsawan, W. E., Koval, V., Suhartanto, D., Babachenko, L., Kapranova, L., & Suryantini, N. P. S. (2023). Invigorating supply chain performance in small medium enterprises: Exploring knowledge sharing as moderator. Business, Management and Economics Engineering, 21(1), 1–18. https://doi.org/10.3846/bmee.2023.17740

Aryee, R., Adaku, E., Quayson, S., & Tetteh, E. O. A. (2024). The returned product-process matrix: A decision-making framework for reverse logistics operations strategic choice. Business Strategy and Development, 7(2), Article e364. https://doi.org/10.1002/bsd2.364

Bani Hani, J. (2022). The influence of supply chain management practices on supply chain performance: The moderating role of information quality. Business, Management and Economics Engineering, 20(1), 152–171. https://doi.org/10.3846/bmee.2022.16597

Basit, A., Wang, L., Nazir, S., Mehmood, S., Hussain, I., Jammu, A., & Kashmir, K. (2023). Managing the COVID-19 Pandemic: Enhancing sustainable supply chain performance through management innovation, information processing capability, business model innovation and knowledge management capability in Pakistan. Sustainability, 15(18), Article 13538. https://doi.org/10.3390/su151813538

Bernstein, F., Kök, A. G., & Xie, L. (2015). Dynamic assortment customization with limited inventories. Manufacturing & Service Operations Management, 17(4), 538–553. https://doi.org/10.1287/msom.2015.0544

Borraz, F., Carozzi, F., González-Pampillón, N., & Zipitría, L. (2024). Local retail prices, product variety, and neighborhood change. American Economic Journal: Economic Policy, 16(1), 1–33. https://doi.org/10.1257/pol.20210817

Brakman, S., Garretsen, H., & van Marrewijk, C. (2001). An introduction to geographical economics: Trade, location and growth. Cambridge University Press. https://doi.org/10.1017/CBO9781139164481

Bulava, M. (2020). Methodical approaches to evaluation of effectiveness of assortment policy of the modern enterprise. Young Scientist, 10(86). https://doi.org/10.32839/2304-5809/2020-10-86-44

Chen, Y., Wu, Z., & Wang, Y. (2024). Omnichannel product selection and shelf space planning optimization. Omega, 127, Article 103074. https://doi.org/10.1016/j.omega.2024.103074

Çömez-Dolgan, N., Moussawi, L., Jaber, M., & Cephe, E. (2022). Capacitated assortment planning of a multi-location system under transshipments. International Journal of Production Economics, 251(6), Article 108550. https://doi.org/10.1016/j.ijpe.2022.108550

Dass, M., & Kumar, P. (2012). Assessing category vulnerability across retail product assortments. International Journal of Retail & Distribution Management, 40(1), 64–81. https://doi.org/10.1108/09590551211193603

Dharmawardane, C., Sillanpää, V., & Holmström, J. (2021). High-frequency forecasting for grocery point-of-sales: Intervention in practice and theoretical implications for operational design. Operations Management Research, 6, 38–60. https://doi.org/10.1007/s12063-020-00176-7

Eccles, R. (1991). The performance measurement manifesto. Harvard Business Review, 69, 131–137.

Fisher, M., & Vaidyanathan, R. (2014). A demand estimation procedure for retail assortment optimization with results from implementations. Management Science, 60(10), 2401–2415. https://doi.org/10.1287/mnsc.2014.1904.

Fildes, R., Kolassa, S., & Ma, Sh. (2021). Post-script – Retail forecasting: Research and practice. International Journal of Forecasting, 38(4), 1319–1324. https://doi.org/10.1016/j.ijforecast.2021.09.012

Fildes, R., Ma, Sh., & Kolassa, S. (2019). Retail forecasting: Research and practice. International Journal of Forecasting, 38(4), 1283–1318. https://doi.org/10.1016/j.ijforecast.2019.06.004

Gallego, G., Iravani, M., & Talebian, M. (2023). Constrained assortment optimization with satisficers consumers. SSRN. https://doi.org/10.2139/ssrn.4402473

Gallego, G., & Li, A. (2024). A random consideration set model for demand estimation, assortment optimization, and pricing. Operations Research, 72(6), 2358-2374. https://doi.org/10.1287/opre.2019.0333

Hamister, J. W., & Sima, M. F. (2016). Cumulative impact of category management on small retailers. International Journal of Retail & Distribution Management, 44(7), 680–693. https://doi.org/10.1108/IJRDM-09-2015-0142

Heger, J., & Klein, R. (2024). Assortment optimization: A systematic literature review. OR Spectrum, 46, 1099–1161. https://doi.org/10.1007/s00291-024-00752-4

Hense, J., Hübner, A., & Schäfer, F. (2022). An analytical assessment of demand effects in omni-channel assortment planning. Omega, 115, Article 102749. https://doi.org/10.1016/j.omega.2022.102749

Holmström, J. (1998). Handling product range complexity: A case study on re‐engineering demand forecasting. Business Process Management Journal, 4(3), 241–258. https://doi.org/10.1108/14637159810231027

Hong, J., Liao, Y., Zhang, Y., & Yu, Z. (2019). The effect of supply chain quality management practices and capabilities on operational and innovation performance: Evidence from Chinese manufacturers. International Journal of Production Economics, 212, 227–235. https://doi.org/10.1016/j.ijpe.2019.01.036

Honhon, D., & Seshadri, S. (2013). Fixed vs. Random proportions demand models for the assortment planning problem under stockout-based substitution. Manufacturing & Service Operations Management, 15(3), 378–386. https://doi.org/10.1287/msom.1120.0425

Huang, M., Hao, Y., Wang, Y., Hu, X., & Li, L. (2023). Split-order consolidation optimization for online supermarkets: Process analysis and optimization models. Frontiers of Engineering Management, 10, 499–516. https://doi.org/10.1007/s42524-022-0221-5

Hübner, A. (2017). A decision support system for retail assortment planning. International Journal of Retail & Distribution Management, 45(7–8), 808–825. https://doi.org/10.1108/IJRDM-09-2016-0166

Hübner, A., & Kuhn, H. (2012). Retail category management: a state-of-the-art review of quantitative research and software applications in assortment and shelf space management. Omega, 40(2), 199–209. https://doi.org/10.1016/j.omega.2011.05.008

Hübner, A., Kuhn, H., & Sternbeck, M. (2013). Demand and supply chain planning in grocery retail: An operations planning framework. International Journal of Retail & Distribution Management, 41(7), 512–530. https://doi.org/10.1108/IJRDM-05-2013-0104

Hübner, A., Kuhn, H., & Wollenburg, J. (2016a). Last mile fulfilment and distribution in omni-channel grocery retailing: A strategic planning framework. International Journal of Retail & Distribution Management, 44(3), 228–247. https://doi.org/10.1108/IJRDM-11-2014-0154

Hübner, A., Kühn, S., & Kuhn, H. (2016b). An efficient algorithm for capacitated assortment planning with stochastic demand and substitution. European Journal of Operational Research, 250(2), 505–520. https://doi.org/10.1016/j.ejor.2015.11.007

Hübner, A., & Schaal, K. (2017). Effect of replenishment and backroom on retail shelf-space planning. Business Research, 10, 123–156. https://doi.org/10.1007/s40685-016-0043-6

Hunter, A., King, R., & Nuttle, H. L. W. (1996). Evaluation of traditional and quick-response retailing procedures by using a stochastic simulation model. Journal of the Textile Institute, 87(1), 42–55. https://doi.org/10.1080/00405009608659101

Iurasov, A. (1998). Adaption of logistics merchandise management systems to the conditions of the consumer market [Doctoral dissertation]. Sankt Petersburg State University of Economics and Finance, Sankt-Petersburg, Russia. https://www.dissercat.com/content/adaptatsiya-logisticheskikh-sistem-upravleniya-tovarodvizheniem-k-konyunkture-potrebitelskog

Iurasov, A., Ivashko, L., & Maksymov, O. (2021). Development of decision support algorithms for management. Financial and Credit Activity: Problems of Theory and Practice, 1(36), 260–269. https://doi.org/10.18371/fcaptp.v1i36.227782

Jasińska-Biliczak, A. (2022). E-commerce from the customer panel: The phenomenon of the pandemic increase and future challenge. Business, Management and Economics Engineering, 20(1), 139–151. https://doi.org/10.3846/bmee.2022.16752

Javed, A., Basit, A., Ejaz, F., Hameed, A., Fodor, Z. J., & Hossain, Md B. (2024). The role of advanced technologies and supply chain collaboration: during COVID-19 on sustainable supply chain performance. Discover Sustainability, 5(1), Article 46. https://doi.org/10.1007/s43621-024-00228-z

Kahn, B. E. (1999). Introduction to the special issue: Assortment planning. Journal of Retailing, 75(3), 289–293. https://doi.org/10.1016/S0022-4359(99)00009-3

Kasprzak, E. (2020). Coronavirus: Supermarket shoppers ‘keep calm’ and queue. BBC News. https://tinyurl.com/fkf3xeby

Kök, A. G., & Fisher, M. L. (2007). Demand estimation and assortment optimization under substitution: Methodology and application. Operations Research, 55(6), 1001–1021. https://doi.org/10.1287/opre.1070.0409

Kök, A. G., Fisher, M. L., & Vaidyanathan, R. (2015). Assortment planning: Review of literature and industry practice. In N. Agrawal, & S. Smith (Eds.), International series in operations research & management science: Vol. 223. Retail supply chain management. Springer. https://doi.org/10.1007/978-1-4899-7562-1_8

Kumar, V., Jabarzadeh, Y., Jeihouni, P., & Garza-Reyes, J. A. (2019). Learning orientation and innovation performance: The mediating role of operations strategy and supply chain integration. Supply Chain Management, 25(4), 457–474. https://doi.org/10.1108/SCM-05-2019-0209

Kunz, G., & Rupe, D. (1999). Volume per stock‐keeping unit for an assortment: A merchandise planning tool. Journal of Fashion Marketing and Management: An International Journal, 3(2), 118–125. https://doi.org/10.1108/eb022553

Li, W., & Gao, G. (2023). Research on multi-product order splitting and distribution route optimization of “multi-warehouse in one place”. Frontiers in Business, Economics and Management, 8(3), 1–8. https://doi.org/10.54097/fbem.v8i3.7449

Liu, D., & Cai, Y. (2023). Peer effect of corporate R&D innovation from the perspective of uncertainty. Journal of Business Economics and Management, 24(2), 315–335. https://doi.org/10.3846/jbem.2023.19047

Ma, S., Kolassa, S., & Fildes, R. (2018). Retail forecasting: Research and practice (Working Paper).

Marshall, F., & Ramnath, V. (2014). A demand estimation procedure for retail assortment optimization with results from implementations. Management Science, 60(10), 2401–2415. https://doi.org/10.1287/mnsc.2014.1904

Miller, C., Smith, S. A., Mcintyre S. H., & Achabal, D. D. (2010). Optimizing and evaluating retail assortments for infrequently purchased products. Journal of Retailing, 86(2), 159–171. https://doi.org/10.1016/j.jretai.2010.02.004

Muñoz, R., Muñoz, J., Ferrer, J.-C., González, V., & Henao Botero, C. (2022). When should shelf stocking be done at night? A workforce management optimization approach for retailers (Working paper).

Nuttle, H., King, R., & Hunter, N. (1991). A stochastic model of the apparel retailing process for seasonal apparel. Journal of the Textile Institute, 82(2), 247–259. https://doi.org/10.1080/00405009508658762

Oh, K., Yoo, H., & Jeong, E. (2023). Research trends in digital transformation in supply chain based on bibliometric and network analysis. Journal of Business Economics and Management, 24(6), 1042–1058. https://doi.org/10.3846/jbem.2023.20649

Peng, Z., Rong, Y., & Zhu, T. (2024). Transformer‐based choice model: A tool for assortment optimization evaluation. Naval Research Logistics (NRL), 71(6), 854–877. https://doi.org/10.1002/nav.22183

Prem, C., Kam, B., Lau, C., Corbitt, B., & Cheong, F. (2017). Improving service responsiveness and delivery efficiency of retail networks: A case study of Melbourne. International Journal of Retail & Distribution Management, 45(3), 271–291. https://doi.org/10.1108/IJRDM-07-2016-0117

Rooderkerk, R. P., & Kök, A. G. (2019). Omnichannel assortment planning. In S. Gallino, & A. Moreno (Eds.), Springer series in supply chain management: Vol. 8. Operations in an omnichannel world. Springer, Cham. https://doi.org/10.1007/978-3-030-20119-7_4

Schäfer, F., Hense, J., & Hübner, A. (2022). An analytical assessment of demand effects in omni-channel assortment planning. Omega, 115, Article 102749. https://doi.org/10.1016/j.omega.2022.102749

Shelby, M. H., & Miller, C. M. (1999). The selection and pricing of retail assortments: An empirical approach. Journal of Retailing, 75(3), 295–318. https://doi.org/10.1016/S0022-4359(99)00010-X

Sillanpää, V., & Liesiö, J. (2018). Forecasting replenishment orders in retail: Value of modelling low and intermittent consumer demand with distributions. International Journal of Production Research, 56(2), 1–18. https://doi.org/10.1080/00207543.2018.1431413

Tan, Y., Guo, C., & Jia, J. (2024). A novel approach for demand estimation under a flexible mixed logit model. Knowledge-Based Systems, 294, Article 111727. https://doi.org/10.1016/j.knosys.2024.111727

van Donselaar, K., Broekmeulen, R., & de Kok, T. (2021). Heuristics for setting reorder levels in periodic review inventory systems with an aggregate service constraint. International Journal of Production Economics, 237, Article 108137. https://doi.org/10.1016/j.ijpe.2021.108137

van Hoek, R. I. (1998). Measuring the unmeasurable – measuring and improving performance in the supply chain. Supply Chain Management, 3(4), 187–192. https://doi.org/10.1108/13598549810244232

van Woensel, T., van Donselaar, K. H., Broekmeulen, R. A. C. M., & Fransoo, J. C. (2007). Consumer responses to shelf out-of-stocks of perishable products. International Journal of Physical Distribution and Logistics Management, 37(9), 704–718. https://doi.org/10.1108/09600030710840822

Xin, G., Messinger, P. R., & Jin, L. (2009). Influence of soldout products on consumer choic. Journal of Retailing, 85(3), 274–287. https://doi.org/10.1016/j.jretai.2009.05.009

Xu, Y., & Wang, Z. (2018). Assortment optimization for a multi-stage choice model. SSRN. https://doi.org/10.2139/ssrn.3243742

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, 199(3), 759–768. https://doi.org/10.1016/j.ejor.2008.08.004

Yuzevych, V., Pawlowski, G., Рavlenchyk, A., Mysiuk, R., Tyrkalo, Y., & Ilchyshyn, M. (2023). Optimization of the management decision regarding the assortment policy of the enterprise using mathematical modeling under conditions of risk. Internauka: Economic Sciences, (2). https://doi.org/10.25313/2520-2294-2023-2-8532

Zhang, J., & Nault, B. R. (2024). Upstream information sharing in platform-based e-commerce with retail plan adjustment. Decision Support Systems, 177, Article 114099. https://doi.org/10.1016/j.dss.2023.114099

Zhang, W., Hao, J., & Liu, F. (2024). Effective social spider optimization algorithms for distributed assembly permutation flowshop scheduling problem in automobile manufacturing supply chain. Scientific Reports, 14, Article 6370. https://doi.org/10.1038/s41598-024-57044-8