← Exception queue

JOB-0038Ilves Telakka Oy

Customer CUS-038 · Completed · opened 23.05.2025 at 21:01 · completed 16.07.2025 at 21:01

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

16 060,33 €
35,54 %
In order

No blocking findings: the margin is reportable.

Quote basis and actual

ItemQuote basisActual
Revenue (allocated)45 715,80 €45 194,64 €
Material14 422,41 €13 769,69 €
Labour317,13 h × 43,66 €/h13 707,49 €
Subcontract0,00 €0,00 €
Other variable costs1 657,13 €1 657,13 €
Margin16 060,33 €

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 562fead89d34

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−521,16 €
    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-000232105.01.2026 at 02:31synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000233126.03.2026 at 21:13synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000234118.05.2026 at 11:20synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000235126.07.2025 at 02:48synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000236117.03.2026 at 11:54synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000237130.11.2025 at 09:15synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000238107.12.2025 at 11:30synthetic/v1In order
    Invoice line invoice_lineinvoicingIL-000239102.11.2025 at 22:40synthetic/v1In order
    Credit line credit_lineinvoicingCR-00027125.11.2025 at 08:26synthetic/v1In order
  • 2Material quantity differencematerial_quantity_varianceCausal+320,11 €
    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-000314117.06.2025 at 21:29synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000315119.06.2025 at 17:39synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000316121.06.2025 at 21:47synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000317130.06.2025 at 02:10synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000318105.06.2025 at 00:31synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000319113.06.2025 at 17:14synthetic/v1In orderqty
    Material consumption material_consumptionerpMC-000320109.07.2025 at 12:28synthetic/v1In orderqty
  • 3Material price differencematerial_price_varianceCausal+332,61 €
    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-000314117.06.2025 at 21:29synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000315119.06.2025 at 17:39synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000316121.06.2025 at 21:47synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000317130.06.2025 at 02:10synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000318105.06.2025 at 00:31synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000319113.06.2025 at 17:14synthetic/v1In orderunitCost
    Material consumption material_consumptionerpMC-000320109.07.2025 at 12:28synthetic/v1In orderunitCost
  • 4Labour hours differencelabour_hours_varianceCausal+138,40 €
    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-000554109.06.2025 at 06:26synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000555114.07.2025 at 20:46synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000556123.06.2025 at 18:53synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000557123.06.2025 at 02:41synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000558103.06.2025 at 02:36synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000559115.07.2025 at 21:52synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000560116.06.2025 at 22:26synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000561104.07.2025 at 14:31synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000562105.06.2025 at 17:51synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000563123.06.2025 at 06:25synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000564120.06.2025 at 16:22synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000565124.06.2025 at 05:56synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000566130.05.2025 at 20:55synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000567111.07.2025 at 21:26synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000568116.07.2025 at 12:33synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000569121.06.2025 at 08:14synthetic/v1In orderhours
    Time entry time_entrytimeclockTE-000570119.06.2025 at 07:33synthetic/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-000554109.06.2025 at 06:26synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000555114.07.2025 at 20:46synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000556123.06.2025 at 18:53synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000557123.06.2025 at 02:41synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000558103.06.2025 at 02:36synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000559115.07.2025 at 21:52synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000560116.06.2025 at 22:26synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000561104.07.2025 at 14:31synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000562105.06.2025 at 17:51synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000563123.06.2025 at 06:25synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000564120.06.2025 at 16:22synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000565124.06.2025 at 05:56synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000566130.05.2025 at 20:55synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000567111.07.2025 at 21:26synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000568116.07.2025 at 12:33synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000569121.06.2025 at 08:14synthetic/v1In orderrate
    Time entry time_entrytimeclockTE-000570119.06.2025 at 07:33synthetic/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 225,97 €
  • ReconcilesJOB-0038 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 225,97 €)
The stored note

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

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 16 060,33 € · 35,54 %

  • Medium mediumUnallocated creditR71 801,20 €

    1 801,20 € of credits carry no job allocation, so no job's revenue is reduced by them.

    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 (1 rows · Causal reference: 1)
    Causal referenceThe rows that produced the amount

    These rows produced the amount: every figure is computed from these rows.

    TableSourceRowVersionTime (UTC)MappingQualityField
    Credit line credit_lineinvoicingCR-900001126.10.2025 at 07:39synthetic/v1In orderjobId