Journal of the Eastern Asia Society for Transportation Studies
Online ISSN : 1881-1124
ISSN-L : 1341-8521
D: Logistics and Freight Transportation
Developing an Excel-Based Route Planning System for Agricultural Products Pickup and Delivery in Benguet, Philippines
Alerik Ezekiel RUIZKrister Ian ROQUELAlexis FILLONEMarla MANIQUIZ-REDILLAS
Author information
JOURNAL FREE ACCESS

2025 Volume 16 Article ID: PP4227

Details
Abstract

Agricultural development is a potent tool to combat extreme poverty, boost shared prosperity, and provide for the projected 9.7 billion people by 2050. Minimizing food waste often involves improving practices at various stages of the ASC, such as better storage methods, more efficient transportation, and optimized distribution systems. The main study area is Benguet, known as the “Salad Bowl of the Philippines” because of its high production of upland vegetables. This study hopes to provide a more robust and efficient transportation of the produce through a route Planning system that provides trip chaining opportunities in the study area using Excel and Excel Visual Basic Advance (VBA) with no internet connection after initialization. Based on the EMME software’s baseline model and trial run of the program, the study has proven that Excel VBA can be utilized to provide a skeletal route Planning system for the primary stakeholders of the study area.

Content from these authors
© Eastern Asia Society for Transportation Studies
Previous article Next article
feedback
Top