Routing Accuracy Audit Template
Routings drive capacity planning, scheduling, labor cost and promise dates. If setup and run times are wrong, every downstream number is wrong. This template gives industrial engineers and planners a repeatable way to audit a routing against what the shop actually does.
Fill in
Routing Accuracy Audit Template
Routing Accuracy Audit
Company: Acme Precision Ltd Plant: Plant 1, Machining Auditor: Industrial Engineering Date: 2026-11-05
Item under audit
Part: MCH-004217 Routing: RTG-004217 Rev C Sample method: Last 10 completed jobs
Scope
Review operation sequence, work center, setup time, run time per piece, tooling, inspection points and scrap against the last 10 completed work orders.
Operation comparison
| Op | Work center (ERP) | Work center (actual) | Setup (ERP) | Setup (actual) | Run/pc (ERP) | Run/pc (actual) | Variance % |
|---|---|---|---|---|---|---|---|
| 10 | |||||||
| 20 | |||||||
| 30 | |||||||
| 40 | |||||||
| 50 |
Checks
| Check | Pass | Fail | Comment |
|---|---|---|---|
| Operation sequence matches the real flow | |||
| Work center and resource group are correct | |||
| Tooling and fixture references are current | |||
| Inspection and sign-off points are routed | |||
| Outside processing steps are included with lead time | |||
| Yield or scrap assumptions match history |
Findings
Run time on OP30 averages above routing. OP50 deburr is performed at a different work center than routed.
Corrective actions
Update OP30 run time after review with the programmer. Move OP50 to work center DBR-02 and revise the routing.
Approvals
Variance percent is (actual - ERP) / ERP x 100 for each time. Many plants investigate variances above 10 percent, but set your own threshold. Decide up front whether routing times represent standard, average or best-demonstrated performance, so you compare like with like.
Want routing variances found from your ERP history?
Optional: we can review an export of routings and job history and highlight the largest gaps.
Optional. The tool and every export work without this. No spam.
How to use the template
Choose a part or family and a sample method: a short time study, recent completed jobs from MES or ERP labor reporting, or operator interviews. Enter the ERP values in the operation comparison table, fill in the actual values, and compute the variance. Complete the checks, then record findings and actions. Export to PDF for sign-off or to Word to continue editing. One audit per high-volume or high-cost routing per year is a practical start.
What to compare
The key fields are sequence, work center, setup time, run time per piece, tooling, inspection points and yield. Run time per piece should be compared per unit after dividing actual job hours by good quantity. Setup is best compared across several jobs, because one outlier can mislead. Also check outside processing steps, since a missing operation or lead time quietly breaks promised dates even when machine times look right.
- Sequence and work center
- Setup and run time
- Tooling and fixtures
- Inspection and sign-off steps
- Yield and scrap assumptions
Reading the variance
A small positive variance on run time may simply mean normal losses are not in the standard. A large negative variance suggests the routing is padded, which inflates capacity needs and lead times. Where actuals vary a lot between operators, fix the process before changing the standard. After any change, tell planning and costing, because new times change capacity loads and, with standard costing, the next cost roll.
Common mistakes
Using one lucky or unlucky job as the sample gives a false answer. Mixing prove-out runs with steady production inflates setup. Updating the routing without a revision record loses the link to costing and quality history. Auditing only times and not work centers misses cases where the job runs on a different machine class, which distorts capacity planning. Close each audit by assigning a named owner for every action.
Frequently Asked Questions
How often should routings be audited?
Audit high-volume and high-cost routings at least yearly, and any routing after a significant process or equipment change. Low-volume parts can be sampled. Automated variance reports from MES or ERP labor data help flag outliers between audits.
What variance should trigger a routing update?
Many plants investigate when average actual time differs from the routing by more than about 10 percent over a meaningful sample. Choose a threshold that fits your cost of error and keep it consistent across audits.
Should routing times be standard or actual?
It depends on the use. Scheduling usually wants realistic average times, while standard costing may want an engineered standard. Decide and document which one your routing holds, then audit against that definition.
Does a routing change affect product cost?
Yes. Changing setup or run time changes planned labor and overhead absorption. With standard costing, the effect shows after the next cost roll. Coordinate with finance before releasing routing changes in bulk.
If you want routing times compared to actual labor and machine history automatically, we can build a read-only comparison on your ERP and MES data, kept on-prem if required.
Related Tools
BOM Accuracy Calculator
Compute BOM and line-level accuracy from an audit sample and estimate the rework effort to reach your target.
ERP OperationsItem Master Data Quality Checklist
A 33-point checklist for auditing item or material master records before they cause wrong MRP, wrong cost or wrong shipments.
ERP OperationsMaster Data Governance RACI Template
A fill-in RACI matrix and policy outline for item, vendor, customer, BOM and routing master data ownership.
Engineering & PLMPart Numbering Scheme Generator Template
Fill in your company rules and get a one-page part numbering standard with format, class codes, examples and governance rules.
More MES & Shop Floor tools
See all- Oracle Fusion OEE Work Center Calculator
- Infor VISUAL Shop Labor Ticket Log Worksheet
- VISUAL Shop Load Versus Capacity Calculator
- VISUAL Shop Resource Capacity and Load Calculator
- IFS Shop Order Status and Lifecycle Reference
- Plex Smart Manufacturing Data Source Request Template
- Plex Production Scheduling Checklist
- Plex Downtime Reason Log and OEE Worksheet
- Plex Go-Live Readiness Sign-Off Template
Keep exploring
Free tools
- BOM Accuracy CalculatorCompute BOM and line-level accuracy from an audit sample and estimate the rework effort to reach your target.
- Manufacturing Routing Sheet TemplateA routing sheet generator for operations, work centers, setup and run times, tooling and inspection points, with a worked sample you can overwrite.
- Business Central Routing and Production BOM Cost WorksheetPlan routing operations with setup time, run time, lot size and work center rate, and see operation cost per unit before you set up routings in BC.
ERP fixes and how-tos
- How to Set Up Routings and WIP in NetSuite ManufacturingSet up manufacturing routings, work centers and WIP in NetSuite: cost templates, operation tasks, work order issue and completion, and why WIP will not clear.
- SAP Table for Routing and Work Center, Work Orders and CapacitySAP PP tables for routing, work center, capacity and production orders: PLKO, PLPO, CRHD, KAKO, AFKO, AFPO, with join keys and SE16N queries to start from.
- SyteLine alternate routing and alternate BOM: a worked exampleA worked example of alternate routings and alternate BOMs in SyteLine, and how planning and job orders choose between them. Includes checks and pitfalls.
Guides
- How to Set Up Routings in Infor SyteLineStep-by-step guide to setting up routings in Infor SyteLine. Define operation sequences, run times, setup times, and work center assignments for manufacturing jobs.
- SyteLine Routing Setup and Configuration Best PracticesConfigure SyteLine routings. Operation sequences, setup/run times, work center assignment, and routing optimization for production scheduling accuracy.
- Human-in-the-Loop Design Patterns for AI AgentsHuman-in-the-loop design patterns for AI agents: approval gates, confidence-based routing, and sampling review, with guidance on where each pattern fits.
AI on your ERP
- AI Production Scheduling on Top of Your ERP: Explain, Triage and Re-Plan Without Replacing the SchedulerHow AI helps planners and schedulers explain late jobs, fix bad routing data and draft reschedules on top of ERP work orders, without replacing the finite scheduler.
- AI for Engineering Change Impact on BOMs, Routings, and Open OrdersAI reads a proposed ECO against live BOM, routing, and open order data to show engineering exactly what a change touches before it gets released.