Skip to content
Routing Analysis app iconRouting AnalysisFiltering

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

  1. Open Routing Analysis and select the routing and date range.
  2. Enter a Min. Average Variance to hide small average gaps.
  3. Enter a Min. Std. Deviation to hide consistent operations.
  4. Choose Generate.
  5. 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.

Routing Analysis app icon

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.

Ask a product question

Product Questions