Production Case Study 11 • Verified Enterprise System

Scottish Courage — RFID Keg Tracking Pilot

RFID Asset Tracking Closed-Loop Logistics Delphi SQL Server Supply Chain Traceability

Pioneered early industrial RFID asset tracking across UK brewery distribution routes—establishing real-time traceability and Shrinkage reporting for thousands of circulating commercial beer kegs.

Role Reporting, Integration & Pilot Testing
Timeline 1996
Scale & Throughput Thousands of Circulating Kegs
Client / Organization Scottish Courage (Edinburgh, UK)
Executive Brief

Operational Snapshot & Impact

High-stakes systems integration demands real-world reliability, sub-second latency, and deterministic execution under peak production load. Here is the operational profile:

Role Reporting, Integration & Pilot Testing
Timeline 1996
Scale & Throughput Thousands of Circulating Kegs
Client / Organization Scottish Courage (Edinburgh, UK)

The Business Problem: Heavy Asset Attrition

Scottish Courage, one of the UK's premier brewing groups, suffered substantial financial losses from lost, stolen, or misplaced stainless-steel beer kegs. In high-turnover hospitality logistics, kegs moved from central breweries onto distribution lorries, into pub cellars, and through collection routes.

Because kegs were untracked commodities, the business could only quantify shrinkage as an aggregate financial deficit at year-end, with zero visibility into which distribution hubs, transit legs, or customer venues were losing kegs. The pilot objective was to validate automated RFID tracking to establish individual keg chain-of-custody.

Closed-Loop RFID Lifecycle

Each stainless steel keg was retrofitted with a rugged industrial RFID tag. The system tracked individual containers across their repeating bi-weekly distribution cycle:

Brewery Automated Filling Line → Overhead RFID Tag Scanned & Timestamped
↓ Palletized Loading
Distribution Depots → Lorry Loading Checkpoint Scan
↓ Direct Store Delivery
Pub Drop-Off → Driver Handheld Terminal Scans Venue & Keg IDs
↓ Cellar Turnover & Collection
Empty Keg Recovery → Scan Associates Returned Container with Pub Account
↓ Return Logistics
Brewery Conveyor Portal → Automatic Ingestion Scan Closes the Loop

Reporting & Shrinkage Analysis

Warren's core engineering contribution was building the reporting and analytics layer in Delphi and Microsoft SQL Server:

  • Chain-of-Custody Tracking: Replaced vague inventory assumptions with precise historical timelines, recording every venue and vehicle each container passed through.
  • Exception Reporting: Automated identification of "stalled" kegs that exceeded standard cellar turnover periods (identifying hoarding or unreturned empties).
  • On-Site Troubleshooting: Warren provided hands-on technical deployment support in Scotland, diagnosing serial reader communications and network synchronization on the brewery floor.

Pilot Implementation & Results

The pilot successfully tracked several thousand active kegs across dedicated distribution routes:

  • Pinpointed Shrinkage Locations: Proved that container losses were concentrated in specific transit handoffs rather than at customer venues.
  • Cycle Velocity Tracking: Measured average container turnaround times, allowing the brewery to optimize its total keg fleet capital expenditure.
  • Demonstrated Feasibility: Validated that automated RF scanning could operate reliably in harsh, moisture-heavy brewery wash-down environments.

A Foundational Engineering Thread

While implemented early in his career, this project established the foundational systems architecture pattern that runs throughout Warren's later work:

Physical Asset → Electronic Tag → Autonomous Ingestion → Database → Actionable Business Insight

From 1996 RFID tracking in Scotland to 22 deep-level mining operations, 5,000 GPS fleet units, and modern ONNX edge vision systems, the engineering objective remains constant: capturing ground truth from the physical world and turning it into reliable, automated software intelligence.

Technology Stack

Languages & Tools Borland Delphi, Crystal Reports, Windows Server
Database Microsoft SQL Server (Relational tracking and transaction logs)
Hardware Subsystem Industrial RFID Tags, Conveyor Portal Readers, Handheld Scanners
Communications Serial RS-232 / RS-485 Interfaces, Custom File Exchange
Domain Application Closed-Loop Supply Chain, Asset Traceability, Loss Prevention
Deployment Location Scottish Courage Brewery Operations (Scotland, UK)
Enterprise Architecture Consulting

Facing Similar Systems Integration Bottlenecks?

Get a 48-Hour High-Stakes Architecture Audit ($8,500) to diagnose bottlenecks and design a zero-downtime execution roadmap with Warren Basterfield.

Book 48-Hour Audit ($8,500) ➔ Consult Principal Architect