Computerization of Logistics Information for Improved Supply Chain Management

1. Computerization of Logistics Information for Improved Supply Chain Management Presentation at JSI 5 November 2009

2. Topics • Background to supply chain management • Tools review • Discussion of challenges and successes

3. The Supply Chain MOH, MoF Proc Agents Courtesy: JSI/DELIVER

4. Global Need Courtesy: JSI/DELIVER

5. Supply Chain Software Functional Overview Global Reproductive Procurement Health Information Interchange l System a n Reports forecasts o and orders i t a n Delivers to r e t n I International Manufacturer Delivers to Delivers to ORION Distributor Orders from Procurement PipeLine , Service Requests ProQ Deliveries l a n o i Health Program t a Manager N Reports Supply Chain to Manager Logistics Reports National Management Unit to Warehouse Delivers to l a n o Sub - national i Reports to g warehouse e Last Mile Delivers to R Technologies , Mobile Tech Orders from y e r Orders from c e i v Service Delivery v Reports to i r l Point e e S D

6. Topics • Background to supply chain management • Tools review • Discussion of challenges and successes

7. Website: http://rhi.rhsupplies.org

9. RHI Inputs and Outputs UNFPAATLAS IPPFSunBusiness Summary of Shipments Crown Agents (DfID)RAP Value Summary IRH Excel Quantity Summary USAIDMy Commodities RHI Geographic Summary MSI Excel Shipment History Govt. of Nepal Excel Shipment Details Govt. of Uganda Excel DKT/Ethiopia Excel Other, future… (Govts., PSI)

11. Users and Uses • TA Providers: preparation for country-specific TA for forecasting, procurement, financing context • MoH RH Program Mgrs: planning & budgeting • Commodity Managers: monitoring of shipments • Donors: coordination • Contraceptive Security Committees: share information, strategize, mobilize resources • Advocates & Researchers: advocacy, support for campaigns and research questions

12. Information Goods ORION™ Version 10.3.0 – 3i Infotech Supply Management ORION Distribution Centers Vendors / Manufacturers

13. View Shipments>> Shipment Summary Reports>> Account Information>> Inventory>> Shipping Information>> Product Catalogue>> Support>> http://deliver.jsi.com/dhome/mycommodities

14. PipeLine Monitoring and Procurement Planning

15. Inputs Outputs

19. PipeLine - Users and countries Program managers and consultants in: Bangladesh, Burkina Faso, Dominican Republic, El Salvador, Ghana, Honduras, Liberia, Malawi, Mozambique, Nepal, Nicaragua, Paraguay, Rwanda, Tanzania, Uganda, Zambia, Zimbabwe

20. ProQQuantification Software for HIV Tests

21. Current Uses of testing: • Blood Safety • VCT • PMTCT • Testing HIV-exposed babies • Clinical Diagnosis • Sentinel Surveillance • Other

22. ProQ: Advocacy Tool for Resource Mobilization and Funding Allocations

23. ProQ - Users and countries • Logistics Advisors • Program Managers and Planners • Product Managers • Procurement Officers and Agents • Donors • Ghana • Zambia • Zimbabwe

24. Main Menu

25. Main inputs & features Inputs: • Quantities issued to facilities or dispensed to users • Quantities received • Losses/adjustments • Stock on hand • Main features: • - Supply status and distribution of stocks at each SDP and storage facility • - Quantities of products dispensed to user • - Trends in commodity consumption for program evaluation and procurement planning • - Service statistics, such as new and continuing users • - Couple years of protection (CYP), calculated for family planning products dispensed • Percentage of facilities reporting, names and locations

26. Delivery Planning Screen

27. Delivery Planning Screen

28. Supply Chain Manager:Users and countries • Program staff and MOH counterparts • Malawi • Zambia • Nigeria

29. Technologies & trends • Mobile technology for capturing data • Web based Logistics Information System • Open source development • Network analysis

31. Supply Chain Guru™LLamasoft, Inc. Supply Chain Network Design • Network Modeling through • Network Optimization • Inventory Optimization • Enterprise Simulation Baseline Network Optimized Network

32. Does using 3-month historical average smooth away variability? • Table below compares projected demand based on 3 month historical averages to the actual demand for 2007 • Red highlights represent projected under-estimating by more than 20% • Yellow highlights represent projected demand over-estimating by more than 20% • Results: 50% of the time the projected was either over or under by more than 20%. Using projections based on 3-months historical data does not necessarily remove variability. Complexity of system requires the use of advanced supply chain modeling software.

33. Effect of Variability on Solola Health Center Condom Stock Outs and Emergency Orders • Scenario Outputs • Stock Out Periods • no variability scenario – 0 • 25% variability scenario – 1 • 50% variability scenario – 5 • Instances Crossing Above Max (overstocked) • No variability scenario – 0 • 25% variability scenario – 5 • 50% variability scenario – 2 • Instances Crossing Below Min (emergency order) • No variability scenario – 0 • 25% variability scenario – 8 • 50% variability scenario – 6 • (Settings: 106 condoms/month; 1/3 month min/max; 2 year period, reorder quantity based on previous 3 month demand)

34. Topics • Background to supply chain management • Tools review • Discussion of challenges and successes

35. Discussion Questions • How has your program used information technology to improve supply operations in a global health setting? • What continue to be the most important hurdles to applying information technology in our context? • What information gaps continue to hamper our ability to assure a transparent and equitable distribution of medical resources?