Skip to Content
author's profile photo Former Member
0
Former Member
Jul 22, 2010 at 10:40 PM

SNP - Safety stock, target stock level, Days Suply, calculation / formula

892 Views

I am trying to understand how safety stock, target stock level and Days' Supply KFs in planning area are calculated. I mean, I have read SAP documentation and numerous threads about these, but none come close to what I am looking for - a simple to understand explanation.

We are using standard safety stock/target stock macros. In our product master, we have Safety days supply = 30, Safety stock level method = SZ, target days supply = 0, target stock level method = blank (meaning, use target days supply).

I would like to know, in simple english (or math or both) how the functions SAFETY_CALC & TARGET_CALC works (when you load a specific product & location in interactive planning.

Similary, how Days' supply COVER_CALC works.

Here is an example, for product P1 @ L1 location, which has same product master settings as mentioned above. I have pasted the screen in two parts here (first, + 18 months. M01 = 07/2010 & M18 = 12/2011 for the sake of this example.

I appreciate if some one can explain me in simple terms how 'Safety stock', 'Target stock level' and 'days' supply' KF values are derived as shown below. We do use standard default macros without any changes. thanks in advance.

-

INIT M01 M02 M03 M04 M05 M06 M07 M08 Total-Demand----
EA-2-- -189 1-- 67 -51 -8 --
Total-Receipts---- EA-146 -33 -110 129 27 -25----
Stock-on-Hand---- -EA-147 -0-- 100 162 138 155 155 155--155 Supply-Shortage-- -EA-0 -9 0 0 0 --
Stock-on-Hand---- -EA-147 -0-- 100 162 138 155 155 155--155 Supply-Shortage-- -EA-0 -9 --
Safety-Stock----
EA-0-- -30 -30 -30 -8----
Reorder-Point---- -EA-0 -0 0 0 0 --
Target-Days´-Supply-D----
Target-Stock-Level EA-0 -30 -30 -30 -8----
Days´-Supply----
D 24 0 50 -457 426 396 365 334--306 ATD-Receipts----
EA-3-- -0 80 -100----
ATD-Issues----
EA-2-- -189 1-- 29 -5----
-
M09 M10 M11 M12 M13 M14 M15-M16 M17 M18 Total-Demand----
EA----
Total-Receipts---- EA --
Stock-on-Hand---- -EA-155 155 155 155 155 155 155 155 155 155 Supply-Shortage-- -EA --
Stock-on-Hand---- -EA-155 155 155 155 155 155 155 155 155 155 Supply-Shortage-- -EA --
Safety-Stock----
EA----
Reorder-Point---- -EA --
Target-Days´-Supply-D----
Target-Stock-Level EA --
Days´-Supply----
D 275 245 214 184 153 122 92 -61 -31 ---- ATD-Receipts----
EA----
ATD-Issues----
EA----

-Bala