How do you Calculate On Time Delivery?

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#11
I've run into this sort of metric several times, and there are several potential pitfalls.

What I'd suggest as a primary chart is a "real time" look at delivery due dates, and were they made or not. Don't take credit for only looking at the end of the month like "I had a shipment due on 6/10, it shipped on 6/20, so today (6/30/2012) I have no overdue shipments".

Also - are you measuring "shipped by" dates, or "shipment received by customer" dates to see if it is "on time"?

So when you evaluate for the week, month, whatever, collect all the orders with scheduled dates within the time interval. Count (either by number of orders, units, dollars, whatever) the number that came due, and the number that met the commitment, and plot that percent.

Now, a gamesmanship problem with this is - once you miss a date, there is no incentive to EVER complete the delivery (at least in terms of this metric). So I usually include a metric of - number of overdue items yet to be completed, as of the end of the month. An average age of overdue items as of the end of the month may also be worthwhile.
 
Elsmar Forum Sponsor

Ninja

Looking for Reality
Staff member
Super Moderator
#12
I tend to collect two metrics:
1. On time and late shipments in period
2. # of days late in the period

The former gives me a rough "how am I doing", and is based in the month that it was to have shipped...not the month it shipped. THis approach keeps May's shipments in May, rather than sluffing it over into June...It was to ship in May and didn't...it's May's late shipment.

The latter gives me an overall measure of "How Late?" 95% on time with each lateness being one day overdue is one thing. 99% with the one lateness overdue by 20 days is another.

This approach still can miss things, but having an 'accumulated days late in period' or 'average days late in period' (averaged only over the late count) helps to point out issues when compared to historical data

HTH.
 

Jim Wynne

Staff member
Admin
#13
I agree that it is quite arbitrary to pick a given period of time, but I have to use some method to catagorize our data to present to Top Management. A month seems a logical choice. As I see it now I would say, "We shipped 100 orders last month - 99 orders were shipped on time and one was shipped after the due date". This would give me a 99% delivery rating. There is no way I could go longer than a month without incuring the wrath of Management. Doing it weekly would become very cumbersome.
I think that there's some confusion in this thread between on-time shipments and on-time deliveries.

The company that's doing the shipping might want to know about ship-to-schedule for its own internal purposes, mainly monthly invoicing. They don't care so much about whether or not a thing is shipped, per se. What they want to know is how well their monthly billing is meeting targets.

The company that's receiving the shipments wants them delivered on schedule because of their own production or service needs, and they don't care whether your monthly invoicing is meeting targets or not.

You seem to be concerned about on-time shipments, not on-time deliveries, at least for the purposes of your intial query.
 
S

silentrunning

#14
Jim, our ship dates are set ahead of the required delivery dates by the amount of time that it has historically taken orders to get to our customers. Sometimes deliveries can take longer but we are pretty close. We try to add one day just for the unexpected.
 

NikkiQSM

Quite Involved in Discussions
#15
EarlyUp to -3 DaysOn-time0 daysLate> +1 Days


Total number of jobs shipped and divide the number of jobs sent that were ontime, late, and early.

That's how we track it.
 
S

ssz102

#16
the OTD calculate is very simply
that is if you company received 100 orders this month and the customer require delivery by the end of this month,
when the early next month, you find the actually shipment is 90 orders, so the OTD is 90% last month
 
L

lostmanager

#17
We calculate OTD by total quantity of valves from orders by total quantity of valves that were late from those orders. Our OTD is really low. Should we calculate total orders by total late orders? And do we have to provide a cushion for late deliveries, if so how long? We are a custom shop and all orders are almost different.
 
Thread starter Similar threads Forum Replies Date
S Bend allowance formula to calculate per degree per radii Manufacturing and Related Processes 2
P Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
M How to calculate benefits? Moving some developed non controlled software/automation systems Service Industry Specific Topics 2
qualprod Calculate number of people in processes, considering cycle time/takt time = quantity of people Lean in Manufacturing and Service Industries 9
S How to calculate the maximum allowable hysteresis of a pressure gauge General Measurement Device and Calibration Topics 1
S How to Calculate the producer Risk AQL - Acceptable Quality Level 25
qualprod Methods to Calculate Available Production Rate ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 0
K Why calculate LCL in P-chart? Statistical Analysis Tools, Techniques and SPC 4
B How to calculate CPK with n = 1 Manufacturing and Related Processes 2
A Add-On software for VMC to calculate setting time, Idle Time, OEE etc.. Manufacturing and Related Processes 2
L How to calculate the Probability of Deficiency of the AQL of an Inspection AQL - Acceptable Quality Level 16
V How to Calculate Unbiasing Constant C4 Statistical Analysis Tools, Techniques and SPC 1
J How to Calculate OEE Indicator for a Workshop (15 Machines) Lean in Manufacturing and Service Industries 6
R How to calculate UCL (Upper COntrol Limit) and LCL (Lower Control Limit) Statistical Analysis Tools, Techniques and SPC 5
T I want to calculate reliability at 750 hours Reliability Analysis - Predictions, Testing and Standards 8
R How To Calculate & Print CDF and Lower Bound CDF value for some t(time) with Minitab? Using Minitab Software 1
N How to calculate the Premium Freight charges Service Industry Specific Topics 4
A How to calculate Mean and standard deviation without sample size in Minitab Using Minitab Software 5
R When do I need to calculate Process OEE? Manufacturing and Related Processes 12
kedarg6500 How to calculate Thread Pitch Diameter for non standard TPI like 5/8" 17.75 NF3 Manufacturing and Related Processes 3
C Definition and Way to Calculate some Metrics Lean in Manufacturing and Service Industries 6
M How calculate P value for Linearity and Bias using Excel Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 8
N Formula that will calculate the NoGo Major Diameter of an M20 x 1.5 6H Thread gage Inspection, Prints (Drawings), Testing, Sampling and Related Topics 3
M How to calculate Cg and Cgk for a 2-Dimensional Area Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
T Calculation Question - Calculate the runner weight for a part Manufacturing and Related Processes 2
M Spreadsheet on How to Calculate SMT Capacity wanted Manufacturing and Related Processes 2
F How to Calculate the unbiased Standard Deviation in Excel using Minitab Formula Capability, Accuracy and Stability - Processes, Machines, etc. 6
S Spreadsheet that will Calculate Audit Duration times based on IAF MD5 and MD11 Excel .xls Spreadsheet Templates and Tools 7
M Calculate PPMs by going back to Date of Production or Date Noticed Quality Tools, Improvement and Analysis 7
M How to calculate MTTF (Mean Time to Failure) Reliability Analysis - Predictions, Testing and Standards 1
H How to calculate the Lot Reject Rate Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
L How calculate the number of samples Statistical Analysis Tools, Techniques and SPC 2
A Simple 125 piece part Capabilty Excel .xls sheet to calculate Cpk Capability, Accuracy and Stability - Processes, Machines, etc. 3
R How to calculate MMC when is placed after datum Inspection, Prints (Drawings), Testing, Sampling and Related Topics 4
S Which one is better to calculate, Cpk or Ppk? Statistical Analysis Tools, Techniques and SPC 11
C How to calculate P value on Probability Plot Statistical Analysis Tools, Techniques and SPC 1
S Supplier Disruption Score and how to calculate it Quality Tools, Improvement and Analysis 4
D IAQG OASIS - New tool to calculate Audit Time AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
M How to calculate dimensions of trapezoid ? Quality Tools, Improvement and Analysis 3
J How to calculate Surveillance Audit Days in Corporate Audit Scheme IATF 16949 - Automotive Quality Systems Standard 4
S How to calculate Supplier PPM at Receiving Inspection Document Control Systems, Procedures, Forms and Templates 2
K How to Calculate Sample Size at 95% Confidence Interval on Surface Roughness Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
R How to calculate the value add time? Lean in Manufacturing and Service Industries 2
G Should I calculate both Cp and Cpk for a Unilateral Tolerance? Statistical Analysis Tools, Techniques and SPC 8
H Continuous Monitoring Instrument Data Validation and how to calculate Outliers Quality Tools, Improvement and Analysis 1
R How to calculate the Air Flow Rate in clause 201.12.4.4.105 of IEC 60601-2-16:2012 IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
A How to calculate Cpk & Ppk if the tolerance changes during the period? Capability, Accuracy and Stability - Processes, Machines, etc. 5
S PPAP - How to calculate tolerance on basic dimension APQP and PPAP 5
B Attrition Rate and the formula to calculate Attrition Rate Quality Manager and Management Related Issues 1
I How to calculate the Current Quality Level (CQL) of a Process Statistical Analysis Tools, Techniques and SPC 5

Similar threads

Top Bottom