Skip to Content
0

Safety Stock MZ calculation

Oct 11, 2016 at 11:43 PM

126

avatar image
Former Member

Does safety stock method MZ uses the same formula as SZ? I believe only the difference between two is where do we maintain safety day's supply.

Formula for SZ and MZ: (Total demand in bucket/no of work days in bucket)*Safety Day's supply.

But I am not getting safety stock result as per above formula. PS screen shot below;

Macro

Looks like macro is just doing bucket wise cumulative sum in backward direction. Macro steps are same as SSP book.

Any clue where i am doing mistake? Also where can i find the macro calculation formula? If you see above macro steps, it's just a list of rows and doesn't explain where is multiplication or division?

Appreciate it.

sst.png (57.0 kB)
macro.png (13.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
R Brahmankar Oct 14, 2016 at 09:23 AM
1

Hello,

Please refer SAP KBA 1960757 Safety stock based on safety days' supply is incorrectly calculated

Normally, as in the standard SNP planning book, the key figure 'Workdays' is an auxiliary key figure. Imporing macro with auxiliary key figure to another data view may mess up the index of auxiliary key figures in the target data view (see SAP KBA 1805579), which causes the auxiliary key figure acting as macro function SAFETY_CALC()'s last parameter incorrectly filled. Normally, as in the standard SNP planning book, the macro that calculates the key figure 'Workdays' is assigned only to 'Start' group. When there is a customizing macro with property 'Do Not Initialize Auxiliary Table' unticked is set to default group, the key figure 'Workdays' will get cleard when the customizing macro is executed, which causes the safety stock incorrectly calculated when the next time macro function SAFETY_CALC() is executed

Best Regards,

R.Brahmankar

Share
10 |10000 characters needed characters left characters exceeded