Milk procurement route optimisation using GIS in a farmers’ dairy organisation Subir Mitra Sr.
Download ReportTranscript Milk procurement route optimisation using GIS in a farmers’ dairy organisation Subir Mitra Sr.
Milk procurement route optimisation using GIS in a farmers’ dairy organisation Subir Mitra Sr. Manager NDDB, Anand [email protected] Darsh Worah Dy. Manager NDDB, Anand [email protected] Mena Paghadar Dy. Manager NDDB, Anand [email protected] Milk procurement system in a typical farmers’ dairy organisation Farmers Milk in vessels Dairy Co-op Society (DCS) Milk in cans through vehicles Dairy plant Chilling Centre Through trucks Milk procurement route optimisation using GIS in a farmers' dairy organisation Present case study • A typical milk union in Maharashtra •138 pick up points •Milk collected in two shifts •Routing is manually planned •Farthest point first Milk procurement route optimisation using GIS in a farmers' dairy organisation Vehicle types and their carrying capacity •Tata 407 = 44 cans •Mahindra max = 40 cans •Minidor = 20 cans •Rickshaw = 8 cans * each can of 40 lit capacity. Milk procurement route optimisation using GIS in a farmers' dairy organisation Milk procurement transportation from villages •All vehicles - Start from Dairy plant - Come back to Dairy plant • Dairy co-operative Society – Source points • Dairy Plant – Sink point •Volumes change : Summer and Winter •Medium sized union – 800 source points, 4-6 Chilling centers/Dairy plants Milk procurement route optimisation using GIS in a farmers' dairy organisation Our objective… • Efficient transport system • Minimise transportation cost • Validating current routes • Scope of improvement • Quicker planning Milk procurement route optimisation using GIS in a farmers' dairy organisation Business constraints •Time •Vehicle Capacity •Time windows •Transportation rate Milk procurement route optimisation using GIS in a farmers' dairy organisation Methodology Data Used: •GPS locations of DCS •Road Network Analysis: Vehicle Routing problem using ArcGIS Network Analyst Optimised Routes: 11 Routes covering 138 DCS Milk procurement route optimisation using GIS in a farmers' dairy organisation Pick up points – DCS Dairy plant Vehicle type, Capacity, Max Order count, Max travelling Distance Milk procurement route optimisation using GIS in a farmers' dairy organisation Dairy plant and DCS locations Milk procurement route optimisation using GIS in a farmers' dairy organisation Existing Routes Milk procurement route optimisation using GIS in a farmers' dairy organisation Optimised Routes Milk procurement route optimisation using GIS in a farmers' dairy organisation Optimised and Existing routes Milk procurement route optimisation using GIS in a farmers' dairy organisation Existing route details Route Name Vehical type Trip distance (km) Trip cost 1 TATA 407 119 657 2 MAX 207 91 521 3 TATA 407 108 596 4 TATA 407 156 874 5 TATA 407 114 645 6 TATA 407 141 835 7 TATA 407 143 847 8 RIKSHAW 24 112 9 Max Mah 102 574 10 TATA 407 114 612 11 TATA 207 100 588 12 Max Mah 173 862 13 MINI DOR 60 358 TOTAL 1445 8080 Milk procurement route optimisation using GIS in a farmers' dairy organisation Optimised route details Route Name Vehical type Trip distance (km) Trip Cost 1 Max Mah 145 722 2 Max Mah 130 732 3 Max 207 130 744 4 Tata 407 83 458 5 Tata 407 117 646 6 Tata 407 101 566 7 Tata 407 62 351 8 Tata 407 146 864 9 Tata 407 148 876 10 Tata 407 149 800 11 Tata 407 139 817 Total 1351 7576 Milk procurement route optimisation using GIS in a farmers' dairy organisation Results EXISTING ROUTES: OPTIMISED ROUTES: No of Routes : 13 No of Routes : 11 Total length : 1445 km / Shift Total length: 1350 km/shift Cost of transportation : 0.75 Rs/lit Cost of transportation: 0.70 Rs/lit Annual transportation cost : 59 lakh Annual transportation cost : 55.3 lakh Annual savings of Rs. 3.7 lakh 6 % savings on annual basis Milk procurement route optimisation using GIS in a farmers' dairy organisation Conclusion • GIS Technology for Farmers’ organisation • Initial hand holding and training required • Better road network – Better optimisation Milk procurement route optimisation using GIS in a farmers' dairy organisation Milk procurement route optimisation using GIS in a farmers' dairy organisation