Great Video. I've been working on inventory analysis for years and never knew about the normsimv function. Have always used the VLookup function. This is so much easier. Extremely helpful, and thanks for the video.
There are two main formulas for calculating safety stock. The method I used in this video is used when demand is less certain, which I think is fair to assume. The equation you mentioned is the other main formula used. In the university I went to the formula I used was taught as more accurate. It was also the formula I used in my supply chain job.
How would you calculate safety stock after a downstream process in the same value stream? Would you calculate lead time from the beginning or from the previous safety stock?
Thanks a lot for the video! This is a really good explanation that helps me a lot. Could you advise if we observe demand on a weekly basis due to some unstable internal processes that don't allow us to do it daily, can I calculate STDEV week to week with the same formula or would this be incorrect? Much appreciated in advance!
Please provide the formula for determining when to reorder the stock? I understood about the quantity below which order to be placed but how to calculate the number of days in which new order to be placed?
@@CalonHeindel I already watched that video but I am interested in knowing the number of days formula based on current stock for reordering purpose. In your video only quantity calculation is given
@@spat21 that all depends on your supplier. If you order materials and it takes on avg 5 days to get to you, then your number would be 5. It just depends how long that takes.
Thanks for the video. I was wondering why if our daily needs below 10 for example (Day 1 = 9, Day 2 = 8, Day 3 = 7, Day 4 = 10, and so on....), safety stock would be 7 with the lead time of 7 days. If the result of the safety stock is 7, isn't it too late to reorder at the point of the safety stock of 7? Thanks
Right so since your standard deviation is so small you don’t need as much safety stock. Generally you would order before you reached safety stock levels, so it wouldn’t be too late. You’d get new inventory before that. I have another video on Re-order point and economic order quantity, that would explain that for you.
@@CalonHeindel thanks for the reply :) so what figure would I use for the LT if this is in weeks and an item has a 9 day LT? im looking at somthing thats square root of the PC/T and is confusing me
I totally get the part where u multiply Zscore with standard dev. But i dont understand the logic why u have to multiply ot with square root of lead time? Can you explain it? Thank you so much
So there are two main formulas used when calculating safety stock. The more accurate in my opinion is the "kings method". This is the method shown in the video. This is used when demand is less certain, which I think is fair to assume on most occasions.
Is the number in the formula formatted as a percentage? If you put your service level less than 50% it’ll be negative. You shouldn’t aim for a service level that low normally.
Can you spot the spelling error?
It should be Safety instead of Saftey
@@queryhsje7514 Haha you got it!
Great Video. I've been working on inventory analysis for years and never knew about the normsimv function. Have always used the VLookup function. This is so much easier. Extremely helpful, and thanks for the video.
Love to hear this video helped you out in some way! That’s way cool!
😂 a 6:04 😮
Extremely helpful. Great explanation alongside step by step instructions. Thank you!
Glad this video was helpful for you! Appreciate the support!
thank you so much and i have some question. what if there is non stable lead time how can i manage it?
In university it's taught as:
ss = ROP - D x L
Where ss is Safey Inventory
ROP is Reorder Point
And D x L is Expected demand during lead time
There are two main formulas for calculating safety stock. The method I used in this video is used when demand is less certain, which I think is fair to assume. The equation you mentioned is the other main formula used. In the university I went to the formula I used was taught as more accurate. It was also the formula I used in my supply chain job.
Clear explanation. Excellent!
Thanks!
Can you give me the reference of the Safety Stock formula. I can't find any relating to this . Thank you !
How would you calculate safety stock after a downstream process in the same value stream? Would you calculate lead time from the beginning or from the previous safety stock?
What would be the calculation if we have weekly sales or monthly ?
Why to take sqrt of lead time?
Thanks a lot for the video! This is a really good explanation that helps me a lot. Could you advise if we observe demand on a weekly basis due to some unstable internal processes that don't allow us to do it daily, can I calculate STDEV week to week with the same formula or would this be incorrect? Much appreciated in advance!
You can calculate week to week. Everything just needs to be in like terms.
Good staff. How about slow moving goods? How to use Poisson function to calculate the safety stock?
Hi, Calon. It's great to see your video, but could you give me the references for the formulas you used?
Please provide the formula for determining when to reorder the stock? I understood about the quantity below which order to be placed but how to calculate the number of days in which new order to be placed?
I also have a video explaining how to calculate the reorder point. You can search reorder point and find that video on my channel
@@CalonHeindel I already watched that video but I am interested in knowing the number of days formula based on current stock for reordering purpose. In your video only quantity calculation is given
@@spat21 that all depends on your supplier. If you order materials and it takes on avg 5 days to get to you, then your number would be 5. It just depends how long that takes.
What is the logic behind square root of Lead time?
This accounts for standard error or standard deviation.
@@CalonHeindel can you please explain in detail. Thanks
Thanks for the video. I was wondering why if our daily needs below 10 for example (Day 1 = 9, Day 2 = 8, Day 3 = 7, Day 4 = 10, and so on....), safety stock would be 7 with the lead time of 7 days. If the result of the safety stock is 7, isn't it too late to reorder at the point of the safety stock of 7? Thanks
Right so since your standard deviation is so small you don’t need as much safety stock. Generally you would order before you reached safety stock levels, so it wouldn’t be too late. You’d get new inventory before that. I have another video on Re-order point and economic order quantity, that would explain that for you.
@@CalonHeindel Thanks for the explanation
Hi,
if this was in weeks, would the LT be 1 rather than 7?
It all needs to be in like terms. Just know if you use weeks, all values and calculations should also be in weeks
@@CalonHeindel thanks for the reply :)
so what figure would I use for the LT if this is in weeks and an item has a 9 day LT?
im looking at somthing thats square root of the PC/T and is confusing me
I totally get the part where u multiply Zscore with standard dev. But i dont understand the logic why u have to multiply ot with square root of lead time? Can you explain it? Thank you so much
So there are two main formulas used when calculating safety stock. The more accurate in my opinion is the "kings method". This is the method shown in the video. This is used when demand is less certain, which I think is fair to assume on most occasions.
I honestly dont remember how the formula is derived 100%. This is what I was taught at the university I went to and what I use in my supply chain job.
@@CalonHeindel thank you. Probably multiplying it with square root of lead time makes it more conservative 😂
@@HLYforever91 Makes sense to me hahaha
Why does my NORMSINV always return negative?
Is the number in the formula formatted as a percentage? If you put your service level less than 50% it’ll be negative. You shouldn’t aim for a service level that low normally.
Safety stock super cool stuff
Is it me or is the volume on this super low?
😘