← Exception queue

JOB-0020Vääksy Kone Oy

Customer CUS-020 · Completed · opened 17.01.2025 at 12:07 · completed 21.01.2025 at 12:07

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

−675,99 €
−4,49 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)15 136,63 €15 059,43 €
Material6 127,58 €6 897,33 €
Labour94,29 h × 57,19 €/h8 358,30 €
Subcontract0,00 €0,00 €
Other variable costs479,79 €479,79 €
Margin−675,99 €

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 c7ed77a7d0c0

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−77,20 €
    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-000117124.07.2026 at 07:38synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000118108.08.2025 at 20:42synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000119123.08.2025 at 16:15synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000120102.11.2025 at 10:06synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000121109.03.2026 at 06:05synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000122119.04.2025 at 02:31synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000123123.05.2025 at 12:28synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000124125.03.2025 at 21:16synthetic/v1In order
    Credit line credit_lineinvoicingCR-00015116.02.2025 at 21:05synthetic/v1In order
  • 2Material quantity differencematerial_quantity_varianceCausal+462,92 €
    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
    Material consumption material_consumptionerpMC-000168118.01.2025 at 07:30synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000169118.01.2025 at 20:05synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000170117.01.2025 at 16:05synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000171118.01.2025 at 00:18synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000172119.01.2025 at 08:47synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000173118.01.2025 at 12:06synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000174118.01.2025 at 23:35synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal−1 232,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
    Material consumption material_consumptionerpMC-000168118.01.2025 at 07:30synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000169118.01.2025 at 20:05synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000170117.01.2025 at 16:05synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000171118.01.2025 at 00:18synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000172119.01.2025 at 08:47synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000173118.01.2025 at 12:06synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000174118.01.2025 at 23:35synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal−2 965,87 €
    Evidence (17 rows · Causal reference: 17)
    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-000277119.01.2025 at 20:52synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000278119.01.2025 at 08:09synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000279118.01.2025 at 15:38synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000280120.01.2025 at 01:25synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000281118.01.2025 at 11:23synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000282120.01.2025 at 03:50synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000283120.01.2025 at 04:41synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000284119.01.2025 at 17:09synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000285120.01.2025 at 22:05synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000286118.01.2025 at 08:21synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000287119.01.2025 at 22:32synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000288121.01.2025 at 09:37synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000289117.01.2025 at 23:48synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900004119.01.2025 at 20:07synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900005120.01.2025 at 22:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900006120.01.2025 at 13:53synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900007119.01.2025 at 18:42synthetic/v1In orderhours
  • 5Labour rate differencelabour_rate_varianceCausal+0,02 €
    Evidence (17 rows · Causal reference: 17)
    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-000277119.01.2025 at 20:52synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000278119.01.2025 at 08:09synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000279118.01.2025 at 15:38synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000280120.01.2025 at 01:25synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000281118.01.2025 at 11:23synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000282120.01.2025 at 03:50synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000283120.01.2025 at 04:41synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000284119.01.2025 at 17:09synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000285120.01.2025 at 22:05synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000286118.01.2025 at 08:21synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000287119.01.2025 at 22:32synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000288121.01.2025 at 09:37synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000289117.01.2025 at 23:48synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900004119.01.2025 at 20:07synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900005120.01.2025 at 22:35synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900006120.01.2025 at 13:53synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900007119.01.2025 at 18:42synthetic/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 75,30 €
  • ReconcilesJOB-0020 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 75,30 €)
The stored note

tolerance 7530 minor units; tasmaa: JOB-0020 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 75,30 €)

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 (3)Margin −675,99 € · −4,49 %

  • High highMargin below targetR1675,99 €

    JOB-0020 completed at a margin of −4,49 %, below the policy threshold: 675,99 € short of it.

    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 (34 rows · Causal reference: 34)
    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-000117124.07.2026 at 07:38synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000118108.08.2025 at 20:42synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000119123.08.2025 at 16:15synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000120102.11.2025 at 10:06synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000121109.03.2026 at 06:05synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000122119.04.2025 at 02:31synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000123123.05.2025 at 12:28synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000124125.03.2025 at 21:16synthetic/v1In order
    Credit line credit_lineinvoicingCR-00015116.02.2025 at 21:05synthetic/v1In order
    Material consumption material_consumptionerpMC-000168118.01.2025 at 07:30synthetic/v1In order
    Material consumption material_consumptionerpMC-000169118.01.2025 at 20:05synthetic/v1In order
    Material consumption material_consumptionerpMC-000170117.01.2025 at 16:05synthetic/v1In order
    Material consumption material_consumptionerpMC-000171118.01.2025 at 00:18synthetic/v1In order
    Material consumption material_consumptionerpMC-000172119.01.2025 at 08:47synthetic/v1In order
    Material consumption material_consumptionerpMC-000173118.01.2025 at 12:06synthetic/v1In order
    Material consumption material_consumptionerpMC-000174118.01.2025 at 23:35synthetic/v1In order
    Time entry time_entrytimeclockTE-000277119.01.2025 at 20:52synthetic/v1In order
    Time entry time_entrytimeclockTE-000278119.01.2025 at 08:09synthetic/v1In order
    Time entry time_entrytimeclockTE-000279118.01.2025 at 15:38synthetic/v1In order
    Time entry time_entrytimeclockTE-000280120.01.2025 at 01:25synthetic/v1In order
    Time entry time_entrytimeclockTE-000281118.01.2025 at 11:23synthetic/v1In order
    Time entry time_entrytimeclockTE-000282120.01.2025 at 03:50synthetic/v1In order
    Time entry time_entrytimeclockTE-000283120.01.2025 at 04:41synthetic/v1In order
    Time entry time_entrytimeclockTE-000284119.01.2025 at 17:09synthetic/v1In order
    Time entry time_entrytimeclockTE-000285120.01.2025 at 22:05synthetic/v1In order
    Time entry time_entrytimeclockTE-000286118.01.2025 at 08:21synthetic/v1In order
    Time entry time_entrytimeclockTE-000287119.01.2025 at 22:32synthetic/v1In order
    Time entry time_entrytimeclockTE-000288121.01.2025 at 09:37synthetic/v1In order
    Time entry time_entrytimeclockTE-000289117.01.2025 at 23:48synthetic/v1In order
    Time entry time_entrytimeclockTE-900004119.01.2025 at 20:07synthetic/v1In order
    Time entry time_entrytimeclockTE-900005120.01.2025 at 22:35synthetic/v1In order
    Time entry time_entrytimeclockTE-900006120.01.2025 at 13:53synthetic/v1In order
    Time entry time_entrytimeclockTE-900007119.01.2025 at 18:42synthetic/v1In order
    Other variable cost other_variable_costerpOVC-00015120.01.2025 at 14:51synthetic/v1In order
  • Medium mediumLabour hours overrunR22 965,87 €

    Quoted-scope labour on JOB-0020 exceeds the allowed factor: 2 965,87 € 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 (17 rows · Causal reference: 17)
    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-000277119.01.2025 at 20:52synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000278119.01.2025 at 08:09synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000279118.01.2025 at 15:38synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000280120.01.2025 at 01:25synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000281118.01.2025 at 11:23synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000282120.01.2025 at 03:50synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000283120.01.2025 at 04:41synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000284119.01.2025 at 17:09synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000285120.01.2025 at 22:05synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000286118.01.2025 at 08:21synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000287119.01.2025 at 22:32synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000288121.01.2025 at 09:37synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000289117.01.2025 at 23:48synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900004119.01.2025 at 20:07synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900005120.01.2025 at 22:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900006120.01.2025 at 13:53synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900007119.01.2025 at 18:42synthetic/v1In orderhours
  • Medium mediumMaterial price increaseR31 009,90 €

    Quoted items on JOB-0020 exceeded the quote basis: 1 009,90 € 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-000168118.01.2025 at 07:30synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000169118.01.2025 at 20:05synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000170117.01.2025 at 16:05synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000171118.01.2025 at 00:18synthetic/v1In orderunitCost