Video není dostupné.
Omlouváme se.
Safety Stock | Reorder Point ROP | Economic Order Quantity EOQ | Min Max Levels calculation in Excel
Vložit
- čas přidán 27. 08. 2023
- This Video Covers extensive information about. ·
Safety Stock | Reorder Point ROP | Economic Order Quantity EOQ | Min Max Levels calculation in Excel
Download Excel template for analysis of SS ROP EOQ Min Max -
docs.google.co...
Visit our website for learning online certification courses at sitmi.in/
Like our Facebook page for more knowledge resources / sitmiedu
SITMI Academy
Nice explanation sir, can you please share the format it is so useful for me
Hi, thank you for your explanation that's very clean and precise, I just wanna ask do you have any suggestion how if we want to adjust the abc xyz analysis result to this safety stock, rop, eoq format?
Hi good video, please elaborate how you are using the Z score, it was not very clear in you video why you are using 92% from some items and why 95% for other items. Also what is the explanation of why you are using the normal distribution table to arrive at the service level factor
Z score is a standard table which you can find on Google by searching "Normal distribution Z table".
Now why we took different service level is depending on us only. If your product has good and stable demand pattern then take more service level, If there is significant variation but products need to be stocked then take lower service levels. Service Level is the probability of fulfilling customer orders with service level percentage.
Why we use normal distribution table - Because that is standard formula across globe for safety stock and this is giving us how much probability of customer order we are expecting to fulfill. Obviously everyone wants 100% but with that service level higher stocks will be carried and cash will be blocked.
Tried to download the file but got an access denied message. I requested access but didn't receive a response. How can I get the download?
Great explanation sir !
Please can i have the excel template
very interesting your explanation.
I sent a request for access to google drive download. please accept.. thx u
good job! how can we get this excel sheet? it is not available on google drive anymore
Hi thanks for sharing
Pls allow access of file so we can able to project data
How did you determine the standard cost?
sir, give me access for download this templete, thanks you so much!
nice explained, please allow so that i can also download file, request has been sent
i want to download this excel, but i don't have acess. would you help this? thanks
i want to download this excel, but i don't have acess. would you help this?
What is the logic behind the square root of lead time?
Can anyone help me with this
I sent a request for this information. Please advise. Not sure if anyone else has access to the great information.
Thank you for providing access and sending, I have asked for access as the file does not provide any editing of the data. One question I have if our company does not use EOQ and suppliers have MOQ how do you factor that into your ordering? I would think you order at the MOQ to bring you back in to your Min/Max range.
Experience