This report summarizes the ESG Navigator data for ABC Company provided by company personnel via the 5 Excel ratings worksheets listed below.
Note: In the tables below, hover over the column headings for brief explanations of each column. Click column headings to sort by that column.
For more information or you have any ideas or suggestions for how to make this ESG Internal Alignment Report better or more useful, visit ESG Navigator, check out the options for joining, or contact Gib Hedstrom (gib@hedstromassociates.com). Report run: Tue 10/10/23 14:25
XLS Files
The following 5 ESG Navigator Excel files were provided by ABC Company:
No.
Contact name
#Rated
#DK
#NA
%Rated
Avg.
#HR(!)
%HR(!)
I-Most
I-Very
I-Impt
I-Less
I-Avg.
#Comm.
Details
Outliers
XLS File
Ver.
1
Angela Adams
100
0
0
100.0
1.5
14
14.0
14
29
57
0
2.6
0
Name: Angela Adams Phone: 123-456-7890 Email: Function: Corporate ESG Location: U.S. & Canada Comment: Please fill in the yellow cells above. Drop down menu for Function and Location.
Name: Connie Carpenter Phone: 123-456-7890 Email: Function: Corporate ESG Location: U.S. & Canada Comment: Please fill in the yellow cells above. Drop down menu for Function and Location.
Name: Joseph Chen Phone: 123-456-7890 Email: Function: Corporate ESG Location: U.S. & Canada Comment: Please fill in the yellow cells above. Drop down menu for Function and Location.
Name: Juan Perez Phone: 123-456-7890 Email: Function: Corporate ESG Location: U.S. & Canada Comment: Please fill in the yellow cells above. Drop down menu for Function and Location.
Name: Matt Johnson Phone: 123-456-7890 Email: Function: Corporate ESG Location: U.S. & Canada Comment: Please fill in the yellow cells above. Drop down menu for Function and Location.
This section describes any quality control (QC) issues that may exist in the underlying data.
No QC issues were found.
Note: QC issues are potential errors/omissions in the underlying Excel files, including: Rating values other than those listed in the Excel drop-down menu; and KSIs flagged as HR(!) but not rated.
KSI Summary
This section shows overall results for each of the 100 KSIs, averaged across all 5 ESG Navigator Excel files for ABC Company. KSI names are colored to reflect the strength of the self-assessment score (green=high score, yellow=moderate score, red=low score).
KSI 1.1 - Company Purpose (Vision, Mission) (Governance & Leadership) Rated by 5 respondents. HR(!) by 4 respondents. No comments. Average (mean) rating: 2.00 +/- 0.55 Flags: Wide range (1.5-3.0), Rated by all, std.dev = 0.55
KSI 1.2 - Operationalizing ESG/S (Governance & Leadership) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.70 +/- 0.68 --> rounded for reporting to 1.5 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.68
KSI 1.3 - Commitments (by Board and/or C-Suite) (Governance & Leadership) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.80 +/- 1.21 --> rounded for reporting to 2.0 Flags: Very wide range (0.5-4.0), Rated by all, std.dev = 1.21
KSI 1.4 - Long-Term Viability of Core Business(es) (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.80 +/- 0.87 --> rounded for reporting to 2.0 Flags: Wide range (1.0-3.5), Rated by all, std.dev = 0.87
KSI 1.5 - ESG/S in Key Business Decisions (Governance & Leadership) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.90 +/- 0.86 --> rounded for reporting to 2.0 Flags: Wide range (1.0-3.5), Rated by all, std.dev = 0.86
KSI 2.1 - CEO/C-Suite Public Posture re ESG/S (Governance & Leadership) Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 1.80 +/- 0.68 --> rounded for reporting to 2.0 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.68
KSI 2.2 - CEO/C-Suite Messages to Investors/Owners (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.20 +/- 0.75 --> rounded for reporting to 2.0 Flags: Wide range (1.5-3.5), Rated by all, std.dev = 0.75
KSI 2.3 - CEO/C-Suite Interaction with Customers (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.78 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.78
KSI 2.4 - CEO/C-Suite Messages to Employees (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.50 +/- 0.63 Flags: Wide range (2.0-3.5), Rated by all, std.dev = 0.63
KSI 2.5 - Engagement by CEO/C-Suite with NGOs (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.30 +/- 1.12 --> rounded for reporting to 1.5 Flags: Very wide range (0.5-3.5), Rated by all, std.dev = 1.12
KSI 3.1 - Full Board Oversight of ESG/S (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.80 +/- 0.51 --> rounded for reporting to 2.0 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 3.3 - Board ESG/S Expertise (Governance & Leadership) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.40 +/- 0.58 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 3.4 - Board Agendas Regarding ESG/S (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.40 +/- 0.58 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 3.5 - Time Spent on ESG/S in Board Meetings (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.40 +/- 0.58 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 3.6 - Board Diversity, Equity & Inclusion (Governance & Leadership) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.60 +/- 0.20 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 4.1 - ESG/S Goals & Roadmap: Near-Term (Governance & Leadership) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.90 +/- 0.37 --> rounded for reporting to 2.0 Flags: Rated by all
KSI 4.2 - ESG/S Goals & Roadmap: Long-Term (Governance & Leadership) Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 1.20 +/- 0.40 --> rounded for reporting to 1.0 Flags: Rated by all
KSI 4.3 - Materiality Assessment (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.10 +/- 0.20 --> rounded for reporting to 2.0 Flags: Rated by all
KSI 4.4 - Tracking Reduction of ESG/S Footprint (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.75 --> rounded for reporting to 1.5 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.75
KSI 4.5 - Revenue From ESG/S-Advantaged PSS (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.30 +/- 0.40 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 4.6 - Acct. for Matl. ESG/S Risks (Governance & Leadership) Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 1.20 +/- 0.40 --> rounded for reporting to 1.0 Flags: Rated by all
KSI 4.7 - ESG/S Ratings & Rankings (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.50 +/- 0.63 Flags: Wide range (2.0-3.5), Rated by all, std.dev = 0.63
KSI 5.1 - Driving ESG/S Culture: Comp. & Goals (Governance & Leadership) Rated by 5 respondents. HR(!) by 5 respondents. No comments. Average (mean) rating: 1.20 +/- 0.40 --> rounded for reporting to 1.0 Flags: Rated by all, HR by all
KSI 5.2 - ESG/S Organization (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.30 +/- 0.68 --> rounded for reporting to 2.5 Flags: Wide range (1.5-3.0), Rated by all, std.dev = 0.68
KSI 5.3 - ESG/S Leadership Role/Position (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.90 +/- 0.58 --> rounded for reporting to 2.0 Flags: Wide range (1.5-3.0), Rated by all, std.dev = 0.58
KSI 5.4 - ESG/S Reward & Recognition (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.60 +/- 0.74 --> rounded for reporting to 1.5 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.74
KSI 6.1 - Annual Reporting & Financial Disclosures (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.80 +/- 0.40 --> rounded for reporting to 2.0 Flags: Rated by all
KSI 6.2 - Disclosure of ESG/S Impacts & Strategy (Governance & Leadership) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.50 +/- 0.55 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.55
KSI 6.3 - Assurance & Verification of ESG/S (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.20 +/- 0.40 --> rounded for reporting to 1.0 Flags: Rated by all
KSI 6.4 - Transparency (Governance & Leadership) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.50 +/- 0.45 Flags: Rated by all
KSI 6.5 - Public Policy (e.g., Lobbying) Alignment (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.40 +/- 0.58 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 6.6 - Corporate Marketing & Advertising (Governance & Leadership) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.63 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.63
KSI 7.1 - Customer ESG/S Engagement (Strategy and Execution) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.00 +/- 0.63 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.63
KSI 7.2 - Market Strategy: Existing PSS (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.60 +/- 0.49 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 7.3 - Market Strategy: New PSS (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.45 Flags: Rated by all
KSI 7.4 - Product Porfolio Transformation (Strategy and Execution) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.70 +/- 0.51 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 7.5 - ESG/S Impacts on Brand (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.68 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.68
KSI 8.1 - Strategic Planning Process (Strategy and Execution) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.80 +/- 0.40 --> rounded for reporting to 2.0 Flags: Rated by all
KSI 8.2 - Use of Scenario Planning (Strategy and Execution) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.30 +/- 0.60 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.60
KSI 8.3 - ESG/S Cost Reduction (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.10 +/- 0.37 --> rounded for reporting to 2.0 Flags: Rated by all
KSI 8.4 - ERM (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.80 +/- 0.75 --> rounded for reporting to 3.0 Flags: Wide range (2.0-4.0), Rated by all, std.dev = 0.75
KSI 8.5 - Revenue Pipeline from ESG/S PSS (Strategy and Execution) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.30 +/- 0.40 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 8.6 - Capital Alloc. to Address ESG/S Impacts (Strategy and Execution) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.50 +/- 0.55 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.55
KSI 9.1 - Linkage Between ESG/S & Innovation (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.30 +/- 0.40 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 9.2 - ESG/S in Materials & Labor Inputs (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.45 Flags: Rated by all
KSI 9.3 - ESG/S in Product Design & Development (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.60 +/- 0.58 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 9.4 - R&D Partnerships - Driving ESG/S Ben. (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.40 +/- 0.49 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 9.5 - R&D Investment in ESG/S PSS & Technology (Strategy and Execution) Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 1.40 +/- 0.37 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 10.1 - Product Value Proposition (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.40 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 10.2 - PSS Stewardship (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 3.00 +/- 0.71 Flags: Wide range (2.0-4.0), Rated by all, std.dev = 0.71
KSI 10.3 - Product ESG/S Risk Assessment (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.80 +/- 0.40 --> rounded for reporting to 3.0 Flags: Rated by all
KSI 10.4 - PSS ESG/S Labeling & Rating (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.10 +/- 0.49 --> rounded for reporting to 2.0 Flags: Rated by all
KSI 10.5 - PSS Quality & Safety (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.80 +/- 0.60 --> rounded for reporting to 3.0 Flags: Wide range (2.0-3.5), Rated by all, std.dev = 0.60
KSI 10.6 - PSS Marketing & Advertising (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.10 +/- 0.58 --> rounded for reporting to 2.0 Flags: Wide range (1.5-3.0), Rated by all, std.dev = 0.58
KSI 11.1 - Responsible Sourcing Approach (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.60 +/- 0.37 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 11.2 - Engaging on Matl. (Supply Chain) Issues (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.51 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 11.3 - Standards for Supply Chain ESG/S Impacts (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.45 Flags: Rated by all
KSI 11.4 - Measuring Supply Chain ESG/S Impacts (Strategy and Execution) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.40 +/- 0.49 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 11.5 - Verifying Supply Chain ESG/S Impacts (Strategy and Execution) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.20 +/- 0.25 --> rounded for reporting to 1.0 Flags: Rated by all
KSI 12.1 - GHG Emissions: Scope 1 (Environmental Stewardship) Rated by 5 respondents. HR(!) by 4 respondents. No comments. Average (mean) rating: 1.70 +/- 0.40 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 12.2 - GHG Emissions: Scope 2 (Environmental Stewardship) Rated by 5 respondents. HR(!) by 4 respondents. No comments. Average (mean) rating: 1.60 +/- 0.49 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 12.3 - Non-Carbon Emissions (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.40 +/- 0.58 --> rounded for reporting to 2.5 Flags: Wide range (2.0-3.5), Rated by all, std.dev = 0.58
KSI 12.4 - Buildings & Equipment (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.55 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.55
KSI 12.5 - Water Management (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.10 +/- 0.37 --> rounded for reporting to 2.0 Flags: Rated by all
KSI 12.6 - Biodiversity & Land Management (Environmental Stewardship) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.70 +/- 0.51 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 12.7 - Waste Management (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.00 +/- 0.55 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.55
KSI 13.1 - Approach to Supply Chain Envir. Impacts (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.51 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 13.2 - Materials Sourced: Human Made (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.60 +/- 0.58 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 13.3 - Materials Sourced: Biological-based (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.51 --> rounded for reporting to 1.5 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 13.4 - GHG Emissions: Scope 3 (Environmental Stewardship) Rated by 5 respondents. HR(!) by 4 respondents. No comments. Average (mean) rating: 1.90 +/- 0.74 --> rounded for reporting to 2.0 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.74
KSI 13.5 - Supply Chain Impact: Biodiversity (Environmental Stewardship) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.50 +/- 0.63 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.63
KSI 13.6 - Supply Chain Impact: Water (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.63 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.63
KSI 13.7 - Supply Chain Impact: Waste (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.63 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.63
KSI 14.1 - Resp. for ESG/S: PSS Use & End-of-life (Environmental Stewardship) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.90 +/- 0.37 --> rounded for reporting to 2.0 Flags: Rated by all
KSI 14.2 - Traceability Related to PSS (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.40 +/- 0.37 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 14.3 - Carbon (GHG) Impact of PSS (Environmental Stewardship) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.60 +/- 0.20 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 14.4 - Durability of PSS (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.32 Flags: Rated by all
KSI 14.5 - Biodegradability of PSS (Environmental Stewardship) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.60 +/- 0.37 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 14.6 - Recyclability & Reusability of PSS (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.00 +/- 0.84 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.84
KSI 14.7 - Water-Use Efficiency of PSS (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.00 +/- 0.63 Flags: Wide range (1.5-3.0), Rated by all, std.dev = 0.63
KSI 14.8 - Product Packaging (Environmental Stewardship) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.20 +/- 0.68 --> rounded for reporting to 2.0 Flags: Wide range (1.5-3.0), Rated by all, std.dev = 0.68
KSI 15.1 - Workplace Environment (Social Responsibility) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.90 +/- 0.80 --> rounded for reporting to 3.0 Flags: Wide range (2.0-4.0), Rated by all, std.dev = 0.80
KSI 15.2 - Diversity, Equity, & Inclusion (DEI) (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.80 +/- 0.51 --> rounded for reporting to 3.0 Flags: Wide range (2.0-3.5), Rated by all, std.dev = 0.51
KSI 15.3 - ESG/S in Recruitment & Retention (Social Responsibility) Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 2.00 +/- 0.71 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.71
KSI 15.4 - Safety Programs & Performance (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 3.60 +/- 0.37 --> rounded for reporting to 3.5 Flags: Rated by all
KSI 15.5 - Health, Wellness, & Sust. Lifestyles (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.90 +/- 0.74 --> rounded for reporting to 2.0 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.74
KSI 15.6 - ESG/S Training & Staff Development (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.80 +/- 0.40 --> rounded for reporting to 2.0 Flags: Rated by all
KSI 15.7 - Employee Engagement with ESG/S (Social Responsibility) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.20 +/- 0.87 --> rounded for reporting to 2.0 Flags: Wide range (1.5-3.5), Rated by all, std.dev = 0.87
KSI 16.1 - Approach to Supply Chain Social Impacts (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.40 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 16.2 - Human Rights (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.20 +/- 0.81 --> rounded for reporting to 2.0 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.81
KSI 16.3 - Labor Relations (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.40 --> rounded for reporting to 1.5 Flags: Rated by all
KSI 16.5 - Supply Chain Capacity Building (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.80 +/- 0.68 --> rounded for reporting to 2.0 Flags: Wide range (1.0-2.5), Rated by all, std.dev = 0.68
KSI 17.1 - Philosophy Regarding Community (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.40 +/- 0.97 --> rounded for reporting to 2.5 Flags: Wide range (1.5-4.0), Rated by all, std.dev = 0.97
KSI 17.2 - Engagement With Communities & NGOs (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.10 +/- 0.80 --> rounded for reporting to 2.0 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.80
KSI 17.3 - Social Investment (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.20 +/- 0.87 --> rounded for reporting to 2.0 Flags: Wide range (1.5-3.5), Rated by all, std.dev = 0.87
KSI 17.4 - Community & Stakeholder Partnerships (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.00 +/- 0.71 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.71
KSI 17.5 - Infrastructure Development (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.90 +/- 0.74 --> rounded for reporting to 2.0 Flags: Wide range (1.0-3.0), Rated by all, std.dev = 0.74
KSI 17.6 - Community Job Creation (Social Responsibility) Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.20 +/- 0.68 --> rounded for reporting to 2.0 Flags: Wide range (1.5-3.0), Rated by all, std.dev = 0.68
Ratings (5):
Angela Adams 1.5
Connie Carpenter 2.0
Joseph Chen 1.5
Juan Perez 3.0
Matt Johnson 3.0
Wide range (1.5-3.0), Rated by all
* PSS = Products, Services and Solutions Wide rating ranges are flagged based on standard deviation (SD): SD>1.0 is 'Very wide'; SD>0.5 is 'Wide'.
Element Summary
This section shows overall results for each of the 17 ESG Navigator Elements, averaged across the 5 Excel files for ABC Company. Element names are colored to reflect the strength of the average score (green=high score, yellow=moderate score, red=low score).
E#
Topic
Element
Average
Nearest To
#HR(!)
#DK
#NA
1
Gov.
Company Purpose and Values
1.84
2.0
8
0
0
2
Gov.
CEO and C-Suite Leadership
1.86
2.0
3
0
0
3
Gov.
Board of Directors Leadership
1.52
1.5
5
0
0
4
Gov.
Goals and Metrics
1.70
1.5
8
0
0
5
Gov.
Culture and Organization
1.75
2.0
5
0
0
6
Gov.
Disclosure and Reporting
1.48
1.5
3
0
0
7
Str.
Customers and Markets
1.70
1.5
3
0
0
8
Str.
Strategic Planning
1.80
2.0
7
0
0
9
Str.
Innovation, R&D
1.44
1.5
3
0
0
10
Str.
Product Offerings
2.42
2.5
0
0
0
11
Str.
Supply Chain Management
1.48
1.5
2
0
0
12
Env.
Environment: Operations
1.86
2.0
10
0
0
13
Env.
Environment: Supply Chain
1.63
1.5
5
0
0
14
Env.
Environment: Products
1.78
2.0
3
0
0
15
Soc.
Workplace
2.46
2.5
4
0
0
16
Soc.
Supply Chain
1.87
2.0
0
0
2
17
Soc.
Community
2.13
2.0
0
0
0
Outliers
This section describes 'outliers', which are ratings and highly relevant ('HR(!)') designations that are significantly different from the average.*
100 of the 100 KSIs (100%) qualified for outlier analysis; 18 outliers were found:
* Note: KSIs qualify for outlier analysis if they are rated by 50% or more of respondents (see the %Rated column in the KSI table above). For qualifying KSIs, outliers are flagged if: a respondent's rating differs from the average by 2.0+; a respondent is the only one to designate the KSI as HR(!); or a respondent did not rate the KSI as HR(!) when most others did.