Stock Projection (Stock + Input - target)
If anyone can help me with this: I need to perform a stock simulation by inputting values, as you can see in Mar 24, I do not have enough to reach the Best Estimate (what I need is 261 to reach). But if I input 1000 in Feb-24, I would have 146 + 1000 = 1146. I need to subtract the target for February, which is 261, from this line item, so I'll have 888 + the new input in March, which is 100 = 988. Feb is good but March should be 998 and Apr 1227. I've tried various approaches, but I believe I need some assistance with this. Can anyone help?