← All projects

PRJ-02

Feb 2023 — Jan 2024 · Axis Lighting, Montreal

Shop Drawing Validation

Quality · Process Design

QualityProcess DesignExcel/VBA ToolsKPI DesignPower BI

Built a validation team, tools and a new KPI to catch shop drawing errors before orders reached production.

NCRs raised after production start

79%→7%

Validation team members

4

Challenge

  • The shop drawing standards project showed that product-specific information were still missing.
  • Many drawings were made by hand, so human errors kept reaching production.
  • About 79% of NCRs surfaced after production started, and each took 3+ days to resolve.

Approach

  • Created two verification checklists, one for the validation team and one for production.
  • Set up a 4-person Validation team in Manufacturing Methods to check drawings early, at schedule/release.
  • Built a Tools and Resources guide showing how to verify every drawing element.
  • Built the Methods Configurator (Excel/VBA, with Vault Viewer data tables) to check values fast.
  • Introduced the User Performance Rating: the share of an order line's NCRs each validator caught, tracked on a dashboard. Top performers were recognised with senior management.
  • Piloted on 51 live orders and tracked results in Excel and Power BI.

Outcome

  • Most NCRs are now caught early, so rework and back-and-forth are down and orders reach the floor clearer to build.
  • The configurator was recognised by SLT and directors, and it became the starting point for the MU10 calculator in the Engineering Data project.

Artifacts

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

SD Validation Dashboard — tracks validation-team progress and performance ratings, splits results before/after the wiring-started assembly stage, and surfaces non-conformance reasons against shipped sales-order lines.

Next · PRJ-03

Engineering Data Architecture

→