In-town tour optimization of conventional mode for municipal solid waste collection.
No Thumbnail Available
Date
2013-11
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Nigerian Journal of Technology (NIJOTECH), . Published by Faculty of Engineering, University of Nigeria, Nsukka, Enugu State, Nigeria.
Abstract
This study study study study illustrates the application of a simple and efficient Solver add illustrates the application of a simple and efficient Solver add illustrates the application of a simple and efficient Solver add illustrates the application of a simple and efficient Solver add----in tool in Microsoft Office Excel in tool in Microsoft Office Excel in tool in Microsoft Office Excel in tool in Microsoft Office Excel© ©© © 2010 2010 2010 2010
software for in software for in software for in software for in----town tour optimization of solid waste collection. Data required for tour optimization was town tour optimization of solid waste collection. Data required for tour optimization was town tour optimization of solid waste collection. Data required for tour optimization was town tour optimization of solid waste collection. Data required for tour optimization was
obtained from the municipal authority, field studies, and a digitized map of obtained from the municipal authority, field studies, and a digitized map of obtained from the municipal authority, field studies, and a digitized map of obtained from the municipal authority, field studies, and a digitized map of Ilorin, Nigeria while collection Ilorin, Nigeria while collection Ilorin, Nigeria while collection Ilorin, Nigeria while collection
operation was formulated as a Trav operation was formulated as a Trav operation was formulated as a Trav operation was formulated as a Traveling Salesman Problem on Excel spreadsheet. The results obtained from eling Salesman Problem on Excel spreadsheet. The results obtained from eling Salesman Problem on Excel spreadsheet. The results obtained from eling Salesman Problem on Excel spreadsheet. The results obtained from
the optimization of ten prominent routes revealed that the optimization of ten prominent routes revealed that the optimization of ten prominent routes revealed that the optimization of ten prominent routes revealed that two two two two empirical route empirical route empirical route empirical routes ss s had the same tour had the same tour had the same tour had the same tour distance distance distance distance as the as the as the as the
optimized tour. optimized tour. optimized tour. optimized tour. However, in the remaining eight However, in the remaining eight However, in the remaining eight However, in the remaining eight routes, the optimization process reduced tour distance by routes, the optimization process reduced tour distance by routes, the optimization process reduced tour distance by routes, the optimization process reduced tour distance by 2.04 2.04 2.04 2.04----
19.27 %, tour time by 0.33 19.27 %, tour time by 0.33 19.27 %, tour time by 0.33 19.27 %, tour time by 0.33----22.80 %, and fuel consumption 22.80 %, and fuel consumption 22.80 %, and fuel consumption 22.80 %, and fuel consumption by by by by 1.78 1.78 1.78 1.78----20.54 %. T 20.54 %. T 20.54 %. T 20.54 %. The cost incurred in purchasing he cost incurred in purchasing he cost incurred in purchasing he cost incurred in purchasing
diesel is also expected to decrease by diesel is also expected to decrease by diesel is also expected to decrease by diesel is also expected to decrease by US$0.11 US$0.11 US$0.11 US$0.11----US$1.65/vehicle/day. US$1.65/vehicle/day. US$1.65/vehicle/day. US$1.65/vehicle/day. Therefore, the pro Therefore, the pro Therefore, the pro Therefore, the proposed method posed method posed method posed method can serve can serve can serve can serve
as as as as a a a a valuable tool for reducing some valuable tool for reducing some valuable tool for reducing some valuable tool for reducing some socio socio socio socio----economic and environmental impacts associated with solid waste economic and environmental impacts associated with solid waste economic and environmental impacts associated with solid waste economic and environmental impacts associated with solid waste
collection. collection. collection. collection.
Description
Keywords
Citation
Solid waste, hauled container, conventional mode, Traveling Salesman Problem, tour optimization