SAP IBP - Leave Zero stock in Producing plant by auto adjusting Transport receipts

[kimon_stergakos]

I have a DC of AB01. It is supplied with from plant MW01. We have scenarios where our production planners enter a value in Production Receipts Adj Interactive greater than the Net Demand for AB01. In my example they enter 30,000 for March. This leaves a projected stock of 11,104 for March in MW01. For my requirement MW01 should never have any projected stock. Is it possible to have IBP automatically re-adjust the Transport Receipts/Supply to add the additional 11,104 cases that are part of the projected stock during the next supply run? I currently run Hueristic Infinite with no shortage.

The new MW01 Transport Receipts would be 18,759 + 11,104 = 29,863

The idea is when the planner puts in a higher number than the net demand the next supply plan run would adjust the Transport Receipts as above to bring the projected stock to zero.

[AyanBishnu]

Hi kimon.stergakos

Yes you can do this using KF calculation and using a setting in the S&OP operator for heuristic. Below are the steps

• Create a KF, lets say KF1@MTHPRODLOC = IF(PROJECTEDSTOCK@MTHPRODLOC > 0,PROJECTEDSTOCK@MTHPRODLOC,NULL).
• 
  
• Create 1 KF, lets say TSRATIODS@MTHPRODLOCLOCTO. Use attribute transformation to transform the value of the KF Location Sourcing Ratio which is @ MTHPRODLOCLOCFR.
• 
  
• Create another KF, lets say ZADJUSTEDTRANSPORTDS@MTHPRODLOCLOCTO = KF1@MTHPRODLOC * TSRATIODS@MTHPRODLOCLOCTO.
• 
  
• Create a copy operator to copy the value from ZADJUSTEDTRANSPORTDS to ADJUSTEDTRANSPORTDS
• Create 1 more heuristic profile in S&OP operator. Everything should be the same as your exisitng profile, only change the merger policy to "Downstream leading". and run that heuristics.

Hope this helps

[ganeshkini]

simple answer in this scenario would be to copy whatever is your production receipts to adj transport supply. This approach will only work when the the DC has only one source of supply. When there are multiple sources and lotsizes involved at the plant the logic to determine what needs to be produced become complex and not sure if there is a standard way to achieve in this case.

[piyush_parekh]

Hi,

I don't think there is an option available to auto-adjust transport receipt basis production receipts adjustments as you highlighted. Probably you can explore modeling it through key figure configuration for e.g., extending adjusted production receipt to downstream locations in transport receipt/supply adjustment key figures using transportation lanes.

Regards,

Piyush