← 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.

  1. Charter (Feb 2024)
  2. Generic part numbers and LOT format
  3. Epicor lot attributes and logic
  4. Relabel (Aug 2024)
  5. Go-live (Sep 2024)
  6. 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.

Side-by-side Epicor Part Class Maintenance screens — the attributes currently tracked versus the new attributes tracked for FIFO, including Reel ID, Supplier, MFGLot, Flux, VF, Best Before Date and Expire Date

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

→