Order Quantity Replenishment Settings

The Order Quantity is a comparison of the adjusted usage during the review cycle and the Economic Order Quantity (EOQ) for the item. The greater of the two values is used for the order quantity, and the quantity is rounded to the next standard pack based on the Round up Order Quantity (ROQ) setting for the item.

The MIN / MAX replenishment model is achieved by setting the Order Point and Line Point values as desired and then setting Frozen Controls to all values with a Freeze Periods of 99.

Economic Order Quantity (EOQ)

Economic order quantity is used to optimize the order quantity based on the cost to place an order vs. the cost to carry the item. EOQ will never reduce the order quantity, but may increase the order quantity if it determined that it’s better to put more on the shelf and order it less frequently.

The EOQ calculation has been established and proven over decades of use, but it requires accurate R-Cost and K-Cost values, which are set in Replenishment Parameter F/M.

The EOQ is calculated as:

Economic Order Quantity
Average Usage is by Month
Multiply by 24 (2 * average usage per year is the EOQ formula)

The calculation of an appropriate Order Point / Line Point values per Item by Warehouse is instrumental to the AIM process. The factors of Lead Time, Vendor Review Cycle, Economic Order Quantity (EOQ), Average Sales Quantity (ASQ), Five-Hi and usage trending are factors in determining an accurate Order Point and Line Point set of values. The addition of daily transactional usage by warehouse and item combination allows these values to be updated to meet the current system state.

Order Quantity Minimums and Rounding Values

The Order Quantity Minimums and Rounding Values are listed below:

OQM for Trend Items ARP Vendor

OQM for non- Trend Items ARP Vendor

OQM for Trend Items ARP Transfer

OQM for non-Trend Items ARP Transfer

Apply Rounding to Order Quantity

Rounding Value for ARP Vendor

Rounding Value for ARP Transfer

Minimum Order Quantity for ARP Vendor

Minimum Order Quantity for ARP Transfer

Order Quantity Minimum (OQM) for Trend Items ARP Vendor

The Order quantity minimum for trend items for the approved replenishment path vendor is used in calculating order point. 

R Cost field specify the replenishment cycle cost The cost to process an order for an item.
K Cost field specify the cost to carry percent The annual cost to carry inventory divided by the average inventory value.
Minimum Days Supply field The number of days supply that the order quantity should always be.
Maximum Days Supply field The number of days supply that the order quantity should never exceed.
Use EOQ check box Indicates you want to apply the economic order quantity calculation.
Expiration Date The expiration date for the using the economic order quantity calculation if you have modified the scope of the parameter to narrow it from the company defaults.
Memo The optional memo for display and reporting purposes.

OQM for Non- Trend Items ARP Vendor

The Order quantity minimum for non-trend items for the approved replenishment path vendor is used in calculating order point.

R Cost field specify the replenishment cycle cost The cost to process an order for an item.
K Cost field specify the cost to carry percent The annual cost to carry inventory divided by the average inventory value.
Minimum Days Supply field The number of days supply that the order quantity should always be.
Maximum Days Supply field The number of days supply that the order quantity should never exceed.
Use EOQ check box Indicates you want to apply the economic order quantity calculation.
Expiration Date The expiration date for the using the economic order quantity calculation if you have modified the scope of the parameter to narrow it from the company defaults.
Memo The optional memo for display and reporting purposes.

OQM for Trend Items ARP Transfer

The Order quantity minimum for trend items for the approved replenishment path transfer is used in calculating order point.

R Cost field specify the replenishment cycle cost The cost to process an order for an item.
K Cost field specify the cost to carry percent The annual cost to carry inventory divided by the average inventory value.
Minimum Days Supply field The number of days supply that the order quantity should always be.
Maximum Days Supply field The number of days supply that the order quantity should never exceed.
Use EOQ check box Indicates you want to apply the economic order quantity calculation.
Expiration Date The expiration date for the using the economic order quantity calculation if you have modified the scope of the parameter to narrow it from the company defaults.
Memo The optional memo for display and reporting purposes.

OQM for non-Trend Items ARP Transfer

The Order quantity minimum for trend items for the approved replenishment path transfer is used in calculating order point.

R Cost field specify the replenishment cycle cost The cost to process an order for an item.
K Cost field specify the cost to carry percent The annual cost to carry inventory divided by the average inventory value.
Minimum Days Supply field The number of days supply that the order quantity should always be.
Maximum Days Supply field The number of days supply that the order quantity should never exceed.
Use EOQ check box Indicates you want to apply the economic order quantity calculation.
Expiration Date The expiration date for the using the economic order quantity calculation if you have modified the scope of the parameter to narrow it from the company defaults.
Memo The optional memo for display and reporting purposes.

Apply Rounding to Order Quantity

The Round up Order Quantity is the UM and quantity that the recommended purchase amount should be rounded up to, usually due to vendor policies.

Item F/M includes an option for “Use ROQ”. This option will round up the recommended order quantity for the item in the Buyer’s Control Center. The unit of measure to utilize is based on an available buying unit of measure for the item. If a quantity needs to be applied to the specified UM it can be indicated. The default quantity is 1 and must be an integer value for rounding. Additionally, the ROQ can be applied for warehouse transfers or ignored.

When indicated in the Item F/M, the ROQ for an item will be applied to the Recommended Quantity. Items that have been flagged as “Required” will remain in the BCC for processing unless remove by the buyer directly or a full Refresh is performed for the Vendor / Warehouse.

You can implement Round up Order Quantity parameters for the order quantity, ARP Vendors and ARP Transfers.

Apply Rounding on Purchase Order Indicates you want to round up to the recommended purchase amount.
Apply Rounding on Transfers Indicates you want to round up to the recommended transfer amount.

Rounding Value for ARP Vendor

Round to the next The amount to use to round the recommended order quantity to the next multiple of this quantity that the recommended purchase amount should be rounded up to, usually due to vendor policies
UM The unit of measure that the recommended purchase amount should be rounded up to, usually due to vendor policies

Rounding Value for ARP Transfer

Round to the next The amount to use to round the recommended order quantity to the next multiple of this quantity that the recommended purchase amount should be rounded up to, usually due to warehouse/item policies
UM The unit of measure that the recommended purchase amount should be rounded up to, usually due to warehouse policies

Minimum Order Quantity for ARP Vendor

Minimum Order Quantity The amount to round the suggested order quantity to if it falls below this minimum.
UM The buying unit of measure that the recommended minimum order quantity should be rounded up to
Expiration Date The expiration date for the using the minimum order quantity as the rounding value for the suggested order quantity.
Memo The optional memo for display and reporting purposes.

Minimum Order Quantity for ARP Transfer

Minimum Order Quantity The amount to round the suggested order quantity to if it falls below this minimum.
UM The buying unit of measure that the recommended minimum order quantity should be rounded up to
Expiration Date The expiration date for the using the minimum order quantity as the rounding value for the suggested order quantity.
Memo The optional memo for display and reporting purposes.

See Also

Entering Order Quantity Replenishment Parameters

Replenishment Parameter Maintenance Procedures

Replenishment Variables Calculations

Inventory Control Replenishment Parameters