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