Replenishment modeling with circular reference
Dear Anaplan Community,
I am facing a circular reference issue modeling replenishment calculation. For this specific client, their trigger condition to place an order is to evaluate below condition:
If I do not place an order today, will my projected end on hand (EOH) on this Item's ETA date fall below this item's safety stock? If yes, then I do need to place an order today to avoid such situation.
For example, if I have an item with lead time 3 days, then I am evaluating its projected end on hand in 3 days on daily basis to see whether I need to place an order on a specific day.
I have attached an Excel example for your reference.
The formula go like:
Beginning on Hand (BOH) = Loaded on hand (if it is Today) or previous EOH
On order from Oracle: loaded data from Oracle
New on order = Offset(Net Reorder Qty, Lead Time)
EOH = BOH + On order from Oracle (Orders placed and expected to arrive) + New on order (Anaplan suggested new orders offset by its lead time) - Demand
ETA EOH < SS? : Order triggering condition stated above
Net Reorder Qty (Net ROQ) = SUM of demand over lead time days after its arrival + ABS gap between BOH and SS on ETA date
You can see that there is a circular reference here where by my Net ROQ goes into on hands then goes into its recalculation again. In excel I am separating the steps so that I won't get circular reference error. But how I can model this efficiently in Anaplan? Any expert can shed light on this one? Much appreciated!