
How it works
- Purpose: Score 5S in a defined area, track the trend over time and close every deviation with a named owner and a date.
- Two audit levels: The short check on sheet 02 runs at every shift handover and takes two minutes. The full audit on sheet 03 runs weekly or monthly and takes twenty.
- How it scores: You count deviations per question, you do not rate an impression. 0 deviations scores 4 points, 1 scores 3, 2 scores 2, 3 scores 1, more than 3 scores 0.
- Why counting: Two auditors who walk the same area must arrive at the same number. Counting is the only method that reliably does that.
- Maximum score: 25 questions times 4 points equals 100 points per area. The percentage on the dashboard is simply points out of 100.
- Where to type: Only white cells with a thin border are input cells. Everything shaded is a label or a formula.
- Workflow: 1. Fill the audit header. 2. Score all 25 questions in one walk. 3. Every score below 4 becomes an action. 4. Transfer to the action plan. 5. Read the dashboard with the team before you leave the area.
Sheets in the workbook
- Read Me
- Dashboard
- Short Check
- Full Audit
- Action Plan
- Red Tag Log
- Cleaning Plan
- Standards
- Area Matrix
- Audit History
Who it is for
Plants that run 5S in many areas and want one consistent audit system.
The method behind the numbers
This workbook is part of the 5S toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.