← Exception queue

JOB-0022Kaskinen Energia Oy

Customer CUS-022 · Completed · opened 20.02.2025 at 11:50 · completed 15.04.2025 at 11:50

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

−2 418,39 €
−3,28 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)73 720,66 €73 720,66 €
Material27 103,15 €30 388,62 €
Labour528,55 h × 53,33 €/h43 690,59 €
Subcontract0,00 €0,00 €
Other variable costs2 059,84 €2 059,84 €
Margin−2 418,39 €

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 1df2b4cb63db

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_varianceNo claim0,00 €

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

  • 2Material quantity differencematerial_quantity_varianceCausal+748,52 €
    Evidence (12 rows · Causal reference: 12)
    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-000184102.04.2025 at 09:52synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000185112.03.2025 at 17:19synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000186115.03.2025 at 10:03synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000187126.02.2025 at 18:30synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000188101.03.2025 at 22:00synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000189105.03.2025 at 12:35synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000190123.03.2025 at 02:19synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000191105.04.2025 at 07:12synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000192113.04.2025 at 04:58synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000193110.03.2025 at 02:24synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000194122.03.2025 at 08:03synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000195110.03.2025 at 15:02synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal−4 033,99 €
    Evidence (12 rows · Causal reference: 12)
    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-000184102.04.2025 at 09:52synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000185112.03.2025 at 17:19synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000186115.03.2025 at 10:03synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000187126.02.2025 at 18:30synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000188101.03.2025 at 22:00synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000189105.03.2025 at 12:35synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000190123.03.2025 at 02:19synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000191105.04.2025 at 07:12synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000192113.04.2025 at 04:58synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000193110.03.2025 at 02:24synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000194122.03.2025 at 08:03synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000195110.03.2025 at 15:02synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal−15 503,03 €
    Evidence (20 rows · Causal reference: 20)
    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-000306103.03.2025 at 06:00synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000307120.02.2025 at 17:48synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000308107.03.2025 at 18:32synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000309101.03.2025 at 01:49synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000310129.03.2025 at 05:36synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000311105.03.2025 at 05:46synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000312110.03.2025 at 06:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000313124.02.2025 at 17:44synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000314113.03.2025 at 09:42synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000315127.03.2025 at 04:40synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000316111.04.2025 at 19:28synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000317126.03.2025 at 21:14synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000318113.03.2025 at 12:13synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000319108.03.2025 at 23:58synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000320126.03.2025 at 23:19synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000321131.03.2025 at 06:08synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900008105.04.2025 at 04:15synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900009116.03.2025 at 22:57synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900010101.03.2025 at 22:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900011104.04.2025 at 22:31synthetic/v1In orderhours
  • 5Labour rate differencelabour_rate_varianceCausal+0,01 €
    Evidence (20 rows · Causal reference: 20)
    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-000306103.03.2025 at 06:00synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000307120.02.2025 at 17:48synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000308107.03.2025 at 18:32synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000309101.03.2025 at 01:49synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000310129.03.2025 at 05:36synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000311105.03.2025 at 05:46synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000312110.03.2025 at 06:35synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000313124.02.2025 at 17:44synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000314113.03.2025 at 09:42synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000315127.03.2025 at 04:40synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000316111.04.2025 at 19:28synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000317126.03.2025 at 21:14synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000318113.03.2025 at 12:13synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000319108.03.2025 at 23:58synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000320126.03.2025 at 23:19synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000321131.03.2025 at 06:08synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900008105.04.2025 at 04:15synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900009116.03.2025 at 22:57synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900010101.03.2025 at 22:35synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900011104.04.2025 at 22:31synthetic/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 368,60 €
  • ReconcilesJOB-0022 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 368,60 €)
The stored note

tolerance 36860 minor units; tasmaa: JOB-0022 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 368,60 €)

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 −2 418,39 € · −3,28 %

  • High highMargin below targetR12 418,39 €

    JOB-0022 completed at a margin of −3,28 %, below the policy threshold: 2 418,39 € 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 (41 rows · Causal reference: 41)
    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-000133102.01.2026 at 14:34synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000134112.02.2026 at 23:05synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000135113.07.2026 at 07:28synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000136105.07.2026 at 23:07synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000137102.10.2025 at 11:53synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000138119.07.2026 at 03:39synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000139122.12.2025 at 12:38synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000140115.03.2026 at 22:15synthetic/v1In order
    Material consumption material_consumptionerpMC-000184102.04.2025 at 09:52synthetic/v1In order
    Material consumption material_consumptionerpMC-000185112.03.2025 at 17:19synthetic/v1In order
    Material consumption material_consumptionerpMC-000186115.03.2025 at 10:03synthetic/v1In order
    Material consumption material_consumptionerpMC-000187126.02.2025 at 18:30synthetic/v1In order
    Material consumption material_consumptionerpMC-000188101.03.2025 at 22:00synthetic/v1In order
    Material consumption material_consumptionerpMC-000189105.03.2025 at 12:35synthetic/v1In order
    Material consumption material_consumptionerpMC-000190123.03.2025 at 02:19synthetic/v1In order
    Material consumption material_consumptionerpMC-000191105.04.2025 at 07:12synthetic/v1In order
    Material consumption material_consumptionerpMC-000192113.04.2025 at 04:58synthetic/v1In order
    Material consumption material_consumptionerpMC-000193110.03.2025 at 02:24synthetic/v1In order
    Material consumption material_consumptionerpMC-000194122.03.2025 at 08:03synthetic/v1In order
    Material consumption material_consumptionerpMC-000195110.03.2025 at 15:02synthetic/v1In order
    Time entry time_entrytimeclockTE-000306103.03.2025 at 06:00synthetic/v1In order
    Time entry time_entrytimeclockTE-000307120.02.2025 at 17:48synthetic/v1In order
    Time entry time_entrytimeclockTE-000308107.03.2025 at 18:32synthetic/v1In order
    Time entry time_entrytimeclockTE-000309101.03.2025 at 01:49synthetic/v1In order
    Time entry time_entrytimeclockTE-000310129.03.2025 at 05:36synthetic/v1In order
    Time entry time_entrytimeclockTE-000311105.03.2025 at 05:46synthetic/v1In order
    Time entry time_entrytimeclockTE-000312110.03.2025 at 06:35synthetic/v1In order
    Time entry time_entrytimeclockTE-000313124.02.2025 at 17:44synthetic/v1In order
    Time entry time_entrytimeclockTE-000314113.03.2025 at 09:42synthetic/v1In order
    Time entry time_entrytimeclockTE-000315127.03.2025 at 04:40synthetic/v1In order
    Time entry time_entrytimeclockTE-000316111.04.2025 at 19:28synthetic/v1In order
    Time entry time_entrytimeclockTE-000317126.03.2025 at 21:14synthetic/v1In order
    Time entry time_entrytimeclockTE-000318113.03.2025 at 12:13synthetic/v1In order
    Time entry time_entrytimeclockTE-000319108.03.2025 at 23:58synthetic/v1In order
    Time entry time_entrytimeclockTE-000320126.03.2025 at 23:19synthetic/v1In order
    Time entry time_entrytimeclockTE-000321131.03.2025 at 06:08synthetic/v1In order
    Time entry time_entrytimeclockTE-900008105.04.2025 at 04:15synthetic/v1In order
    Time entry time_entrytimeclockTE-900009116.03.2025 at 22:57synthetic/v1In order
    Time entry time_entrytimeclockTE-900010101.03.2025 at 22:35synthetic/v1In order
    Time entry time_entrytimeclockTE-900011104.04.2025 at 22:31synthetic/v1In order
    Other variable cost other_variable_costerpOVC-00016112.04.2025 at 14:42synthetic/v1In order
  • Medium mediumLabour hours overrunR215 503,03 €

    Quoted-scope labour on JOB-0022 exceeds the allowed factor: 15 503,03 € 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 (20 rows · Causal reference: 20)
    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-000306103.03.2025 at 06:00synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000307120.02.2025 at 17:48synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000308107.03.2025 at 18:32synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000309101.03.2025 at 01:49synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000310129.03.2025 at 05:36synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000311105.03.2025 at 05:46synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000312110.03.2025 at 06:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000313124.02.2025 at 17:44synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000314113.03.2025 at 09:42synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000315127.03.2025 at 04:40synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000316111.04.2025 at 19:28synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000317126.03.2025 at 21:14synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000318113.03.2025 at 12:13synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000319108.03.2025 at 23:58synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000320126.03.2025 at 23:19synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000321131.03.2025 at 06:08synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900008105.04.2025 at 04:15synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900009116.03.2025 at 22:57synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900010101.03.2025 at 22:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900011104.04.2025 at 22:31synthetic/v1In orderhours
  • Medium mediumMaterial price increaseR34 381,42 €

    Quoted items on JOB-0022 exceeded the quote basis: 4 381,42 € 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-000189105.03.2025 at 12:35synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000190123.03.2025 at 02:19synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000191105.04.2025 at 07:12synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000192113.04.2025 at 04:58synthetic/v1In orderunitCost