🧼 Sanitation Score (#)

🧾 Definition

The Sanitation Score is a numeric indicator reflecting the cleanliness and hygiene standards of a facility (such as a food production plant). It is typically derived from structured inspections or audits, covering various aspects like equipment hygiene, pest control, staff practices, and waste management.

Higher scores indicate strong sanitation practices, while lower scores highlight areas of concern requiring corrective action.

---

🧮 Calculation (DAX/SQL)

Formula:

Sanitation Score = (Points Scored / Total Possible Points) × 100

🧠 Example:

Points Scored = 85
Total Possible Points = 100

Sanitation Score = (85 / 100) × 100 = 85

In most organizations, sanitation scores are generated using digital food safety tools or during manual audits through predefined scoring templates.

---

💼 Business Context

Sanitation is crucial in ensuring food safety and preventing contamination. A sanitation score acts as a quality gate—tracking operational hygiene and validating compliance with food safety standards.

Key Uses:

• Ensures compliance with regulatory and internal standards
• Detects and addresses sanitation issues early
• Improves audit readiness for external inspections (e.g., FDA, ISO, FSSAI)
• Enhances consumer trust through consistent cleanliness practices

---

🚨 Thresholds and Alerts

Level	Sanitation Score	Alert Type
✅ Good	90 – 100	Excellent – No Action Required
⚠️ Caution	70 – 89	Review Needed – Minor Issues Exist
❌ Critical	< 70	Immediate Action – Audit Required

Alerts should be triggered when the score drops below 90, or when there is a declining trend across 2–3 periods.

---

📈 Historical Insights

• Monthly Tracking: Scores can be trended over time to identify declining hygiene patterns or audit fatigue.
• Root Cause Mapping: Scores combined with issue logs help identify recurring cleanliness failures.
• Location Benchmarking: Facilities can be ranked and prioritized for hygiene training or sanitation upgrades.

---