📊 Company Reportable Rate

🧾 Definition

The Company Reportable Rate measures the frequency of serious work-related incidents (injuries, illnesses, or dangerous events) that must be officially reported in accordance with regulatory guidelines. It provides a standardized view of workplace safety, allowing comparison across time periods and different organizations regardless of size.

This metric is normalized per 100 full-time employees over one year, making it a reliable indicator of overall EHS performance.

---

🧮 Calculation (DAX/SQL)

🧠 Formula:

Reportable Rate = ( Number of Reportable Incidents × 200,000 ) / Total Hours Worked

💡 Why 200,000?

This figure represents the total number of hours worked annually by 100 full-time employees (40 hours/week × 50 weeks × 100 employees), providing a normalized benchmark for safety tracking.

SQL Query:

SELECT (CAST([Reportable_Incidents] AS FLOAT) * 200000.0) / NULLIF([Total_Hours_Worked], 0) AS Reportable_Rate FROM SafetyMetrics WHERE [Month] = '2025-03'

---

🧩 DAX (Power BI):

Reportable Rate = DIVIDE( [Reportable Incidents] * 200000, [Total Hours Worked], BLANK() )

---

💼 Business Context

This metric serves as a leading safety indicator, highlighting the company’s success in preventing serious incidents. A rising reportable rate may indicate underlying risks, operational hazards, or procedural lapses. Conversely, a declining trend demonstrates a healthier and safer work environment.

Company leadership and safety teams use this KPI to:

Benchmark EHS performance over time.

Identify departments or plants needing corrective action.

Align safety efforts with compliance standards (e.g., OSHA).

---

🚨 Thresholds and Alerts

Level	Reportable Rate	Alert Type
✅ Good	0 – 1.0	No action needed
⚠️ Warning	1.1 – 3.0	Review safety programs
❌ Critical	> 3.0	Immediate EHS investigation

Notifications should be sent when the Reportable Rate crosses thresholds or increases consecutively for multiple months.

---

📈 Historical Insights

Trend Tracking: Monthly trends allow quick identification of spikes that may relate to specific operations, seasons, or events.

Comparative Analysis: Benchmarked against industry averages or internal business units.

Actionable Insights: Used alongside root cause analysis to design safety training and operational improvements.

---