EUVIMEDEUVIMED entdecken
Open Access · CC BY-SA 4.0

Determining Book Distribution Routes by Implementing Vehicle Routing Problems Using Excel Solver at Gunadarma University

Maulida Boru Butar Butar, Alsen Medikano, Yahya Zulkarnain

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).

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →