My Client wants to calculate Order Quantity based on consumption Value. He will set a Re order Point if stock falls below this reorder point, based on consumption and lead time system should calculate order quantity in PR. He will also set minimum and maximum stock levels, maximum order quantity in PR should exceed maximum stock level.
Material : ABC,
Re order point : 20
Minimum Stock level : 10
Maximum Stock level : 100
if stock falls below the re order point i.e 20, based on consumption and lead time it should calculate order quantity in PR, even through system calculates order quantity more than maximum stock level based on consumption values, it should propose only maximum stock level i.e. 100.
Please provide me any solution for above scenario.