← All projects
PRJ-06
Oct 2023 — Aug 2024 · Axis Lighting
HMI Production Efficiency
LEAN SIX SIGMA · PRODUCTION EFFICIENCY FORECAST
Lean Six SigmaKaizenPRODUCTIONData & Reporting
Grew a Kaizen event into a Lean Six Sigma project that let production forecast its own hourly efficiency, automating attendance, ERP data flow and reporting across 7 business units.
Daily manual reporting effort
8 hours→30 minutes
Problem
- No look-ahead: no forecast of next-hour output, so managers reacted after the hour was lost.
- Manual reporting: attendance was collected on paper from the business units and typed into Excel (1 to 1.5 hours); ERP reports were exported and uploaded into a master workbook by hand every hour, and results were emailed manually to managers and directors.
Approach
- Project path: started as a Kaizen event to teach production and managers how efficiency is calculated, then grew into a Lean Six Sigma project to build tools that let production forecast its own efficiency.
- Governance: chartered with a cross-functional team (Production, Planning, Methods, Quality, Stores) and ran a current-state analysis business unit by business unit.
- Education: taught managers, then floor teams, how HMI is calculated from sections completed, each fixture's standard time (with an inefficiency factor) and people available.
- Interactive X tool (Excel): managers and lead hands of 7 business units (18 assembly lines) enter attendance before 8:00 AM; an efficiency forecaster shows achievable efficiency by headcount and planned products so they can plan toward 90 to 100%.
- Automated data flow: the ERP produces an hourly Excel report to a set folder; Power Automate flows pick up the file for the right date and shift and load it into the master HMI workbook, whose database tabs refresh every hour, with attendance and schedule loading daily.
- Reporting: Power BI reports auto-email to senior leadership daily and to production managers, the manufacturing director and planning hourly; a bilingual (English/French) Excel dashboard view runs on production-floor TVs.
Outcome
- Reporting effort: manual effort for attendance collection, ERP export handling and hourly uploads fell from about 8 hours to 30 minutes per day.
- Attendance: paper collection and typing replaced by direct entry from managers before 8:00 AM.
- Planning ahead: managers can forecast shift efficiency by headcount and product mix instead of reacting.
Artifacts
Selected outputs from the project — videos, generated drawings, code, and stakeholder decks.
INTERACTIVE X TOOL — ATTENDANCE ENTRY AND HOURLY/DAILY EFFICIENCY FORECASTING TO PLAN THE SECTIONS NEEDED FOR 100% EFFICIENCY.
Next · PRJ-07
FIFO Process Implementation