Back to Tutorials
Tutorial 3 of 6 · Product LCA

BOM & Product LCA Calculation

Product Designer UI, monetary vs physical calculation tracks, and invoice settlement footprints.

Next: Data Sources

Two Calculation Tracks

AspectMonetaryPhysical
Source of truthExiobase sectorlca-sources entity
Category selected in UIexiobase_sector (canonical name)lca_entity (alias/prefLabel, 26 languages)
Quantity basiscomposition_pct (% economic, Σ=100)unit_amount + unit (kg/L/kWh/…)
Impact formulaco2e_per_eur × amount_eur_allocatedunit_amount × impact_factor (kg CO₂e)
Currency dependenceYes (FX to EUR)No (currency-invariant)
composition_pctRequired (Σ=100)N/A
Flagdata_type = monetarydata_type = physical

Calculation Formulas

Single product — Monetary
impact = co2e_per_eur × amount_eur
Single product — Physical
impact = unit_amount × impact_factor

Physical components contribute absolute kg directly (never × amount_eur); monetary components contribute allocated spend × sector factor × composition weight. No double counting.

Multi-Product Invoice Allocation

denominator = Σ_products (price_eur_p × qty_p) amount_eur_allocated_p = amount_eur × (price_eur_p × qty_p) / denominator for each product p in invoice: for each component c in BOM(p): if c.data_type == 'physical': impact_c = unit_amount_c × impact_factor_c else: w_c = composition_pct_c / 100 impact_c = co2e_per_eur(sector_c, country_c) × amount_eur_allocated_p × w_c accumulate impact_c into scope totals invoice_co2e = Σ_p Σ_c impact_c
Edge cases:
  • No price on product: equal split across price-less products; log invoice_allocation_no_price.
  • Physical + monetary mix: both handled; invoice total = sum.
  • Product not in any BOM: falls back to product's own exiobase_sector as single monetary component.
  • Single-product invoice: amount_eur_allocated = amount_eur.

bom_components Schema

ColumnTypeDescription
data_typeVARCHAR(16)monetary or physical
lca_entityVARCHAR(256)Matched prefLabel/notation
impact_factorNUMERIC(18,10)kg CO₂e / reference_unit
reference_unitVARCHAR(32)kg, L, MJ, pcs
composition_pctNUMERIC(10,6)Economic % (monetary only, Σ=100)
unit_amountNUMERIC(12,4)Physical quantity
price_eurNUMERIC(18,8)Component unit price (optional)