Bartu ArslanÖzlem ErdinDeniz Gülce DağıstanlıoğluOzan BolelÇağlar SuBanu Yetkin Yetkin EkrenCansu YurtsevenYurtseven, CansuSu, ÇağlarEkren, Banu Y.Arslan, BartuErdin, ÖzlemDağıstanlıoğlu, Deniz GülceBolel, OzanM.N. Osman Zahid , R. Abd. Aziz , A.R. Yusoff , N. Mat Yahya , F. Abdul Aziz , M. Yazid Abu , N.M. Durakbasa , M.G. Gençyilmaz2025-10-0620209789819650583, 9783031991585, 9783031948886, 9789819667314, 9789811937156, 9783030703318, 9789811622779, 9789811969447, 9789819701056, 97898197480519789811509490978303031342521954364, 219543562195-435610.1007/978-3-030-31343-2_562-s2.0-85076209931https://www.scopus.com/inward/record.uri?eid=2-s2.0-85076209931&doi=10.1007%2F978-3-030-31343-2_56&partnerID=40&md5=ded663e2e823bd04a0a2b616f386caa8https://gcris.yasar.edu.tr/handle/123456789/9324https://doi.org/10.1007/978-3-030-31343-2_56This study deals with a daily shipment plan for a bedding company in Turkey. We develop a decision support system optimizing total travel distance of vehicles completing daily shipment plans. In detail the developed models both assign the shipment goods to capacitated vehicles as well as minimize the total travel distance of these vehicles by considering an open vehicle routing algorithm. The decision support system is coded by using the MS excel-macro and a user friendly tool is developed for users’ convenience. In the developed tool there are two different solution approaches: a mixed integer mathematical programming and a heuristic solution approaches. For the small size plans (i.e. less than 25 demand points) mathematical modelling guaranteeing the optimal solution can be utilized. For the large size cases the heuristic algorithm providing a near-optimal result promptly can be utilized. The macro-based tool is designed such a flexible way that the user can make any revisions on the provided plan whenever necessary. © 2022 Elsevier B.V. All rights reserved.Englishinfo:eu-repo/semantics/closedAccessCapacitated Vehicle Routing, Daily Shipment Plan, Decision Support System, Open Vehicle Routing, Optimization, Artificial Intelligence, Decision Support Systems, Heuristic Algorithms, Integer Programming, Ships, Capacitated Vehicle Routing, Capacitated Vehicles, Daily Shipment Plan, Developed Model, Ms Excel, Open Vehicle Routing, Open Vehicle Routing Problems, Optimisations, Solution Approach, Travel Distance, Vehicle RoutingArtificial intelligence, Decision support systems, Heuristic algorithms, Integer programming, Ships, Capacitated vehicle routing, Capacitated vehicles, Daily shipment plan, Developed model, MS Excel, Open vehicle routing, Open vehicle routing problems, Optimisations, Solution approach, Travel distance, Vehicle routingCapacitated Vehicle RoutingOptimizationOpen Vehicle RoutingDaily Shipment PlanDecision Support SystemConference Object