Excel routing tool for optimizing supply chain distribution

Excel routing tool for optimizing supply chain distribution Mariam Zameer 20 th November, 2019

Thanks to our generous sponsors

Excel Routing Tool for Optimizing Supply Chain Distribution Authors: Larissa P. G. Petroianu, Ph. D candidate 1; Mariam Zameer, Manager, Health Systems 2; Dr. Zelda B. Zabinsky, Professor, Dept. of Industrial & Systems Engineering 1; Mamiza M. Muteia, System Design Officer 2; Aida L. Coelho, Senior Program Manager 2 1 University of Washington; 2 Village. Reach Mariam Zameer Village. Reach With generous funding from:

Agenda • • • Background Why use this tool? Preparing inputs Interpreting outputs Conclusion 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Background • Developed a user-friendly, Excel-based optimization model • For use in Mozambique as Village. Reach transitions to Government 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Why use this tool? Optimized route on time, risk, or combo Does not require specialized software skills Use in routine and emergencies Easy to use interface Considers road conditions Results in minutes 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Route modelling for distribution HF 1 Store HF 2 HF 4 HF 3

How to use the tool • Prepare the input sheets • Download and run the tool • Attach input sheet • View outputs in minutes 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Prepare Inputs 9

Parameters Easy to follow instructions on every sheet • Minimize total transit time for all vehicles and, hence, spoilage since most risk to vaccines is during transit • Minimize risk to vaccines by using better roads and reliable vehicles

Products and Center Capacities 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Demand Warning for Storage User calculates demand using existing tools, and enters in the tool Tool detects and pre-populates the products from the input sheet Adjust demand till warning does not show Enter demand for vaccines (in doses) and other supplies in units

Vehicle

Distance User enters distance from each center based on location and/or GPS coordinates Tool detects and pre-populates the centers from the input 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Road Conditions User selects the road condition for going and returning, separately

Interpreting Outputs 16

Outputs • Easy to read, copy, and print results in Excel Shows time to leave health center, order of visit and road condition 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Outputs Storage utilization for products delivered Quantity of products 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Conclusions • Easy optimized routing for use by governments, for more cost-effective or reduced risk in deliveries • Can easily update for centers and road conditions in emergency situations • Can quickly update which vehicles to use for optimized route, based on vehicles available for delivery that month • Easy to read, interpret and print outputs • Less reliance on technical partners, as governments can run the tool themselves and get results in minutes 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Questions? 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa

Thanks to our generous sponsors 2019 Global Health Supply Chain Summit, Johannesburg, S. Africa