JOB-0021Aurora Energia Oy

Customer CUS-021 · Completed · opened 03.02.2025 at 04:52 · completed 18.02.2025 at 04:52

Work centres: CNC-1, CNC-2, WELD-1

8 921,77 €

27,23 %

In order

No blocking findings: the margin is reportable.

Quote basis and actual

Item	Quote basis	Actual
Revenue (allocated)	33 336,20 €	32 759,48 €
Material	16 105,80 €	15 380,64 €
Labour	127,16 h × 63,33 €/h	8 457,07 €
Subcontract	0,00 €	0,00 €
Other variable costs	0,00 €	0,00 €
Margin	—	8 921,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 0e7131c1da7a

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−576,72 €

Evidence (9 rows · Causal reference: 9)

Causal referenceThe rows that produced the amount

These 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-000125	1	27.03.2026 at 17:42	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000126	1	26.02.2025 at 07:55	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000127	1	11.04.2025 at 01:04	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000128	1	23.11.2025 at 05:30	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000129	1	18.08.2025 at 11:06	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000130	1	29.08.2026 at 11:33	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000131	1	25.03.2026 at 23:07	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000132	1	19.05.2026 at 06:05	synthetic/v1	In order	—
Credit line credit_line	invoicing	CR-00016	1	14.08.2026 at 06:16	synthetic/v1	In order	—

2Material quantity differencematerial_quantity_varianceCausal+691,45 €

Evidence (9 rows · Causal reference: 9)

Causal referenceThe rows that produced the amount

These 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-000175	1	10.02.2025 at 22:22	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000176	1	05.02.2025 at 21:19	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000177	1	15.02.2025 at 00:14	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000178	1	16.02.2025 at 21:32	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000179	1	15.02.2025 at 05:22	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000180	1	04.02.2025 at 12:48	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000181	1	07.02.2025 at 23:48	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000182	1	15.02.2025 at 09:17	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000183	1	13.02.2025 at 00:53	synthetic/v1	In order	qty

3Material price differencematerial_price_varianceCausal+356,41 €

Evidence (9 rows · Causal reference: 9)

Causal referenceThe rows that produced the amount

These 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-000175	1	10.02.2025 at 22:22	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000176	1	05.02.2025 at 21:19	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000177	1	15.02.2025 at 00:14	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000178	1	16.02.2025 at 21:32	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000179	1	15.02.2025 at 05:22	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000180	1	04.02.2025 at 12:48	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000181	1	07.02.2025 at 23:48	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000182	1	15.02.2025 at 09:17	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000183	1	13.02.2025 at 00:53	synthetic/v1	In order	unitCost

4Labour hours differencelabour_hours_varianceCausal+80,43 €

Evidence (16 rows · Causal reference: 16)

Causal referenceThe rows that produced the amount

These 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-000290	1	18.02.2025 at 00:53	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000291	1	07.02.2025 at 17:01	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000292	1	10.02.2025 at 12:46	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000293	1	16.02.2025 at 21:51	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000294	1	07.02.2025 at 09:50	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000295	1	17.02.2025 at 07:50	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000296	1	12.02.2025 at 14:41	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000297	1	08.02.2025 at 22:44	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000298	1	16.02.2025 at 16:33	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000299	1	08.02.2025 at 22:05	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000300	1	03.02.2025 at 15:11	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000301	1	16.02.2025 at 20:55	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000302	1	17.02.2025 at 15:40	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000303	1	17.02.2025 at 06:03	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000304	1	08.02.2025 at 06:57	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000305	1	06.02.2025 at 21:27	synthetic/v1	In order	hours

5Labour rate differencelabour_rate_varianceCausal+0,01 €

Evidence (16 rows · Causal reference: 16)

Causal referenceThe rows that produced the amount

These 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-000290	1	18.02.2025 at 00:53	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000291	1	07.02.2025 at 17:01	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000292	1	10.02.2025 at 12:46	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000293	1	16.02.2025 at 21:51	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000294	1	07.02.2025 at 09:50	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000295	1	17.02.2025 at 07:50	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000296	1	12.02.2025 at 14:41	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000297	1	08.02.2025 at 22:44	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000298	1	16.02.2025 at 16:33	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000299	1	08.02.2025 at 22:05	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000300	1	03.02.2025 at 15:11	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000301	1	16.02.2025 at 20:55	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000302	1	17.02.2025 at 15:40	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000303	1	17.02.2025 at 06:03	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000304	1	08.02.2025 at 06:57	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000305	1	06.02.2025 at 21:27	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_varianceCausal−807,17 €

Evidence (4 rows · Causal reference: 4)

Causal referenceThe rows that produced the amount

These 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-900002	1	09.02.2025 at 09:11	synthetic/v1	In order	—
Time entry time_entry	timeclock	TE-900018	1	14.02.2025 at 23:18	synthetic/v1	In order	—
Time entry time_entry	timeclock	TE-900019	1	09.02.2025 at 07:53	synthetic/v1	In order	—
Time entry time_entry	timeclock	TE-900020	1	16.02.2025 at 13:27	synthetic/v1	In order	—

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.

Reconciliation0,00 €tolerance 163,80 €

ReconcilesJOB-0021 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 163,80 €)

The stored note

tolerance 16380 minor units; tasmaa: JOB-0021 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 163,80 €)

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 921,77 € · 27,23 %

Medium mediumReworkR6807,17 €

807,17 € of work on JOB-0021 was done on operations outside the quoted scope.

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 (4 rows · Causal reference: 4)

Causal referenceThe rows that produced the amount

These 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-900002	1	09.02.2025 at 09:11	synthetic/v1	In order	—
Time entry time_entry	timeclock	TE-900018	1	14.02.2025 at 23:18	synthetic/v1	In order	—
Time entry time_entry	timeclock	TE-900019	1	09.02.2025 at 07:53	synthetic/v1	In order	—
Time entry time_entry	timeclock	TE-900020	1	16.02.2025 at 13:27	synthetic/v1	In order	—