JOB-0041Aurora Metalli Oy
Customer CUS-001 · Completed · opened 11.06.2025 at 08:53 · completed 06.07.2025 at 08:53
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) | 27 329,33 € | 27 329,33 € |
| Material | 12 771,94 € | 11 994,75 € |
| Labour | 169,39 h × 49,01 €/h | 7 056,44 € |
| Subcontract | 0,00 € | 0,00 € |
| Other variable costs | 471,28 € | 471,28 € |
| Margin | — | 7 806,86 € |
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 ec966a373b92
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_varianceNo claim0,00 €
No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.
- 2Material quantity differencematerial_quantity_varianceCausal+371,52 €
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-000335 1 28.06.2025 at 14:04 synthetic/v1 In order qty Material consumption material_consumption erp MC-000336 1 13.06.2025 at 11:11 synthetic/v1 In order qty Material consumption material_consumption erp MC-000337 1 19.06.2025 at 13:58 synthetic/v1 In order qty Material consumption material_consumption erp MC-000338 1 15.06.2025 at 12:10 synthetic/v1 In order qty Material consumption material_consumption erp MC-000339 1 13.06.2025 at 23:00 synthetic/v1 In order qty Material consumption material_consumption erp MC-000340 1 13.06.2025 at 18:11 synthetic/v1 In order qty Material consumption material_consumption erp MC-000341 1 14.06.2025 at 03:04 synthetic/v1 In order qty Material consumption material_consumption erp MC-000342 1 01.07.2025 at 02:44 synthetic/v1 In order qty - 3Material price differencematerial_price_varianceCausal+405,67 €
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-000335 1 28.06.2025 at 14:04 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000336 1 13.06.2025 at 11:11 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000337 1 19.06.2025 at 13:58 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000338 1 15.06.2025 at 12:10 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000339 1 13.06.2025 at 23:00 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000340 1 13.06.2025 at 18:11 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000341 1 14.06.2025 at 03:04 synthetic/v1 In order unitCost Material consumption material_consumption erp MC-000342 1 01.07.2025 at 02:44 synthetic/v1 In order unitCost - 4Labour hours differencelabour_hours_varianceCausal+1 245,34 €
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-000598 1 24.06.2025 at 01:07 synthetic/v1 In order hours Time entry time_entry timeclock TE-000599 1 22.06.2025 at 23:59 synthetic/v1 In order hours Time entry time_entry timeclock TE-000600 1 21.06.2025 at 19:32 synthetic/v1 In order hours Time entry time_entry timeclock TE-000601 1 01.07.2025 at 18:33 synthetic/v1 In order hours Time entry time_entry timeclock TE-000602 1 01.07.2025 at 15:42 synthetic/v1 In order hours Time entry time_entry timeclock TE-000603 1 02.07.2025 at 10:14 synthetic/v1 In order hours Time entry time_entry timeclock TE-000604 1 27.06.2025 at 23:10 synthetic/v1 In order hours Time entry time_entry timeclock TE-000605 1 01.07.2025 at 11:18 synthetic/v1 In order hours Time entry time_entry timeclock TE-000606 1 30.06.2025 at 14:58 synthetic/v1 In order hours Time entry time_entry timeclock TE-000607 1 19.06.2025 at 16:04 synthetic/v1 In order hours Time entry time_entry timeclock TE-000608 1 20.06.2025 at 00:15 synthetic/v1 In order hours Time entry time_entry timeclock TE-000609 1 03.07.2025 at 03:04 synthetic/v1 In order hours Time entry time_entry timeclock TE-000610 1 28.06.2025 at 11:59 synthetic/v1 In order hours Time entry time_entry timeclock TE-000611 1 24.06.2025 at 05:40 synthetic/v1 In order hours Time entry time_entry timeclock TE-000612 1 01.07.2025 at 23:40 synthetic/v1 In order hours Time entry time_entry timeclock TE-000613 1 12.06.2025 at 15:40 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-000598 1 24.06.2025 at 01:07 synthetic/v1 In order rate Time entry time_entry timeclock TE-000599 1 22.06.2025 at 23:59 synthetic/v1 In order rate Time entry time_entry timeclock TE-000600 1 21.06.2025 at 19:32 synthetic/v1 In order rate Time entry time_entry timeclock TE-000601 1 01.07.2025 at 18:33 synthetic/v1 In order rate Time entry time_entry timeclock TE-000602 1 01.07.2025 at 15:42 synthetic/v1 In order rate Time entry time_entry timeclock TE-000603 1 02.07.2025 at 10:14 synthetic/v1 In order rate Time entry time_entry timeclock TE-000604 1 27.06.2025 at 23:10 synthetic/v1 In order rate Time entry time_entry timeclock TE-000605 1 01.07.2025 at 11:18 synthetic/v1 In order rate Time entry time_entry timeclock TE-000606 1 30.06.2025 at 14:58 synthetic/v1 In order rate Time entry time_entry timeclock TE-000607 1 19.06.2025 at 16:04 synthetic/v1 In order rate Time entry time_entry timeclock TE-000608 1 20.06.2025 at 00:15 synthetic/v1 In order rate Time entry time_entry timeclock TE-000609 1 03.07.2025 at 03:04 synthetic/v1 In order rate Time entry time_entry timeclock TE-000610 1 28.06.2025 at 11:59 synthetic/v1 In order rate Time entry time_entry timeclock TE-000611 1 24.06.2025 at 05:40 synthetic/v1 In order rate Time entry time_entry timeclock TE-000612 1 01.07.2025 at 23:40 synthetic/v1 In order rate Time entry time_entry timeclock TE-000613 1 12.06.2025 at 15:40 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-0041 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 136,65 €)
The stored note
tolerance 13665 minor units; tasmaa: JOB-0041 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 136,65 €)
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 7 806,86 € · 28,57 %
- Medium mediumUnallocated creditR71 071,31 €
1 071,31 € of credits carry no job allocation, so no job's revenue is reduced by them.
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 (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 Credit line credit_line invoicing CR-900004 1 01.06.2026 at 22:42 synthetic/v1 In order jobId