Facility Level Requirements Tool
Facility Level Initial Requirements Tool [XLS, 104KB]
This tool calculates the initial supply of LPV/r pellets to deliver to individual facilities. Subsequent deliveries will account for changes in consumption patterns through the normal resupply calculation system.
Calculating Initial Supply of LPV/r Pellets to Deliver By Facility
There are three tabs in this worksheet.
- The first tab is the data entry tab that allows you to enter the base data that affects the last two tabs with basic information.
- The second tab allows you to calculate initial supply quantities at the facility level using a maximum-minimum inventory control system.
- The third tab allows you to calculate initial supply quantities at the facility level using order interval plus buffer stock.
Before you begin entering data into the tool, please note that you will need the following information:
- Maximum or target stock level for facilities or resupply intervals and desired buffer stock.
- Scale-up plan information which would require the number of patients to be using LPV/r pellets per facility by the end of Month 4; and the percentage of these patients using LPV/r pellets by the end of Months 1, 2 and 3.
- A separate workbook should be used for facilities that are not starting in Month 1.
Note on estimating percentage of patients expected to be on LPV/r pellets. Although a program may have a planned rate for transitioning patients to LPV/r pellets from another formulation (e.g., solution), it is important to realize that some health facilities may transition at a slower or faster pace. In order to have the most accurate information on transition rates as possible, here are a few strategies that you can use:
- Survey facilities to better determine:
- percentage of consumption that is pellets/solution versus tablets.
- percentage of patients who take pellets/solution versus tablets.
- percentage of patients in each age/weight band.
- Survey a sample of large, medium, and small facilities, and call them or carry out data collection to triangulate and/or verify the data that are being used at the national level for the forecasting, distribution plan, etc.
- Remember to include patients who will be started directly on the regimen using LPV/r pellets, e.g., not transitioning from another formulation.
- Include the average number of bottles dispensed to each patient per month. For the most accurate estimate, it is helpful to know the general proportion of smaller babies to larger infants (see survey results above).