General Presentation:

In this page you have the detailed PCF for each Finished Product / Site.

By clicking on the colours of the scope of the Finished Product/ Site couple you are interested in, the breakdown will be displayed on the right hand side of the dashboard. You can display the breakdown of each Scope by selected the select any Finished product and see the breakdown by different scope. 

Filters:

  • Year
  • GBU 
  • Finished product Site (FP Site)
  • Finished Product  (By default selected on Rheomer 33 200 KG Drum)
  • Raw Material 
  • Intermediates (By default : Show selected, ONLY for Raw Material)
Left side of the dashboard : Split by Scope for one combinaison Finished Product / Site

Right side of the dashboard: Details per selected scope of Intermediate Product and Intermediate PCF Contributions

Breakdown by scope details:

Color codeScopeTable columns 

Scope 1 Energy
  • Energy type
  • Contribution
  • Emission factor
  • Quantity  (Unit)

Scope 1 other GHG
  • Contribution
  • Emission factor
  • Quantity  (Unit)
  • Missing BOM recipe (KPI)
  • Outbound site (Production site)

Scope 2
  • Energy type
  • Contribution
  • Emission factor
  • Quantity  (Unit)

Scope 3.3
  • Energy type
  • Contribution
  • Emission factor
  • Quantity  (Unit)

Scope 3.4
  •  Transported material ( Raw material )
  • Contribution
  • Emission factor
  • Quantity  (Unit )
  • Missing routes (KPI)
  • Missing BOM recipe (KPI)
  • Outbound plant (Production plant of the transported material)
  • Inbound plant ( Plant where the transported material is used)

Scope 3.5
  • Waste type
  • Contribution
  • Emission factor
  • Quantity  (Unit)
  • Missing BOM recipe (KPI)
  • Outbound site ( Production site)


KPIs:

Name

Definition

Calculation


% Raw Material Mappedfor each finished product of a site, the % of raw materials quantites for which an emission factor is available in the database

RM_Mapped_pc  = if (Emission_Factor' is not empty AND 'IS an Intermediate='#' ) then  abs( 'Adjusted Qty') 

if  ( 'IS an Intermediate' ='#' ) then abs( 'Adjusted Qty')

abs( 'Adjusted Qty')  / abs( 'Adjusted Qty') 

Contribution 

Unit: (in kg of CO2 from RM / kg of FP) 

Contribution of the selected Scope in the Finished Product carbon footprint. 

The sum of all th Scope contributions of a finished product  IS the PCF of the selected scope of the Finished products

 Emission Factor of the selected Scope x Adjusted_Qty / Finished_Product_STD_Qty

PCF Source

Indicate data source of the Emission factor for the Raw Materials. 

Options of PCF Source: 

  • RM Mapping = Ecoinvent data base or Proxy
  • Name of the supplier that communicated the PCF of the Raw Material 
n.a
Emission Factors

emission factor Unit: (in kg of CO2 / kg of Finished product)

CO2 content per kg of the selected Scope (Raw material, intermediate transport, or waste)

n.a

Adjusted QuantityQuatity of the intermediate n.a
Missing BOM recipe

KPI to identify missing recipe of intermediates, kind of error in BOM

Missing BOM recipe = 1 if missing BOM of intermediate (outbound plant is NULL).
Missing routes (Only Scope 3.4)KPI to flag if the source table of Emission factors for standard routes is missing a route between 2 plants. If we are no able to map this route for a transported Raw Material, then Missing routes= 1n.a




Features: 

Possibility to extract the data in a CSV/Excel/Gsheet file by clicking on the button "Get Data".