Variance Threshold Filters for Microsoft Dynamics 365 Business Central
A routing analysis that lists every operation, including those within a few hundredths of an hour of standard, buries the few that need attention. Routing Analysis has two threshold filters in Business Central: Min. Average Variance and Min. Std. Deviation.
Operations below the thresholds you set drop out of the results, so only meaningful gaps appear.
How Variance threshold filters works in Routing Analysis
- Open Routing Analysis and select the routing and date range.
- Enter a Min. Average Variance to hide small average gaps.
- Enter a Min. Std. Deviation to hide consistent operations.
- Choose Generate.
- Review the operations that remain, and adjust the thresholds if the list is too long or too short.
Key capabilities
Minimum average variance
Suppress operations whose average difference from the routing is smaller than the value you set.
Minimum standard deviation
Suppress operations more consistent than the value you set, which is how you go looking for variability specifically rather than slowness.
Set before generating
Both filters sit in Filter Settings with the routing number, date range, and routing line display, and apply when you choose Generate.
A step beyond Only Difference
Only Difference Display hides operations whose actual run time matches the routing; the thresholds also hide differences too small to act on.
See Variance threshold filters on screen
Real screens from Routing Analysis, shown with demo data.
Details that matter on the floor
Separate settings for separate problems
Because average variance and standard deviation have their own thresholds, an engineer can look for slow operations in one pass and inconsistent ones in the next.
Who uses Variance threshold filters
Manufacturing engineers
Cut a long operation list down to the standards worth reviewing.
Operations managers
Review only the operations that differ enough from standard to affect the plan.
Questions about Variance threshold filters
Can I hide routing operations with small variances?
Yes. In Routing Analysis, set Min. Average Variance, and operations whose average difference is smaller than that value are left out of the results.
Can I list only the inconsistent operations?
Yes. Set Min. Std. Deviation, and operations more consistent than that value are left out.
Do the thresholds change the routing?
No. They only filter the results. Routing times change only when you edit them.
Related Routing Analysis features
All Routing Analysis features →Part of Routing Analysis
Optimize production with routing analysis to reduce variability and enhance costing accuracy.
Have a question about Variance threshold filters?
Send us a note and the Routing Analysis team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.
