← Exception queue

JOB-0027Kvarts Energia Oy

Customer CUS-027 · Completed · opened 23.03.2025 at 18:30 · completed 25.04.2025 at 18:30

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

8 122,61 €
25,26 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)33 429,61 €32 155,94 €
Material16 071,06 €15 452,78 €
Labour201,51 h × 39,08 €/h7 245,04 €
Subcontract0,00 €0,00 €
Other variable costs1 335,51 €1 335,51 €
Margin8 122,61 €

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 af2fa42e6def

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 273,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-000165109.07.2025 at 21:24synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000166107.10.2025 at 06:05synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000167119.10.2025 at 21:40synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000168123.09.2025 at 02:55synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000169111.01.2026 at 18:45synthetic/v1In order
    Credit line credit_lineinvoicingCR-00020111.08.2025 at 21:45synthetic/v1In order
    Credit line credit_lineinvoicingCR-00021117.07.2026 at 03:13synthetic/v1In order
  • 2Material quantity differencematerial_quantity_varianceCausal+706,05 €
    Evidence (11 rows · Causal reference: 11)
    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-000223118.04.2025 at 13:22synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000224121.04.2025 at 21:16synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000225130.03.2025 at 17:40synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000226124.03.2025 at 15:35synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000227113.04.2025 at 02:35synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000228129.03.2025 at 15:54synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000229128.03.2025 at 03:58synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000230125.03.2025 at 09:55synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000231108.04.2025 at 12:31synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000232113.04.2025 at 21:49synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000233107.04.2025 at 04:39synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal−87,77 €
    Evidence (11 rows · Causal reference: 11)
    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-000223118.04.2025 at 13:22synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000224121.04.2025 at 21:16synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000225130.03.2025 at 17:40synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000226124.03.2025 at 15:35synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000227113.04.2025 at 02:35synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000228129.03.2025 at 15:54synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000229128.03.2025 at 03:58synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000230125.03.2025 at 09:55synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000231108.04.2025 at 12:31synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000232113.04.2025 at 21:49synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000233107.04.2025 at 04:39synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal+629,97 €
    Evidence (16 rows · Causal reference: 16)
    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-000385119.04.2025 at 01:39synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000386125.03.2025 at 23:54synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000387121.04.2025 at 14:28synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000388114.04.2025 at 10:28synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000389123.04.2025 at 15:29synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000390106.04.2025 at 12:23synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000391123.03.2025 at 20:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000392126.03.2025 at 14:51synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000393111.04.2025 at 22:07synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000394104.04.2025 at 19:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000395104.04.2025 at 17:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000396127.03.2025 at 14:33synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000397111.04.2025 at 00:20synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000398123.04.2025 at 19:59synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000399125.03.2025 at 16:24synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000400107.04.2025 at 20:15synthetic/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 160,78 €
  • ReconcilesJOB-0027 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 160,78 €)
The stored note

tolerance 16078 minor units; tasmaa: JOB-0027 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 160,78 €)

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 8 122,61 € · 25,26 %

  • Medium mediumUnallocated labourR4213,00 €

    Labour attributed to JOB-0027 by its operation carries no job allocation: 213,00 € at the posted rates.

    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 (5 rows · Causal reference: 5)
    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-900031118.04.2025 at 11:40synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900032120.04.2025 at 13:03synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900033111.04.2025 at 22:13synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900034128.03.2025 at 01:05synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900035111.04.2025 at 08:09synthetic/v1In orderhours