← Exception queue

JOB-0047Kvarts Metalli Oy

Customer CUS-007 · Completed · opened 31.07.2025 at 06:22 · completed 06.09.2025 at 06:22

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

926,68 €
14,46 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)6 461,21 €6 408,87 €
Material3 166,84 €2 905,62 €
Labour25,56 h × 64,45 €/h2 092,04 €
Subcontract0,00 €0,00 €
Other variable costs484,53 €484,53 €
Margin926,68 €

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 72ac05cf91c2

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−52,34 €
    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-000286114.03.2026 at 01:02synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000287124.01.2026 at 22:58synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000288120.03.2026 at 13:19synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000289124.04.2026 at 00:37synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000290126.07.2026 at 18:09synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000291107.09.2026 at 23:56synthetic/v1In order
    Credit line credit_lineinvoicingCR-00033104.09.2026 at 10:05synthetic/v1In order
  • 2Material quantity differencematerial_quantity_varianceCausal+203,17 €
    Evidence (8 rows · Causal reference: 8)
    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-000387113.08.2025 at 21:09synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000388105.08.2025 at 00:03synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000389104.08.2025 at 23:35synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000390130.08.2025 at 14:17synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000391109.08.2025 at 00:24synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000392102.08.2025 at 19:15synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000393116.08.2025 at 18:34synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000394131.07.2025 at 23:13synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal+58,05 €
    Evidence (8 rows · Causal reference: 8)
    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-000387113.08.2025 at 21:09synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000388105.08.2025 at 00:03synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000389104.08.2025 at 23:35synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000390130.08.2025 at 14:17synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000391109.08.2025 at 00:24synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000392102.08.2025 at 19:15synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000393116.08.2025 at 18:34synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000394131.07.2025 at 23:13synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal−444,71 €
    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-000691108.08.2025 at 21:20synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000692117.08.2025 at 20:24synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000693105.09.2025 at 06:00synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000694103.09.2025 at 09:40synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000695112.08.2025 at 07:47synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000696115.08.2025 at 07:51synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000697102.08.2025 at 22:33synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000698106.08.2025 at 17:49synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000699122.08.2025 at 03:48synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000700105.09.2025 at 04:18synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000701129.08.2025 at 09:41synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000702120.08.2025 at 11:36synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000703131.08.2025 at 03:33synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900066118.08.2025 at 05:47synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900067103.08.2025 at 11:53synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900068119.08.2025 at 09:41synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900069114.08.2025 at 11:56synthetic/v1In orderhours
  • 5Labour rate differencelabour_rate_varianceCausal+0,01 €
    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-000691108.08.2025 at 21:20synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000692117.08.2025 at 20:24synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000693105.09.2025 at 06:00synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000694103.09.2025 at 09:40synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000695112.08.2025 at 07:47synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000696115.08.2025 at 07:51synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000697102.08.2025 at 22:33synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000698106.08.2025 at 17:49synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000699122.08.2025 at 03:48synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000700105.09.2025 at 04:18synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000701129.08.2025 at 09:41synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000702120.08.2025 at 11:36synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000703131.08.2025 at 03:33synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900066118.08.2025 at 05:47synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900067103.08.2025 at 11:53synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900068119.08.2025 at 09:41synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-900069114.08.2025 at 11: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 50,00 €
  • ReconcilesJOB-0047 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 50,00 €)
The stored note

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

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 926,68 € · 14,46 %

  • Medium mediumLabour hours overrunR2444,71 €

    Quoted-scope labour on JOB-0047 exceeds the allowed factor: 444,71 € 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-000691108.08.2025 at 21:20synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000692117.08.2025 at 20:24synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000693105.09.2025 at 06:00synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000694103.09.2025 at 09:40synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000695112.08.2025 at 07:47synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000696115.08.2025 at 07:51synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000697102.08.2025 at 22:33synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000698106.08.2025 at 17:49synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000699122.08.2025 at 03:48synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000700105.09.2025 at 04:18synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000701129.08.2025 at 09:41synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000702120.08.2025 at 11:36synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000703131.08.2025 at 03:33synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900066118.08.2025 at 05:47synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900067103.08.2025 at 11:53synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900068119.08.2025 at 09:41synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-900069114.08.2025 at 11:56synthetic/v1In orderhours