Avoiding Circular Dependency when Calculating Inventory Projection

I am soliciting forecast feedback from users for a product/location/futuredate combination and am trying to merge this feedback with an replenishment table to be able to show a month...