sap ibp net requirement - simple calculation without using S&OP heuristic or copy operator

[jeanluchospital]

Hi,

I am trying to perform the type of calculation described in the question below

basically based on Initial Inventory, Demand, Safety Stock Requirement, Days of Supply Requirement, I want to calculate my replenishment plan and projected inventory...

This is a recursive calculation, as to determine the Replenishment of M, I need Inventory of M-1 and to determine Inventory of M I need replenishment of M and inventory M-1

So I get into the loop trap as well explained in the question below as well

Cycle found in the calculation chain of the key fi... - SAP Community

But there was no final answer to this... any one would have some solution?

see also attached example from excel

	March	April	May	June	July	August	September	October	November
PROJINVT0	150
PROJINV	150	130	90	120	90	60	40	65	40
DMD		20	40	80	30	30	20	30	25
SS		10	20	40	15	15	10	15	12.5
DOS		60	120	110	60	50	50	55	85
PROJSELLOUT		0	0	110	0	0	0	55	0

PROJINVOFFSET = IBP_PERIODSHIFT(PROJINV,1)
PROJINT = PROJINVOFFSET-( SS +DMD)
PROJSELLOUT = IF(PROJINT<0,0,MAX(PROJINT;DOS))
PROJINV = IF(PERIODID3 =$$PERIODID3CU$$-1,PROJINVT0,PROJSELLOUT +IBP_PROJINVOFFSET-DMD)

Many thanks for your help !

Jean-Luc

[Andrei_Lupu]

Hi @jeanluchospital,

Have a look at the solution I have provided here.

It is very similar to what you are trying to achieve:  period shifting and use of max.

Regards, 

Andrei 

[jeanluchospital]

hi Andrei, thanks for the hint... I feel indeed that the solution is in this direction but I am struggling to apply it to my example...

[jeanluchospital]

hi Andrei, thanks for the hint... I feel indeed that the solution is in this direction but I am struggling to apply it to my example... would that be too much to ask to apply this solution to my example ?

[Andrei_Lupu]

Hi @jeanluchospital, I will give it try, but can you amend the table and mention the Receipt and Inter values ? I see them mentioned in the formulas, but not in the graph.

[jeanluchospital]

To make it clear :

[jeanluchospital]

To make it clear | Metric | March | April | May | June | July | August | September | October | November | December | |------------|-------|-------|------|------|------|--------|-----------|---------|----------|----------| | PROJINVT0 | 150 | | | | | | | | | | | PROJINV | 150 | 130 | 90 | 120 | 90 | 60 | 40 | 65 | 40 | 40 | | DMD | | 20 | 40 | 80 | 30 | 30 | 20 | 30 | 25 | 60 | | SS | | 10 | 20 | 40 | 15 | 15 | 10 | 15 | 12.5 | 30 | | DOS | | 60 | 120 | 110 | 60 | 50 | 50 | 55 | 85 | 60 | | PROJSELLOUT| | 0 | 0 | 110 | 0 | 0 | 0 | 55 | 0 | 60 | PROJINVOFFSET = IBP_PERIODSHIFT(PROJINV,1) PROJINT = PROJINVOFFSET-( SS +DMD) PROJSELLOUT = IF(PROJINT<0,0,MAX(PROJINT;DOS)) PROJINV = IF(PERIODID3 =$$PERIODID3CU$$-1,PROJINVT0,PROJSELLOUT +IBP_PROJINVOFFSET-DMD)