← Exception queue

JOB-0065Teräs Energia Oy

Customer CUS-025 · Completed · opened 31.10.2025 at 03:05 · completed 24.11.2025 at 03:05

Work centres: CNC-1, CNC-2, WELD-1

13 036,14 €
20,43 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)65 522,81 €63 819,21 €
Material28 120,99 €31 435,50 €
Labour344,15 h × 65,37 €/h19 347,57 €
Subcontract0,00 €0,00 €
Other variable costs0,00 €0,00 €
Margin13 036,14 €

The estimated margin is not a stored figure: the quote basis stores the items, and the bridge sets out the difference between estimated and actual line by line.

Snapshot computed 21.09.2026 at 14:48 · definition job-margin/2026-09-20.1 · inputs 0b30e862433c

The margin bridge

The bridge explains the arithmetic difference: each line says how much of the gap between the estimated and the actual margin that driver accounts for. It does not establish a cause. Why a price or an hours figure moved is a different question, and this view does not answer it.

  • 1Revenue differencerevenue_varianceCausal−1 703,60 €
    Evidence (7 rows · Causal reference: 7)
    Causal referenceThe rows that produced the amount

    These rows produced the amount: every figure is computed from these rows.

    TableSourceRowVersionTime (UTC)MappingQualityField
    Invoice line invoice_lineinvoicingIL-000396120.07.2026 at 19:52synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000397124.05.2026 at 13:36synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000398111.07.2026 at 16:53synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000399102.01.2026 at 17:02synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000400127.03.2026 at 09:05synthetic/v1In order
    Credit line credit_lineinvoicingCR-00051107.03.2026 at 20:58synthetic/v1In order
    Credit line credit_lineinvoicingCR-00052131.01.2026 at 22:33synthetic/v1In order
  • 2Material quantity differencematerial_quantity_varianceCausal+1 583,49 €
    Evidence (6 rows · Causal reference: 6)
    Causal referenceThe rows that produced the amount

    These rows produced the amount: every figure is computed from these rows.

    TableSourceRowVersionTime (UTC)MappingQualityField
    Material consumption material_consumptionerpMC-000531119.11.2025 at 17:00synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000532131.10.2025 at 15:01synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000533107.11.2025 at 03:47synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000534123.11.2025 at 22:36synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000535114.11.2025 at 05:29synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000536102.11.2025 at 16:47synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal−4 898,00 €
    Evidence (6 rows · Causal reference: 6)
    Causal referenceThe rows that produced the amount

    These rows produced the amount: every figure is computed from these rows.

    TableSourceRowVersionTime (UTC)MappingQualityField
    Material consumption material_consumptionerpMC-000531119.11.2025 at 17:00synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000532131.10.2025 at 15:01synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000533107.11.2025 at 03:47synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000534123.11.2025 at 22:36synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000535114.11.2025 at 05:29synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000536102.11.2025 at 16:47synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal+3 149,53 €
    Evidence (14 rows · Causal reference: 14)
    Causal referenceThe rows that produced the amount

    These rows produced the amount: every figure is computed from these rows.

    TableSourceRowVersionTime (UTC)MappingQualityField
    Time entry time_entrytimeclockTE-000959114.11.2025 at 07:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000960131.10.2025 at 20:29synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000961115.11.2025 at 19:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000962131.10.2025 at 14:29synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000963108.11.2025 at 09:52synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000964112.11.2025 at 04:48synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000965123.11.2025 at 00:13synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000966121.11.2025 at 12:37synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000967107.11.2025 at 19:22synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000968119.11.2025 at 15:28synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000969111.11.2025 at 15:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000970118.11.2025 at 03:49synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000971119.11.2025 at 12:22synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000972112.11.2025 at 09:29synthetic/v1In orderhours
  • 5Labour rate differencelabour_rate_varianceCausal−0,01 €
    Evidence (14 rows · Causal reference: 14)
    Causal referenceThe rows that produced the amount

    These rows produced the amount: every figure is computed from these rows.

    TableSourceRowVersionTime (UTC)MappingQualityField
    Time entry time_entrytimeclockTE-000959114.11.2025 at 07:06synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000960131.10.2025 at 20:29synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000961115.11.2025 at 19:45synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000962131.10.2025 at 14:29synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000963108.11.2025 at 09:52synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000964112.11.2025 at 04:48synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000965123.11.2025 at 00:13synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000966121.11.2025 at 12:37synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000967107.11.2025 at 19:22synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000968119.11.2025 at 15:28synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000969111.11.2025 at 15:45synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000970118.11.2025 at 03:49synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000971119.11.2025 at 12:22synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000972112.11.2025 at 09:29synthetic/v1In orderrate
  • 6Subcontract differencesubcontract_varianceNo claim0,00 €

    No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.

  • 7Rework differencerework_varianceNo claim0,00 €

    No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.

  • 8Other variable cost differenceother_variable_varianceNo claim0,00 €

    No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.

  • 9Unexplained differenceresidual_unexplainedNo claim0,00 €

    No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.

Reconciliation0,00 €tolerance 319,10 €
  • ReconcilesJOB-0065 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 319,10 €)
The stored note

tolerance 31910 minor units; tasmaa: JOB-0065 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 319,10 €)

The bridge is computed from the stored snapshot. The next step is always the same: open the line's evidence and check the source rows.

Findings (1)Margin 13 036,14 € · 20,43 %

  • Medium mediumMaterial price increaseR33 489,19 €

    Quoted items on JOB-0065 exceeded the quote basis: 3 489,19 € above the quote basis.

    The job is in order · work centres CNC-1, CNC-2, WELD-1 · version job-margin-rules/2026-09-20.1 · computed 21.09.2026 at 14:48

    Evidence (3 rows · Causal reference: 3)
    Causal referenceThe rows that produced the amount

    These rows produced the amount: every figure is computed from these rows.

    TableSourceRowVersionTime (UTC)MappingQualityField
    Material consumption material_consumptionerpMC-000534123.11.2025 at 22:36synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000535114.11.2025 at 05:29synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000536102.11.2025 at 16:47synthetic/v1In orderunitCost