Title: Full Deliveries by Product

Description/purpose

Calculate the percentage of health units that received a “full delivery” of PAV related supplies during a field coordinator’s site visit.  

Definitions

• Full Delivery Event = when a field coordinator delivers enough stock of either a vaccine so that the Health Unit stock amount after the delivery of that item is greater than or equal to that item’s Ideal Stock Amount. True or False.
• Full Delivery = Existing Stock + Delivered Stock ≥ Ideal Stock Amount (this equation represents the full delivery statistic per item)
• Ideal Stock Amount = is the amount of stock for that item required at the health unit.  This number is derived from the estimated target group number for that specific item.  This metric (wheither the default calculation or the over-ridden amount) is stored in the visit record by the OpenLMIS system.
• Existing Stock: is the amount of stock of an item present when the field coordinator visits a health unit.
• Distributed Stock: is the amount of stock of an item the field coordinator delivers to the health unit.
• % of health units receiving full delivery of items

Full Delivery Calculation - Products with Single Vial Size

A Full Delivery occurs when the delivered stock amount plus the existing stock amount is greater than or equal to the ideal stock amount.  This is a binary event, either it happened or it didn’t.

Calculation: Delivered Stock (in doses) + Existing Stock (in doses) >= ISA (in doses)

If a facility is not visited, there is not a full delivery

Tableau Calculation:

sum(if 
(((zn([epi_inventory_penta1_existing])+zn([epi_inventory_penta1_delivered])) * [Doses per Vial - Penta1]) >= [epi_inventory_penta1_isa])
or (((zn([epi_inventory_penta10_existing])+zn([epi_inventory_penta10_delivered])) * [Doses per Vial - Penta10]) >= [epi_inventory_penta10_isa])
then 1 else 0
end)

Full Delivery Calculation - Products with Multiple Vial Sizes (Polio 10 dose, 20 dose & Penta 1 dose, 10 dose)

For products with multiple vial sizes, the calculation is complicated by:

A. ISA varies by Vial Size

Each vial size may have a different ISA (if they have different wastage rates). This scenario doesn't occur today (in all cases multiple vial sizes have the same wastage rate) but soon we will have more accurate (and different) wastage rates for both vaccines.

B. Multiple Vial Sizes In Stock, Delivered

Typically, only a single vial size is in use at a health facility. At some point the inventory delivered may switch from one vial size to another. In this case there will be some stock of one size, and some stock of another. 

Business Rules:

1. If a product has more than one vial size, but only one is in use (the other has 0 existing and delivered) , apply the standard Single Vial full delivery calculation rule to the vial size that is in use. 
2. If there is non-zero existing quantity or delivered quantity for more than one vial size of a product, a Full Delivery occurs when the delivered stock plus existing stock of both vial sizes is greater than the max ideal stock amount (of both vial sizes).  The calculation is:
   Delivered Stock (vial size A) + Existing Stock  (vial size A) + Delivered Stock (vial size B) + Existing Stock  (vial size B) > MAX [ Vial Size A ISA, Vial Size B ISA ]  *
   
   * all values in doses

Example

Max ISA is 250. 

 250 <= ((1+0)*20)+((15+8)*10)

Tableau Calculation

Mike to insert

Calculation/aggregation Rules

• If existing quantity is marked as N/R, this is converted to a zero for the purposes of this calculation
• Only visited health units (health units not visited during the period are EXCLUDED) are included in this report.