LOGISTIC CARBON COSTING
Carbon footprint reduction is a major stake for everyone. We worked in the aeronautic industry to develop a digital solution : the underlying models estimate the CO2 footprint of logistic flows and identify scenarios to reduce cost and carbon footprint.
DATA & STACK
All logistic flows to manufacture and deliver parts represent millions of rows, much more as we also leveraged jobcards and Bill of Materials to analyse the manufacturing processes at part level. The main challenges were to deal with multiple ERP sources with low data quality, and design a responsive user interface with low latency when manipulating high data volumes.
Our Tech Stack includes : Python, PostgreSQL, React.JS, Mongo DB, Celery and Docker
CONTEXT & APPROACH
The CEO of a major detailed parts manufacturer is willing to anticipate the EU ETS implementation in the industrial sector. Our approach articulated three steps to progressively quantify and reduce the company CO2 footprint
First step is to cartography and visualize all transport flows from material supply to customer delivery at individual part granularity.(including internal flow between plants and with subcontractors). We then define a C02 emission model per transport mean and quantify the CO2 emission on each route and part. Last step is to flag outliers and simulate alternatives scenarios to reduce costs and CO2 emissions.
D3S team delivered a software to analyze logistic flows, compute the cost (CO2 and financial) and optimize. It relies on a Single of Source Truth with all routings, BoM and transport from all industrial sites. Our advanced data processing engine controls data quality, identifies erroneous values and proposes approximations when required. The CO2 model was developped per transport mean (truck, maritime, air transport) leveraging major data providers. The solution allows to estimate optimal CO2 consumption and transport costs, and measure associated deviation at part level.
Next step is to include logistic costing in our Digital Costing solution ;