Tutorial 3 of 6 · Product LCA
BOM & Product LCA Calculation
Product Designer UI, monetary vs physical calculation tracks, and invoice settlement footprints.
Two Calculation Tracks
| Aspect | Monetary | Physical |
|---|---|---|
| Source of truth | Exiobase sector | lca-sources entity |
| Category selected in UI | exiobase_sector (canonical name) | lca_entity (alias/prefLabel, 26 languages) |
| Quantity basis | composition_pct (% economic, Σ=100) | unit_amount + unit (kg/L/kWh/…) |
| Impact formula | co2e_per_eur × amount_eur_allocated | unit_amount × impact_factor (kg CO₂e) |
| Currency dependence | Yes (FX to EUR) | No (currency-invariant) |
| composition_pct | Required (Σ=100) | N/A |
| Flag | data_type = monetary | data_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
| Column | Type | Description |
|---|---|---|
| data_type | VARCHAR(16) | monetary or physical |
| lca_entity | VARCHAR(256) | Matched prefLabel/notation |
| impact_factor | NUMERIC(18,10) | kg CO₂e / reference_unit |
| reference_unit | VARCHAR(32) | kg, L, MJ, pcs |
| composition_pct | NUMERIC(10,6) | Economic % (monetary only, Σ=100) |
| unit_amount | NUMERIC(12,4) | Physical quantity |
| price_eur | NUMERIC(18,8) | Component unit price (optional) |