Solving Vehicle Routing Problem: A Case Study of ABC Drinking Water Company Limited
Keywords:Vehicle routing, Saving Algorithm, Nearest Neighbor Algorithm, Microsoft Excel Solver, VRP Spreadsheet Solver
ABC Drinking Water Co., Ltd. is one of the water drinking companies in Nakhon Ratchasima province. The company encountered the problem of goods transportation as the new freight transport employees could not effectively manage the vehicle routing, resulting in the reverse transport route over the original route. This problem affected the increase in transportation costs. This research aims to optimize the vehicle routing for drinking water transportation by solving vehicle routing problems with four methods as the Saving Algorithm method, the Nearest Neighbor Algorithm method, Microsoft Excel Solver program, and VRP Spreadsheet Solver program. The collection of routes and location coordinate data was for 20 delivery rounds of drinking water with the A-GPS tracker application and created the transport routes by the Google Maps program. The result showed that the mean distance before vehicle routing was 21.56 ± 8.86 km. The mean distance from the Microsoft Excel Solver was the shortest, about 20.98 ± 8.83 km (decreased 2.69%). While the vehicle routing from Saving Algorithm, the Nearest Neighbor Algorithm, and the VRP Spreadsheet Solver affected the increase of the transportation distance that the average distance of them was 22.06 ± 8.90 km (increased 2.32%), 21.92 ± 9.61 km (increased 1.67%), and 22.15 ± 9.23 km (increased 2.74%), respectively. However, the average distance before vehicle routing and the average distance obtained from four vehicle routing methods were not statistically different (P>0.05). The vehicle routing of water drinking transportation in this research could be used to plan for goods transportation and create the work instruction for transport employees to be the standard operation.
Aungkoonsit, Y., Pichpibul, T., Thanathanomkul, K., Lomprakhon, C., & Sirivorapat Puthpongsiriporn, T. (2017). An application of savings algorithm to solve the vehicle routing problem with simultaneous pickup and delivery. Journal of Business Administration, 6(2), 175-188.
Chaimankong, C., Songsiriyot, W., & Mahapole, S. (2020). Freight Transport and Logistics. Southeast Bangkok Journal, 6(1), 104-115.
Chaiwongsakda, N., Ananaue, P., Jeenaboonrueang, N., Winyangkul, S., Sinnarong, K., Jakkaew, T., & Srisawang, N. (2015). Vehicle routing by using a saving algorithm and the traveling salesman problem: A case study of a drinking water factory. Thai Journal of Operations Research, 3(1), 51-61.
Chunchaiphak, P. (2018). School Bus Routing: A Case Study of Prasitsuksasongkroh School. Master of Engineering Thesis, Ubon Ratchathani University.
Erdogan, G. (2017). An open source spreadsheet solver for vehicle routing problems. Computers & Operations Research, 84(1), 62–72.
Food Intelligence Center. (2021). Still Bottled Water Market in Thailand. Retrieved from http://fic.nfi.or.th/MarketOverviewDomesticDetail.php?id=329
Gao, J., Gu, F., Hu, P., Xie, Y., & Yao, B. (2016). Automobile chain maintenance parts delivery problem using an improved ant colony algorithm. Advances in Mechanical Engineering, 8(9), 1–13.
Goldberg, D. (1989). Genetic Algorithms in Search, Optimisation and Machine Learning. Massachusetts: Addison-Wesley.
Jakara, M., Pasagic Skrinjar, J., & Brnjac, N. (2019). Vehicle routing problem – Case study on logistics company in Croatia. International Journal for Traffic and Transport Engineering. 9(4), 456-470.
Jaruphat, O., & Chaovalitwongse, P. (2013). Heuristic for open vehicle routing problem to reduce transportation cost. Engineering Journal, 4(3), 57-72.
Jitt-Aer, K. (2017). Vehicle routing problem with stochastic demand. NKRAFA Journal of Science and Technology, 13(13), 19-24.
Karthik, G.R.P., & Reddy, K.D. (2019). A Comparative analysis of vehicle routing problem in APSRTC firm. International Journal of Applied Engineering Research. 14(21), 4042-4046.
Kasamtaranan, N., & Tiewtong, H. (2019). Routing for gasoline transportation: A case study of gasoline transport service company. Interdisciplinary Sripatum Chonburi Journal, 6(2), 91-98.
Kulkarni, S., Sohani, N., & Sehta, N. (2014). Capacitated vehicle routing using nearest neighbor algorithm in supply chain. International Journal of Engineering Research & Technology, 3(5), 1331-1334.
Phanphiphat, P., & Khemavuk, P. (2019). Vehicle routing arrangement of heavy trucks for bulk and sack products: A case study of transportation. Kasem Bundit Engineering Journal, 9(1), 136-151.
Pitacaso, R. (2011). Metaheuristic to Solve the Problems of Production Planning and Logistics Management (1st ed.). Bangkok: Technology Promotion Association (Thailand-Japan).
Ragsdale, C. (2015). Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics (7th ed.). Connecticut: Cengage Learning.
Rattanapongporn, K., & Rahotan, J. (2016). Vehicle routing for delivery of the transportation car service: A case study of Sin Chai Auto Limited Partnership. Sripatum Chonburi Journal, 12(4), 55-64.
Rungrodchatchaval, N., Sriswang, I., & Kongkaew, W. (2016). Application of the vehicle routing problem for solid waste collection: A case study of Prince of Songkla University, Hat Yai campus. Thai Journal of Operations Research, 4(2), 18-31.
Saboohom, S., Phanomthip, A., Pimsang, S., & Supattananon, N. (2021). The Vehicle Routing using Nearest Neighbor Algorithm: A Case Study of LPG tank transportation. In Proceeding of the 8th NEU National Conference 2021: Integrated Research and Innovation for the New Normal Society (pp. 1347-1355). Khon Kaen, North Eastern University.
Sahroni, T.R., Anggoro, L.A., Ismail, S., & Aerna. (2018). Application of an open source spreadsheet solver in single depot routing problem. International Journal of Supply Chain Management, 7(6), 375-371.
Si Mueang, K. (2007). Finding the Number of Trucks that are Suitable for Transportation of Goods in the Retail Business. A Case Study of Tops Supermarket. Master of engineering thesis, King Mongkut's university of technology north Bangkok
Srisen, W. (2013). Vehicle Routing Problem for Cost Reduction : A Case Study of TTK Logistics (Thailand) Co.,Ltd. Master of Business Administration Thesis, University of the Thai Chamber of Commerce.
Sueni, K. (2020). The routes transportation by comparison between using the saving algorithm and the nearest neighbor algorithm. Economics and Business Administration Journal Thaksin University, 12(2), 1-14.
Thippayakraisorn, S. (2011). A future of Thailand’s transportation “dream becomes true or drifting imaginary,”. Executive Journal, 31(3), 99-104.
Veruwan, P., & Srimungkul, P. (2019). Increasing efficiency of vehicle routing by using VRP spreadsheet Solver: A case study of distribution center in Khon Kaen. In Proceeding of the first National and International Conference of Kalasin University 2019 : Recent Innovations of Science and Social Sciences for Sustainability (pp. 120-128). Kalasin: Kalasin University.
Wajanawichakon, K., & Srisurin, K. (2018). Solution methods for vehicle routing problems of garbage truck: A case study of Ubon District, Ubon Ratchathani Province. UBU Engineering Journal, 11(2), 41-52.
Yongpisanphob, W. (2019). Industry Outlook 2019-2021: Beverage Industry. Retrieved from https://www.krungsri.com/en/research/industry/industry-outlook/Food-Beverage/Beverage/IO/io-beverage-20-th
How to Cite
Copyright (c) 2022 Economics and Business Administration Journal Thaksin University
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.