JOB-0044Helmi Metalli Oy
Customer CUS-004 · Completed · opened 05.06.2025 at 20:09 · completed 19.07.2025 at 20:09
Work centres: CNC-2, WELD-1
No blocking findings: the margin is reportable.
Quote basis and actual
| Item | Quote basis | Actual |
|---|---|---|
| Revenue (allocated) | 15 714,60 € | 15 390,88 € |
| Material | 7 740,50 € | 7 075,17 € |
| Labour | 109,00 h × 39,06 €/h | 3 576,35 € |
| Subcontract | 0,00 € | 0,00 € |
| Other variable costs | 786,44 € | 990,36 € |
| Margin | — | 3 749,00 € |
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 3c632a96e7f2
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−323,72 €
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-000267 1 04.02.2026 at 21:24 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000268 1 06.03.2026 at 15:24 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000269 1 29.07.2026 at 19:24 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000270 1 18.04.2026 at 16:28 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000271 1 25.07.2025 at 23:19 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000272 1 29.08.2026 at 14:48 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000273 1 07.09.2026 at 13:49 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000274 1 19.09.2025 at 22:28 synthetic/v1 In order — Credit line credit_line invoicing CR-00030 1 06.07.2026 at 20:28 synthetic/v1 In order — - 2Material quantity differencematerial_quantity_varianceCausal+452,74 €
Evidence (7 rows · Causal reference: 7)
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-000359 1 16.07.2025 at 09:37 synthetic/v1 In order qty Material consumption material_consumption erp MC-000360 1 07.06.2025 at 06:35 synthetic/v1 In order qty Material consumption material_consumption erp MC-000361 1 12.07.2025 at 08:54 synthetic/v1 In order qty Material consumption material_consumption erp MC-000362 1 12.07.2025 at 21:54 synthetic/v1 In order qty Material consumption material_consumption erp MC-000363 1 25.06.2025 at 14:41 synthetic/v1 In order qty Material consumption material_consumption erp MC-000364 1 07.07.2025 at 23:29 synthetic/v1 In order qty Material consumption material_consumption erp MC-000365 1 01.07.2025 at 10:56 synthetic/v1 In order qty - 3Material price differencematerial_price_varianceCausal+212,59 €
Evidence (7 rows · Causal reference: 7)
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-000359 1 16.07.2025 at 09:37 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000360 1 07.06.2025 at 06:35 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000361 1 12.07.2025 at 08:54 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000362 1 12.07.2025 at 21:54 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000363 1 25.06.2025 at 14:41 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000364 1 07.07.2025 at 23:29 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000365 1 01.07.2025 at 10:56 synthetic/v1 In order unitCost - 4Labour hours differencelabour_hours_varianceCausal+681,21 €
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-000644 1 18.07.2025 at 12:13 synthetic/v1 In order hours Time entry time_entry timeclock TE-000645 1 13.07.2025 at 11:54 synthetic/v1 In order hours Time entry time_entry timeclock TE-000646 1 08.07.2025 at 02:25 synthetic/v1 In order hours Time entry time_entry timeclock TE-000647 1 17.06.2025 at 17:53 synthetic/v1 In order hours Time entry time_entry timeclock TE-000648 1 08.07.2025 at 01:15 synthetic/v1 In order hours Time entry time_entry timeclock TE-000649 1 16.06.2025 at 07:29 synthetic/v1 In order hours Time entry time_entry timeclock TE-000650 1 06.07.2025 at 14:31 synthetic/v1 In order hours Time entry time_entry timeclock TE-000651 1 21.06.2025 at 08:13 synthetic/v1 In order hours Time entry time_entry timeclock TE-000652 1 06.06.2025 at 03:19 synthetic/v1 In order hours Time entry time_entry timeclock TE-000653 1 26.06.2025 at 06:10 synthetic/v1 In order hours Time entry time_entry timeclock TE-000654 1 10.06.2025 at 19:07 synthetic/v1 In order hours Time entry time_entry timeclock TE-000655 1 13.07.2025 at 22:19 synthetic/v1 In order hours Time entry time_entry timeclock TE-000656 1 16.07.2025 at 21:50 synthetic/v1 In order hours Time entry time_entry timeclock TE-000657 1 16.07.2025 at 18:01 synthetic/v1 In order hours Time entry time_entry timeclock TE-000658 1 14.06.2025 at 03:55 synthetic/v1 In order hours Time entry time_entry timeclock TE-000659 1 23.06.2025 at 21:14 synthetic/v1 In order hours Time entry time_entry timeclock TE-000660 1 27.06.2025 at 10:52 synthetic/v1 In order hours Time entry time_entry timeclock TE-000661 1 30.06.2025 at 20:21 synthetic/v1 In order hours - 5Labour rate differencelabour_rate_varianceCausal−0,02 €
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-000644 1 18.07.2025 at 12:13 synthetic/v1 In order rate Time entry time_entry timeclock TE-000645 1 13.07.2025 at 11:54 synthetic/v1 In order rate Time entry time_entry timeclock TE-000646 1 08.07.2025 at 02:25 synthetic/v1 In order rate Time entry time_entry timeclock TE-000647 1 17.06.2025 at 17:53 synthetic/v1 In order rate Time entry time_entry timeclock TE-000648 1 08.07.2025 at 01:15 synthetic/v1 In order rate Time entry time_entry timeclock TE-000649 1 16.06.2025 at 07:29 synthetic/v1 In order rate Time entry time_entry timeclock TE-000650 1 06.07.2025 at 14:31 synthetic/v1 In order rate Time entry time_entry timeclock TE-000651 1 21.06.2025 at 08:13 synthetic/v1 In order rate Time entry time_entry timeclock TE-000652 1 06.06.2025 at 03:19 synthetic/v1 In order rate Time entry time_entry timeclock TE-000653 1 26.06.2025 at 06:10 synthetic/v1 In order rate Time entry time_entry timeclock TE-000654 1 10.06.2025 at 19:07 synthetic/v1 In order rate Time entry time_entry timeclock TE-000655 1 13.07.2025 at 22:19 synthetic/v1 In order rate Time entry time_entry timeclock TE-000656 1 16.07.2025 at 21:50 synthetic/v1 In order rate Time entry time_entry timeclock TE-000657 1 16.07.2025 at 18:01 synthetic/v1 In order rate Time entry time_entry timeclock TE-000658 1 14.06.2025 at 03:55 synthetic/v1 In order rate Time entry time_entry timeclock TE-000659 1 23.06.2025 at 21:14 synthetic/v1 In order rate Time entry time_entry timeclock TE-000660 1 27.06.2025 at 10:52 synthetic/v1 In order rate Time entry time_entry timeclock TE-000661 1 30.06.2025 at 20:21 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_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_unexplainedCausal−203,92 €
Evidence (1 rows · Causal reference: 1)
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 Other variable cost other_variable_cost erp OVC-900002 1 14.06.2025 at 22:24 synthetic/v1 In order —
- Unattributed cost1 cost row(s) on JOB-0044 worth 203,92 € point at operations no operation of this job carries, so no driver can place them (rows OVC-900002)
- Unexplained−203,92 € of the difference between the estimated and the actual margin of JOB-0044 is placed by no driver, above the 76,95 € tolerance: the job does not reconcile
The stored note
tolerance 7695 minor units; kohdistamaton_kustannus: 1 cost row(s) on JOB-0044 worth 203,92 € point at operations no operation of this job carries, so no driver can place them (rows OVC-900002) | selittamaton: −203,92 € of the difference between the estimated and the actual margin of JOB-0044 is placed by no driver, above the 76,95 € tolerance: the job does not reconcile
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.
Unattributed cost rows
A cost whose operation does not belong to this job: the row is charged to the job, but no driver explains it. The row is named, not placed.
- Unattributed cost rowunmatched_cost_rowother_variable_cost OVC-900002 v1
Findings (1)Margin 3 749,00 € · 24,36 %
- Medium mediumUnreconciled differenceR8203,92 €
203,92 € of the difference between the estimated and the actual margin of JOB-0044 is placed by no driver, above the tolerance.
The job is in order · work centres 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 amountThese rows produced the amount: every figure is computed from these rows.
Table Source Row Version Time (UTC) Mapping Quality Field Other variable cost other_variable_cost erp OVC-900002 1 14.06.2025 at 22:24 synthetic/v1 In order —