Safety Stock | Reorder Point ROP | Economic Order Quantity EOQ | Min Max Levels calculation in Excel

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

[@SD-un3ii]

Very good explanation, I am studying these topics. Could you please share this file so that I can get to make more clarity.
Thank you for such a nice explanatory video.

[@SittikornNoomKratsuwan]

Great!!

[@anisanisrina7278]

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?

[@venkatayatheshkumar5035]

Nice explanation sir, can you please share the format it is so useful for me

[@desireesanchez3880]

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?

[@stefangarnett4029]

How did you determine the standard cost?

[@83jatin]

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

[@sitmiacademy]

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.

[@mohamedgalal7414]

good job! how can we get this excel sheet? it is not available on google drive anymore

[@aliharb2102]

Great explanation sir !
Please can i have the excel template

[@micheelee6979]

i want to download this excel, but i don't have acess. would you help this? thanks

[@johnhatzigrigoriou8924]

Hi - great video. Can I get access to the file?

[@gagakhitam666]

sir, give me access for download this templete, thanks you so much!

[@karyawanwfh2350]

very interesting your explanation.
I sent a request for access to google drive download. please accept.. thx u

[@jyotimahara319]

Hi thanks for sharing
Pls allow access of file so we can able to project data

[@mtariqraheem1]

nice explained, please allow so that i can also download file, request has been sent

[@abdulaziz1982]

What is the logic behind the square root of lead time?

[@abdulaziz1982]

Can anyone help me with this

[@adareone]

I sent a request for this information. Please advise. Not sure if anyone else has access to the great information.

[@adareone]

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.

[@Durrii-wl6vy]

Experience

[@OwenLuan-f3p]

i want to download this excel, but i don't have acess. would you help this?