JOB-0018Ilves Kone Oy
Customer CUS-018 · Completed · opened 23.01.2025 at 12:08 · completed 17.02.2025 at 12:08
Work centres: CNC-1, WELD-1
No blocking findings: the margin is reportable.
Quote basis and actual
| Item | Quote basis | Actual |
|---|---|---|
| Revenue (allocated) | 20 879,58 € | 20 411,88 € |
| Material | 7 102,13 € | 6 716,34 € |
| Labour | 80,60 h × 66,97 €/h | 5 213,64 € |
| Subcontract | 0,00 € | 0,00 € |
| Other variable costs | 624,28 € | 624,28 € |
| Margin | — | 7 857,62 € |
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 f7e505b6a00f
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−467,70 €
Evidence (9 rows · Causal reference: 9)
Causal referenceThe rows that produced the amountThese rows produced the amount: every figure is computed from these rows.
Table Source Row Version Time (UTC) Mapping Quality Field Invoice line invoice_line invoicing IL-000103 1 19.01.2026 at 18:33 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000104 1 31.12.2025 at 05:04 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000105 1 06.04.2026 at 11:14 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000106 1 23.12.2025 at 21:44 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000107 1 15.05.2026 at 05:44 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000108 1 28.02.2026 at 23:27 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000109 1 02.03.2026 at 07:49 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000110 1 22.02.2025 at 12:56 synthetic/v1 In order — Credit line credit_line invoicing CR-00014 1 28.12.2025 at 21:01 synthetic/v1 In order — - 2Material quantity differencematerial_quantity_varianceCausal+578,06 €
Evidence (6 rows · Causal reference: 6)
Causal referenceThe rows that produced the amountThese rows produced the amount: every figure is computed from these rows.
Table Source Row Version Time (UTC) Mapping Quality Field Material consumption material_consumption erp MC-000153 1 27.01.2025 at 22:45 synthetic/v1 In order qty Material consumption material_consumption erp MC-000154 1 27.01.2025 at 23:56 synthetic/v1 In order qty Material consumption material_consumption erp MC-000155 1 26.01.2025 at 20:55 synthetic/v1 In order qty Material consumption material_consumption erp MC-000156 1 02.02.2025 at 00:02 synthetic/v1 In order qty Material consumption material_consumption erp MC-000157 1 08.02.2025 at 06:01 synthetic/v1 In order qty Material consumption material_consumption erp MC-000158 1 28.01.2025 at 05:46 synthetic/v1 In order qty - 3Material price differencematerial_price_varianceCausal+80,84 €
Evidence (6 rows · Causal reference: 6)
Causal referenceThe rows that produced the amountThese rows produced the amount: every figure is computed from these rows.
Table Source Row Version Time (UTC) Mapping Quality Field Material consumption material_consumption erp MC-000153 1 27.01.2025 at 22:45 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000154 1 27.01.2025 at 23:56 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000155 1 26.01.2025 at 20:55 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000156 1 02.02.2025 at 00:02 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000157 1 08.02.2025 at 06:01 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000158 1 28.01.2025 at 05:46 synthetic/v1 In order unitCost - 4Labour hours differencelabour_hours_varianceCausal+594,02 €
Evidence (15 rows · Causal reference: 15)
Causal referenceThe rows that produced the amountThese rows produced the amount: every figure is computed from these rows.
Table Source Row Version Time (UTC) Mapping Quality Field Time entry time_entry timeclock TE-000246 1 30.01.2025 at 22:27 synthetic/v1 In order hours Time entry time_entry timeclock TE-000247 1 10.02.2025 at 14:15 synthetic/v1 In order hours Time entry time_entry timeclock TE-000248 1 27.01.2025 at 04:58 synthetic/v1 In order hours Time entry time_entry timeclock TE-000249 1 31.01.2025 at 10:08 synthetic/v1 In order hours Time entry time_entry timeclock TE-000250 1 10.02.2025 at 08:09 synthetic/v1 In order hours Time entry time_entry timeclock TE-000251 1 27.01.2025 at 19:10 synthetic/v1 In order hours Time entry time_entry timeclock TE-000252 1 11.02.2025 at 11:51 synthetic/v1 In order hours Time entry time_entry timeclock TE-000253 1 25.01.2025 at 13:20 synthetic/v1 In order hours Time entry time_entry timeclock TE-000254 1 08.02.2025 at 16:12 synthetic/v1 In order hours Time entry time_entry timeclock TE-000255 1 26.01.2025 at 03:25 synthetic/v1 In order hours Time entry time_entry timeclock TE-000256 1 13.02.2025 at 09:40 synthetic/v1 In order hours Time entry time_entry timeclock TE-000257 1 17.02.2025 at 08:16 synthetic/v1 In order hours Time entry time_entry timeclock TE-000258 1 17.02.2025 at 07:49 synthetic/v1 In order hours Time entry time_entry timeclock TE-000259 1 04.02.2025 at 04:04 synthetic/v1 In order hours Time entry time_entry timeclock TE-000260 1 13.02.2025 at 17:46 synthetic/v1 In order hours - 5Labour rate differencelabour_rate_varianceCausal−0,02 €
Evidence (15 rows · Causal reference: 15)
Causal referenceThe rows that produced the amountThese rows produced the amount: every figure is computed from these rows.
Table Source Row Version Time (UTC) Mapping Quality Field Time entry time_entry timeclock TE-000246 1 30.01.2025 at 22:27 synthetic/v1 In order rate Time entry time_entry timeclock TE-000247 1 10.02.2025 at 14:15 synthetic/v1 In order rate Time entry time_entry timeclock TE-000248 1 27.01.2025 at 04:58 synthetic/v1 In order rate Time entry time_entry timeclock TE-000249 1 31.01.2025 at 10:08 synthetic/v1 In order rate Time entry time_entry timeclock TE-000250 1 10.02.2025 at 08:09 synthetic/v1 In order rate Time entry time_entry timeclock TE-000251 1 27.01.2025 at 19:10 synthetic/v1 In order rate Time entry time_entry timeclock TE-000252 1 11.02.2025 at 11:51 synthetic/v1 In order rate Time entry time_entry timeclock TE-000253 1 25.01.2025 at 13:20 synthetic/v1 In order rate Time entry time_entry timeclock TE-000254 1 08.02.2025 at 16:12 synthetic/v1 In order rate Time entry time_entry timeclock TE-000255 1 26.01.2025 at 03:25 synthetic/v1 In order rate Time entry time_entry timeclock TE-000256 1 13.02.2025 at 09:40 synthetic/v1 In order rate Time entry time_entry timeclock TE-000257 1 17.02.2025 at 08:16 synthetic/v1 In order rate Time entry time_entry timeclock TE-000258 1 17.02.2025 at 07:49 synthetic/v1 In order rate Time entry time_entry timeclock TE-000259 1 04.02.2025 at 04:04 synthetic/v1 In order rate Time entry time_entry timeclock TE-000260 1 13.02.2025 at 17:46 synthetic/v1 In order rate - 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_varianceCausal−682,97 €
Evidence (4 rows · Causal reference: 4)
Causal referenceThe rows that produced the amountThese rows produced the amount: every figure is computed from these rows.
Table Source Row Version Time (UTC) Mapping Quality Field Material consumption material_consumption erp MC-900000 1 12.02.2025 at 01:02 synthetic/v1 In order — Time entry time_entry timeclock TE-900012 1 26.01.2025 at 02:58 synthetic/v1 In order — Time entry time_entry timeclock TE-900013 1 16.02.2025 at 07:35 synthetic/v1 In order — Time entry time_entry timeclock TE-900014 1 30.01.2025 at 15:16 synthetic/v1 In order — - 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.
- ReconcilesJOB-0018 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 102,06 €)
The stored note
tolerance 10206 minor units; tasmaa: JOB-0018 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 102,06 €)
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 7 857,62 € · 38,50 %
- Medium mediumReworkR6682,97 €
682,97 € of work on JOB-0018 was done on operations outside the quoted scope.
The job is in order · work centres CNC-1, 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 amountThese rows produced the amount: every figure is computed from these rows.
Table Source Row Version Time (UTC) Mapping Quality Field Material consumption material_consumption erp MC-900000 1 12.02.2025 at 01:02 synthetic/v1 In order — Time entry time_entry timeclock TE-900012 1 26.01.2025 at 02:58 synthetic/v1 In order — Time entry time_entry timeclock TE-900013 1 16.02.2025 at 07:35 synthetic/v1 In order — Time entry time_entry timeclock TE-900014 1 30.01.2025 at 15:16 synthetic/v1 In order —