Previous | Next | Contents | Index | Glossary | Library |

Oracle Inventory performs min-max planning for your items at either the organization level or the subinventory level. When you min-max plan at the organization level, you can optionally include open sales orders and work in process component requirements as demand in the min-max planning calculation. Purchase requisitions for buy items and WIP unreleased jobs for make items for the suggested replenishment quantities can be optionally created. You can then turn these requisitions into purchase orders or internal orders and the unreleased jobs into jobs for the required items.

When you min-max plan at the subinventory level, you can optionally include only open sales orders as demand in the min-max planning calculation. Requisitions for the suggested replenishment quantities can be optionally created. Also, subinventory level planning cannot generate jobs and does not consider WIP jobs as supply or WIP components as demand. You can then turn these requisitions into purchase orders or internal orders for the required items.

To use min-max planning at the organization level you must set the item attributes used by min-max planning. You can start by setting the Inventory Planning Method item attribute to *Min-max planning*. You establish your minimum and maximum levels used in the calculation using the Min-Max Minimum Quantity and the Min-Max Maximum Quantity item attributes. You can optionally set the order quantity modifier item attributes (Minimum Order Quantity, Maximum Order Quantity, and Fixed Lot Size Multiplier) to further control the suggested order quantities generated by min-max planning. Set the Make or Buy flag to *Make* to optionally generate unreleased jobs and to *Buy* to optionally generate requisitions. See: General Planning Attribute Group.

For repetitive items, since you cannot generate repetitive plans, you have the option of generating requisitions, unplanned jobs, or a report only.

Min-max planning is performed by running the Min-Max Planning Report. By selecting organization level planning, you run min-max planning for your organization. In addition to the planning level option, Oracle Inventory offers the options to *Net Reserved Orders, Net Unreserved Orders, Net WIP Demand, *and* Include Non-nettable Inventory Quantities*** **when calculating availability. You also specify a *Demand Cutoff Date* and a *Supply Cutoff Date*. If you choose *No* to all the net demand options, Oracle Inventory performs the following calculation:

- Nettable Quantity on Hand + On Order = Total Available, where:

- Nettable Quantity on Hand is the sum of the quantities on hand for the item across all the nettable subinventories within your organization. Non-nettable quantities may optionally be included

- On Order is the sum of open purchase orders, requisitions, internal orders and work in process jobs scheduled for receipt on or before the Supply Cutoff Date

- If Total Available < Minimum Quantity, suggest a new order, where:

- Minimum Quantity is the value for the Min-Max Minimum Quantity item attribute.

- Order Quantity = Maximum Quantity - Total Available, adjusted for order quantity modifiers:

- Oracle Inventory revises the order quantity if necessary for the quantity to be a multiple of the fixed lot size multiplier

- The order quantity must be greater than or equal to the minimum quantity, or Oracle Inventory revises the quantity upward to the minimum

- The order quantity must be less than or equal to the maximum quantity, or Oracle Inventory revises the quantity down to the maximum.

- Nettable Quantity on Hand + On Order - Open Demand = Total Available, where

- Nettable Quantity on Hand is the sum of the quantities on hand for the item across all the nettable subinventories within your organization. Non-nettable quantities may optionally be included.

- On Order is the sum of open purchase orders, requisitions, and internal orders and work in process jobs scheduled for receipt on or before the Supply Cutoff Date

- Open Demand is the sum of unreserved sales orders, reserved sales orders, and WIP component demand scheduled for issue on or before the Demand Cutoff Date

- If Total Available < Minimum Quantity, suggest a new order, where

- Minimum Quantity is the value for the Min-Max Minimum Quantity item attribute.

- Order Quantity = Maximum Quantity - Total Available, adjusted for order quantity modifiers:

- Oracle Inventory revises the order quantity if necessary for the quantity to be a multiple of the fixed lot size multiplier

- The order quantity must be greater than or equal to the minimum quantity, or Oracle Inventory revises the quantity upward to the minimum

- The order quantity must be less than or equal to the maximum quantity, or Oracle Inventory revises the quantity down to the maximum.

The following example shows you how Oracle Inventory performs min-max planning. Assume an item has the following quantity values and item attribute settings:

- Nettable quantity on hand = 25

- Open supply quantity = 50

- Open reserved sales order quantity = 90

- Inventory planning method = Min-max planning

- Min-max minimum quantity = 100

- Min-max maximum quantity = 500

- Total Available: 25 + 50 = 75

- We assume that all the supply is within the supply cutoff date, for a supply total of 50

- Total available quantity is 75

- Below min check: 75 < 100

- The total available quantity is less than the min-max minimum quantity, so Oracle Inventory plans a new order

- Max quantity less total available: 500 - 75 = 425

- To bring the quantity available back to the min-max maximum, Oracle Inventory will plan an order for 425.

- Total Available: (25 + 50) - 90 = (-15)

- We assume that all the supply is within the supply cutoff date, for a supply total of 50

- We assume that all the demand is within the demand cutoff date, so open reserved orders total to 90

- Total available quantity is (-15)

- Below min check: (-15) < 100

- The total available quantity is less than the min-max minimum quantity, so Oracle Inventory plans a new order

- Max quantity less total available: 500 - (-15) = 515

- To bring the quantity available back to the min-max maximum, Oracle Inventory will plan an order for 515.

To perform min-max planning at the subinventory level, you establish the following values at the subinventory level using either the Subinventory Items or the Item Subinventories windows:

- Min-max minimum quantity

- Min-max maximum quantity

- Planning method set to Min-max planning

- Fixed lot multiple (optional)

- Maximum order quantity

- Minimum order quantity

- Item sourcing details

- Sourcing type (supplier or inventory)

- Sourcing organization (if type is inventory)

- Sourcing subinventory (if type is inventory) (optional)

- Lead times (optional)

Assigning Items to a Subinventory

- Quantity on Hand + On Order = Total Available, where:

- Quantity on Hand is the quantity in the subinventory you specified in the Min-Max Planning Report.

- On Order is the sum of open purchase orders, requisitions, and internal sales orders scheduled for receipt to the specified subinventory prior on or before the Supply Cutoff Date. Note that supply orders referencing a different subinventory, or with no subinventory specified, are not included

- If Total Available < Minimum Quantity, suggest a new order, where:

- Minimum Quantity is the value for the Min-Max Minimum Quantity set at the item/subinventory level.

- Order Quantity = Maximum Quantity - Total Available, adjusted for item/subinventory order quantity modifiers:

- Oracle Inventory revises the order quantity if necessary for the quantity to be a multiple of the fixed lot size multiplier

- The order quantity must be greater than or equal to the minimum quantity, or Oracle Inventory revises the quantity upward to the minimum

- The order quantity must be less than or equal to the maximum quantity, or Oracle Inventory revises the quantity down to the maximum.

- Quantity on Hand + On Order - Open Demand = Total Available, where

- Quantity on Hand is the quantity in the subinventory specified in the Min-Max Planning Report.

- On Order is the sum of open purchase orders, requisitions, and internal orders scheduled for receipt to the specified subinventory on or before the Supply Cutoff Date. Note that orders referencing a different subinventory, or with no subinventory specified, are not included

- Open Demand is the sum of open sales orders and inventory reservations scheduled to ship from this subinventory on or before the Demand Cutoff Date. Note that sales orders and inventory reservations referencing a different subinventory, or with no subinventory specified, are not included

- If Total Available < Minimum Quantity, suggest a new order, where:

- Minimum Quantity is the value for the Min-Max Minimum Quantity specified at the item/subinventory level.

- Order Quantity = Maximum Quantity - Total Available, adjusted for order quantity modifiers specified at the item/subinventory level:

The following example shows you how Oracle Inventory performs min-max planning. Assume an item has the following quantity values and item attribute settings:

- Quantity on hand for specified subinventory = 25

- Open supply quantity for specified subinventory = 50

- Open sales order quantity placed against specified subinventory= 90

- Inventory planning method at item/subinventory level = Min-max planning

- Min-max minimum quantity specified at the subinventory level = 100

- Min-max maximum quantity specified at the subinventory level = 500

- Total Available: 25 + 50 = 75

- The quantity on hand for the specified subinventory is 25

- We assume that all the supply is within the supply cutoff date, and is destined for our specified subinventory, for a supply total of 50

- Total available quantity is 75

- Below min check: 75 < 100

- The total available quantity is less than the min-max minimum quantity, so Oracle Inventory plans a new order

- Max quantity less total available: 500 - 75 = 425

- To bring the quantity available back to the min-max maximum, Oracle Inventory will plan an order for 425.

- Total Available: (25 + 50) - 90 = (-15)

- The quantity on hand for the specified subinventory is 25

- We assume that all the supply is within the supply cutoff date, and is destined for our specified subinventory, for a supply total of 50

- We assume that all the demand is within the demand cutoff date, and the sales orders are against our specified subinventory, so open sales orders total to 90

- Total available quantity is (-15)

- Below min check: (-15) < 100

- Max quantity less total available: 500 - (-15) = 515

- To bring the quantity available back to the min-max maximum, Oracle Inventory will plan an order for 515.

Previous | Next | Contents | Index | Glossary | Library |