I have a sheet that simulates inventory levels at a store with deliveries for replenishment. I have the demand and leadtime be random so I am using conditions and INDIRECT multiple times.

A circular reference error has appeared and I cannot trace it to solve it as Excel is showing me 6 cells contributing to the circular computation! If I use a fixed value for leadtime (Column H), I have no issue. If I use the random one (Column J) which doesn't seem to be dependent on the required value of Net Stock (Column F), I get the circular reference.

Here is the Excel sheet:

https://www.dropbox.com/s/l829sndqgpr1977/circular ref.xlsx?dl=0

Can anyone please let me know how to fix it?