Solving the Problem of Garbage Truck Routing by Modeling Method for Decision Making Using Microsoft Excel Solver: A Case Study of Nong Kob Subdistrict Administrative Organization, Ban Pong District, Ratchaburi Province

Abstract

The purpose of this research is to study the problem model and the routing development for garbage collection of administrative organizations in Nong Kop Subdistrict, Ban Pong District, Ratchaburi province. The evolutionary method is used to find a suitable and efficient routing for collecting solid waste to reduce costs and time. Moreover, new and original solutions are compared. The results showed that the evolutionary method provided a route with an optimal total distance that could reduce operating time and costs, resulting in better results than the original route. Furthermore, there are 8 routes per week with 36 stopping points, 42,350 kilograms of solid waste per week, and the total distance is reduced to 6.75 kilometers per week. As a result, fixed costs and variable costs were reduced, such as the wage rate, which was decreased by 25,200 baht/month and 302,400 baht/year, and fuel consumption, which was decreased by 675 baht/month or 8,100 baht/year. In addition, the new route has a reasonable workload in terms of distance in each route that is more suitable than the original route.