A Probability Distribution for Demand Variability

What is a good probability distribution to model fluctuating demand?  Is the Normal distribution applicable?  How can you estimate a probability distribution when history is unreliable?

Understanding demand variability is key to setting an inventory strategy.  Demand variability directly affects the safety stock calculation.  Demand variability and shelf life interact to affect production frequency, thus affecting cycle stock.  An accurate model of demand variability is essential, especially if you have products with limited shelf life that will lose value if demand is less than expected.

This is the second in a series of blogs on the topic of lot sizing to determine optimal batch quantity for production or ordering in uncertain times.  The first blog in this series covered the traditional methodology for Economic Lot Size (ELS).   Upcoming blogs will show how to integrate traditional ELS with the demand distribution covered in this blog and how to estimate a demand distribution when history is unreliable.

Continue reading

How Much is Enough -Without Being Too Much?

How much should I make when demand is uncertain? How much should I order?  How much is too much when inventory has a shelf life after which it is no longer usable or sellable? 

These are uncertain times.  For many industries, past sales are no longer valid in predicting future demand. At least not until the economy gets back to a new normal after the pandemic.  Demand is way down, or even completely gone in some industries (such as foodservice and travel).  Demand is way up or at record levels in other industries (such as PPE and cleaning products).

This is the first in a series of blogs on the topic of lot sizing to determine optimal batch quantity for production or ordering in uncertain times.  I’ll explore some of the historical methodologies and some of the newer philosophies.  My focus is on adapting these methodologies and philosophies for products with finite shelf life when demand is uncertain.

Continue reading