Discrete ManufacturingFree templatePDF, Excel, Word export

How to Make a Routing: Manufacturing Routing Sheet Template

A routing sheet lists, in order, every operation needed to make a part, where it is done and how long it takes. This template gives you the structure and a worked example, so you can learn how to make a routing and produce a controlled sheet in minutes.

Fill in

Live preview
Download:

Manufacturing Routing Sheet Template

Routing Sheet

Company: Northfield Precision Components Part: SHF-220 - Drive shaft, 22 mm Drawing rev: B Routing rev: 3 Standard lot: 100 Prepared by: M. Okafor, Manufacturing Engineering Date: 2026-10-20

Operations

OpDescriptionWork centerSetup (h)Run (min/pc)Tooling or fixtureInspection
10Cut bar to lengthWC-110 Saw0.30.5Saw stopFirst piece length
20Turn and faceWC-120 CNC lathe1.02.8Soft jaws, insert CNMGFirst piece and every 25
30Mill keywayWC-210 Mill0.81.2V-block fixtureWidth and depth
40Heat treat (outside)Subcontract00Per specHardness cert
50Cylindrical grindWC-410 Grinder1.21.6CentersDiameter, runout
60Final inspection and packQC-010.20.4Gauges100% visual

Special Notes

Ground diameter must be within drawing tolerance after heat treat. Segregate lots by furnace batch. Record material heat number at operation 10.

Approvals

Prepared by (engineering) / Date
Reviewed by (production) / Date
Approved by (quality) / Date

Run times are per piece and setup is per lot. Total time per lot is setup plus run time times lot size. Version the routing whenever any step, work center or time changes.

Check routings against ERP data

Optional: an expert review of how to validate routing times and work centers against actual ERP data.

Optional. The tool and every export work without this. No spam.

How to make a routing, step by step

Start from the drawing and BOM. List each operation in the order the part is made, from raw material to final inspection and packing. Assign each to a work center, then add setup time per lot and run time per piece. Record tooling, fixtures and inspection points. Review with the people who run the machines, since the shop floor knows the real sequence and times. Finally, version and approve it.

  • List operations in sequence and number them 10, 20, 30 to allow inserts
  • Name the work center or outside process for each step
  • Separate setup time (per lot) from run time (per piece)
  • Note tooling, fixtures, gauges and inspection requirements
  • Add the drawing and routing revision, then approve

Reading the result

Lot time equals setup plus run time multiplied by the lot size. In the sample, operation 20 takes 1.0 hour setup plus 2.8 minutes times 100 pieces, around 5.7 hours. Summing operations gives total touch time for scheduling and costing. Add queue and move time separately when you plan lead time; routing times alone understate it.

Routing in your ERP

In an ERP the routing is a master data record that drives scheduling, costing and shop floor reporting. SAP uses routings with work centers, Oracle and NetSuite use routings or work definitions, and SyteLine and Epicor store operations on the job or method. Keep the sheet and the ERP aligned, because stale ERP routings lead to wrong lead times and costs. Use this sheet for design reviews and quoting, and load the approved data into the system.

Common mistakes

Frequent problems include copying standard times without validating them, forgetting outside processing and inspection steps, mixing units, and not versioning changes. Another is a routing that reflects how the process should work rather than how it does. Time studies on the floor, even short ones, fix most of this.

Frequently Asked Questions

What is a routing sheet?

A routing sheet is a document that lists the ordered operations required to make a part, with the work center, setup time, run time, tooling and inspection requirements for each.

What is the difference between a routing and a BOM?

A BOM lists the materials and components needed. A routing lists the operations and resources needed to turn them into the finished item. Together they define how to build a part.

How do I calculate time for a lot?

Lot time per operation is setup time plus run time per piece multiplied by lot quantity. Add up all operations for total touch time. Queue, move and wait time are additional.

Can I use this as an office routing sheet?

The structure of ordered steps with owners and sign-offs works for document routing too. Rename the columns to steps and departments, and keep the approvals block for sign-off.

If routing data is scattered across spreadsheets and ERP records, Netray can help compare and clean routings against live ERP data with a private AI layer, on-prem if required.

Keep exploring

Free tools

ERP fixes and how-tos

Runs with your ERP

Guides

AI on your ERP