CASE FILE / HOSPITAL-CONSUMABLES · ANONYMISED
01 / Background and challenge
The hospital carries a wide consumables catalogue with small order quantities per item. Departments used to raise plans ad hoc, which produced peak-season shortages and near-expiry stock at the same time.
Batch and expiry records sat in paper ledgers, so an inspection meant opening boxes one by one to reconcile the numbers.
02 / Approach
A rolling replenishment table was built from each department's historical usage, with safety stock for core items and a quarterly review.
Every delivery now arrives with batch, expiry and delivery-note details, recorded in an electronic ledger by product specification.
Items within 90 days of expiry trigger an early warning, with exchange or split delivery offered.
03 / Implementation
The first two weeks covered catalogue review and historical usage checks to set the initial stock list.
Weekly replenishment ran for the first month, then switched to threshold-based ordering.
A batch-ledger template was handed over so the device department can export inspection documents itself.
04 / Results and evidence
Stock-outs fell from six a month to one.
Batch and expiry records travel with each delivery and can be exported in one step.
Near-expiry stock is flagged 90 days ahead.