Job Shop On-Time Delivery Tracker
On-time delivery is the number small shops are judged on, and few track it past a gut feeling. This worksheet computes days late and the on-time rate from the promised and actual ship days, with a reason code so you can see what is actually causing misses.
| Job number | Customer | Promised date | Ship date | Promise day number | Ship day number | Days late | On time (1 yes, 0 no) | Late reason | |
|---|---|---|---|---|---|---|---|---|---|
0 | 1 | ||||||||
3 | 0 | ||||||||
0 | 1 | ||||||||
3 | 0 |
Enter the working day number alongside the dates so the sheet can compute lateness. Count a job on time when it ships on or before the promised day.
Weekly delivery report from your ERP
Optional: ask about automated on-time delivery and late-reason reporting.
Optional. The tool and every export work without this. No spam.
How to use the tracker
Add one row per shipped job. Enter the promised and actual dates for the record, and the working day number of each within the month for the calculation. The sheet then shows days late, flags on-time jobs and calculates the shop on-time delivery rate. Pick a late reason for every miss. After a month, sort or export to Excel and count which reason appears most often.
The formula
On-time delivery percent equals jobs shipped on or before the promised date divided by total jobs shipped, multiplied by 100. Be consistent about the promise date: use the date confirmed to the customer, not the original request, or report both. Measure by job or by line and keep the method the same each month.
- Use the date acknowledged to the customer as the promise
- Count partial shipments consistently
- Report by customer if one account drives the misses
- Review late reasons monthly, not just the total
Reading the result
A single percentage hides the pattern. If most late jobs share the reason Outside processing, the fix is scheduling and vendor lead time, not overtime. If the reason is Material, review how you order against the quote. The late reason column turns a score into an action list.
ERP notes
JobBOSS, E2 Shop System, Global Shop Solutions and ProShop all hold promise and ship dates on the job or order line, and most offer a delivery report. Use this sheet if you want a simple view with your own reason codes, or to compare against what the ERP reports. Differences usually come from how partial shipments and changed due dates are treated.
Frequently Asked Questions
Why do I enter day numbers as well as dates?
The calculation engine works on numbers, so the working day of the month for each date gives a simple, consistent measure. Keep the dates for your record and use the day numbers for the math within one month.
What is a good on-time delivery rate?
It depends on the customer base and industry. Many customers expect 90 percent or better, and some aerospace and defense accounts set higher targets. Check your customer scorecards for the actual requirement.
How do I handle partial shipments?
Pick one rule and apply it every time. Common choices are to measure on the final shipment of the job or to measure each shipment line separately. The important part is consistency.
Can I track across several months?
Yes, but reset day numbers per month or export each month separately. For multi-month analysis, export to Excel and use date arithmetic there.
If you want delivery performance and late reasons calculated straight from your ERP each week, Netray can help set that up.
Related Tools
Outside Processing Purchase Order Template for Job Shops
A purchase order template for sending parts out for heat treat, plating, anodize, grinding or paint, with process spec, certs and return instructions.
Costing & FinanceJob Shop Machine Hour Rate Worksheet
Editable worksheet that converts machine price, life, hours, power draw and maintenance into a cost per run hour for each machine.
Costing & FinanceJob Shop Job Close-Out Variance Worksheet
Editable worksheet comparing quoted versus actual hours and material to show variance and margin per closed job.
Discrete ManufacturingJob Shop RFQ Intake Form Template
A one-page request for quote intake form so every RFQ reaches the estimator with the same information before anyone opens JobBOSS, E2 Shop System or Global Shop Solutions.
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
- On-Time Delivery CalculatorEnter shipped lines, on-time lines and in-full lines to get OTD, OTIF, late and early rates and the gap to your target.
- Supplier PPM and On-Time Delivery SQL Query GeneratorFill in your receipt table and column names to generate a ready-to-run SQL query for supplier reject PPM and on-time delivery.
- Supplier Delivery Performance CalculatorCalculate supplier on-time delivery (OTD), on-time in-full (OTIF), early and late percentages, and how many lines need to improve to hit your target.
ERP fixes and how-tos
- SyteLine customer on-time shipments: which dates to compare and how to report OTDHow to measure customer on-time shipments in Infor SyteLine: which dates to compare (due, promise, ship), standard reports, and a SQL query for OTD percent.
- How to Issue a Supplier Corrective Action Request (SCAR) Using ERP Receiving and Reject DataBuild supplier quality records from ERP data: receipt rejects, PPM, on-time delivery, and when to trigger a SCAR. Includes query shapes and scorecard pitfalls.
- How to Add a Private AI Layer to Classic JobBOSS On-PremHow to add a private on-prem AI assistant to classic JobBOSS: read-only SQL Server access, job and operation data, permissions, GPU sizing and rollout.
Guides
- Machine Shop Scheduling for CNC Job Shops: Why Schedules Break and How to Fix ThemMachine shop scheduling for CNC job shops: why schedules break, finite versus infinite capacity, the data it needs, and where AI helps daily.
- Machine Shop Quoting Software: What CNC Job Shops Should Look ForMachine shop quoting software compared by approach: ERP estimating modules, standalone quoting tools and AI drafting, with what each does for CNC job shops.
- ERP for Job Shops and Custom FabricatorsERP for job shops and custom fabricators: fast quoting, estimating accuracy, shop floor data collection, nesting and real-time job costing that protects margin.
AI on your ERP
- AI for JobBOSS2 in Precision Machining: Quotes, Routings and Job Cost Answers from Your Own DataPrivate AI for JobBOSS2 precision machine shops: quote history, routing actuals, job cost variance and on-time delivery answers, kept on your own network.
- AI for JobBOSS2 quoting and schedulingHow AI helps JobBOSS2 job shops quote from past job actuals and explain scheduling conflicts, with read-only access and private hosting options.
Integrations
- How to connect Power BI to Global Shop SolutionsConnect Power BI to Global Shop Solutions: ODBC or warehouse options, on-prem gateway, key job shop dashboards, and adding natural-language Q&A on top.
- How to connect Power BI to ECI E2 Shop SystemHow to connect Power BI to ECI E2 Shop System: SQL Server direct or warehouse, on-prem data gateway, key job shop dashboards, and natural-language Q&A.
Software
- Global Shop SolutionsWhat Global Shop Solutions ERP is, how its estimating, scheduling and shop floor modules serve job shops, and which ERP alternatives to compare.
- Infor VISUALIndependent guide to Infor VISUAL ERP for job shops and make-to-order manufacturers: modules, integrations, deployment, strengths, limits and alternatives.