← All projects

PRJ-05

Mar 2023 — Jun 2024 · Axis Lighting

LED Board Depletion

Inventory · ERP & Automation Logic

EpicorPower BIPower AutomateExcelERP RulesInventory Control

Orders were matched to obsolete LED boards by engineering-approved rules, in both the ERP and the shop drawing automation. Power BI alerts told us when to stop.

Axis LED board inventory (45% reduction)

CAD $872K→CAD $481K

Rules managed in the depletion rules tracker

112K

Challenge

  • Obsolete rigid LED boards were tying up capital and the LED storage space.
  • Picking and automation ignored old stock, and the company was moving to flexible boards.

Approach

  • Built a rule-based depletion process that matches orders to old boards by product, CRI, CCT, length and mounting.
  • Mechanical engineering approved the rules. I loaded them into Epicor and passed each update to the automation team.
  • Built the rules workbook that shows which rules are active, and a Forms flow that emails rule statistics to engineering leads.
  • Built the first Power BI report, which the operations team later extended. I set up Power BI alerts and Power Automate emails, so stakeholders could switch off depletion once boards reached the limit reserved for after-sales and warranty replacement.
  • Trained stores and the warehouse on issuing parts for depletion orders.

Outcome

  • Phase 1 reduced Axis inventory from CAD $872K to $481K (45%).
  • Only old boards were used, never mixed with new ones, so there were no lot issues.
  • The depletion process is standardized. Supplier stock (Phase 2) can be handled through a standard ECO.

Artifacts

Selected outputs from the project — videos, generated drawings, code, and stakeholder decks.

Power BI Reports — depletion tracking with alerts and automated emails so stakeholders can switch off depletion at the after-sales limit.

Next · PRJ-06

HMI Production Efficiency

→