← Exception queue

JOB-0063Norva Energia Oy

Customer CUS-023 · Completed · opened 25.10.2025 at 00:58 · completed 08.11.2025 at 00:58

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

3 805,28 €
24,95 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)15 434,12 €15 250,45 €
Material5 824,34 €7 180,98 €
Labour84,38 h × 46,94 €/h3 762,71 €
Subcontract0,00 €0,00 €
Other variable costs501,48 €501,48 €
Margin3 805,28 €

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 3b5b198e51bf

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−183,67 €
    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-000382101.09.2026 at 16:31synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000383127.06.2026 at 21:07synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000384130.06.2026 at 03:04synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000385116.06.2026 at 21:31synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000386118.06.2026 at 02:22synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000387125.03.2026 at 08:23synthetic/v1In order
    Credit line credit_lineinvoicingCR-00048119.08.2026 at 13:08synthetic/v1In order
  • 2Material quantity differencematerial_quantity_varianceCausal+210,80 €
    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-000518126.10.2025 at 08:34synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000519103.11.2025 at 16:30synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000520105.11.2025 at 21:36synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000521126.10.2025 at 12:57synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000522130.10.2025 at 15:59synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000523126.10.2025 at 17:05synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal−1 567,44 €
    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-000518126.10.2025 at 08:34synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000519103.11.2025 at 16:30synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000520105.11.2025 at 21:36synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000521126.10.2025 at 12:57synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000522130.10.2025 at 15:59synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000523126.10.2025 at 17:05synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal+198,09 €
    Evidence (18 rows · Causal reference: 18)
    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-000929102.11.2025 at 14:20synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000930106.11.2025 at 08:42synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000931105.11.2025 at 20:13synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000932105.11.2025 at 05:49synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000933126.10.2025 at 05:32synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000934102.11.2025 at 19:44synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000935101.11.2025 at 06:48synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000936101.11.2025 at 11:42synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000937126.10.2025 at 05:31synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000938127.10.2025 at 06:38synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000939105.11.2025 at 05:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000940104.11.2025 at 07:08synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000941130.10.2025 at 14:34synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000942101.11.2025 at 23:55synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000943104.11.2025 at 17:54synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000944125.10.2025 at 08:36synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000945125.10.2025 at 21:21synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000946104.11.2025 at 23:39synthetic/v1In orderhours
  • 5Labour rate differencelabour_rate_varianceNo claim0,00 €

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

  • 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 76,25 €
  • ReconcilesJOB-0063 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 76,25 €)
The stored note

tolerance 7625 minor units; tasmaa: JOB-0063 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 76,25 €)

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 3 805,28 € · 24,95 %

  • Medium mediumMaterial price increaseR31 430,52 €

    Quoted items on JOB-0063 exceeded the quote basis: 1 430,52 € 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 (4 rows · Causal reference: 4)
    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-000518126.10.2025 at 08:34synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000519103.11.2025 at 16:30synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000520105.11.2025 at 21:36synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000521126.10.2025 at 12:57synthetic/v1In orderunitCost