Application of an Open Source Spreadsheet Solver in Single Depot Routing Problem

Abstract

The VRP has been broadly developed with additional feature such as deliveries, selective pickups time windows. This paper presents the application of an open source spreadsheet solver in single depot routing problem. This study focuses on Fast Moving Consumer Goods (FMCG) Company as a case study. The objective of this research is to minimize the distance travel. This research begins by collecting data from a respective FMCG Company. An FMCG company based in Jakarta, Indonesia provides drinking water packaged in the gallon. This FMCG Company has two distributions characteristic. Head office distribution was used in this case study due to highest internally rejected by the company such as un-routed order, no visit, not enough time to visit and transportation issue. Based on computational results, overall solutions to delivered 214 gallons to 26 customers having total distance traveled 56.76 km, total driving time 2 hour and 49 minutes, the total driver working time 7 hours and 57 minutes. Total savings of distances traveled between current route and the proposed solutions using open source spreadsheet solver is 7.25 km. As a result, by using open source spreadsheet solver in single depot routing problem can be implemented in FMCG Company.