When you’re looking for overstock items with Reverse Planning, it’s possible to set up criteria as all or end criteria.
Let’s see how it works.
So, if we, in this template, looking for overstock items, and I have quite a few down here, and the criteria was highest inventory value, 25,000, end inventory value higher than 5,000, and I have no multiple of quantities up here.
Now if I select and as a criteria instead, both those criteria need to be fulfilled, and when I calculate now, of course, I would expect less items because they need to fulfill both criteria.
Likewise, I could have set an inventory value, it needs to be higher than 10,000 for instance, and I could have added order multiples up here.
So, for instance, my regular point times 1.2 should be fulfilled as well as a criteria.
And again, when I calculate with the end criteria, all of those criteria need to be fulfilled.
And now we have down to two items.
I could also use the lock functionality just to show you that it will, because I know one of those items has a planning flexibility none item, order line somewhere.
And this way I could filter on my criteria as being fulfilled, all of them to be a critical item or an overstock item I want to view.