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: Fri 11/11/22 13:20
XLS Files
The following 5 ESG Navigator Excel files were provided by ABC Company:
Name: Matt Johnson Phone: 123-456-7890 Email: Function: C-Suite Location: U.S. & Canada
no comments provided
10
ABC CO. MATT JOHNSON - ESG NAVIGATOR EXCEL WORKBOOK V5.3 (2022_09_21).XLSX
v5.2
QC Results
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.4 - Governance & Leadership - Long-Term Viability of Core Business(es) Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.80 +/- 0.87 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.0-3.5), Rated by all, std.dev = 0.87
KSI 1.5 - Governance & Leadership - ESG/S in Key Business Decisions Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.90 +/- 0.86 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.0-3.5), Rated by all, std.dev = 0.86
KSI 2.1 - Governance & Leadership - CEO/C-Suite Public Posture re ESG/S Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 1.80 +/- 0.68 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.0-3.0), Rated by all, std.dev = 0.68
KSI 2.2 - Governance & Leadership - CEO/C-Suite Messages to Investors/Owners Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.20 +/- 0.75 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.5-3.5), Rated by all, std.dev = 0.75
KSI 2.5 - Governance & Leadership - Engagement by CEO/C-Suite with NGOs Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.30 +/- 1.12 --> rounded for reporting to 1.5
Ratings by respondent: Very wide range (0.5-3.5), Rated by all, std.dev = 1.12
KSI 3.1 - Governance & Leadership - Full Board Oversight of ESG/S Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 1.80 +/- 0.51 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 3.5 - Governance & Leadership - Time Spent on ESG/S in Board Meetings Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.40 +/- 0.58 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 4.4 - Governance & Leadership - Tracking Reduction of ESG/S Footprint Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.70 +/- 0.75 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-3.0), Rated by all, std.dev = 0.75
KSI 4.5 - Governance & Leadership - Revenue From ESG/S-Advantaged PSS Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.30 +/- 0.40 --> rounded for reporting to 1.5
KSI 4.6 - Governance & Leadership - Acct. for Matl. ESG/S Risks Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.20 +/- 0.40 --> rounded for reporting to 1.0
KSI 6.3 - Governance & Leadership - Assurance & Verification of ESG/S Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.20 +/- 0.40 --> rounded for reporting to 1.0
KSI 6.5 - Governance & Leadership - Public Policy (e.g., Lobbying) Alignment Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.40 +/- 0.58 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 7.2 - Governance & Leadership - Mkt. Strategy for Product ESG/S Ben. Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.60 +/- 0.49 --> rounded for reporting to 1.5
KSI 7.4 - Governance & Leadership - ESG/S Attrib. in Product Line Extension Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.70 +/- 0.51 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 7.5 - Governance & Leadership - ESG/S Impacts on Brand Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.68 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.68
KSI 8.1 - Strategy and Execution - Strategic Planning Process Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 1.80 +/- 0.40 --> rounded for reporting to 2.0
KSI 8.2 - Strategy and Execution - Use of Scenario Planning Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.30 +/- 0.60 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.60
KSI 8.3 - Strategy and Execution - ESG/S Cost Reduction Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.10 +/- 0.37 --> rounded for reporting to 2.0
KSI 8.4 - Strategy and Execution - ERM Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 2.80 +/- 0.75 --> rounded for reporting to 3.0
Ratings by respondent: Wide range (2.0-4.0), Rated by all, std.dev = 0.75
KSI 8.5 - Strategy and Execution - Revenue Pipeline from ESG/S PSS Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.30 +/- 0.40 --> rounded for reporting to 1.5
KSI 8.6 - Strategy and Execution - Capital Alloc. to Address ESG/S Impacts Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.50 +/- 0.55
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.55
KSI 9.1 - Strategy and Execution - Linkage Between ESG/S & Innovation Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.30 +/- 0.40 --> rounded for reporting to 1.5
KSI 9.2 - Strategy and Execution - ESG/S in Materials & Labor Inputs Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.50 +/- 0.45
KSI 9.3 - Strategy and Execution - ESG/S in Product Design & Development Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.60 +/- 0.58 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 9.4 - Strategy and Execution - R&D Partnerships - Driving ESG/S Ben. Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.40 +/- 0.49 --> rounded for reporting to 1.5
KSI 9.5 - Strategy and Execution - R&D Investment in ESG/S PSS & Technology Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.40 +/- 0.37 --> rounded for reporting to 1.5
KSI 10.1 - Strategy and Execution - PSS Value Proposition Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 1.70 +/- 0.40 --> rounded for reporting to 1.5
KSI 10.3 - Strategy and Execution - Product ESG/S Risk Assessment Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.80 +/- 0.40 --> rounded for reporting to 3.0
KSI 10.4 - Strategy and Execution - PSS ESG/S Labeling & Rating Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.10 +/- 0.49 --> rounded for reporting to 2.0
KSI 10.5 - Strategy and Execution - PSS Quality & Safety Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.80 +/- 0.60 --> rounded for reporting to 3.0
Ratings by respondent: Wide range (2.0-3.5), Rated by all, std.dev = 0.60
KSI 10.6 - Strategy and Execution - PSS Marketing & Advertising Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.10 +/- 0.58 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.5-3.0), Rated by all, std.dev = 0.58
KSI 11.1 - Strategy and Execution - Responsible Sourcing Approach Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.60 +/- 0.37 --> rounded for reporting to 1.5
KSI 11.2 - Strategy and Execution - Engaging on Matl. (Supply Chain) Issues Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.70 +/- 0.51 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 11.3 - Strategy and Execution - Standards for Supply Chain ESG/S Impacts Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.50 +/- 0.45
KSI 11.4 - Strategy and Execution - Measuring Supply Chain ESG/S Impacts Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.40 +/- 0.49 --> rounded for reporting to 1.5
KSI 11.5 - Strategy and Execution - Verifying Supply Chain ESG/S Impacts Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.20 +/- 0.25 --> rounded for reporting to 1.0
KSI 12.3 - Environmental Stewardship - Non-Carbon Emissions Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.40 +/- 0.58 --> rounded for reporting to 2.5
Ratings by respondent: Wide range (2.0-3.5), Rated by all, std.dev = 0.58
KSI 12.5 - Environmental Stewardship - Water Management Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.10 +/- 0.37 --> rounded for reporting to 2.0
KSI 12.6 - Environmental Stewardship - Biodiversity & Land Management Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.51 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 13.1 - Environmental Stewardship - Approach to Supply Chain Envir. Impacts Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 1.70 +/- 0.51 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.51
KSI 13.2 - Environmental Stewardship - Materials Sourced: Human Made Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.60 +/- 0.58 --> rounded for reporting to 1.5
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.58
KSI 14.1 - Environmental Stewardship - Resp. for ESG/S: PSS Use & End-of-life Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.90 +/- 0.37 --> rounded for reporting to 2.0
KSI 14.2 - Environmental Stewardship - Traceability Related to PSS Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.40 +/- 0.37 --> rounded for reporting to 1.5
KSI 14.3 - Environmental Stewardship - Carbon (GHG) Impact of PSS Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.60 +/- 0.20 --> rounded for reporting to 1.5
KSI 14.5 - Environmental Stewardship - Biodegradability of PSS Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.60 +/- 0.37 --> rounded for reporting to 1.5
KSI 14.8 - Environmental Stewardship - Product Packaging Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.20 +/- 0.68 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.5-3.0), Rated by all, std.dev = 0.68
KSI 15.1 - Social Responsibility - Workplace Environment Rated by 5 respondents. HR(!) by 3 respondents. No comments. Average (mean) rating: 2.90 +/- 0.80 --> rounded for reporting to 3.0
Ratings by respondent: Wide range (2.0-4.0), Rated by all, std.dev = 0.80
KSI 15.2 - Social Responsibility - Diversity, Equity, & Inclusion (DEI) Rated by 5 respondents. HR(!) by 4 respondents. No comments. Average (mean) rating: 2.80 +/- 0.51 --> rounded for reporting to 3.0
Ratings by respondent: Wide range (2.0-3.5), Rated by all, std.dev = 0.51
KSI 15.3 - Social Responsibility - ESG/S in Recruitment & Retention Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.00 +/- 0.71
Ratings by respondent: Wide range (1.0-3.0), Rated by all, std.dev = 0.71
KSI 15.4 - Social Responsibility - Safety Programs & Performance Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 3.60 +/- 0.37 --> rounded for reporting to 3.5
KSI 15.5 - Social Responsibility - Health, Wellness, & Sust. Lifestyles Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.90 +/- 0.74 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.0-3.0), Rated by all, std.dev = 0.74
KSI 15.6 - Social Responsibility - ESG/S Training & Staff Development Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.80 +/- 0.40 --> rounded for reporting to 2.0
KSI 15.7 - Social Responsibility - Employee Engagement with ESG/S Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 2.20 +/- 0.87 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.5-3.5), Rated by all, std.dev = 0.87
KSI 16.1 - Social Responsibility - Approach to Supply Chain Social Impacts Rated by 5 respondents. HR(!) by 2 respondents. No comments. Average (mean) rating: 1.70 +/- 0.40 --> rounded for reporting to 1.5
KSI 16.2 - Social Responsibility - Human Rights Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.20 +/- 0.81 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.0-3.0), Rated by all, std.dev = 0.81
KSI 16.3 - Social Responsibility - Labor Relations Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.70 +/- 0.40 --> rounded for reporting to 1.5
KSI 16.5 - Social Responsibility - Supply Chain Capacity Building Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 1.80 +/- 0.68 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.0-2.5), Rated by all, std.dev = 0.68
KSI 17.1 - Social Responsibility - Philosophy Regarding Community Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.40 +/- 0.97 --> rounded for reporting to 2.5
Ratings by respondent: Wide range (1.5-4.0), Rated by all, std.dev = 0.97
KSI 17.2 - Social Responsibility - Engagement With Communities & NGOs Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.10 +/- 0.80 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.0-3.0), Rated by all, std.dev = 0.80
KSI 17.3 - Social Responsibility - Social Investment Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.20 +/- 0.87 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.5-3.5), Rated by all, std.dev = 0.87
KSI 17.4 - Social Responsibility - Community & Stakeholder Partnerships Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 2.00 +/- 0.71
Ratings by respondent: Wide range (1.0-3.0), Rated by all, std.dev = 0.71
KSI 17.5 - Social Responsibility - Infrastructure Development Rated by 5 respondents. No HR(!). No comments. Average (mean) rating: 1.90 +/- 0.74 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.0-3.0), Rated by all, std.dev = 0.74
KSI 17.6 - Social Responsibility - Community Job Creation Rated by 5 respondents. HR(!) by 1 respondents. No comments. Average (mean) rating: 2.20 +/- 0.68 --> rounded for reporting to 2.0
Ratings by respondent: Wide range (1.5-3.0), Rated by all, std.dev = 0.68
Angela Adams 1.50
Connie Carpenter 2.00
Joseph Chen 1.50
Juan Perez 3.00
Matt Johnson 3.00 HR(!)
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(!)
1
Gov.
Company Purpose and Values
1.84
2.0
8
2
Gov.
CEO and C-Suite Leadership
1.86
2.0
9
3
Gov.
Board of Directors Leadership
1.52
1.5
6
4
Gov.
Goals and Metrics
1.70
1.5
12
5
Gov.
Culture and Organization
1.75
2.0
5
6
Gov.
Disclosure and Reporting
1.48
1.5
5
7
Gov.
Customers and Markets
1.70
1.5
7
8
Str.
Strategic Planning
1.80
2.0
8
9
Str.
Innovation, R&D
1.44
1.5
6
10
Str.
Product Offerings
2.42
2.5
8
11
Str.
Supply Chain Management
1.48
1.5
6
12
Env.
Environment: Operations
1.86
2.0
6
13
Env.
Environment: Supply Chain
1.63
1.5
7
14
Env.
Environment: Products
1.78
2.0
7
15
Soc.
Workplace
2.46
2.5
12
16
Soc.
Supply Chain
1.87
2.0
4
17
Soc.
Community
2.13
2.0
3
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; 38 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.