← 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