EAI & CO₂ Dashboard – Executive Summary

Purpose
Combine supplier EAI (social / environmental) compliance scores and four carbon-impact totals into a single interactive view.

1 Data Sources

  • VF Audit Details – pass / fail answers for social-compliance questions
  • Material Footprint – four Total impact columns per material supplier

2 Key Steps

  1. Clean & Match Names

    • lower-case
    • remove “Inc./Ltd.”, punctuation
      ⇒ exact match between audit and CO₂ supplier names

  2. Compute Eight EAI Category Scores (0 – 1)
    Categories: Child Labor, Forced Labor, Fair Remuneration, Hours of Work,
    Freedom of Association, Harassment & Abuse, Health & Safety, Non-Discrimination

    EAI_score = 1 - (# Failures) / (# questions in category)

  3. Compute Overall EAI
    Mean of the eight category scores (0 – 1).

  4. Compute CO₂ Totals – new
    For each supplier, sum the four Total impact metrics:

    • GWP (kg CO₂ eq)
    • Eutrophication (kg PO₄ eq)
    • Water Scarcity (m³)
    • Abiotic Resource Depletion (MJ)

  5. Assemble Final Table
    One row per supplier with

    • 8 EAI category columns
    • Overall EAI
    • 4 CO₂-total columns

  6. Interactive Dashboard

    • Left pane: radar chart (8 EAI scores)

    • Right pane: grouped bar chart (4 CO₂ totals)

    • Dropdown: choose a supplier

    • Annotation:

      Overall EAI : 0.82

    • Hover tooltips:

      • Radar → “Category : 0.XX”
      • Bars → “Metric : 1,234”

3 How to Read It

  • Radar polygon shows pass-rate (0 – 1) in each EAI category.
  • Grouped bars quantify that supplier’s total carbon-impact across the four metrics.
  • Overall EAI gives an at-a-glance compliance score.

Example (Supplier A)

Metric Value
Child Labor score 0.80
Forced Labor score 1.00
… …
Overall EAI 0.78
GWP (kg CO₂ eq) 12 345
Eutrophication (kg PO₄ eq) 123
Water Scarcity (m³) 456
Abiotic Depletion (MJ) 7 890

Benefit – Quickly compare suppliers on both compliance (0 – 1) and absolute carbon impacts (native units).