Optimization of number of checkouts in retail chain using imitational modeling with means of Python programming language

Issue: № 12, 2024

Doi: https://doi.org/10.37634/efp.2024.12.9

This paper explores the optimization of checkout systems in retail supermarkets using simulation modeling. The study employs queuing theory and simulation methods implemented in Python's SimPy package to evaluate and improve the efficiency of checkout operations under various scenarios. The model incorporates customer flow intensity, checkout service rates, and permissible queue wait times, which are dynamically adjusted based on the location type (transport hubs, central districts, or residential areas), day of the week, and peak or non-peak hours. Data sourced from Google Maps on hourly supermarket occupancy levels is used to simulate real-world scenarios. The analysis identifies optimal checkout numbers for different conditions by minimizing total costs, which include operating expenses for checkouts and losses from customers abandoning queues due to excessive waiting times. The results highlight significant differences in optimal checkout numbers depending on supermarket location and customer behavior patterns. For instance, transport hubs require fewer checkouts due to lower peak loads, while central districts demand higher numbers to manage consistent customer flow. Additionally, residential area supermarkets benefit from increased evening checkouts to accommodate after-work shopping surges. Sensitivity analysis reveals that the most critical factors influencing optimal checkout numbers are the maximum allowable wait time, service rate (dependent on average basket size), and customer flow intensity. These findings provide practical recommendations for retail management, suggesting adaptive checkout allocation strategies that align with customer flow patterns and service expectations. The proposed methodologies enhance decision-making and cost-efficiency, offering valuable tools for integrating queue optimization within supermarket management systems.

Keywords : simulation modeling, checkout number optimization, customer flow, checkout productivity, retail

References:

1. Pidhurskyi O.I. Mathematical and simulation modeling of the processes of functioning of a hybrid transaction flow concentration hub. Economy. Finance. Management: Current Issues of Science and Practice. 2018. № 10. pp. 92-107. (in Ukrainian).

2. Xin‐She Yang. Discrete event simulation. 2024. pp. 187-196. URL: https://doi.org/10.1016/b978-0-44-314084-6.00020-6

3. Allen T.T. Theory of Queues. 2011. pp. 79-86. URL: https://doi.org/10.1007/978-0-85729-139-4_6

4. Gautam Natarajan Analysis of Queues: Methods and Applications. CRC Press, 2012.

5. Ravaliminoarimalalason T.B., Randimbindrainibe F. The Poisson Process. Queues Applied to Telecoms / ed T.B. Ravaliminoarimalalason, F. Randimbindrainibe. URL: https://doi.org/10.1002/9781394191987.ch1

6. Wei Xiong, Tayfur Altiok. An approximation for multi-server queues with deterministic reneging times. Annals of Operations Research. 2009. Vol. 172(1). pp. 143-151. URL: https://doi.org/10.1007/S10479-009-0534-3

Download paper