Challenge
Packaging compliance data was spread across PLM, ERP, supplier portals and lab systems while market regulations kept changing.
Green Dot Packaging Sustainability
One cockpit for packaging footprint, scenarios and regulatory compliance.
Packaging data from ERP, PLM, supplier portals, lab systems and regulatory sources, brought together in operational, strategic and compliance views.
Delivered
A Packaging Sustainability & Compliance Cockpit with operational, strategic and compliance views.
Decision support
Scenario planning, supplier scorecards and a regulatory tracking matrix, including Plastic Tax calculation.
Challenge
Multi-market FMCG operations face accelerating packaging regulation - plastic taxes in the UK, Spain, and Italy, packaging declarations in France, EPR schemes across Germany and France, and CSRD reporting at the EU level. Compliance data lived in disconnected sources: PLM systems for material specs, ERP for volumes and weights, supplier portals for PCR (post-consumer recycled) content, lab data for recyclability. Tracking compliance against each market's deadline required manual reconciliation across teams.
Approach
We built a unified Packaging Sustainability & Compliance Cockpit that consolidates packaging footprint data across all products, materials, suppliers, and markets. The platform integrates ERP, PLM, supplier portals, lab systems, and external regulatory databases into a single source of truth.
Three connected views:
- Operational view - real-time visibility into total weight, recyclability, PCR content, CO₂ per unit, year-over-year trends
- Strategic view - scenario planning to model weight reduction, material shifts, and PCR optimization with cost and CO₂ impact
- Compliance view - regulatory tracking matrix for plastic taxes, EPR schemes, packaging declarations, and CSRD across 8+ European markets - including Plastic Tax calculation
Inside the Green Dot cockpit
Two screens from the cockpit.
Dashboard screen · 01 / 02
Packaging footprint overview
Total weight, recyclable packaging share, PCR content, CO₂ per unit, material breakdown, top products by weight and a regulatory compliance matrix.
- Year, region and product filters
- Packaging weight trend and material breakdown
- Regulatory compliance matrix with deadlines
Dashboard screen · 02 / 02
Operational view
Material distribution, a supplier quality scorecard, regional distribution and the supplier reliability trend.
- Supplier scorecard with PCR availability and certification level
- Regional distribution map
- Supplier reliability trend
Outcomes
Qualitative project outcomes; no measured savings are claimed.
Single source of truth for packaging sustainability across the product portfolio
Proactive regulatory compliance tracking across 8 European markets
Supplier scorecards with PCR availability and certification tier benchmarking
Scenario modeling connecting sustainability goals to cost savings
Plastic Tax calculation built into the cockpit
Foundation for ESG reporting and CSRD compliance
Technology
Power BI
Databricks/Snowflake
ERP/PLM connectors
Supplier portal integration
External regulatory data sources
Solution areas: Data Foundations · Data Products
