×

An optimisation approach for the e-grocery order picking and delivery problem. (English) Zbl 07557115

Summary: Traditional supermarket chains that are adopting an omni-channel approach must now carry out the order picking and delivery processes to serve online orders, previously done by the customer. The complexity of the logistics processes has increased, therefore modelling and optimising e-grocery operations becomes definitely important. Since there are few studies modelling order picking and delivery processes, we propose an approach that simultaneously optimises the decision variables of different functions which have traditionally been treated separately. In this study, we present a linear programming model for store-based e-fulfilment strategies with multiple picking locations. The proposed model optimises the allocation of online orders to stores, based on the e-fulfilment costs. As well as minimising the picking and delivery costs, the proposed approach consolidates workloads in order to avoid idle times and reduce the amount of resources required. A weighted sum method is applied to compute the solution, integrating parameters that represent different store features such as the product range, sales mode and physical store activities. The proposed model has been tested on one of the largest grocery sellers, showing that substantial savings can be achieved by reallocating orders to different stores, time windows and delivery vehicles. By focusing on optimising e-fulfilment resources, this approach serves as a guide for traditional grocery sellers to redesign their supply chains and to facilitate decision-making at a managerial level.

MSC:

90Bxx Operations research and management science

References:

[1] Agatz, N.; Campbell, A.; Fleischmann, M.; Savelsbergh, M., Time slot management in attended home delivery, Transp Sci, 45, 3, 435-449 (2011) · doi:10.1287/trsc.1100.0346
[2] Aksoy, A., Integrated model for renewable energy planning in Turkey, Int J Green Energy, 16, 1, 34-48 (2019) · doi:10.1080/15435075.2018.1531872
[3] Al-nawayseh, MK; Alnabhan, MM; Al-Debei, MM; Balachandran, W., An adaptive decision support system for last mile logistics in E-commerce: a study on online grocery shopping, Int J Decis Support Syst Technol, 5, 1, 40-65 (2013) · doi:10.4018/jdsst.2013010103
[4] Archetti C, Speranza MG, Vigo D (2014) Chapter 10: Vehicle routing problems with profits. In: Vehicle routing: problems, methods, and Applications, 2nd edn. Soc Ind Applied Math, pp 273-297. doi:10.2307/27642002
[5] Aspray W, Royer G, Ocepek MG (2013) Anatomy of a dot-com failure: the case of online grocer Webvan. In: Food internet age. Springer, Cham, pp 25-35. doi:10.1007/978-3-319-01598-9
[6] Belavina, E.; Girotra, K.; Kabra, A., Online grocery retail: revenue models and environmental impact, Manag Sci, 63, 6, 1781-1799 (2016) · doi:10.1287/mnsc.2016.2430
[7] Bernstein, F.; Song, JS; Zheng, X., “Bricks-and-mortar“ vs “clicks-and-mortar”: an equilibrium analysis, Eur J Oper Res, 187, 3, 671-690 (2008) · Zbl 1137.90600 · doi:10.1016/j.ejor.2006.04.047
[8] Bhattacharjya, J.; Ellison, A.; Tripathi, S., An exploration of logistics-related customer service provision on Twitter: the case of e-retailers, Int J Phys Distrib Logist Manag, 46, 6-7, 659-680 (2016) · doi:10.1108/IJPDLM-01-2015-0007
[9] Boyer, KK; Tomas, GT; Frohlich, M., An exploratory analysis of extended grocery supply chain operations and home delivery, Integr Manuf Syst, 14, 8, 652-663 (2003) · doi:10.1108/09576060310503465
[10] Cai, GG, Channel selection and coordination in dual-channel supply chains, J Retail, 86, 1, 22-36 (2010) · doi:10.1016/j.jretai.2009.11.002
[11] Cao, J.; So, KC; Yin, S., Impact of an “online-to-store” channel on demand allocation, pricing and profitability, Eur J Oper Res, 248, 1, 234-245 (2016) · Zbl 1346.90081 · doi:10.1016/j.ejor.2015.07.014
[12] Chintagunta, PK; Chu, J.; Cebollada, J., Quantifying transaction costs in online/off-line grocery channel choice, Mark Sci, 31, 1, 96-114 (2012) · doi:10.1287/mksc.1110.0678
[13] De Kervenoael, R.; Yanık, S.; Bozkaya, B.; Palmer, M.; Hallsworth, A., Trading-up on unmet expectations? Evaluating consumers’ expectations in online premium grocery shopping logistics, Int J Logist Res Appl, 19, 2, 83-104 (2016) · doi:10.1080/13675567.2015.1023186
[14] De Koster RB (2002) The logistics behind the enter click. In: Quantitative approaches to distribution logistics and supply chain management. Springer, Berlin, Heidelberg, pp 131-148. doi:10.1007/978-3-642-56183-2 · Zbl 1005.90502
[15] Emeç, U.; Çatay, B.; Bozkaya, B., An adaptive large neighborhood search for an e-grocery delivery routing problem, Comput Oper Res, 69, 109-125 (2016) · Zbl 1349.90085 · doi:10.1016/j.cor.2015.11.008
[16] Fernie, J.; Sparks, L.; McKinnon, AC, Retail logistics in the UK: past, present and future, Int J Retail Distrib Manag, 38, 11-12, 894-914 (2010) · doi:10.1108/09590551011085975
[17] Fikar, C., A decision support system to investigate food losses in e-grocery deliveries, Comput Ind Eng, 117, 282-290 (2018) · doi:10.1016/j.cie.2018.02.014
[18] Fisher, G.; Kotha, S., HomeGrocer.com: anatomy of a failure, Bus Horiz, 57, 2, 289-300 (2014) · doi:10.1016/j.bushor.2013.12.003
[19] Ghezavati, VR; Hooshyar, S.; Tavakkoli-Moghaddam, R., A Benders’ decomposition algorithm for optimizing distribution of perishable products considering postharvest biological behavior in agri-food supply chain: a case study of tomato, Cent Eur J Oper Res, 25, 1, 29-54 (2017) · Zbl 1364.90201 · doi:10.1007/s10100-015-0418-3
[20] Griffis, SE; Rao, S.; Goldsby, TJ; Voorhees, CM; Iyengar, D., Linking order fulfillment performance to referrals in online retailing: an empirical analysis, J Bus Logist, 33, 4, 279-294 (2012) · doi:10.1111/jbl.12002
[21] He, B.; Gan, X.; Yuan, K., Entry of online presale of fresh produce: a competitive analysis, Eur J Oper Res, 272, 1, 339-351 (2019) · Zbl 1403.90121 · doi:10.1016/j.ejor.2018.06.006
[22] Herhausen, D.; Binder, J.; Schoegel, M.; Herrmann, A., Integrating bricks with clicks: retailer-level and channel-level outcomes of online-offline channel integration, J Retail, 91, 2, 309-325 (2015) · doi:10.1016/j.jretai.2014.12.009
[23] Herrel, K., A visual interactive simulation application for minimizing risk and improving outbound logistical efficiency in time-sensitive attended home deliveries and services, Simulation, 90, 4, 377-404 (2014) · doi:10.1177/0037549714520746
[24] Hübner, A.; Ostermeier, M., A multi-compartment vehicle routing problem with loading and unloading costs, Transp Sci, 53, 1, 282-300 (2018) · doi:10.1287/trsc.2017.0775
[25] Hübner, A.; Wollenburg, J.; Holzapfel, A., Retail logistics in the transition from multi-channel to omni-channel, Int J Phys Distrib Logist Manag, 46, 6-7, 562-583 (2016) · doi:10.1108/IJPDLM-08-2015-0179
[26] Ishfaq, R.; Bajwa, N., Profitability of online order fulfillment in multi-channel retailing, Eur J Oper Res, 272, 3, 1028-1040 (2019) · Zbl 1403.90673 · doi:10.1016/j.ejor.2018.07.047
[27] Kämäräinen, V.; Småros, J.; Holmström, J.; Jaakola, T., Cost-effectiveness in the e-grocery business, Int J Retail Distrib Manag, 29, 1, 41-48 (2001) · doi:10.1108/09590550110366352
[28] Kantar Worldpanel (2018) Global online FMCG sales grow by 13
[29] Klein, R.; Mackert, J.; Neugebauer, M.; Steinhardt, C., A model-based approximation of opportunity cost for dynamic pricing in attended home delivery, OR Spectr, 40, 4, 969-996 (2018) · doi:10.1007/s00291-017-0501-3
[30] Klein, R.; Neugebauer, M.; Ratkovitch, D.; Steinhardt, C., Differentiated time slot pricing under routing considerations in attended home delivery, Transp Sci, 53, 1, 236-255 (2019) · doi:10.1287/trsc.2017.0738
[31] Koufteros, X.; Droge, C.; Heim, G.; Massad, N.; Vickery, SK, Encounter satisfaction in e-tailing: are the relationships of order fulfillment service quality with its antecedents and consequences moderated by historical satisfaction?, Decis Sci, 45, 1, 5-48 (2014) · doi:10.1111/deci.12056
[32] Kovačić, D.; Hontoria, E.; Ros-McDonnell, L.; Bogataj, M., Location and lead-time perturbations in multi-level assembly systems of perishable goods in Spanish baby food logistics, Cent Eur J Oper Res, 23, 3, 607-623 (2015) · Zbl 1339.90217 · doi:10.1007/s10100-014-0372-5
[33] Kuijpers D, Simmons V, Van Wamelen J (2018) Reviving grocery retail: six imperatives. https://www.mckinsey.com/industries/retail/our-insights/reviving-grocery-retail-six-imperatives?cid=eml-website. Accessed 10 Jan 2020
[34] Lin, II; Mahmassani, HS, Can online grocers deliver? Some logistics considerations, Transp Res Rec, 1, 17-24 (2002) · doi:10.3141/1817-03
[35] Mackert, J., Choice-based dynamic time slot management in attended home delivery, Comput Ind Eng, 129, 333-345 (2019) · doi:10.1016/j.cie.2019.01.048
[36] Mackert, J.; Steinhardt, C.; Klein, R., Integrating customer choice in differentiated slotting for last-mile logistics, Logist Res, 12, 1, 5 (2019) · doi:10.23773/2019_5
[37] Marler, RT; Arora, JS, The weighted sum method for multi-objective optimization: new insights, Struct Multidiscip Optim, 41, 6, 853-862 (2010) · Zbl 1274.90359 · doi:10.1007/s00158-009-0460-7
[38] Martín, JC; Pagliara, F.; Román, C., The research topics on e-grocery: trends and existing gaps, Sustainability, 11, 2, 321 (2019) · doi:10.3390/su11020321
[39] Martins, S.; Ostermeier, M.; Amorim, P.; Hübner, A.; Almada-Lobo, B., Product-oriented time window assignment for a multi-compartment vehicle routing problem, Eur J Oper Res, 276, 3, 893-909 (2019) · Zbl 1430.90110 · doi:10.1016/j.ejor.2019.01.053
[40] Melacini, M.; Perotti, S.; Rasini, M.; Tappia, E., E-fulfilment and distribution in omni-channel retailing: a systematic literature review, Int J Phys Distrib Logist Manag, 48, 4, 391-414 (2018) · doi:10.1108/IJPDLM-02-2017-0101
[41] Murfield, M.; Boone, CA; Rutner, P.; Thomas, R., Investigating logistics service quality in omni-channel retailing, Int J Phys Distrib Logist Manag, 47, 4, 263-296 (2017) · doi:10.1108/IJPDLM-06-2016-0161
[42] Netessine, S.; Rudi, N., Supply chain choice on the internet, Manag Sci, 52, 6, 844-864 (2006) · Zbl 1232.90288 · doi:10.1287/mnsc.1060.0512
[43] Ofek, E.; Katona, Z.; Sarvary, M., “Bricks and clicks”: the impact of product returns on the strategies of multichannel retailers, Mark Sci, 30, 1, 42-60 (2011) · doi:10.1287/mksc.1100.0588
[44] Osterwalder, A.; Pigneur, Y.; Oliveira, MA; Ferreira, JJP, Business model generation: a handbook for visionaries, game changers, and challengers, Afric J Bus Manag, 5, 7, 22-30 (2011)
[45] Pan, S.; Giannikas, V.; Han, Y.; Grover-Silva, E.; Qiao, B., Using customer-related data to enhance e-grocery home delivery, Ind Manag Data Syst, 117, 9, 1917-1933 (2017) · doi:10.1108/IMDS-10-2016-0432
[46] Peidro, D.; Mula, J.; Jiménez, M.; del Mar, Botella M., A fuzzy linear programming based approach for tactical supply chain planning in an uncertainty environment, Eur J Oper Res, 205, 1, 65-80 (2010) · Zbl 1187.90184 · doi:10.1016/j.ejor.2009.11.031
[47] Peinkofer, ST; Esper, TL; Smith, RJ; Williams, BD, Assessing the impact of price promotions on consumer response to online stockouts, J Bus Logist, 36, 3, 260-272 (2015) · doi:10.1111/jbl.12095
[48] Pires, M.; Pratas, J.; Liz, J.; Amorim, P., A framework for designing backroom areas in grocery stores, Intl J Retail Distrib Manag, 45, 3, 230-252 (2017) · doi:10.1108/IJRDM-01-2016-0004
[49] Punakivi, M.; Saranen, J., Identifying the success factors in e-grocery home delivery, Int J Phys Distrib Logist Manag, 29, 4, 156-163 (2001) · doi:10.1108/09590550110387953
[50] Ring, LJ; Tigert, DJ, Viewpoint: the decline and fall of Internet grocery retailers, Int J Retail Distrib Manag, 29, 6, 264-271 (2001) · doi:10.1108/09590550110393956
[51] Rodríguez García, M.; Domínguez Caamaño, P.; Comesaña Benavides, JA; Prado-Prado, JC, Designing a fair, financially sustainable pay rate for owner-operator truck drivers. Modelling and case study, Eng Econ, 63, 3, 250-272 (2018) · doi:10.1080/0013791X.2017.1414342
[52] Scott, CH; Scott, JE, Efficient allocation of online grocery orders, Int J Product Qual Manag, 1, 1-2, 88-102 (2006) · doi:10.1504/IJPQM.2006.008375
[53] Vahidinasab, V.; Jadid, S., Joint economic and emission dispatch in energy markets: a multiobjective mathematical programming approach, Energy, 35, 3, 1497-1504 (2010) · doi:10.1016/j.energy.2009.12.007
[54] Valle, CA; Beasley, JE; da Cunha, AS, Optimally solving the joint order batching and picker routing problem, Eur J Oper Res, 262, 3, 817-834 (2017) · Zbl 1375.90025 · doi:10.1016/j.ejor.2017.03.069
[55] Vanelslander, T.; Deketele, L.; Van Hove, D., Commonly used e-commerce supply chains for fast moving consumer goods: comparison and suggestions for improvement, Int J Logist Res Appl, 16, 3, 243-256 (2013) · doi:10.1080/13675567.2013.813444
[56] Wang, Z.; Liang, W.; Hu, X., A metaheuristic based on a pool of routes for the vehicle routing problem with multiple trips and time windows, J Oper Res Soc, 65, 1, 37-48 (2014) · doi:10.1057/jors.2013.4
[57] Williams, HP, Model building in mathematical programming (2013), Hoboken: Wiley, Hoboken · Zbl 1261.90003 · doi:10.2307/253935
[58] Wollenburg, J.; Hübner, A.; Kuhn, H.; Trautrims, A., From bricks-and-mortar to bricks-and-clicks: logistics networks in omni-channel grocery retailing, Int J Phys Distrib Logist Manag, 48, 4, 415-438 (2018) · doi:10.1108/IJPDLM-10-2016-0290
[59] Yanik, S.; Bozkaya, B., A new VRPPD model and a hybrid heur istic solution approach for e-tailing, Eur J Oper Res, 236, 3, 879-890 (2014) · Zbl 1304.90048 · doi:10.1016/j.ejor.2013.05.023
[60] Zadeh, L., Optimality and non-scalar-valued performance criteria, IEEE Trans Autom Control, 8, 59-60 (1963) · doi:10.1109/TAC.1963.1105511
[61] Zissis, D.; Aktas, E.; Bourlakis, M., A new process model for urban transport of food in the UK, Transp Res Procedia, 22, 2016, 588-597 (2017) · doi:10.1016/j.trpro.2017.03.048
[62] Zissis, D.; Aktas, E.; Bourlakis, M., Collaboration in urban distribution of online grocery orders, Int J Logist Manag (2018) · doi:10.1108/IJLM-11-2017-0303
This reference list is based on information provided by the publisher or from digital mathematics libraries. Its items are heuristically matched to zbMATH identifiers and may contain data conversion errors. In some cases that data have been complemented/enhanced by data from zbMATH Open. This attempts to reflect the references listed in the original paper as accurately as possible without claiming completeness or a perfect matching.