← All case studiesPharmacy Operations

QR Scanned Pharmacy Dispensing and FEFO Compliance

A traceable dispensing and stock-control workflow that turns QR adoption, expiry verification and FEFO discipline into management evidence.

73.8%QR adoption5.7 minQR average TAT+2.1 ptsFull FEFO lift97.6%QR expiry verified
01 · Context

The challenge

Manual batch and expiry verification created avoidable gaps at the point of issue. Pharmacy leaders also needed a defensible way to compare QR and normal dispensing performance across facilities and users.

02 · System

What I built

I developed QR-enabled medicine issue and return workflows with inventory barcoding, batch visibility, expiry capture, QR stock taking and variance reporting. I then built an audit dashboard that separates QR from normal issues and reconstructs expiry and FEFO references from stock and purchase detail records.

PHP 8.3MySQLQR and barcode workflowsAudit dashboardsInventory integration
03 · Outcome

How the organisation benefits

The solution strengthens stock discipline, traceability and management oversight. In the measured window, QR dispensing averaged 5.7 minutes versus 9.1 minutes for normal issue, while full FEFO compliance showed a 2.1-point lift. The dashboard makes adoption, turnaround time, expiry verification and reference coverage visible enough for daily action.

04 · Practice

Delivery reality

Transformation evidence must be defensible. I designed the comparison around repeatable data lineage and clearly distinguished enforced QR controls from retrospective normal-issue alignment.

05 · Visual evidence

System narrative

Continue exploring

More operational case studies.