Water-supply -- Mexico -- Copper Canyon -- Management, Water resources development, Operations research, Vehicle routing problem
The Tarahumara Children’s Hospital Fund (TCHF) is a non-profit organization supporting the indigenous Tarahumara Indians in the Copper Canyon region of Chihuahua Mexico. In 2015, a project was established to improve the management of limited water resources by surveying and thereby identifying the sources most in need of repair or improvement. During the two water supply survey trips completed to date, about half of the ~220 water sources have been visited. To improve the efficiency and effectiveness of a future trip, this project set out to optimize both the survey routes and the volunteer team assignments. The commercial software SAS is used to address the Vehicle Routing Problem (VRP), which provides optimum routing for all the given locations by minimizing the distance traveled while performing work at each site. The team planning problem is formulated using Microsoft Excel. The spreadsheet model is used to schedule the twelve teams for the 6 day period established by the VRP results.
Alkharboosh, Haitham; Guntipalli, Ramya Priya; Forrester, Eva; Jirage, Rushikesh; and Schneider, Ronnie, "Water Supply Survey Planning: Route and Team Optimization" (2017). Engineering and Technology Management Student Projects. 1172.