5. Triangular and Exponential Distributions | Simulation using Excel

Поділитися
Вставка
  • Опубліковано 9 лис 2024

КОМЕНТАРІ • 3

  • @MotswanaTota-012
    @MotswanaTota-012 23 дні тому +1

    Thank you for the clear explanation. Well appreciated 😊

  • @ArockiaPraveen-dz2vb
    @ArockiaPraveen-dz2vb 6 місяців тому +2

    Can you kindly post a video of the safety stock calculation when the demand pattern doesn’t follow the normal distribution

    • @classicquants778
      @classicquants778  6 місяців тому +1

      You need to plot the distribution for the lead time demand and see where is the 95% line (suppose the service level is 95%). The left side of the curve to that line will be the safety stock. An easier method is to use normal approximation. For example, if the distribution is Possion with a mean λ, then use an approximate normal distribution of mean=λ and std dev=√λ. Then use this normal distribution to find safety stock.