Identifying the impact of time-varying demand

Objective

After completing this lesson, you will be able to understand known versus uncertain demand.

Fundamental Drivers of Safety Stock Requirements

Safety stock (SS) is based on:

  • Forecast error
  • Service level target

The forecast error is modeled by using a gamma distribution:

  • Gamma can be asymmetric or symmetric.
  • If symmetric, a normal distribution can be used.

Service level target can be expressed using:

  • Non-stockout probability
  • Fill rate

Inventory Replenishment Definitions

The impact of key drivers on inventory are:

  • Frequent versus infrequent review
  • Instantaneous replenishment versus planning for lead time
  • Known versus uncertain demand
  • Impact of time-varying demand

Z Factors Lookup Table

The following table shows target service level and z factors.

Z Factors Lookup Table

Target Service LevelZ Factor
50%0.000000
60%0.253347
70%0.524401
75%0.674490
80%0.841621
85%1.036433
90%1.281552
91%1.340755
92%1.405072
93%1.475791
94%1.554774
95%1.644854
96%1.750686
97%1.880794
98%2.053749
99%2.326348
99.9%3.090232
99.99%3.719016

Width of Distribution

In the following figure, the forecast for standard deviation impacts the width of the distribution.

The figure describes the Width of Distribution.

Example: Demand Variability with Instantaneous Lead Time

The following example shows a scenario with PBR = 1, a lead time of 0, a demand of 100 plus/minus 25, and a service level of 95%.

The figure describes the Demand and Service Level.

The initial on-hand value is 41 units, and the target inventory position (TIP) is calculated according to the formula given in the figure.

The figure describes the Demand and Service Level.

Next, the missing values for period 2 are derived.

The figure describes the Demand and Service Level.

The steps are repeated for periods 3 and 4, and the average is calculated.

The figure describes the Demand and Service Level.

Multiple Periods Create Risk Pooling Opportunity

Assume the distributions in two consecutive periods is given in the following figure.

The figure describes the Risk Pooling Opportunity

Risk Pooling Opportunity

Risk pooling can reduce the total risk and insecurity by combining different individual risks and insecurities, as shown in the following figure.

The figure describes the Risk Pooling Opportunity .

Example: Demand Variability, PBR = 1, LT =2

The following example shows a scenario with PBR = 1, LT = 2, NSP = 95%, and a demand of 100 plus/minus 25. The value for target inventory position (TIP) is calculated as shown in the figure.

The figure describes the Safety Stock and Inventory Position

The initial on-hand value is 72 units and the initial planned receipts is 100 + 100 units. The values for the subsequent periods are calculated according to the table in the figure.

The figure describes the On-Hand Inventory.

The values for the different subsequent periods are calculated by repeating the steps. Finally, an average is determined.

The figure describes the Demand and Replenishment.

Safety Stock Usage

To further characterize and define safety stock, two questions are important:

  1. How often do situations occur in which the safety stock is needed at all?

  2. In how many of these cases is the amount of safety stock not sufficient to satisfy the requirement?

The figure describes the Safety Stock Usage.