In Guatemala, Data Visibility Supports Better Decision Making

Topics:
Related Supply Chain Topics
Related Global Health Areas
Date
Lead Paragraph/Summary

During the past 18 years, Guatemala’s Ministry of Health (MOH) has had varying degrees of success in designing and implementing a system to track stock levels, distribution and consumption patterns of medicines — critical information that is used to identify risks of overstock, expiry and stockouts, and to ensure that actions are taken on time to avoid them.

Various versions of these systems — also called logistics management information systems (LMIS) — were introduced, but the MOH’s Logistics Management Unit and its other health programs continued to rely on spreadsheet-based systems, which were not stable enough to sustain large data sets, usually beyond 10,000 records. Therefore, staff had to consolidate logistics data by hand through a time-consuming cut-and-paste process that limited the availability of reliable data. 

Over time, however, advances in information and communication technology — particularly the adoption of cloud-based systems and improvements in local access to the internet — provided new opportunities to develop systems that would be more efficient, less costly, and better meet the needs of the public health supply chain system. 

Paragraphs
Heading
A simple, low-cost, open-source solution: The Online Logistics Information Integrator
Body

Recognizing that simple-to-use, low-cost tools are often more effective, GHSC-PSM used free, open-source technology to help develop the Online Logistics Information Integrator.

At the 16 hospitals providing HIV/AIDS treatment, personnel in charge of logistics management use the Integrator to upload their monthly balance and requisition forms, which report on the actual levels of stock. This process eliminates the cut-and-paste operation previously used to consolidate all logistics information at the central level of the national HIV/AIDS program. An operation that once took one person over 10 days now takes just one day. 

A snapshot of monthly stock-on-hand reports allow users to identify risk of stock out for antiretroviral medicines used in HIV/AIDS treatment and take action to prevent stock out. A snapshot of monthly stock-on-hand reports allow users to identify risk of stock out for antiretroviral medicines used in HIV/AIDS treatment and take action to prevent stock out. The red box indicates risk of stock out; yellow indicates stock levels below agreed minimum; green indicates appropriate stock levels; and black indicates levels above agreed maximum.

In addition to the consolidation of information, the Integrator has many other features that support decision making. For instance, the Integrator generates a variety of reports, some designed to identify potential stockouts so that corrective actions can be taken. Other useful features include:
 

  • Easy to review trends in consumption patterns 
  • The organization of all logistics information by first, second, and third-line antiretroviral medicines (ARVs)
  • The monitoring of ARVs at USAID-priority hospitals
     

The Online Logistics Information Integrator is empowering staff from the National HIV/AIDS program to better understand their entire logistics network for ARVs. Moreover, this tool could be integrated or used as a complement to any future nationwide LMIS.