JOB-0042Kaskinen Metalli Oy
Customer CUS-002 · Completed · opened 08.06.2025 at 16:47 · completed 16.06.2025 at 16:47
Work centres: CNC-1, WELD-1
No blocking findings: the margin is reportable.
Quote basis and actual
| Item | Quote basis | Actual |
|---|---|---|
| Revenue (allocated) | 21 582,56 € | 21 081,84 € |
| Material | 7 468,44 € | 7 148,79 € |
| Labour | 106,68 h × 64,41 €/h | 5 496,77 € |
| Subcontract | 0,00 € | 0,00 € |
| Other variable costs | 0,00 € | 229,79 € |
| Margin | — | 8 206,49 € |
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 1aa016070968
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−500,72 €
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 Invoice line invoice_line invoicing IL-000256 1 04.04.2026 at 21:31 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000257 1 05.03.2026 at 11:58 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000258 1 10.05.2026 at 21:24 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000259 1 23.09.2025 at 05:24 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000260 1 25.08.2025 at 13:09 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000261 1 17.10.2025 at 14:10 synthetic/v1 In order — Credit line credit_line invoicing CR-00029 1 20.05.2026 at 16:13 synthetic/v1 In order — - 2Material quantity differencematerial_quantity_varianceCausal+161,76 €
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-000343 1 09.06.2025 at 02:08 synthetic/v1 In order qty Material consumption material_consumption erp MC-000344 1 14.06.2025 at 15:02 synthetic/v1 In order qty Material consumption material_consumption erp MC-000345 1 15.06.2025 at 19:10 synthetic/v1 In order qty Material consumption material_consumption erp MC-000346 1 09.06.2025 at 02:23 synthetic/v1 In order qty Material consumption material_consumption erp MC-000347 1 10.06.2025 at 11:26 synthetic/v1 In order qty Material consumption material_consumption erp MC-000348 1 13.06.2025 at 04:41 synthetic/v1 In order qty Material consumption material_consumption erp MC-000349 1 10.06.2025 at 15:30 synthetic/v1 In order qty Material consumption material_consumption erp MC-000350 1 09.06.2025 at 16:27 synthetic/v1 In order qty Material consumption material_consumption erp MC-000351 1 12.06.2025 at 20:56 synthetic/v1 In order qty Material consumption material_consumption erp MC-000352 1 16.06.2025 at 12:09 synthetic/v1 In order qty - 3Material price differencematerial_price_varianceCausal+157,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-000343 1 09.06.2025 at 02:08 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000344 1 14.06.2025 at 15:02 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000345 1 15.06.2025 at 19:10 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000346 1 09.06.2025 at 02:23 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000347 1 10.06.2025 at 11:26 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000348 1 13.06.2025 at 04:41 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000349 1 10.06.2025 at 15:30 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000350 1 09.06.2025 at 16:27 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000351 1 12.06.2025 at 20:56 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000352 1 16.06.2025 at 12:09 synthetic/v1 In order unitCost - 4Labour hours differencelabour_hours_varianceCausal+1 374,51 €
Evidence (16 rows · Causal reference: 16)
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-000614 1 11.06.2025 at 23:51 synthetic/v1 In order hours Time entry time_entry timeclock TE-000615 1 13.06.2025 at 07:05 synthetic/v1 In order hours Time entry time_entry timeclock TE-000616 1 10.06.2025 at 05:42 synthetic/v1 In order hours Time entry time_entry timeclock TE-000617 1 12.06.2025 at 04:56 synthetic/v1 In order hours Time entry time_entry timeclock TE-000618 1 15.06.2025 at 09:17 synthetic/v1 In order hours Time entry time_entry timeclock TE-000619 1 15.06.2025 at 04:27 synthetic/v1 In order hours Time entry time_entry timeclock TE-000620 1 14.06.2025 at 10:38 synthetic/v1 In order hours Time entry time_entry timeclock TE-000621 1 10.06.2025 at 23:13 synthetic/v1 In order hours Time entry time_entry timeclock TE-000622 1 09.06.2025 at 00:59 synthetic/v1 In order hours Time entry time_entry timeclock TE-000623 1 11.06.2025 at 18:00 synthetic/v1 In order hours Time entry time_entry timeclock TE-000624 1 08.06.2025 at 19:03 synthetic/v1 In order hours Time entry time_entry timeclock TE-000625 1 15.06.2025 at 17:31 synthetic/v1 In order hours Time entry time_entry timeclock TE-000626 1 14.06.2025 at 22:20 synthetic/v1 In order hours Time entry time_entry timeclock TE-000627 1 11.06.2025 at 19:04 synthetic/v1 In order hours Time entry time_entry timeclock TE-000628 1 14.06.2025 at 23:02 synthetic/v1 In order hours Time entry time_entry timeclock TE-000629 1 12.06.2025 at 17:15 synthetic/v1 In order hours - 5Labour rate differencelabour_rate_varianceCausal−0,02 €
Evidence (16 rows · Causal reference: 16)
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-000614 1 11.06.2025 at 23:51 synthetic/v1 In order rate Time entry time_entry timeclock TE-000615 1 13.06.2025 at 07:05 synthetic/v1 In order rate Time entry time_entry timeclock TE-000616 1 10.06.2025 at 05:42 synthetic/v1 In order rate Time entry time_entry timeclock TE-000617 1 12.06.2025 at 04:56 synthetic/v1 In order rate Time entry time_entry timeclock TE-000618 1 15.06.2025 at 09:17 synthetic/v1 In order rate Time entry time_entry timeclock TE-000619 1 15.06.2025 at 04:27 synthetic/v1 In order rate Time entry time_entry timeclock TE-000620 1 14.06.2025 at 10:38 synthetic/v1 In order rate Time entry time_entry timeclock TE-000621 1 10.06.2025 at 23:13 synthetic/v1 In order rate Time entry time_entry timeclock TE-000622 1 09.06.2025 at 00:59 synthetic/v1 In order rate Time entry time_entry timeclock TE-000623 1 11.06.2025 at 18:00 synthetic/v1 In order rate Time entry time_entry timeclock TE-000624 1 08.06.2025 at 19:03 synthetic/v1 In order rate Time entry time_entry timeclock TE-000625 1 15.06.2025 at 17:31 synthetic/v1 In order rate Time entry time_entry timeclock TE-000626 1 14.06.2025 at 22:20 synthetic/v1 In order rate Time entry time_entry timeclock TE-000627 1 11.06.2025 at 19:04 synthetic/v1 In order rate Time entry time_entry timeclock TE-000628 1 14.06.2025 at 23:02 synthetic/v1 In order rate Time entry time_entry timeclock TE-000629 1 12.06.2025 at 17:15 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−229,79 €
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-900000 1 14.06.2025 at 21:55 synthetic/v1 In order —
- Unattributed cost1 cost row(s) on JOB-0042 worth 229,79 € point at operations no operation of this job carries, so no driver can place them (rows OVC-900000)
- Unexplained−229,79 € of the difference between the estimated and the actual margin of JOB-0042 is placed by no driver, above the 105,41 € tolerance: the job does not reconcile
The stored note
tolerance 10541 minor units; kohdistamaton_kustannus: 1 cost row(s) on JOB-0042 worth 229,79 € point at operations no operation of this job carries, so no driver can place them (rows OVC-900000) | selittamaton: −229,79 € of the difference between the estimated and the actual margin of JOB-0042 is placed by no driver, above the 105,41 € 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-900000 v1
Findings (1)Margin 8 206,49 € · 38,93 %
- Medium mediumUnreconciled differenceR8229,79 €
229,79 € of the difference between the estimated and the actual margin of JOB-0042 is placed by no driver, above the tolerance.
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 (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-900000 1 14.06.2025 at 21:55 synthetic/v1 In order —