Bookmark and Share Subscribe You may face visibility problem if http://docs.google.com is blocked on your network

Wednesday, December 3, 2008

Min-Max Planning

*For better visibility open pictures in new window.
Item DEV001 is min-max planned item with minimum quantity 20
If the quantity of DEV001 goes below 20 in FG subinventory then, user is going to take DEV001 from RM subinventory where huge stock for this item is maintained..
For this create an item in the Item Master. In the General Planning tab, selects the Inventory Planning Method as Min-Max. and source type as Sub-inventory.
In the Planning tab for the FG subinventory, specifies that the item DEV001 is Min-Max driven whenever it resides in FG. And whenever the quantity falls below the Min Qty of 20 in FG, it will be time for Min-Max to trigger replenishment.
The quantity of 400 is just the suggested quantity to maintain as the maximum on hand balance



In the Order Modifiers tab an opportunity is there to specify a Fixed Lot Multiple of 15. This implies that the quantity for replenishment will be suggested (calculated by the Min-Max algorithm) in multiples of 15. Minimum 30 items has to be ordered and maximum of 150 at a time.
There can be multiple order lines to reach Max Qty 400 (say 150+150+100). But the Fixed lot Multiple is 15, so order can’t be of 100 qty (100 is not a multiple of 15). Hence max level of 400 can be reached by orders of 150 +150+105 qty (Total 405).


Finally, in the Sourcing tab, mention that RM will be the sourcing subinventory.


Now checkout the on-hand for DEV001 in FG.


As the on-hand in FG for DEV001 is just 5 i.e. below minimum level of 20, it’s time to trigger replenishment.
The only task that is left is to run the Min-Max Planning report. This report serves to highlight items that need replenishment and also suggests the replenishment quantity based on the setup.
Unlike most reports, the Min-Max Planning report can also trigger the replenishment process. This means creating Pre-Approved Move Orders to fulfill the suggested replenishment quantity.
To launch the replenishment process, run the Min-Max Planning report with the parameter Restock set to Yes


The O/P of this report shows that Reorder Quantity as 405. This figure matches with the calculation given above. That indicates we are on the right track so far. As the report has Restock=Yes it must have generated pre-approved Move Order.




Search for the Move order created:


Here again above calculation proves it self. There lines got created to reach max qty level of 400.


Now just allocate (click on Allocate button) material for the lines and simply transact the same. If the item on line is serial/lot controlled the allocation must be done by clicking button View/Update Allocation button.
After Transact Move Order material must have reached to destination i.e. in FG sub-inventory.
Just checkout this:


Here the cycle gets completed….
Now user can consume material form FG sub-inventory and the replenishment will keep happening whenever stock comes below the specified level.
Similarly we can follow the cycle for the items which are purchased by selecting supply type as Supplier and so on….

Another wonder full article on Min Max planning is ... https://www.apps2fusion.com/apps/apps-training/801-min-max-plan-r12 and here example is of replenishing from different inventory organization

Keep practicing…. Keep blogging….

Please add your valuable feedback / comments

Declaimer:

This blog is purely personal and the thoughts expressed here represent only me. The purpose of this blog is to share information and knowledge about Oracle's product which I have come across with my exposure to the product, practice and observations. The blog has been created keeping only one intention of sharing knowledge and for learning purpose. The blog has been created solely as a educational, for storing portions of the vast Oracle knowledge world. Oracle EBS is an Oracle Corp. product and you should contact Oracle directly for any specific fact or issue.

*NOTE: Few articles on this blog are not completely prepared by me, content is edited and complied after referring various sites to make visitor's job easy