How do you Calculate On Time Delivery?

S

silentrunning

#1
I just found out that our calculation of on time delivery might be skewed. We run a tally at the end of each month and that is the number I present to Top Management. I had always assumed that it was the number of dollars shipped during the month divided into the number of dollars that was due but not shipped times 100. This would give us our percentage of late materials. I now find out that it is figured by dividing the number of LATE dollars SHIPPED by the total dollars shipped times 100. This means we can have 20 late jobs at the end of this month and still show a 100% on time delivery. Next month would look bad of course.

We go by dollar volume because some jobs are $300 and some are $100,000. Now I am not even sure that this is the correct way to calculate this. Maybe jobs would be better, but a lot of our sales are KANBAN so I’m not sure how we would handle that.

I am thoroughly confused on this and would appreciate some Cove input.

Marc, Please feel free to move this if you think it will do better elsewhere.
 
Elsmar Forum Sponsor

Jim Wynne

Staff member
Admin
#2
Re: How do you figure On Time Delivery?

What you're calculating isn't on-time delivery, at least the in the way that customers look at it. Each order has a promised delivery date, usually with some kind of +/- cushion. On-time delivery is a measure of how well you meet those dates.

What you're measuring is some kind of dollars-lost (or payments delayed) due to late deliveries, which is a different kettle of fish.
 
D

dkusleika

#3
We used to do the calculation by both dollars and units, but quit using dollars. Sometimes our $300 order holds up a $1m project, so the fact that it was a small order doesn't necessarily correlate with customer satisfaction.

Now we only use late-units/total-units, but after reading your post, I'm re-thinking that. If we have some May deliveries that ship in June, it should be May's numbers that look bad, not June. I'm not sure if it matters (depends on the root cause) but thanks for the process improvement idea.
 

Jim Wynne

Staff member
Admin
#4
We used to do the calculation by both dollars and units, but quit using dollars. Sometimes our $300 order holds up a $1m project, so the fact that it was a small order doesn't necessarily correlate with customer satisfaction.

Now we only use late-units/total-units, but after reading your post, I'm re-thinking that. If we have some May deliveries that ship in June, it should be May's numbers that look bad, not June. I'm not sure if it matters (depends on the root cause) but thanks for the process improvement idea.
It shouldn't matter what month it is if a thing is delivered late. Tracking on-time delivery should be a method of monitoring how well you're keeping customers happy. Although there's probably not much you can do about it, having anyone other than accountants tracking monthly billing will lead to "business decisions" regarding nonconforming or suspect product sooner or later.
 

somashekar

Staff member
Super Moderator
#5
We used to do the calculation by both dollars and units, but quit using dollars. Sometimes our $300 order holds up a $1m project, so the fact that it was a small order doesn't necessarily correlate with customer satisfaction.

Now we only use late-units/total-units, but after reading your post, I'm re-thinking that. If we have some May deliveries that ship in June, it should be May's numbers that look bad, not June. I'm not sure if it matters (depends on the root cause) but thanks for the process improvement idea.
There are customers who do not consider early delivery as better, just because you have stocks on hand. An other aspect is the transit time that is taken for the actual delivery at customer specified place, if this is your responsibility. Considering these two, you will have to assess how many of your shipments touch base on the stipulated date (customer warehouse or your warehouse as the case may be) and how many have missed.
Finally the purpose of this is to find out the reason why you have missed so that you can decide how you can correct them going forward.
 
S

silentrunning

#6
I think the phrase I overlooked was “Customer Satisfaction”. This is what we are really measuring, not dollars & cents. I now think we should go by the job, not the value. A $300 job that is late may be just as important to customer A as a $300,000 job is to customer B. I will work on this, but would still appreciate any input that anyone has. .
 
D

dkusleika

#7
Here's the over-the-top example that the OP got me thinking about. I have three shipments in May and 100 in June. One of the May shipments goes in June and everything else is on time. Now I calculate 100% on time in May and 99% on time in June. The other way it's 67% in May and 100% in June.

In the former, I don't investigate because 99% is above my threshold. In the latter, I do investigate. In reality, if my shipments really fluctuate that much I shouldn't be using a percentage to determine when to investigate, but it's just an extreme example to illustrate a point.

I guess it comes down to finding the right metric to alert me when there's a problem. Probably I shouldn't look at one month in isolation and look at trends. If the on times are trending worse, it's time to look at the details. If they're steady or improving but with an aberration in a particular month, maybe committing resources would be a waste.
 

somashekar

Staff member
Super Moderator
#8
When we work to months, we tend to get into 12 blocks and see deliveries more as our monthly targets rather than when customer requires. The better way we follow is to work on production weeks (week number 01 to 52) of the calendar, and plan the complete supply chain and subsequent deliveries over these 52 weeks aligning with customer delivery schedules. The performance and monitoring gets better as well as the controls.
 
Last edited:

Jim Wynne

Staff member
Admin
#9
Here's the over-the-top example that the OP got me thinking about. I have three shipments in May and 100 in June. One of the May shipments goes in June and everything else is on time. Now I calculate 100% on time in May and 99% on time in June. The other way it's 67% in May and 100% in June.

In the former, I don't investigate because 99% is above my threshold. In the latter, I do investigate. In reality, if my shipments really fluctuate that much I shouldn't be using a percentage to determine when to investigate, but it's just an extreme example to illustrate a point.

I guess it comes down to finding the right metric to alert me when there's a problem. Probably I shouldn't look at one month in isolation and look at trends. If the on times are trending worse, it's time to look at the details. If they're steady or improving but with an aberration in a particular month, maybe committing resources would be a waste.
If you're concerned about whether or not deliveries are on time, using extrinsic parameters such as month of shipment doesn't help anything. A thing is either on time or it's not.
 
S

silentrunning

#10
If you're concerned about whether or not deliveries are on time, using extrinsic parameters such as month of shipment doesn't help anything. A thing is either on time or it's not.
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.
 
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