CHAI Simple ARV Forecasting Tool (CHAI Simple Tool)

When forecasting adult and/or pediatric ARV in treatment programs and when looking to manage demand on a clinic level.

Quantification

  • Sub-categories HIV/AIDS
  • Commodities Medicines
  • Latest update 2017-02-15 00:00:00
  • Version 6.0
  • Developed by CHAI
  • When to use When forecasting adult and/or pediatric ARV in treatment programs and when looking to manage demand on a clinic level.
  • Languages English, French
  • Level of use Central, District, Facility, Regional
  • Form MS Excel-based software - 2 files, 3.4MB
  • Amount of training / TA required Minimal - a few hours
  • Inputs & outputs Inputs: - Current patients on ARV treatment - Treatment targets - Distribution over regimens – Pediatric Weightband Distribution - Required security stock - Drug prices - Central stock inventory. Outputs: - Demand for each formulation over next 36 months, taking into account current stock - Total cost
  • Cost Free
  • Advantages Inputs: - Current patients on ARV treatment - Treatment targets - Distribution over regimens – Pediatric Weightband Distribution - Required security stock - Drug prices - Central stock inventory. Outputs: - Demand for each formulation over next 36 months, taking into account current stock - Total cost
  • Limitations Extensive modifications require strong knowledge of Excel and Visual Basic for Applications (VBA)
  • Availability Free to all organizations with ARV program. Contact CHAI to receive a copy of this tool
  • Remarks An example of a filled-in template is included to highlight full functionality of both Adult and Pediatric forecasting tools. Please direct any questions to Aude Wilhelm, Procurement Manager, Drug Access Team, Clinton Health Access Initiative
  • Downloadable files CHAI Simple Tool for ARV Forecasting.zip
    CHAI Simple Tool for ARV Forecasting.zip
  • Contact vprabhu@clintonhealthaccess.org
  • Submission date 2017-04-24 02:00:00