← Exception queue

JOB-0015Teräs Kone Oy

Customer CUS-015 · Completed · opened 31.12.2024 at 16:23 · completed 25.01.2025 at 16:23

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

−906,73 €
−4,84 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)19 181,06 €18 716,88 €
Material8 839,96 €10 853,68 €
Labour128,21 h × 44,13 €/h8 769,93 €
Subcontract0,00 €0,00 €
Other variable costs0,00 €0,00 €
Margin−906,73 €

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 f6a27fad8c86

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−464,18 €
    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-000084123.04.2026 at 21:00synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000085117.01.2026 at 01:10synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000086125.06.2025 at 20:42synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000087118.11.2025 at 02:53synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000088122.08.2026 at 21:14synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000089114.06.2025 at 06:35synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000090111.08.2025 at 09:29synthetic/v1In order
    Credit line credit_lineinvoicingCR-00009107.12.2025 at 12:37synthetic/v1In order
    Credit line credit_lineinvoicingCR-00010120.01.2026 at 00:14synthetic/v1In order
  • 2Material quantity differencematerial_quantity_varianceCausal−228,95 €
    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-000129109.01.2025 at 04:19synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000130107.01.2025 at 09:02synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000131118.01.2025 at 02:17synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000132119.01.2025 at 05:34synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000133110.01.2025 at 09:37synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000134102.01.2025 at 03:22synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal−1 784,77 €
    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-000129109.01.2025 at 04:19synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000130107.01.2025 at 09:02synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000131118.01.2025 at 02:17synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000132119.01.2025 at 05:34synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000133110.01.2025 at 09:37synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000134102.01.2025 at 03:22synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal−3 112,05 €
    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-000197124.01.2025 at 22:44synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000198121.01.2025 at 21:53synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000199107.01.2025 at 10:08synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000200102.01.2025 at 18:29synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000201124.01.2025 at 07:01synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000202111.01.2025 at 04:23synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000203111.01.2025 at 11:14synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000204121.01.2025 at 21:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000205125.01.2025 at 08:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000206106.01.2025 at 23:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000207111.01.2025 at 14:38synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000208119.01.2025 at 22:59synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000209107.01.2025 at 17:09synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000210121.01.2025 at 00:37synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000211112.01.2025 at 23:11synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000212101.01.2025 at 11:40synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000213113.01.2025 at 23:13synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000214121.01.2025 at 17:01synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900000106.01.2025 at 01:08synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900001109.01.2025 at 15:11synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900002122.01.2025 at 20:28synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900003107.01.2025 at 11:54synthetic/v1In orderhours
  • 5Labour rate differencelabour_rate_varianceCausal+0,03 €
    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-000197124.01.2025 at 22:44synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000198121.01.2025 at 21:53synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000199107.01.2025 at 10:08synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000200102.01.2025 at 18:29synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000201124.01.2025 at 07:01synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000202111.01.2025 at 04:23synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000203111.01.2025 at 11:14synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000204121.01.2025 at 21:06synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000205125.01.2025 at 08:35synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000206106.01.2025 at 23:06synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000207111.01.2025 at 14:38synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000208119.01.2025 at 22:59synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000209107.01.2025 at 17:09synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000210121.01.2025 at 00:37synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000211112.01.2025 at 23:11synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000212101.01.2025 at 11:40synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000213113.01.2025 at 23:13synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000214121.01.2025 at 17:01synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900000106.01.2025 at 01:08synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900001109.01.2025 at 15:11synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900002122.01.2025 at 20:28synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900003107.01.2025 at 11:54synthetic/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 93,58 €
  • ReconcilesJOB-0015 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 93,58 €)
The stored note

tolerance 9358 minor units; tasmaa: JOB-0015 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 93,58 €)

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 −906,73 € · −4,84 %

  • High highMargin below targetR1906,73 €

    JOB-0015 completed at a margin of −4,84 %, below the policy threshold: 906,73 € 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 (37 rows · Causal reference: 37)
    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-000084123.04.2026 at 21:00synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000085117.01.2026 at 01:10synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000086125.06.2025 at 20:42synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000087118.11.2025 at 02:53synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000088122.08.2026 at 21:14synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000089114.06.2025 at 06:35synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000090111.08.2025 at 09:29synthetic/v1In order
    Credit line credit_lineinvoicingCR-00009107.12.2025 at 12:37synthetic/v1In order
    Credit line credit_lineinvoicingCR-00010120.01.2026 at 00:14synthetic/v1In order
    Material consumption material_consumptionerpMC-000129109.01.2025 at 04:19synthetic/v1In order
    Material consumption material_consumptionerpMC-000130107.01.2025 at 09:02synthetic/v1In order
    Material consumption material_consumptionerpMC-000131118.01.2025 at 02:17synthetic/v1In order
    Material consumption material_consumptionerpMC-000132119.01.2025 at 05:34synthetic/v1In order
    Material consumption material_consumptionerpMC-000133110.01.2025 at 09:37synthetic/v1In order
    Material consumption material_consumptionerpMC-000134102.01.2025 at 03:22synthetic/v1In order
    Time entry time_entrytimeclockTE-000197124.01.2025 at 22:44synthetic/v1In order
    Time entry time_entrytimeclockTE-000198121.01.2025 at 21:53synthetic/v1In order
    Time entry time_entrytimeclockTE-000199107.01.2025 at 10:08synthetic/v1In order
    Time entry time_entrytimeclockTE-000200102.01.2025 at 18:29synthetic/v1In order
    Time entry time_entrytimeclockTE-000201124.01.2025 at 07:01synthetic/v1In order
    Time entry time_entrytimeclockTE-000202111.01.2025 at 04:23synthetic/v1In order
    Time entry time_entrytimeclockTE-000203111.01.2025 at 11:14synthetic/v1In order
    Time entry time_entrytimeclockTE-000204121.01.2025 at 21:06synthetic/v1In order
    Time entry time_entrytimeclockTE-000205125.01.2025 at 08:35synthetic/v1In order
    Time entry time_entrytimeclockTE-000206106.01.2025 at 23:06synthetic/v1In order
    Time entry time_entrytimeclockTE-000207111.01.2025 at 14:38synthetic/v1In order
    Time entry time_entrytimeclockTE-000208119.01.2025 at 22:59synthetic/v1In order
    Time entry time_entrytimeclockTE-000209107.01.2025 at 17:09synthetic/v1In order
    Time entry time_entrytimeclockTE-000210121.01.2025 at 00:37synthetic/v1In order
    Time entry time_entrytimeclockTE-000211112.01.2025 at 23:11synthetic/v1In order
    Time entry time_entrytimeclockTE-000212101.01.2025 at 11:40synthetic/v1In order
    Time entry time_entrytimeclockTE-000213113.01.2025 at 23:13synthetic/v1In order
    Time entry time_entrytimeclockTE-000214121.01.2025 at 17:01synthetic/v1In order
    Time entry time_entrytimeclockTE-900000106.01.2025 at 01:08synthetic/v1In order
    Time entry time_entrytimeclockTE-900001109.01.2025 at 15:11synthetic/v1In order
    Time entry time_entrytimeclockTE-900002122.01.2025 at 20:28synthetic/v1In order
    Time entry time_entrytimeclockTE-900003107.01.2025 at 11:54synthetic/v1In order
  • Medium mediumLabour hours overrunR23 112,05 €

    Quoted-scope labour on JOB-0015 exceeds the allowed factor: 3 112,05 € 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-000197124.01.2025 at 22:44synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000198121.01.2025 at 21:53synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000199107.01.2025 at 10:08synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000200102.01.2025 at 18:29synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000201124.01.2025 at 07:01synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000202111.01.2025 at 04:23synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000203111.01.2025 at 11:14synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000204121.01.2025 at 21:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000205125.01.2025 at 08:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000206106.01.2025 at 23:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000207111.01.2025 at 14:38synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000208119.01.2025 at 22:59synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000209107.01.2025 at 17:09synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000210121.01.2025 at 00:37synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000211112.01.2025 at 23:11synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000212101.01.2025 at 11:40synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000213113.01.2025 at 23:13synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000214121.01.2025 at 17:01synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900000106.01.2025 at 01:08synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900001109.01.2025 at 15:11synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900002122.01.2025 at 20:28synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900003107.01.2025 at 11:54synthetic/v1In orderhours
  • Medium mediumMaterial price increaseR32 035,32 €

    Quoted items on JOB-0015 exceeded the quote basis: 2 035,32 € 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-000129109.01.2025 at 04:19synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000130107.01.2025 at 09:02synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000131118.01.2025 at 02:17synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000132119.01.2025 at 05:34synthetic/v1In orderunitCost