← Exception queue

JOB-0057Kvarts Kone Oy

Customer CUS-017 · Completed · opened 24.09.2025 at 01:59 · completed 04.10.2025 at 01:59

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

3 045,30 €
9,33 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)33 449,68 €32 656,92 €
Material14 932,94 €14 227,23 €
Labour207,19 h × 47,57 €/h14 981,20 €
Subcontract0,00 €0,00 €
Other variable costs403,19 €403,19 €
Margin3 045,30 €

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 65a7a383e430

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−792,76 €
    Evidence (9 rows · Causal reference: 9)
    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-000345122.12.2025 at 22:53synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000346129.05.2026 at 03:14synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000347110.03.2026 at 10:44synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000348103.07.2026 at 23:21synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000349104.04.2026 at 01:02synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000350119.08.2026 at 00:15synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000351113.10.2025 at 14:51synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000352111.12.2025 at 22:08synthetic/v1In order
    Credit line credit_lineinvoicingCR-00044113.05.2026 at 09:18synthetic/v1In order
  • 2Material quantity differencematerial_quantity_varianceCausal+288,83 €
    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-000472127.09.2025 at 00:59synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000473101.10.2025 at 04:00synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000474130.09.2025 at 21:21synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000475127.09.2025 at 07:43synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000476130.09.2025 at 17:53synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000477130.09.2025 at 12:43synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000478125.09.2025 at 08:51synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000479129.09.2025 at 12:25synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000480124.09.2025 at 23:30synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000481126.09.2025 at 23:38synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000482103.10.2025 at 21:59synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal+416,88 €
    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-000472127.09.2025 at 00:59synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000473101.10.2025 at 04:00synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000474130.09.2025 at 21:21synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000475127.09.2025 at 07:43synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000476130.09.2025 at 17:53synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000477130.09.2025 at 12:43synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000478125.09.2025 at 08:51synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000479129.09.2025 at 12:25synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000480124.09.2025 at 23:30synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000481126.09.2025 at 23:38synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000482103.10.2025 at 21:59synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal−5 125,19 €
    Evidence (22 rows · Causal reference: 22)
    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-000839101.10.2025 at 10:47synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000840130.09.2025 at 21:20synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000841125.09.2025 at 11:33synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000842101.10.2025 at 06:46synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000843103.10.2025 at 10:59synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000844103.10.2025 at 23:54synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000845102.10.2025 at 13:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000846102.10.2025 at 19:10synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000847130.09.2025 at 17:50synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000848130.09.2025 at 11:01synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000849130.09.2025 at 10:02synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000850101.10.2025 at 11:19synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000851102.10.2025 at 11:41synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000852130.09.2025 at 01:03synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000853129.09.2025 at 23:18synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000854102.10.2025 at 17:49synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900096102.10.2025 at 19:21synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900097129.09.2025 at 10:22synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900098125.09.2025 at 12:55synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900099127.09.2025 at 20:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900100129.09.2025 at 11:21synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900101124.09.2025 at 15:18synthetic/v1In orderhours
  • 5Labour rate differencelabour_rate_varianceCausal+0,02 €
    Evidence (22 rows · Causal reference: 22)
    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-000839101.10.2025 at 10:47synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000840130.09.2025 at 21:20synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000841125.09.2025 at 11:33synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000842101.10.2025 at 06:46synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000843103.10.2025 at 10:59synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000844103.10.2025 at 23:54synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000845102.10.2025 at 13:06synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000846102.10.2025 at 19:10synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000847130.09.2025 at 17:50synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000848130.09.2025 at 11:01synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000849130.09.2025 at 10:02synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000850101.10.2025 at 11:19synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000851102.10.2025 at 11:41synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000852130.09.2025 at 01:03synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000853129.09.2025 at 23:18synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000854102.10.2025 at 17:49synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900096102.10.2025 at 19:21synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900097129.09.2025 at 10:22synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900098125.09.2025 at 12:55synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900099127.09.2025 at 20:45synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900100129.09.2025 at 11:21synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900101124.09.2025 at 15:18synthetic/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 163,28 €
  • ReconcilesJOB-0057 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 163,28 €)
The stored note

tolerance 16328 minor units; tasmaa: JOB-0057 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 163,28 €)

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 045,30 € · 9,33 %

  • Medium mediumLabour hours overrunR25 125,19 €

    Quoted-scope labour on JOB-0057 exceeds the allowed factor: 5 125,19 € at the estimated rate.

    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 (22 rows · Causal reference: 22)
    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-000839101.10.2025 at 10:47synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000840130.09.2025 at 21:20synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000841125.09.2025 at 11:33synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000842101.10.2025 at 06:46synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000843103.10.2025 at 10:59synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000844103.10.2025 at 23:54synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000845102.10.2025 at 13:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000846102.10.2025 at 19:10synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000847130.09.2025 at 17:50synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000848130.09.2025 at 11:01synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000849130.09.2025 at 10:02synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000850101.10.2025 at 11:19synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000851102.10.2025 at 11:41synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000852130.09.2025 at 01:03synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000853129.09.2025 at 23:18synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000854102.10.2025 at 17:49synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900096102.10.2025 at 19:21synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900097129.09.2025 at 10:22synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900098125.09.2025 at 12:55synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900099127.09.2025 at 20:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900100129.09.2025 at 11:21synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900101124.09.2025 at 15:18synthetic/v1In orderhours