I have Capacity , On hand , Backorder, Need, Saeftystock quantities.
- For each period I Calculated the net need as (Capacity + On hand - Backorder - Need - SaeftyStock)
- What has been calculated at point 1 , needs to be carried over through the periods, with a maximum cap driven by Saefty Stock (so the carry over amount cannot be more than saefty stock value )
- Here below i put all the measure (Capacity , on hand , backorder , need , saefty stock) and i summarized by Available and Need with the difference shown as NET
- On the Expected Carryover is what i expect to get from a formula
- On the Carryover i set the formula suggested, but is not working as expected
Do you mind to help me in understanding what i'm missing? Thank you!