Skip to content
Routing Analysis app iconRouting AnalysisAnalysis

Actual Versus Expected Run Times for Microsoft Dynamics 365 Business Central

When routing times are wrong, every production order built on them carries the error into costing and scheduling, and nobody sees it until someone compares recorded times with the standards by hand. Routing Analysis makes that comparison in Business Central: it takes the run times recorded on finished production orders and compares them with the times the routing expects, operation by operation.

A routing is the sequence of operations, work centers, and times used to make an item, so one wrong time affects every order that uses it.

How Actual versus expected run times works in Routing Analysis

  1. Production records actual run times on production orders, through the production journal or a time capture app.
  2. The production orders are finished in Business Central.
  3. A planner or engineer opens Routing Analysis, selects a routing, and sets the date range of finished orders to include.
  4. They choose Generate, and Routing Analysis lists each operation with its average actual time, difference, percentage difference, and standard deviation.
  5. Where a standard is wrong, they change the routing time on the same line.

Key capabilities

Recorded times, not estimates

The figures come from run time posted against finished production orders, through the production journal or a time capture app such as Shop Floor Insight, Insight Works' shop floor data collection app. Routing Analysis compares them with the run time on the routing.

Operation by operation

Each routing operation gets its own line, with its work center, description, and the routing's setup, run, wait, and move times beside the results.

Average time per unit

The Mean Time (Hours) per Quantity (Base) column shows the average actual run time per unit for each operation, expressed in hours.

Difference and percentage

Average and Percentage Run Time Difference shows how far that average sits from the routing, in time and as a percentage.

Consistency as well as speed

Standard Deviation per Operation measures how much the recorded times vary, not only how long they take on average.

The history behind each line

Each operation shows the number of production order lines behind it, so it is clear how much recorded history the comparison rests on.

See Actual versus expected run times on screen

Real screens from Routing Analysis, shown with demo data.

Details that matter on the floor

Captured times come first

Routing Analysis depends on actual operation times being recorded. A shop that does not yet record them has nothing to compare, so time capture is the first step.

Finished orders only

Only finished production orders inside the date range count. Orders still in progress do not change the figures until they are finished.

Who uses Actual versus expected run times

Manufacturing engineers

Own the routings, compare them with what the floor records, and correct the standards.

Production managers

Check that expected times match reality, so the schedule built on them is achievable.

Cost accountants

Rely on correct routing times, since labor and overhead costing runs off them.

Questions about Actual versus expected run times

Can Business Central compare actual run times with routing times?

Yes, with Routing Analysis. Routing Analysis compares run times recorded on finished production orders with the routing's run time, operation by operation, and reports the average difference, percentage difference, and standard deviation.

Where does Routing Analysis get actual times?

From run time posted against finished production orders. Your shop records it through the production journal or a time capture app such as Shop Floor Insight.

Are production orders still in progress included?

No. Routing Analysis counts only finished production orders whose finished date falls inside the date range you choose.

Which licenses do I need?

Routing Analysis needs the Business Central Premium tier, because production orders and routings are only on that tier. See the licensing FAQ or contact your Microsoft Partner.

Routing Analysis app icon

Part of Routing Analysis

Optimize production with routing analysis to reduce variability and enhance costing accuracy.

Have a question about Actual versus expected run times?

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