Inventory Management
Unit & Central Stock Intelligence
Demand forecasting and full LMIS analysis per unit or Central Store, plus expiry monitoring, requisition anomalies, stock variance and receiving checks.
LMIS Overview — GOPD Pharmacy
Average Monthly Consumption (AMC), Reorder Level (ROL), safety/max stock, and months of stock (MOS) remaining, with a recommendation per item.
| Medicine | Stock | AMC | ROL | Min / Max | MOS | Status | Recommendation |
|---|---|---|---|---|---|---|---|
| Amoxicillin 500mg | 3200 | 1080 | 1500 | 800 / 4500 | 3 | Adequate | Stock within normal range (~3 months of stock) — no action needed. |
| Metformin 1000mg | 2600 | 860 | 1200 | 600 / 3600 | 3 | Adequate | Stock within normal range (~3 months of stock) — no action needed. |
| Salbutamol Inhaler | 1400 | 365 | 500 | 250 / 2000 | 3.8 | Adequate | Stock within normal range (~3.8 months of stock) — no action needed. |
| Bisoprolol 5mg | 520 | 310 | 300 | 150 / 800 | 1.7 | Adequate | Stock within normal range (~1.7 months of stock) — no action needed. |
| Amlodipine 5mg | 610 | 365 | 350 | 175 / 900 | 1.7 | Adequate | Stock within normal range (~1.7 months of stock) — no action needed. |
| Nifedipine 10mg | 95 | 110 | 120 | 60 / 300 | 0.9 | Below Reorder Level | Order 205 units to reach max stock level before it runs out (~0.9 months of stock remain). |
| Atorvastatin 20mg | 780 | 400 | 400 | 200 / 1000 | 2 | Adequate | Stock within normal range (~2 months of stock) — no action needed. |
| Gliclazide 80mg | 340 | 245 | 250 | 125 / 650 | 1.4 | Adequate | Stock within normal range (~1.4 months of stock) — no action needed. |
| Lisinopril 10mg | 430 | 293 | 300 | 150 / 750 | 1.5 | Adequate | Stock within normal range (~1.5 months of stock) — no action needed. |
| Ciprofloxacin 500mg | 88 | 150 | 150 | 75 / 400 | 0.6 | Below Reorder Level | Order 312 units to reach max stock level before it runs out (~0.6 months of stock remain). |
| Ferrous Sulfate 200mg | 560 | 293 | 300 | 150 / 750 | 1.9 | Adequate | Stock within normal range (~1.9 months of stock) — no action needed. |
| Medicine | Stock | Expiry | Risk |
|---|---|---|---|
| Amoxicillin 500mg | 3200 | 08/2026 | Low |
| Metformin 1000mg | 2600 | 11/2026 | Low |
| Salbutamol Inhaler | 1400 | 09/2026 | Low |
| Bisoprolol 5mg | 520 | 05/2027 | Low |
| Amlodipine 5mg | 610 | 07/2027 | Low |
| Nifedipine 10mg | 95 | 02/2027 | Medium |
| Atorvastatin 20mg | 780 | 09/2027 | Low |
| Gliclazide 80mg | 340 | 04/2027 | Low |
| Lisinopril 10mg | 430 | 06/2027 | Low |
| Ciprofloxacin 500mg | 88 | 12/2026 | High |
| Ferrous Sulfate 200mg | 560 | 08/2027 | Low |
Amoxicillin 500mg — Predicted Demand
GOPD Pharmacy · Reorder point: 1500 units · trend: +9.7%/mo
Current Stock Level3200 units
Stock is currently healthy — no urgent reorder action needed.