Cost Appraisal of Municipal Solid Waste Transfer to Disposal Site Using Visual Basic Program

Document Type : Original Research Paper


1 Department of Civil Engineering, Covenant University, P.M.B. 1023, Ota, Ogun State, Nigeria

2 Department of Water Resources and Environmental Engineering, University of Ilorin, Nigeria



Collection of Municipal Solid Waste (MSW) accounts for a significant proportion of most municipal budgets, and has drawn some degree of researchers‟ interest. This study was conducted in Ota, Southwest Nigeria, to explore the use of Visual basic program as an innovative tool to select the most economic haulage system among three systems found in literature (conventional-, modified- and Stationary- hauled system) for collection and transfer of MSW to disposal sites. Factors that affect the costs of collection and transportation of waste such as: vehicle cost, total time spent on waste collection, and gross travel cost, were considered in the analysis. The result of the study shows that the stationary hauled method of waste collection is the optimal and economical method of collection. This method recorded a 56% and 43% reduction in total cost of daily travel per waste collection, as compared to the conventional and the modified systems, respectively. The application of visual basic program proffers implementable solutions to reduce the cost of MSW transportation to disposal sites. This would reduce travel time and costs of vehicle fueling, and increase the prompt collection of waste which would in turn facilitate the development of an aesthetically balanced and environmentally friendly municipality that would perhaps boost economic development.


Agunwamba, J.C. (2001). Waste Engineering and Management Tools. Immaculate publications Ltd, Enugu. pp. 307.
Agunwamba, J. C. (2003). Optimization of Solid Waste Collection System in Onitsha, Nigeria, Int. J. of Environmental Issues, 1(1), 124-135.
Agunwamba, J.C., Egbuniwe, N., and Ogwueleka, T.C. (2003). Least cost management of solid waste collection. Journal of Solid Waste Technology and Management, 29 (3), 154-167.
Arebey, M. Hannan, M.A., Begum R.A. and Basri, H. (2012). Solid waste bin level detection Using graylevel co-occurrence matrix feature extraction approach, J Env Management, 104, 9-18.
Aremu, A.S., Sule, B.F., Downs, J. and Mihelcic, J.R. (2012). Framework to determine the optimal number and spatial location of municipal solid waste bins in a developing world urban neighborhood, Journal of Environmental Engineering, Vol. 138 (6), 645–653.
Chang, N.B. and Wei, Y.L. (2002). Comparative study between heuristics algorithm and optimization technique for vehicle routing and scheduling in the solid waste management system. Civil Engineering and Environmental System, 19 (1), 41-65.
Di Felice, P. (2014a). Integration of Spatial and Descriptive Information to Solve the Urban Waste Accumulation Problem. Procedia - Social and Behavioral Sciences, 147, 182-188.
Kao, J., Tsai, Y. and Huang, Y. (2013). Spatial Service Location-Allocation Analysis for Siting Recycling Depots. J. Environ. Eng.-ASCE, 139(8), 1035–1041.
Kyessi, A and Mwakalinga, V., (2009). GIS Application in Coordinating Solid Waste collection: The Case of Sinza Neighborhood in Kinondoni Municipality, Dar es Salaam City, Tanzania. Unpublished Paper Presented in to Surveyors Key Role in accelerated Development, Eilat, Israel, 3-8 May 2009.
McDonald, M. (2009). Microsoft Visual Basic.Net Programmers Cookbook. ISBN 9780735637436. Published by O‟Reilly Media.
National Population Census (2006). Volume 1 of the national population census. Pp15, Date Accessed: 10/12/2012.
Nguyen, T.T. and Wilson, B.G. (2010). Fuel Consumption Estimation For Curbside Municipal Solid Waste (MSW) Collection Activities. Waste Management & Research, 28 (4): pp.289–297.
Nithya, R., Velumani, A. and Kumar, S.R.R. (2012). Optimal location and proximity distance of municipal solid waste collection bin using GIS: A case study of Coimbatore city, WSEAS Transactions on Environment and Development, 8(4), 107-119.
Ogwueleka, T.C. (2003). Analysis of urban solid waste in Nsukka, Nigeria. Journal of Solid Waste Technology and Management, 29 (4), 239-246.
Ogwueleka, T. C. (2009). Route Optimization for Solid Waste Collection: Onitsha (Nigeria) Case Study. J Appl Sci Environ Manag, 13 (2), 37- 40.
Ojiako, G.U. and Nwosu, A.D. (1989). Optimal Strategy for Solid Waste Collection in Nigeria Urban Towns. A Case Study Proc. of Eng. Research for Develop., Sept. 25-28, p 38-43.
Olukanni, D. O. and Akinyinka, O. M. (2012). Environment, Health and Wealth: Towards an analysis of municipal solid waste management in Ota, Ogun State, Nigeria. Presented at the International Conference on Clean Technology and Engineering Management, Covenant University, Ota, Nigeria, ICCEM (2012) 51 – 71.
Olukanni, D. O. (2013). Analysis of Municipal Solid Waste Management in Ota, Ogun State, Nigeria: Potential for Wealth Generation. Proceedings of the International Conference on Solid Waste Management (ICSW), Widener University, Chester, Philadelphia USA, 10th –13th March, 2013.
Olukanni, D. O., Akinyinka, O. O., Ede, A. N., 
Akinwumi, I. I. and Ajanaku, K. O. (2014). Appraisal of Municipal Solid Waste Management, Its Effect And Resource Potential In A Semi-Urban City: A Case Study, Journal of South African Business Research , Vol. 2014, Article ID 705695, DOI: 10.5171/2014.705695 Petroutsos, E. (2010). Mastering Microsoft Visual Basic 2010 Wiley Publishers ISBN: 978-0- 470-53287-4. Purkayastha, D., Majumder, M. and Chakrabarti, S. (2015). Collection and recycle bin location- allocation problem in solid waste management: A review. Pollution, 1(2), 175-191. Rada, E.C., Ragazzi, M. and Fedrizzi, P. (2013). Web-GIS oriented systems viability for municipal solid waste selective collection optimization in developed and transient economies. Waste Manage. 33(4), 785-792.
Salako, R. A. (1999). Ota: The Biography of the Foremost Awori Town. Penink and Co. pp. 85- 87.
Stessel, R. I., (1996). Recycling and Resource Recovery Engineering. Principle of Waste Processing. Springer, Pp. 155-180.
Teixeira, C.A., Avelino, C., Ferreira, F. and Bentes, I. (2014). Statistical analysis in MSW collection performance assessment. Waste Management 34(9), 1584-1594.
Tchobanoglous, G., Theisen, H., and Vigil, S. A. (1993) Integrated Solid Waste Management: Engineering Principles and Management Issues. McGraw-Hill, 978 pages
Zak, D. (2013). Programming with Microsoft Visual Basic. ISBN 9781285077925. Published by Cengage Learning.
Zurbrugg, C. (2003). Urban Solid Waste Management in Low-Income Countries of Asia: How to Cope with the Garbage Crisis, Urban Solid Waste Management Review Session, Durban, South Africa, 1-10.