Question:
How to calculate Standard Deviation of Lead Time?
chetan_vbelle
2011-07-16 09:32:17 UTC
I am trying to calculate safety stock whose formula as goes below:
Safety Stock:
{Z * SQRT (Avg. Lead Time * Standard Deviation of Demand ^2 + Avg. Demand ^2 * Standard Deviation of Lead Time ^2}.

I have all the inputs except standard deviation of lead time... can any1 help me out with this?
Six answers:
2011-07-16 09:51:27 UTC
Because you have used that to measure the average lead time it suggests that you should have the sample data of the historic lead time. Take the standard deviation from that data.



Also please tell how many samples do you have for the lead time. If the sample size is >30 then lead time is a good way to measure safety stock.
ruggiero
2016-10-14 09:20:56 UTC
Standard Deviation Of Demand
2015-08-14 11:52:12 UTC
This Site Might Help You.



RE:

How to calculate Standard Deviation of Lead Time?

I am trying to calculate safety stock whose formula as goes below:

Safety Stock:

{Z * SQRT (Avg. Lead Time * Standard Deviation of Demand ^2 + Avg. Demand ^2 * Standard Deviation of Lead Time ^2}.



I have all the inputs except standard deviation of lead time... can any1 help me out with this?
Sandra
2016-03-15 07:10:24 UTC
STDEV assumes that its arguments are a sample of the population. The standard deviation is calculated using the "unbiased" or "n-1" method. STDEV uses the following formula: squar root of((sum of(x- x bar)^2)/(n-1)) where x is the sample mean AVERAGE(number1,number2,…) and n is the sample size.
Kamrava
2011-07-16 09:32:55 UTC
Reading this question is like listening to dubstep
marta
2016-09-15 21:02:12 UTC
Can you give more details?


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...