← Exception queue

JOB-0054Helmi Kone Oy

Customer CUS-014 · Completed · opened 05.08.2025 at 10:42 · completed 30.08.2025 at 10:42

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

2 941,15 €
13,70 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)21 956,07 €21 466,45 €
Material7 677,44 €7 314,15 €
Labour115,40 h × 65,20 €/h11 211,15 €
Subcontract0,00 €0,00 €
Other variable costs0,00 €0,00 €
Margin2 941,15 €

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 eb081d75fd6c

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−489,62 €
    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-000327104.11.2025 at 05:09synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000328111.04.2026 at 23:55synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000329122.06.2026 at 23:26synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000330104.11.2025 at 07:52synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000331126.10.2025 at 09:19synthetic/v1In order
    Credit line credit_lineinvoicingCR-00040125.02.2026 at 23:18synthetic/v1In order
    Credit line credit_lineinvoicingCR-00041114.06.2026 at 22:11synthetic/v1In order
  • 2Material quantity differencematerial_quantity_varianceCausal+190,42 €
    Evidence (14 rows · Causal reference: 14)
    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-000437113.08.2025 at 08:58synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000438128.08.2025 at 21:12synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000439121.08.2025 at 22:20synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000440109.08.2025 at 06:20synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000441118.08.2025 at 08:04synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000442125.08.2025 at 23:30synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000443116.08.2025 at 02:16synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000444107.08.2025 at 23:07synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000445106.08.2025 at 07:33synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000446112.08.2025 at 11:16synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000447122.08.2025 at 13:54synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000448119.08.2025 at 12:29synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000449126.08.2025 at 10:15synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000450128.08.2025 at 14:42synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal+172,87 €
    Evidence (14 rows · Causal reference: 14)
    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-000437113.08.2025 at 08:58synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000438128.08.2025 at 21:12synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000439121.08.2025 at 22:20synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000440109.08.2025 at 06:20synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000441118.08.2025 at 08:04synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000442125.08.2025 at 23:30synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000443116.08.2025 at 02:16synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000444107.08.2025 at 23:07synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000445106.08.2025 at 07:33synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000446112.08.2025 at 11:16synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000447122.08.2025 at 13:54synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000448119.08.2025 at 12:29synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000449126.08.2025 at 10:15synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000450128.08.2025 at 14:42synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal−3 687,06 €
    Evidence (18 rows · Causal reference: 18)
    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-000794116.08.2025 at 11:09synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000795119.08.2025 at 14:40synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000796126.08.2025 at 23:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000797113.08.2025 at 01:18synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000798129.08.2025 at 23:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000799127.08.2025 at 08:43synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000800129.08.2025 at 19:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000801117.08.2025 at 16:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000802113.08.2025 at 20:05synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000803123.08.2025 at 01:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000804128.08.2025 at 15:05synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000805108.08.2025 at 23:20synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000806110.08.2025 at 11:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000807121.08.2025 at 13:43synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900084114.08.2025 at 00:17synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900085126.08.2025 at 20:43synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900086114.08.2025 at 04:52synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900087114.08.2025 at 06:56synthetic/v1In orderhours
  • 5Labour rate differencelabour_rate_varianceCausal−0,01 €
    Evidence (18 rows · Causal reference: 18)
    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-000794116.08.2025 at 11:09synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000795119.08.2025 at 14:40synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000796126.08.2025 at 23:45synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000797113.08.2025 at 01:18synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000798129.08.2025 at 23:45synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000799127.08.2025 at 08:43synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000800129.08.2025 at 19:06synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000801117.08.2025 at 16:06synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000802113.08.2025 at 20:05synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000803123.08.2025 at 01:35synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000804128.08.2025 at 15:05synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000805108.08.2025 at 23:20synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000806110.08.2025 at 11:45synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000807121.08.2025 at 13:43synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900084114.08.2025 at 00:17synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900085126.08.2025 at 20:43synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900086114.08.2025 at 04:52synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900087114.08.2025 at 06:56synthetic/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 107,33 €
  • ReconcilesJOB-0054 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 107,33 €)
The stored note

tolerance 10733 minor units; tasmaa: JOB-0054 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 107,33 €)

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 2 941,15 € · 13,70 %

  • Medium mediumLabour hours overrunR23 687,06 €

    Quoted-scope labour on JOB-0054 exceeds the allowed factor: 3 687,06 € 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 (18 rows · Causal reference: 18)
    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-000794116.08.2025 at 11:09synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000795119.08.2025 at 14:40synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000796126.08.2025 at 23:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000797113.08.2025 at 01:18synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000798129.08.2025 at 23:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000799127.08.2025 at 08:43synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000800129.08.2025 at 19:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000801117.08.2025 at 16:06synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000802113.08.2025 at 20:05synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000803123.08.2025 at 01:35synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000804128.08.2025 at 15:05synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000805108.08.2025 at 23:20synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000806110.08.2025 at 11:45synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000807121.08.2025 at 13:43synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900084114.08.2025 at 00:17synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900085126.08.2025 at 20:43synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900086114.08.2025 at 04:52synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900087114.08.2025 at 06:56synthetic/v1In orderhours