Page tree

What is Safety Stock ?


“A quantity of stock planned to be in inventory to protect against fluctuation in demand or supply”


The formula of Transformation Center is the following:



The Safety Stock is calculated following the 3 main steps below:


  1. Calculate Safety Stock based on Demand Variability formula (k * σWD  * √RLT)
  2. Calculate proportion to past demand average during RLT => Safety Stock based on past/Average Past Demand during RLT
  3. Apply proportion to the future demand average during RLT => For each month, calculate the future demand during RLT

Then the last result in step 3 is reworked with the Safety Stock matrix below, following the Variability and the Usage of the item.





REMARKS:

> To calculate the Demand Variability and the Average Past demand, we look at the actual demand (Internal + External) on the last 108 weeks based on the last requested GI date. Data come from the following BW Query:

BW_QRY_MVSDSO56_0002 /  Historical Data - Sales & Purchase Orders

> Variability is calculated with the following formula:

Coefficient of Variation (COV) = (Demand Variability / Demand Average) * 100

Then the Variability is determined as:

  • Low (X) if the CoV is below 50%
  • Medium (Y) if the CoV is between 50% and 100%
  • High (Z) if the CoV is above 100%

> Usage is determined following the number of weeks with demand, out of the last 108 weeks

Usage is:

  • Low (L) if the number of weeks with demand is below 10
  • Medium (M) if the number of weeks with demand is between 10 and 35
  • High (Z) if the number of weeks with demand is above 35






Additional functionalities:

There is as specific view that used for 2 additional functionalities that will impact Safety stock. 

This view is accessible through the shortcut named "P&I - Weekly past demand"

> It is possible to unselect specific weeks from the calculation of these datafields but this action is not supported by TC as it should include all 108 weeks. You can do so by ticking / unticking the box called "Past weeks" in the view above.

> For TS exclusively: it is possible to only consider External demand for the calculation of Past demand average and Past demand variability. You can do so by ticking / unticking the box called "Demand = External demand only" in the view above.

Be careful, if you tick this box, it will be at SKU level and it will also impact other data such as Past demand average (none zero) & Future demand which are used in Safety Stock & Cycle Stock calculations.






The Contractual Safety Stock


The contractual safety stock is an additional field, taken into account in the Target stock calculation. It is a manual datafield that will allow the planner to adjust the safety stock, by adding or removing quantities, month by month and item by item.

This field is located in the 11. Safety stock tab in the Dynasys data review workspace. 


The best way to get IT support is to use the new Service One Platform.