110 likes | 220 Vues
This study analyzes the current residential trash collection route in Sparta, TN, to identify cost-saving measures. Utilizing GIS, we aimed to create a more efficient route running only three days per week. Our analysis revealed that the existing five-day route covers 103 miles at a cost of $891.64 weekly, totaling $46,365.28 annually. The proposed new route, covering 80 miles, will reduce costs to $855.39 weekly or $44,480.28 yearly. This effective methodology of combining GIS and traditional methods ensures the best balance of efficiency and cost-effectiveness.
E N D
Trash Collection Study For Sparta, TN Daniel Marcum
The Introduction • Perform a cost analysis of the current Residential Trash Collection Route. • Use GIS to create a new route that is more efficient and cost effective. • Requirement for new route: Garbage truck should only run three days per week.
The Data • Roads (from tngis.org) • Parcels (from State of TN) • City Limits (from Sparta GIS)
The Methodology • Loaded necessary files into ArcMap. • Used “polygon to point” tool to create points from parcel polygons. • Used Network Analyst to try to create an efficient route. • Loaded points into “stops” in Network Analyst.
The Methodology • Set options to re-order stops to optimize route. • Crashed ArcMap… 5 times… • Decided to resort to old school methods of calculating efficiency… calculator and common sense.
The Results • The current routes are being ran 5 days per week (103 miles/week). • The current route costs $891.64 per week ($46,365.28/yr). • The new, three-day route(80 miles/week) will cost $855.39 per week ($44,480.28/yr).
The Results • 3.4 mph • 27 miles/day • 3 days/week • 649 stops/day (1,947 stops/week) • 82 stops/hour (about 45 seconds/stop) • 60 miles of road (allowing for 80 miles per week)
Thank You Questions ?