Decision support algorithm development for assortment optimization in the retail chain
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

This work is licensed under a Creative Commons Attribution 4.0 International License.
References
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