Determining Book Distribution Routes by Implementing Vehicle Routing Problems Using Excel Solver at Gunadarma University
Journal of Renewable Engineering · 2024
DOI: 10.62872/dt01s735 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Renewable Engineering, 2024. Verfasst von Maulida Boru Butar Butar und 2 weiteren Autor:innen. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).
Abstract (Originalsprache)
Gunadarma University operates multiple campuses, each equipped with its own library. To ensure equitable access to newly acquired titles, it is imperative that these materials are disseminated across all campus libraries. So, when a new book title is added, this book must also be owned by the library at each campus location. In this research, book distribution routes with the shortest distance and time will be determined using the Vehicle Routing Problem (VRP) method with Excel Solver. Gunadarma University has a central library which is the starting point for distributing books to other campuses. The central university library serves as the distribution hub, from which books are dispatched to seven additional campus locations. Simulation results using Excel Solver showed that the shortest route for sending books to seven library locations on the Gunadarma University campus using one vehicle was a distance of 137.14 km in 3 hours 12 minutes. This optimized route yielded substantial cost savings, amounting to a 12.5% reduction compared to previous distribution practices.
Zitieren
APA
Butar, M. B. B., Medikano, A., & Zulkarnain, Y. (2024). Determining Book Distribution Routes by Implementing Vehicle Routing Problems Using Excel Solver at Gunadarma University. Journal of Renewable Engineering. https://doi.org/10.62872/dt01s735
Vancouver
Butar MBB, Medikano A, Zulkarnain Y. Determining Book Distribution Routes by Implementing Vehicle Routing Problems Using Excel Solver at Gunadarma University. Journal of Renewable Engineering. 2024. doi:10.62872/dt01s735
BibTeX
@article{Butar2024,
author = {Butar, Maulida Boru Butar and Medikano, Alsen and Zulkarnain, Yahya},
title = {Determining Book Distribution Routes by Implementing Vehicle Routing Problems Using Excel Solver at Gunadarma University},
journal = {Journal of Renewable Engineering},
year = {2024},
doi = {10.62872/dt01s735}
}
EUVIMED