← 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