← All projects
PRJ-07
Feb 2024 — Sep 2024 · a high-mix architectural lighting manufacturer in Montreal
FIFO Process Implementation
Inventory · ERP · Process Improvement
Project ManagementInventoryERP (Epicor)Process ImprovementCross-functional
Led generic part-number mapping, LOT tracking and first-in-first-out picking for LED boards — live in Epicor in September 2024.
- Charter (Feb 2024)
- Generic part numbers and LOT format
- Epicor lot attributes and logic
- Relabel (Aug 2024)
- Go-live (Sep 2024)
- Driver phase (later, new team)
Part Number Optimization
92 LED board part numbers mapped to generic part numbers
LOT tracked Picking
FIFO in Warehouse
Challenge
- Aged stock: LED boards dating back to 2019 sat unused on top shelves because only new inventory was issued.
- Scale: the business case recorded about $2.4M of dead-stock boards, $1.16M of dormant stock and 189,665 obsolete boards blocking space for new supply.
- Quality impact: mixed lots caused dimming issues, rework and extra cost.
- Process gaps: manual, error-prone picking, and a different part number for the same board from every supplier.
Approach
- Governance: wrote the charter, work breakdown structure and Gantt chart, and aligned senior leadership and the sponsor on scope and timeline.
- Cross-functional delivery: ran kickoff and the project across Stores, Engineering, IT, Procurement, Internal Audit, Shop Drawing, BOM, Methods, Production and Quality.
- Phased scope: Phase 1 LED boards, Phase 2 drivers and other electrical parts, Phase 3 mechanical parts
- Generic part numbers: replaced supplier-specific numbers with one generic number per board, with the supplier carried in a new LOT number (supplier, Vf bin, flux bin, date code, reel ID). Mapped 92 board part numbers in Phase 1.
- LOT standard: set the LOT format rules (sequence, length, separators) behind the supplier packaging label and packing slip standards.
- ERP specification: defined the lot attributes to track (reel ID, supplier, manufacturing lot, flux, Vf, best-before, expiry) and the picking logic (oldest received first, same flux) for the developers who built it in Epicor Kinetic.
- Validation: tested the new job pick lists to confirm parts and lots were issued by date and flux.
- Physical transition (Aug 2024): relabelled about 75 boxes over three days with about 13 warehouse and stores staff, and reloaded Epicor with the new lot numbers.
- Visibility: built a Power BI dashboard tracking LED board quantities.
Outcome
- Live: LOT tracking and first-in-first-out process went live in Epicor in Sep 2024.
Artifacts
Selected outputs from the project — videos, generated drawings, code, and stakeholder decks.

LOT ATTRIBUTES FOR FIFO — LED BOARDS: THE ATTRIBUTES CURRENTLY TRACKED (LEFT) VERSUS THE NEW ATTRIBUTES TO BE TRACKED FOR FIFO, INCLUDING REEL ID, SUPPLIER, MFGLOT, FLUX, VF, BEST-BEFORE DATE AND EXPIRE DATE.
Next · PRJ-08
DriveWorks Transformation