Dashboard
Muhimbili National Hospital — Central Pharmacy
System Online
TZS 4.7M
Today's Revenue
▲ 12.4% vs yesterday
1,284
Prescriptions Dispensed
▲ 8.1% this week
98.7%
Drug Authenticity Rate
● TFDA Compliant
23
Low Stock Alerts
▼ 3 critical items
47
Pending Orders
▲ 6 dispatched today

COUNTERFEIT ALERT: Batch #TZ-2024-AMX-009 (Amoxicillin 500mg) flagged by TFDA — quarantine immediately. 3 units affected.

EXPIRY WARNING: 14 drug batches expire within 30 days. Artemether-Lumefantrine Batch #B4421 — 8 days remaining.

12,847
Authenticated Products (MTD)
+4.2% from last month
3,429
Total SKUs in Stock
98.3% availability
7
Counterfeit Detections (MTD)
+2 new today — report filed
142
Active Supply Routes
18 in transit now
Dispensing Volume — Last 7 Days
Prescriptions fulfilled per day
+8.1%
Category Breakdown
100%
Coverage
Antibiotics30%
Antimalarials20%
Analgesics13%
ARVs7%
Other30%
Recent Transactions
TX IDDrug / BatchPatientQtyAmountStatus
TXN-89241
Amoxicillin 500mg
Batch #B7721
J. Mwangi30 tabsTZS 4,500Completed
TXN-89240
Artemether-Lumef.
Batch #B4421
F. Kibwana6 tabsTZS 8,200Completed
TXN-89239
Metformin 500mg
Batch #C1109
A. Rashid60 tabsTZS 6,000Processing
TXN-89238
Atorvastatin 20mg
Batch #D3302
M. Saleh30 tabsTZS 12,000Completed
TXN-89237
Amoxicillin 500mg
Batch #TZ-009 ⚠
K. Omar15 tabsTZS 2,250Flagged
Batch Expiry Monitor
3 Critical
Artemether-Lumef. #B44218 days
Expiry: 19 Mar 2026 · 240 units remaining
ORS Sachets #ORS-119014 days
Expiry: 25 Mar 2026 · 1,200 units
Paracetamol Syrup #PS-771021 days
Expiry: 1 Apr 2026 · 88 bottles
Metronidazole 400mg #M-002828 days
Expiry: 8 Apr 2026 · 560 units
All Drugs
Antibiotics
Antimalarials
Analgesics
ARVs
Diabetes
Cardiovascular
Supplements

Dispensing Cart

0 items

Fatuma Kibwana · F/34

Rx #PRX-2024-8821 · Dr. Hassan Mwenda · Prescription verified ✓

Cart is empty

Click drugs to add

23 items below reorder point · 3 items out of stock · 7 batches flagged for expiry within 30 days

Automatic reorder enabled for 18 items via approved suppliers
3,429
Total SKUs
TZS 847M
Total Inventory Value
Drug Inventory — Batch Level
Drug NameGeneric NameBatch #CategoryQtyUnit PriceExpiryLocationStatusAction
Drug Authentication Scanner
LUMO AuthChain™

Tap to Scan QR / Barcode

2D QR · 1D Barcode · NFC · DataMatrix supported

VERIFIED — Authentic Product
Amoxicillin 500mg · Batch #B7721 · Pfizer Tanzania Ltd
Mfg: Jan 2024 · Exp: Jan 2026 · Registered: TFDA/MED/2022/0044
SUSPECT — Possible Counterfeit
Amoxicillin 500mg · Batch #TZ-2024-AMX-009 · Unknown Mfr
⚠ Not registered in TFDA database · Quarantine and report immediately
Authentication Statistics
98.7%
Authenticity Rate
7
Counterfeits (MTD)
Anti-Counterfeit Architecture
LUMO AuthChain™
VERIFICATION LAYERS
1
GS1 Barcode Verification
Global Trade Item Number · Country of origin check
2
TFDA Registry Lookup
Real-time API to Tanzania Food & Drugs Authority database
3
Blockchain Ledger Hash
Immutable batch hash stored on distributed ledger
4
Manufacturer Signature
Digital signature from WHO-approved manufacturer
5
Physical Security Feature
Hologram · Color-shift ink · Microprint verification

Offline authentication uses cached TFDA signatures (updated every 24h). All verifications are logged to the immutable audit trail.

Recent Verification Log
TimeDrug / BatchVerified ByResult
09:41Amoxicillin #B7721Dr. A. MselemAuthentic
09:38Amoxicillin #TZ-009Dr. A. MselemCounterfeit
09:22Artemether #B4421K. MachariaAuthentic
09:10Metformin #C1109K. MachariaAuthentic
08:58Atorvastatin #D3302Dr. A. MselemPending
18
Shipments In Transit
124
Delivered This Month
47
Pending Orders
3
Flagged Shipments
Active Shipment Tracker
Shipment IDDrug / ContentsOriginDestinationStatusETAAuthenticity
SHP-9901
Artemether 20mg×6
2,400 units · 4 pallets
Pfizer NairobiMuhimbili HospitalIn TransitMar 13Verified
SHP-9900
Amoxicillin 500mg
10,000 units · 8 pallets
DKSH Dar es SalaamSerenity PharmacyCustoms HoldMar 15Verified
SHP-9898
Metformin 500mg
5,000 units · 3 pallets
Cipla IndiaRegional WarehouseFlagged—Suspect
SHP-9897
Atorvastatin 20mg
3,000 units · 2 pallets
Novartis MumbaiAga Khan PharmacyDeliveredMar 10Verified
SHP-9895
ORS Sachets
12,000 units · 12 pallets
UNICEF Supply Div.MSD RegionalDeliveredMar 9Verified
Batch #B7721 Journey
COMPLETED
Manufactured
Pfizer Ltd · Nairobi, Kenya · 15 Jan 2024
Quality Control Passed
WHO-GMP Certified Lab · QC #KE-2024-0088
TFDA Import Clearance
Tanzania FDA · Permit #TFDA/IMP/2024-0441
Regional Warehouse Received
MSD Warehouse Dodoma · 8 Feb 2024
Dispensed at Point of Care
Muhimbili Hospital · Now dispensing
Purchase Orders
Manage drug procurement from approved suppliers
PO NumberSupplierDrug / ItemQty OrderedTotal ValueDateStatusActions
PO-2024-0441DKSH TanzaniaAmoxicillin 500mg · 10,000 units10,000TZS 3.2MMar 8Confirmed
PO-2024-0440Pfizer East AfricaArtemether 20mg×6 · 2,400 units2,400TZS 8.8MMar 7Pending
PO-2024-0439Cipla PharmaMetformin 500mg · 5,000 units5,000TZS 2.1MMar 5Under Review
PO-2024-0437UNICEF SupplyORS Sachets · 12,000 units12,000TZS 1.4MFeb 28Received
Approved Suppliers
TFDA-licensed pharmaceutical suppliers
SupplierLicense No.CountryCategoryRatingStatusLast Order
Pfizer East Africa
pfizer.ea@supply.com
TZ-SUP-0044KenyaAntibiotics · ARVs⭐⭐⭐⭐⭐ 4.9ActiveMar 7, 2026
DKSH Tanzania Ltd
orders@dksh.tz
TZ-SUP-0031TanzaniaGeneral Medicines⭐⭐⭐⭐ 4.4ActiveMar 8, 2026
Cipla Pharmaceuticals
africa@cipla.com
TZ-SUP-0058India/TanzaniaGenerics · Diabetes⭐⭐⭐ 3.1Under ReviewMar 5, 2026
UNICEF Supply Division
supply@unicef.org
TZ-SUP-0002GlobalEssential Medicines⭐⭐⭐⭐⭐ 5.0ActiveFeb 28, 2026
Novartis AG
africa@novartis.com
TZ-SUP-0017SwitzerlandCardiovascular · Oncology⭐⭐⭐⭐⭐ 4.8ActiveMar 10, 2026
TZS 94M
Monthly Revenue
▲ 7.2%
38,421
Prescriptions (MTD)
▲ 5.1%
12,847
Authentications (MTD)
● 98.7% pass rate
99.2%
TFDA Compliance
● Excellent
0.3%
Drug Wastage Rate
▼ below 1% target
Available Reports

Daily Sales Report

Transactions, revenue, prescription breakdown

TFDA Compliance Report

Drug registration, adverse events, recalls

Counterfeit Detection Report

Authentication failures, flagged batches, actions taken

Inventory Valuation

Stock value, turnover rate, carrying costs

Expiry Management Report

FEFO/FIFO analysis, wastage prevention

Government Narcotic Report

Controlled substance tracking — DDA format

LUMO Pharmacy Database Schema — 108 tables across 12 modules. PostgreSQL 16 with JSONB audit columns, UUID primary keys, and row-level security.

System Audit Trail
TimestampUserActionTable / RecordIP AddressDetails
2026-03-11 09:41:22Dr. A. MselemDISPENSEtransactions · TXN-8924110.0.1.44Amoxicillin 500mg · 30 tabs · Batch B7721
2026-03-11 09:38:55Dr. A. MselemAUTH_FAILdrug_auth · Batch TZ-00910.0.1.44Counterfeit detected — TFDA alert triggered
2026-03-11 09:15:03K. MachariaSTOCK_INinventory · INV-330210.0.1.50Received 2400 units Artemether #B4421
2026-03-11 08:44:11SystemALERTbatch_monitor · B4421SystemExpiry warning triggered — 8 days remaining
2026-03-11 08:31:00adminLOGINauth_sessions10.0.1.44Successful login — Dr. A. Mselem
2026-03-11 08:00:00SystemSYNCtfda_registrySystemDaily TFDA signature sync completed — 14,821 records updated
Patient / Client Records
Drug dispensing history and prescription management
Patient IDNameAge/SexNHIF No.Last VisitPrescriptionsOutstandingActions
PAT-00441
Fatuma Kibwana
fatuma.k@mail.tz
34 / FNHIF-884-2200Mar 1112TZS 0
PAT-00439
John Mwangi
jmwangi@hospital.tz
52 / MNHIF-221-0091Mar 118TZS 4,200
PAT-00432
Amina Rashid
—
28 / F—Mar 103TZS 0
PAT-00418
Mohammed Saleh
msaleh@gov.tz
61 / MNHIF-110-5542Mar 824TZS 0
Facility Information
System Modules
Offline Mode
Operate without internet — sync when reconnected
TFDA Live Sync
Real-time drug registry validation
NHIF Integration
Insurance claim processing
Blockchain Logging
Immutable supply chain ledger
SMS Alerts
Patient prescription reminders via SMS
System Information
LUMO PHARMACY SYSTEM
Version: v3.2.1-enterprise
Build: 2026.03.11.0841
Database: PostgreSQL 16.2
Tables: 108 active
Records: 4,281,940
TFDA Sync: ✓ Active (08:00 today)
Blockchain: ✓ Node connected
PWA Cache: ✓ 98% cached
© 2026 Abawei Technologies
Mbezi Beach, Dar es Salaam, Tanzania
Active Users — This Session
AM
Dr. Amina Mselem
Chief Pharmacist · 10.0.1.44
Online
KM
Kibwana Macharia
Pharmacy Tech · 10.0.1.50
Online
Action completed