Page Comparison

...

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

For products with multiple vial sizes, a Full Delivery occurs when the delivered stock plus existing stock of both vial sizes is greater than the ideal stock amount.The ideal stock amount is the number of doses of the vaccine needed at the health center, regardless of vial size. For example, the ideal stock of polio doses is 240, and when the field coordinator visits there are currently 40 doses in stock (four 10-dose vials). An addition 200 doses are needed - It doesn't matter if this is fulfilled with twenty 10-dose vials of ten 20-dose vials.

Unfortunately, SELV doesn't support this concept of a general Polio ISA. Instead in SELV there is an ISA for Polio (10 dose) and Polio (20 dose).  These calculations are currently the same for the various sizes: Example:

Image Removed

Calculation: Delivered Stock Polio (10 dose) + Existing Stock Polio (10 dose) + Delivered Stock Polio (20 dose) + Existing Stock Polio (20 dose) > Polio (10 dose) ISA*     Note: All values in calculation are in doses

*because SELV doesn't have a general Polio ISA, the calculation compares the total stock to the Polio (10 dose) ISA. This should be fine, because the Polio (10 dose) and Polio (20 dose) ISAs are the same. If they ever become different, this needs to be re-evaluated.

Tableau Calculation

...

:

sum(if 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)

Multiple Vial Sizes:

Josh to insert)

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.
                                                                                                                                

...