JOB-0047Kvarts Metalli Oy
Customer CUS-007 · Completed · opened 31.07.2025 at 06:22 · completed 06.09.2025 at 06:22
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) | 6 461,21 € | 6 408,87 € |
| Material | 3 166,84 € | 2 905,62 € |
| Labour | 25,56 h × 64,45 €/h | 2 092,04 € |
| Subcontract | 0,00 € | 0,00 € |
| Other variable costs | 484,53 € | 484,53 € |
| Margin | — | 926,68 € |
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 72ac05cf91c2
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−52,34 €
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-000286 1 14.03.2026 at 01:02 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000287 1 24.01.2026 at 22:58 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000288 1 20.03.2026 at 13:19 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000289 1 24.04.2026 at 00:37 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000290 1 26.07.2026 at 18:09 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000291 1 07.09.2026 at 23:56 synthetic/v1 In order — Credit line credit_line invoicing CR-00033 1 04.09.2026 at 10:05 synthetic/v1 In order — - 2Material quantity differencematerial_quantity_varianceCausal+203,17 €
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 Material consumption material_consumption erp MC-000387 1 13.08.2025 at 21:09 synthetic/v1 In order qty Material consumption material_consumption erp MC-000388 1 05.08.2025 at 00:03 synthetic/v1 In order qty Material consumption material_consumption erp MC-000389 1 04.08.2025 at 23:35 synthetic/v1 In order qty Material consumption material_consumption erp MC-000390 1 30.08.2025 at 14:17 synthetic/v1 In order qty Material consumption material_consumption erp MC-000391 1 09.08.2025 at 00:24 synthetic/v1 In order qty Material consumption material_consumption erp MC-000392 1 02.08.2025 at 19:15 synthetic/v1 In order qty Material consumption material_consumption erp MC-000393 1 16.08.2025 at 18:34 synthetic/v1 In order qty Material consumption material_consumption erp MC-000394 1 31.07.2025 at 23:13 synthetic/v1 In order qty - 3Material price differencematerial_price_varianceCausal+58,05 €
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 Material consumption material_consumption erp MC-000387 1 13.08.2025 at 21:09 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000388 1 05.08.2025 at 00:03 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000389 1 04.08.2025 at 23:35 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000390 1 30.08.2025 at 14:17 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000391 1 09.08.2025 at 00:24 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000392 1 02.08.2025 at 19:15 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000393 1 16.08.2025 at 18:34 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000394 1 31.07.2025 at 23:13 synthetic/v1 In order unitCost - 4Labour hours differencelabour_hours_varianceCausal−444,71 €
Evidence (17 rows · Causal reference: 17)
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-000691 1 08.08.2025 at 21:20 synthetic/v1 In order hours Time entry time_entry timeclock TE-000692 1 17.08.2025 at 20:24 synthetic/v1 In order hours Time entry time_entry timeclock TE-000693 1 05.09.2025 at 06:00 synthetic/v1 In order hours Time entry time_entry timeclock TE-000694 1 03.09.2025 at 09:40 synthetic/v1 In order hours Time entry time_entry timeclock TE-000695 1 12.08.2025 at 07:47 synthetic/v1 In order hours Time entry time_entry timeclock TE-000696 1 15.08.2025 at 07:51 synthetic/v1 In order hours Time entry time_entry timeclock TE-000697 1 02.08.2025 at 22:33 synthetic/v1 In order hours Time entry time_entry timeclock TE-000698 1 06.08.2025 at 17:49 synthetic/v1 In order hours Time entry time_entry timeclock TE-000699 1 22.08.2025 at 03:48 synthetic/v1 In order hours Time entry time_entry timeclock TE-000700 1 05.09.2025 at 04:18 synthetic/v1 In order hours Time entry time_entry timeclock TE-000701 1 29.08.2025 at 09:41 synthetic/v1 In order hours Time entry time_entry timeclock TE-000702 1 20.08.2025 at 11:36 synthetic/v1 In order hours Time entry time_entry timeclock TE-000703 1 31.08.2025 at 03:33 synthetic/v1 In order hours Time entry time_entry timeclock TE-900066 1 18.08.2025 at 05:47 synthetic/v1 In order hours Time entry time_entry timeclock TE-900067 1 03.08.2025 at 11:53 synthetic/v1 In order hours Time entry time_entry timeclock TE-900068 1 19.08.2025 at 09:41 synthetic/v1 In order hours Time entry time_entry timeclock TE-900069 1 14.08.2025 at 11:56 synthetic/v1 In order hours - 5Labour rate differencelabour_rate_varianceCausal+0,01 €
Evidence (17 rows · Causal reference: 17)
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-000691 1 08.08.2025 at 21:20 synthetic/v1 In order rate Time entry time_entry timeclock TE-000692 1 17.08.2025 at 20:24 synthetic/v1 In order rate Time entry time_entry timeclock TE-000693 1 05.09.2025 at 06:00 synthetic/v1 In order rate Time entry time_entry timeclock TE-000694 1 03.09.2025 at 09:40 synthetic/v1 In order rate Time entry time_entry timeclock TE-000695 1 12.08.2025 at 07:47 synthetic/v1 In order rate Time entry time_entry timeclock TE-000696 1 15.08.2025 at 07:51 synthetic/v1 In order rate Time entry time_entry timeclock TE-000697 1 02.08.2025 at 22:33 synthetic/v1 In order rate Time entry time_entry timeclock TE-000698 1 06.08.2025 at 17:49 synthetic/v1 In order rate Time entry time_entry timeclock TE-000699 1 22.08.2025 at 03:48 synthetic/v1 In order rate Time entry time_entry timeclock TE-000700 1 05.09.2025 at 04:18 synthetic/v1 In order rate Time entry time_entry timeclock TE-000701 1 29.08.2025 at 09:41 synthetic/v1 In order rate Time entry time_entry timeclock TE-000702 1 20.08.2025 at 11:36 synthetic/v1 In order rate Time entry time_entry timeclock TE-000703 1 31.08.2025 at 03:33 synthetic/v1 In order rate Time entry time_entry timeclock TE-900066 1 18.08.2025 at 05:47 synthetic/v1 In order rate Time entry time_entry timeclock TE-900067 1 03.08.2025 at 11:53 synthetic/v1 In order rate Time entry time_entry timeclock TE-900068 1 19.08.2025 at 09:41 synthetic/v1 In order rate Time entry time_entry timeclock TE-900069 1 14.08.2025 at 11:56 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_unexplainedNo claim0,00 €
No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.
- ReconcilesJOB-0047 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 50,00 €)
The stored note
tolerance 5000 minor units; tasmaa: JOB-0047 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 50,00 €)
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 926,68 € · 14,46 %
- Medium mediumLabour hours overrunR2444,71 €
Quoted-scope labour on JOB-0047 exceeds the allowed factor: 444,71 € at the estimated rate.
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 (17 rows · Causal reference: 17)
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-000691 1 08.08.2025 at 21:20 synthetic/v1 In order hours Time entry time_entry timeclock TE-000692 1 17.08.2025 at 20:24 synthetic/v1 In order hours Time entry time_entry timeclock TE-000693 1 05.09.2025 at 06:00 synthetic/v1 In order hours Time entry time_entry timeclock TE-000694 1 03.09.2025 at 09:40 synthetic/v1 In order hours Time entry time_entry timeclock TE-000695 1 12.08.2025 at 07:47 synthetic/v1 In order hours Time entry time_entry timeclock TE-000696 1 15.08.2025 at 07:51 synthetic/v1 In order hours Time entry time_entry timeclock TE-000697 1 02.08.2025 at 22:33 synthetic/v1 In order hours Time entry time_entry timeclock TE-000698 1 06.08.2025 at 17:49 synthetic/v1 In order hours Time entry time_entry timeclock TE-000699 1 22.08.2025 at 03:48 synthetic/v1 In order hours Time entry time_entry timeclock TE-000700 1 05.09.2025 at 04:18 synthetic/v1 In order hours Time entry time_entry timeclock TE-000701 1 29.08.2025 at 09:41 synthetic/v1 In order hours Time entry time_entry timeclock TE-000702 1 20.08.2025 at 11:36 synthetic/v1 In order hours Time entry time_entry timeclock TE-000703 1 31.08.2025 at 03:33 synthetic/v1 In order hours Time entry time_entry timeclock TE-900066 1 18.08.2025 at 05:47 synthetic/v1 In order hours Time entry time_entry timeclock TE-900067 1 03.08.2025 at 11:53 synthetic/v1 In order hours Time entry time_entry timeclock TE-900068 1 19.08.2025 at 09:41 synthetic/v1 In order hours Time entry time_entry timeclock TE-900069 1 14.08.2025 at 11:56 synthetic/v1 In order hours