Versions Compared

Version Old Version 10 New Version Current
Changes made by

Mengji Chen

Lauren Fox

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Stock Status by Product (Figure 1.)

Data submitted by mobile workers are analyzed to assess stock status.This summary report includes:

  1. Product Name: 
    1. the list of
product
    1. products registered (
i.e. Coartem, Condom, Oxytocin)see how to register products here (tbc
    1. How to: Products)
  2. # Facilities: 
    1. number of facilities that have data reported for each product 
    2. number of facilities for each product would differ for each product if the demand for types of products is facility specific (i.e. some facility might only have supply of coartem, some might have all)
    3. number of facilities for products might differ from the total number of facilities if there are facilities not submitting enough data for CommTrack to generate stock status assessment
  3. Stocked out: Percentage of facilities that have no stock of the product during the time range you set
  4. Understocked: percentage of facilities that do not have enough stock to last until next order is received 
  5. Adequate stock: percentage of facilities that have enough stock to last until next order is received
  6. Overstocked: percentage of facilities that have too much stock until next order is received 
  7. Insufficient Data:
CommTrack needs the average quantities of product dispensed in the most recent three months before it could generate all stock status assessments above. (Before getting that amount of data for each facility, you might see gray columns. Once you get there, all gray columns would disappear)  

 

Inventory

An inventory is the process of counting the total numbers of units of products at any given time. An inventory report could hold information about all the coartem in a storage facility. It includes: 

  • Total SOH (total stock on hand of coartem in the clinic) 
  • Total AMC (total average monthly consumption, aka the amount of coartem delivered to the clinic per month)
  • Remaining MOS : remaining stock measured in months, this gives an assessment of how long the coartem supply in the clinic will last. It is the result of dividing Total SOH by Total AMC)
    • Stock Status (the status is decided by two factors: Stock Level settings and the remaining MOS. See documentation on stock level settings)
  •  If Remaining MOS < Emergency Level/Low Stock level, understock; 
  •  If Remaining MOS > Adequate & Remaining MOS < Overstock level, adequate
    •  If Remaining MOS > Overstock level, overstock
  • Resupply quantity suggested (the quantity is decided by remaining MOS and the monthly consumption rate. See documentation on Consumption Settings) 
    1. with stock status assessed by the two indicators above (Remaining MOS and Stock Status), RQS gives an suggestion of resupply quantity in your next order/distribution. The value is decided by remaining MOS and the monthly consumption rate configured in your project
    2. Resupply Quantity suggested will not return any real value if the storing facility is over-stocked

    •  

     

     

    Reporting Rate

    This report includes assessment on the reporting time in each district. Threshold for each type of reporting status needs to be spec'd.

     

    Stock Status Map

    overview of all facilities

    Image Removed

     

    Image Removed

    Image Removed

     

    Image Removed

    at facility level

    Image Removed

     

    Reporting Status (map)

    Using a geographic information system (GIS), this report provides a view of every supply point and their current reporting status. This report is designed for web users to easily view mobile worker performance in terms of their reporting time. Say 

    Say an organization Rushmore wants to see how the stock status of  

    This report includes information on the geographic location of all supply points and their current reporting status with a map view. 

     

    Reporting Status (map)

     

     

     

    Figure 1.1

    Image Removed

    Figure 1.2

    Image Removed

     

    Image Removed

    Image Removed

    Image Removed

     

    Image Removed
    1. all data submission would go to insufficient data column temporarily before data submissions for each facility (by mobile user) reach the length of user-configured minimum window for calculation (days). Once data submissions get over the minimum window for calculation, insufficient data column would go away and stock status per facility would be displayed correctly. 

     

    Figure 1.1

    Image AddedFigure 1.2 (This graph means 30% of all facilities in this domain have not submitted enough consumption reports in the minimum window period for CommTrack to provide real-time consumption calculation

    Image Added