How to define custom formula-based segmentation for replenishment planning?

Summary:

Business has a requirement to have segmentation based on custom logics. The segments would be "A", "B", "C", "D". Where any item will fall in segment "A" if that item has transacted or has any movement for more than or equal to 5 months in horizon of 6 months irrespective of quantity or number of transactions. Similarly, if any item will fall in segment "B" if that item has transacted or has any movement in any 2 to 4 months in horizon of 6 months irrespective of quantity or number of transactions. And same goes for C - where item