INCREASING EFFICIENCY OF VEHICLE ROUTING BY USING VRP SPREADSHEET SOLVER CASE STUDY OF THAINAMTHIP CO., LTD. Research Aticle
Article Sidebar
Main Article Content
Abstract
The objective of this research was to increase the efficiency of the arrangement of freight vehicles. Due to the high competition in logistics business, resulting in logistics business sector They have to find ways to improve their work processes to reduce costs and maximize profits. In this study, the case study of Thainamthip co.,Ltd with the management of the transportation of goods to customers local shopping malls Pathum Thani Province In this study, the routing pattern of Thainamthip co.,Ltd Every day, there are uncertain orders that make it impossible to deliver according to the delivery plan. Make an impact on customer satisfaction may include spoiling The opportunity to sell and cause the company to lose profit and incur higher transportation costs accordingly Therefore, in order to create a transportation plan for the cost-effectiveness of each trip Therefore, this research has applied the theory of solving the problem of route management Vehicle Routing Problem (VRP) and transportation program VRP Spreadsheet Solver Let's develop efficient route management and reduce transportation costs with the goal of delivering products to customers on time make the distance traveled less reduce the cost of transportation as well. The results obtained from this study showed that after the routing method VRPTW Can reduce distance by up to 38% and reduce fuel consumption by 39% per month, valued at 103,860 baht per month.
Article Details
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
This article is published and copyrighted by the Science and Technology Journal. South East Bangkok College
References
P. Veluwan and P. Srimungkul, "Increasing efficiency of vehicle routing by using VRP spreadsheet Solver: A case study of distribution center in khon kaen," The First National and International Conference of Kalasin University 2019: Recent Innovation of Sciences and Social Sciences for Sustainability (2019 KSUC), Kalasin University,15-16 July, 2019, P.120-128.
P. Kanwimon and S. Chansuwan, "The Study of Milk-Run Vehicle Routing Problem and Receiving Schedule Adjustment A Case Study of Just-In-Time Automobile Factory ABC," Thai Journal of Operations Research: TJOR, Vol 9 No 2, P.1-11, July – December, 2021.
N. Binsi and N. Suthikannaruenai, "An Application of Vehicle Routing Technique for Convenient Store’s Equipment Maintenance Scheduling ," Journal of Nakhonratchasima College, Vol.12 No.2,P.105-113, May – August, 2018.
T. Thepharak and P. Ruengchoengchum," Vehicle Routing for Waste Reduction from The Delay of Transportation Process by using Saving Algorithm: A Case Study of Kitcharoensap Chumphae Transport , Khonkaen Province," Srinakharinwirot Business Administration Journal, Vol.13 No.1,P.119-136, January-June, 2022.
S. Sanuthornsrilikit, "Increasing competitiveness of BBB Co., Ltd.," independent study M.B.A. (Logistics Management),University of the Thai Chamber of Commerce, Bangkok, Thailand, 2015.
M. Yothongyot and P. Sawasdisan, "Determining the sample size for research, Academic Service Center Institute for Promotion of Research and Innovation, Nakhon Si Thammarat Province," [Online]. Available: http://dspace.nstru.ac.th. [Accessed: Feb. 27, 2022].