Fault Line — Production Order Cost Variance

Work center

Source item

Date from

Date to

Orders

—

in selection

Total material var.

—

expected vs actual

Total capacity var.

—

operation cost

Total overhead var.

—

capacity overhead

Orders over budget

—

any positive variance

Note on Expected Capacity Cost (Applied): This metric exists in Business Central's RPO Statistics report but is computed as a runtime FlowField — it is not stored in any underlying table and cannot be reliably extracted via OData. The three remaining cost types have been reconstructed accurately from Prod Order Routing Lines, Value Entries, and Capacity Ledger Entries. The Applied Capacity Cost column is shown as a known gap pending a manual calculation workaround.

Finished production orders — expected vs actual cost variance Positive variance = over budget · negative = under budget

RPO no.	Source item	Finished date	Output qty	Material cost			Operation cost			Capacity overhead			Cap. cost applied ⚠
RPO no.	Source item	Finished date	Output qty	Expected	Actual	Variance	Expected	Actual	Variance	Expected	Actual	Variance	Expected	BC FlowField

Total variance by cost type All finished orders in selection

Material variance by item Cumulative across all orders

Cost prediction methodology: Expected costs for in-progress orders are derived from BOM component costs × required quantities, plus routing line expected times × work center rates. This mirrors Business Central's internal calculation logic and has been validated against finished order actuals. Orders are flagged when predicted cost trajectory diverges significantly from the expected standard cost.

In-progress production orders — predicted cost vs expected Based on BOM cost shares and routing line data

RPO no.	Source item	Status	Due date	Output qty	% complete	Expected total	Predicted total	Variance	Variance %	Trend

Predicted vs expected by order Sorted by variance

Completion vs cost consumed Orders above the line are spending ahead of progress