JOB-0028Ilves Energia Oy
Customer CUS-028 · Completed · opened 10.03.2025 at 11:34 · completed 08.04.2025 at 11:34
Work centres: CNC-1, CNC-2, WELD-1
No blocking findings: the margin is reportable.
Quote basis and actual
| Item | Quote basis | Actual |
|---|---|---|
| Revenue (allocated) | 50 720,13 € | 50 081,06 € |
| Material | 19 811,57 € | 18 852,71 € |
| Labour | 232,29 h × 70,79 €/h | 14 470,89 € |
| Subcontract | 0,00 € | 0,00 € |
| Other variable costs | 0,00 € | 0,00 € |
| Margin | — | 16 757,46 € |
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 cac45f894968
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−639,07 €
Evidence (8 rows · Causal reference: 8)
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-000170 1 20.11.2025 at 08:42 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000171 1 18.01.2026 at 18:04 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000172 1 02.05.2026 at 02:16 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000173 1 17.04.2026 at 06:37 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000174 1 15.07.2025 at 22:00 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000175 1 03.12.2025 at 02:33 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000176 1 05.01.2026 at 05:01 synthetic/v1 In order — Credit line credit_line invoicing CR-00022 1 14.05.2025 at 03:49 synthetic/v1 In order — - 2Material quantity differencematerial_quantity_varianceCausal+141,89 €
Evidence (10 rows · Causal reference: 10)
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-000234 1 19.03.2025 at 15:42 synthetic/v1 In order qty Material consumption material_consumption erp MC-000235 1 03.04.2025 at 22:39 synthetic/v1 In order qty Material consumption material_consumption erp MC-000236 1 24.03.2025 at 12:01 synthetic/v1 In order qty Material consumption material_consumption erp MC-000237 1 22.03.2025 at 23:30 synthetic/v1 In order qty Material consumption material_consumption erp MC-000238 1 13.03.2025 at 23:52 synthetic/v1 In order qty Material consumption material_consumption erp MC-000239 1 10.03.2025 at 16:29 synthetic/v1 In order qty Material consumption material_consumption erp MC-000240 1 15.03.2025 at 13:07 synthetic/v1 In order qty Material consumption material_consumption erp MC-000241 1 13.03.2025 at 18:07 synthetic/v1 In order qty Material consumption material_consumption erp MC-000242 1 16.03.2025 at 06:34 synthetic/v1 In order qty Material consumption material_consumption erp MC-000243 1 27.03.2025 at 16:13 synthetic/v1 In order qty - 3Material price differencematerial_price_varianceCausal+816,97 €
Evidence (10 rows · Causal reference: 10)
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-000234 1 19.03.2025 at 15:42 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000235 1 03.04.2025 at 22:39 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000236 1 24.03.2025 at 12:01 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000237 1 22.03.2025 at 23:30 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000238 1 13.03.2025 at 23:52 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000239 1 10.03.2025 at 16:29 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000240 1 15.03.2025 at 13:07 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000241 1 13.03.2025 at 18:07 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000242 1 16.03.2025 at 06:34 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000243 1 27.03.2025 at 16:13 synthetic/v1 In order unitCost - 4Labour hours differencelabour_hours_varianceCausal+1 972,92 €
Evidence (18 rows · Causal reference: 18)
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-000401 1 16.03.2025 at 14:54 synthetic/v1 In order hours Time entry time_entry timeclock TE-000402 1 29.03.2025 at 03:07 synthetic/v1 In order hours Time entry time_entry timeclock TE-000403 1 27.03.2025 at 01:25 synthetic/v1 In order hours Time entry time_entry timeclock TE-000404 1 25.03.2025 at 22:01 synthetic/v1 In order hours Time entry time_entry timeclock TE-000405 1 17.03.2025 at 22:27 synthetic/v1 In order hours Time entry time_entry timeclock TE-000406 1 25.03.2025 at 23:15 synthetic/v1 In order hours Time entry time_entry timeclock TE-000407 1 17.03.2025 at 06:38 synthetic/v1 In order hours Time entry time_entry timeclock TE-000408 1 01.04.2025 at 15:26 synthetic/v1 In order hours Time entry time_entry timeclock TE-000409 1 25.03.2025 at 09:46 synthetic/v1 In order hours Time entry time_entry timeclock TE-000410 1 20.03.2025 at 09:13 synthetic/v1 In order hours Time entry time_entry timeclock TE-000411 1 22.03.2025 at 16:17 synthetic/v1 In order hours Time entry time_entry timeclock TE-000412 1 06.04.2025 at 12:09 synthetic/v1 In order hours Time entry time_entry timeclock TE-000413 1 03.04.2025 at 15:02 synthetic/v1 In order hours Time entry time_entry timeclock TE-000414 1 14.03.2025 at 12:56 synthetic/v1 In order hours Time entry time_entry timeclock TE-000415 1 29.03.2025 at 14:17 synthetic/v1 In order hours Time entry time_entry timeclock TE-000416 1 02.04.2025 at 13:32 synthetic/v1 In order hours Time entry time_entry timeclock TE-000417 1 13.03.2025 at 17:31 synthetic/v1 In order hours Time entry time_entry timeclock TE-000418 1 28.03.2025 at 08:46 synthetic/v1 In order hours - 5Labour rate differencelabour_rate_varianceNo claim0,00 €
No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.
- 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.
- ReconcilesJOB-0028 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 250,41 €)
The stored note
tolerance 25041 minor units; tasmaa: JOB-0028 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 250,41 €)
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 757,46 € · 33,46 %
- Medium mediumUnallocated labourR4310,78 €
Labour attributed to JOB-0028 by its operation carries no job allocation: 310,78 € at the posted rates.
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 (5 rows · Causal reference: 5)
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-900036 1 25.03.2025 at 09:02 synthetic/v1 In order hours Time entry time_entry timeclock TE-900037 1 20.03.2025 at 00:30 synthetic/v1 In order hours Time entry time_entry timeclock TE-900038 1 18.03.2025 at 13:24 synthetic/v1 In order hours Time entry time_entry timeclock TE-900039 1 17.03.2025 at 22:11 synthetic/v1 In order hours Time entry time_entry timeclock TE-900040 1 21.03.2025 at 22:42 synthetic/v1 In order hours