JOB-0058Ilves Kone Oy

Customer CUS-018 · Completed · opened 24.09.2025 at 03:14 · completed 18.11.2025 at 03:14

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

6 399,01 €

35,30 %

In order

No blocking findings: the margin is reportable.

Quote basis and actual

Item	Quote basis	Actual
Revenue (allocated)	18 286,79 €	18 127,69 €
Material	6 577,33 €	7 065,09 €
Labour	93,80 h × 39,27 €/h	3 352,07 €
Subcontract	1 311,52 €	1 311,52 €
Other variable costs	0,00 €	0,00 €
Margin	—	6 399,01 €

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 9a358a8c0a2e

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−159,10 €

Evidence (8 rows · Causal reference: 8)

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-000353	1	20.03.2026 at 12:22	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000354	1	07.08.2026 at 15:12	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000355	1	28.07.2026 at 01:11	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000356	1	08.09.2026 at 12:54	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000357	1	24.03.2026 at 07:01	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000358	1	30.03.2026 at 18:07	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000359	1	10.01.2026 at 13:16	synthetic/v1	In order	—
Credit line credit_line	invoicing	CR-00045	1	06.08.2026 at 11:48	synthetic/v1	In order	—

2Material quantity differencematerial_quantity_varianceCausal+657,74 €

Evidence (6 rows · Causal reference: 6)

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-000483	1	20.10.2025 at 18:28	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000484	1	10.10.2025 at 11:43	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000485	1	28.09.2025 at 13:34	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000486	1	28.09.2025 at 10:09	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000487	1	28.10.2025 at 22:02	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000488	1	03.11.2025 at 06:49	synthetic/v1	In order	qty

3Material price differencematerial_price_varianceCausal−1 145,50 €

Evidence (6 rows · Causal reference: 6)

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-000483	1	20.10.2025 at 18:28	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000484	1	10.10.2025 at 11:43	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000485	1	28.09.2025 at 13:34	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000486	1	28.09.2025 at 10:09	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000487	1	28.10.2025 at 22:02	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000488	1	03.11.2025 at 06:49	synthetic/v1	In order	unitCost

4Labour hours differencelabour_hours_varianceCausal+331,44 €

Evidence (17 rows · Causal reference: 17)

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-000855	1	10.10.2025 at 08:45	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000856	1	30.09.2025 at 07:37	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000857	1	24.09.2025 at 22:45	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000858	1	02.10.2025 at 02:16	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000859	1	15.11.2025 at 08:30	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000860	1	17.10.2025 at 01:15	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000861	1	19.10.2025 at 09:40	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000862	1	13.10.2025 at 12:58	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000863	1	04.10.2025 at 22:53	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000864	1	07.11.2025 at 22:56	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000865	1	04.11.2025 at 01:57	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000866	1	04.11.2025 at 18:02	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000867	1	01.11.2025 at 13:42	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000868	1	10.10.2025 at 23:31	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000869	1	28.09.2025 at 06:32	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000870	1	01.10.2025 at 04:51	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000871	1	17.11.2025 at 17:00	synthetic/v1	In order	hours

5Labour rate differencelabour_rate_varianceCausal+0,02 €

Evidence (17 rows · Causal reference: 17)

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-000855	1	10.10.2025 at 08:45	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000856	1	30.09.2025 at 07:37	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000857	1	24.09.2025 at 22:45	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000858	1	02.10.2025 at 02:16	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000859	1	15.11.2025 at 08:30	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000860	1	17.10.2025 at 01:15	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000861	1	19.10.2025 at 09:40	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000862	1	13.10.2025 at 12:58	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000863	1	04.10.2025 at 22:53	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000864	1	07.11.2025 at 22:56	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000865	1	04.11.2025 at 01:57	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000866	1	04.11.2025 at 18:02	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000867	1	01.11.2025 at 13:42	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000868	1	10.10.2025 at 23:31	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000869	1	28.09.2025 at 06:32	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000870	1	01.10.2025 at 04:51	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000871	1	17.11.2025 at 17:00	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.

Reconciliation0,00 €tolerance 90,64 €

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

The stored note

tolerance 9064 minor units; tasmaa: JOB-0058 reconciles: the drivers account for the whole of the difference between the estimated and the actual margin (residual 0,00 €, tolerance 90,64 €)

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 6 399,01 € · 35,30 %

Medium mediumMaterial price increaseR3688,35 €

Quoted items on JOB-0058 exceeded the quote basis: 688,35 € above the quote basis.

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

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-000486	1	28.09.2025 at 10:09	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000487	1	28.10.2025 at 22:02	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000488	1	03.11.2025 at 06:49	synthetic/v1	In order	unitCost