min max planning demo
TRANSCRIPT
![Page 1: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/1.jpg)
VMI 11/16/2004Presented by: Suryanarayana Murthy Teegela
![Page 2: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/2.jpg)
Min-Max Planning 2
What is Min Max Planning?
specify minimum and maximum inventory levels for your items.
Minimum = “order point”.
Maximum = "order up to" .
When the inventory level for an item drops below the minimum, Oracle Inventory suggests a new purchase requisition or internal requisition to bring the balance back up to the maximum.
![Page 3: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/3.jpg)
Min-Max Planning 3
Purchase Requisition:- for Buy Items Item=Buy Source =Supplier Internal Requisition:- for Items Internal movements Item=Buy Source =Org/Subinventory
Inventory Level = (on-hand quantity) + (quantity on-order)
Where:On-Order Qty = open PO + Approved Requisitions
![Page 4: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/4.jpg)
Min-Max Planning 4
TIMING OF ORDERSInventory Level < minimum quantity
QUANTITY OF ORDERSOrder quantity = Maximum Qty – Inventory Level
Performed by running the Min-Max Planning report.Can perform at 2 levels:
Org Level : Uses item attribute planning modifiers
Subinventory Level : Uses values and parameters set at theitem/subinventory level.
![Page 5: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/5.jpg)
Min-Max Planning 5
SET UP
Item Attributes:Inventory ItemStockableTransactablePurchasedPurchasableList Price (if Buy item)Inventory Planning Method: Min-MaxMake or Buy: BuyMin-Max QuantityOrder QuantitySource: Supplier
![Page 6: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/6.jpg)
Min-Max Planning 6
![Page 7: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/7.jpg)
Min-Max Planning 7
![Page 8: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/8.jpg)
Min-Max Planning 8
![Page 9: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/9.jpg)
Min-Max Planning 9
Org Level Setup:In Item General Tab : EnterInventory Planning Method: Min-Max, Make or Buy: BuyMin-Max Quantity & Order QuantitySource Type : Supplier
![Page 10: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/10.jpg)
Min-Max Planning 10
Sub-Inventory Level Setup:
Values can be set using either the Subinventory Items or the Item/Subinventories windows:In Item General Tab : EnterInventory Planning Method: Min-Max, Make or Buy: BuyMin-Max Quantity & Order QuantitySource Type : Supplier
Go to Org Attributes in Organization AssignementGo to Tools: Item SubinventoriesMin Max Quantity set at Subinventory levelSourcing : Supplier
Note: Sub-Inventory Level setup overrides Org level controls of the item.
![Page 11: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/11.jpg)
Min-Max Planning 11
![Page 12: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/12.jpg)
Min-Max Planning 12
![Page 13: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/13.jpg)
Min-Max Planning 13
![Page 14: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/14.jpg)
Min-Max Planning 14
Min-Max Report:
Run Min-Max Report with following parameters:
Planning Level: Organization / SubinventorySubinventory: Select subinventory if planning level is subinventory
Item Selection: Items under min quantityItems: Select range of itemsDemand & Supply cut-off dates: default (system date) Restock: YES (creates purchase requisition)
Leave other parameters as their defaults
![Page 15: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/15.jpg)
Min-Max Planning 15
![Page 16: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/16.jpg)
Min-Max Planning 16
![Page 17: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/17.jpg)
Min-Max Planning 17
See the out put after report completed with normal
As parameter RESTOCK is set to ‘YES’ inventory creates Purchase Requisition in interface tables.
Open the view output of the completed report to see the details of replenishment of the item.
Minimum QuantityMaximum QuantityOn Hand QuantitySupply Quantity (Approved PRs + Purchased Orders)Available Quantity (On Hand quantity + Supply Quantity)Min Max Order QuantityReorder Quantity: Max Order quantity – Available Quantity
![Page 18: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/18.jpg)
Min-Max Planning 18
![Page 19: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/19.jpg)
Min-Max Planning 19
After PR is created and interfaced in Inventory, Go to Purchasing responsibility run request “REQUISITION IMPORT” with the following parameters:
Import Source: INV (Default)Group By: All (Default)Initiate Approval after ReqImport: Yes / NoYes indicates initiate approval process of sending PR for next level of approval.No Indicates won’t initiate approval process – User need to send it for approval manually.
Note: Request must run from purchasing user responsibility
![Page 20: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/20.jpg)
Min-Max Planning 20
![Page 21: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/21.jpg)
Min-Max Planning 21
After completion of request open the view output window to see the status of the Purchase Requisition.
Can see 2 kinds of messages1)Number of unapproved requisitions created = 1 2)Number of approved requisitions created = 1
Unapproved requisitions will be created if the user who imported requistion does not have sufficient approval limits.
Approved requisitions will be created if the user who imported requision does have sufficient approval limits.
These approval process will be initiated when ‘Initiate Approval after ReqImport’ Is set to ‘YES’ in parameter of ‘Requisition Import’ request.
![Page 22: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/22.jpg)
Min-Max Planning 22
![Page 23: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/23.jpg)
Min-Max Planning 23
After Requisition import is completed go to Requisition summary window to see the imported requisition.
![Page 24: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/24.jpg)
Min-Max Planning 24
![Page 25: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/25.jpg)
Min-Max Planning 25
“Purchase Requistions for re-orders are automatically created by the system on daily basis” can be achieved by using Concurrent Request scheduling process.
Schedule to run “Min-Max Report” on daily basis.
Submit Min-Max Report from SRS window and go to “Schedule” and select Run the job ‘Periodically’ to rerun every ‘1’ ‘day’ and enable check box of “increment date parameter each run” and submit the request.
Request will be scheduled to run every day with incremental data parameter, subsequently PRs will be created for reorder quantities of items under minimum quantity level.
![Page 26: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/26.jpg)
Min-Max Planning 26
![Page 27: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/27.jpg)
Min-Max Planning 27
After completion of scheduled Min-Max Report, schedule to run “Requisition Import” concurrent report.
Schedule to run “Requisition Import” on daily basis.
Submit Requisition Import Report from SRS window and go to “Schedule” and select Run the job ‘Periodically’ to rerun every ‘1’ ‘day’ and enable check box of “increment date parameter each run” and submit the request.
Request will be scheduled to run every day with incremental data parameter, subsequently PRs will be imported which are created against Min Max Report.
![Page 28: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/28.jpg)
Min-Max Planning 28
While scheduling the above reports optionally choose notification option to see the view outputs of the completed requests and their status.
Go to Options and select people under “Notify the following people”, it allows you to select N number of people for those you want to send the view outputs of these completed requests.
After completion of the request system will send a notification with URL to see the output of the completed request.
![Page 29: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/29.jpg)
Min-Max Planning 29
![Page 30: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/30.jpg)
Min-Max Planning 30
![Page 31: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/31.jpg)
Min-Max Planning 31
People under the ‘Notify the following people’ will receive a notification in their ‘Notification Summary’ after completion of every request.
![Page 32: Min Max Planning DEMO](https://reader033.vdocuments.us/reader033/viewer/2022050801/54faa1494a795956048b4aca/html5/thumbnails/32.jpg)
Min-Max Planning 32