JOB-0061Aurora Energia Oy
Customer CUS-021 · Completed · opened 31.10.2025 at 18:49 · completed 17.12.2025 at 18:49
Work centres: CNC-1, CNC-2
No blocking findings: the margin is reportable.
Quote basis and actual
| Item | Quote basis | Actual |
|---|---|---|
| Revenue (allocated) | 39 159,73 € | 38 807,29 € |
| Material | 13 645,32 € | 14 518,37 € |
| Labour | 286,00 h × 42,94 €/h | 11 912,42 € |
| Subcontract | 2 835,50 € | 2 835,50 € |
| Other variable costs | 1 045,23 € | 1 045,23 € |
| Margin | — | 8 495,77 € |
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 bedc2c1a9ac7
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−352,44 €
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-000368 1 10.06.2026 at 19:39 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000369 1 16.02.2026 at 14:24 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000370 1 02.09.2026 at 17:59 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000371 1 19.07.2026 at 12:06 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000372 1 04.05.2026 at 21:08 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000373 1 18.01.2026 at 20:55 synthetic/v1 In order — Invoice line invoice_line invoicing IL-000374 1 13.07.2026 at 09:50 synthetic/v1 In order — Credit line credit_line invoicing CR-00047 1 20.01.2026 at 06:30 synthetic/v1 In order — - 2Material quantity differencematerial_quantity_varianceCausal+1 074,56 €
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-000501 1 06.12.2025 at 22:45 synthetic/v1 In order qty Material consumption material_consumption erp MC-000502 1 22.11.2025 at 22:12 synthetic/v1 In order qty Material consumption material_consumption erp MC-000503 1 12.11.2025 at 05:37 synthetic/v1 In order qty Material consumption material_consumption erp MC-000504 1 26.11.2025 at 16:24 synthetic/v1 In order qty Material consumption material_consumption erp MC-000505 1 13.11.2025 at 01:59 synthetic/v1 In order qty Material consumption material_consumption erp MC-000506 1 08.12.2025 at 03:23 synthetic/v1 In order qty Material consumption material_consumption erp MC-000507 1 12.12.2025 at 11:31 synthetic/v1 In order qty Material consumption material_consumption erp MC-000508 1 03.11.2025 at 23:03 synthetic/v1 In order qty Material consumption material_consumption erp MC-000509 1 10.11.2025 at 06:48 synthetic/v1 In order qty Material consumption material_consumption erp MC-000510 1 02.12.2025 at 10:52 synthetic/v1 In order qty - 3Material price differencematerial_price_varianceCausal−1 947,61 €
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-000501 1 06.12.2025 at 22:45 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000502 1 22.11.2025 at 22:12 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000503 1 12.11.2025 at 05:37 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000504 1 26.11.2025 at 16:24 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000505 1 13.11.2025 at 01:59 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000506 1 08.12.2025 at 03:23 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000507 1 12.12.2025 at 11:31 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000508 1 03.11.2025 at 23:03 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000509 1 10.11.2025 at 06:48 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000510 1 02.12.2025 at 10:52 synthetic/v1 In order unitCost - 4Labour hours differencelabour_hours_varianceCausal+368,43 €
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-000898 1 23.11.2025 at 01:22 synthetic/v1 In order hours Time entry time_entry timeclock TE-000899 1 23.11.2025 at 18:12 synthetic/v1 In order hours Time entry time_entry timeclock TE-000900 1 27.11.2025 at 07:37 synthetic/v1 In order hours Time entry time_entry timeclock TE-000901 1 28.11.2025 at 22:35 synthetic/v1 In order hours Time entry time_entry timeclock TE-000902 1 25.11.2025 at 20:40 synthetic/v1 In order hours Time entry time_entry timeclock TE-000903 1 05.11.2025 at 09:37 synthetic/v1 In order hours Time entry time_entry timeclock TE-000904 1 12.12.2025 at 19:21 synthetic/v1 In order hours Time entry time_entry timeclock TE-000905 1 25.11.2025 at 05:34 synthetic/v1 In order hours Time entry time_entry timeclock TE-000906 1 16.11.2025 at 18:51 synthetic/v1 In order hours Time entry time_entry timeclock TE-000907 1 12.12.2025 at 08:31 synthetic/v1 In order hours Time entry time_entry timeclock TE-000908 1 22.11.2025 at 13:57 synthetic/v1 In order hours Time entry time_entry timeclock TE-000909 1 09.12.2025 at 12:57 synthetic/v1 In order hours Time entry time_entry timeclock TE-000910 1 04.11.2025 at 19:46 synthetic/v1 In order hours Time entry time_entry timeclock TE-000911 1 27.11.2025 at 02:47 synthetic/v1 In order hours Time entry time_entry timeclock TE-000912 1 02.12.2025 at 18:35 synthetic/v1 In order hours Time entry time_entry timeclock TE-000913 1 11.11.2025 at 20:33 synthetic/v1 In order hours Time entry time_entry timeclock TE-000914 1 27.11.2025 at 19:18 synthetic/v1 In order hours Time entry time_entry timeclock TE-000915 1 05.11.2025 at 16:49 synthetic/v1 In order hours - 5Labour rate differencelabour_rate_varianceCausal−0,01 €
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-000898 1 23.11.2025 at 01:22 synthetic/v1 In order rate Time entry time_entry timeclock TE-000899 1 23.11.2025 at 18:12 synthetic/v1 In order rate Time entry time_entry timeclock TE-000900 1 27.11.2025 at 07:37 synthetic/v1 In order rate Time entry time_entry timeclock TE-000901 1 28.11.2025 at 22:35 synthetic/v1 In order rate Time entry time_entry timeclock TE-000902 1 25.11.2025 at 20:40 synthetic/v1 In order rate Time entry time_entry timeclock TE-000903 1 05.11.2025 at 09:37 synthetic/v1 In order rate Time entry time_entry timeclock TE-000904 1 12.12.2025 at 19:21 synthetic/v1 In order rate Time entry time_entry timeclock TE-000905 1 25.11.2025 at 05:34 synthetic/v1 In order rate Time entry time_entry timeclock TE-000906 1 16.11.2025 at 18:51 synthetic/v1 In order rate Time entry time_entry timeclock TE-000907 1 12.12.2025 at 08:31 synthetic/v1 In order rate Time entry time_entry timeclock TE-000908 1 22.11.2025 at 13:57 synthetic/v1 In order rate Time entry time_entry timeclock TE-000909 1 09.12.2025 at 12:57 synthetic/v1 In order rate Time entry time_entry timeclock TE-000910 1 04.11.2025 at 19:46 synthetic/v1 In order rate Time entry time_entry timeclock TE-000911 1 27.11.2025 at 02:47 synthetic/v1 In order rate Time entry time_entry timeclock TE-000912 1 02.12.2025 at 18:35 synthetic/v1 In order rate Time entry time_entry timeclock TE-000913 1 11.11.2025 at 20:33 synthetic/v1 In order rate Time entry time_entry timeclock TE-000914 1 27.11.2025 at 19:18 synthetic/v1 In order rate Time entry time_entry timeclock TE-000915 1 05.11.2025 at 16:49 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-0061 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 194,04 €)
The stored note
tolerance 19404 minor units; tasmaa: JOB-0061 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 194,04 €)
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 8 495,77 € · 21,89 %
- Medium mediumMaterial price increaseR31 424,95 €
Quoted items on JOB-0061 exceeded the quote basis: 1 424,95 € above the quote basis.
The job is in order · work centres CNC-1, CNC-2 · version job-margin-rules/2026-09-20.1 · computed 21.09.2026 at 14:48
Evidence (2 rows · Causal reference: 2)
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-000509 1 10.11.2025 at 06:48 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000510 1 02.12.2025 at 10:52 synthetic/v1 In order unitCost