How to Calculate EOQ (Economic Order Quantity)
Q - Can you tell me what calculation is used in Elliott for EOQ (economic order quantity)? Is this something that can be modified? Can it be added to our ATP report?
A - EOQ - This field is not a calculated field, although you may modify it for your reasonable quantity. The following is the explanation from Elliott manual about "Economic Order Quantity".
"It may be beneficial to purchase this item in large enough quantities that the cost of repeatedly ordering it is minimized. At the same time, you will want to keep the dollar value of inventory as low as possible in order to minimize carrying costs. The quantity of the item to order that best balances these factors is called the Economic Order Quantity. This value is not calculated by the package. You should determine, based on your experience, what this quantity should be and enter it here."
EOQ is already on the ATP Summary Report and Reordering Advice Report (User Defined CSV Export).
Related Articles
Feature - ATP Regen to Consider Order Multiple and Economic Order Qty
Release Date: 03/09/2016 Revision Date: 01/20/2021 Version: 8.5 & Up When running the ATP Regen to create plan orders, the program only creates enough plan order quantity to make sure there will be no negative inventory in the future. The program ...Change - Price Recalculation When Quantity Changes
Release Date - 6/25/18 A change was made to how prices are recalculated on the Order Line Item screen in Order Entry. When you first enter a line item: The system will calculate the proper unit price based on price codes on file. If the calculated ...Feature - Sales Order Import ATP Quantity Warning
Release Date: 6/17/19 Version: 8.2 and Up Sales Order Import gives the user warning messages in some situations when the quantity ordered is greater than the quantity available. This feature gives the user the ability to also give a warning if the ...Feature - Calculate Order Total Sales Amount for Open Non-Picked Orders
Release Date - 2/20/19 This feature gives the user the ability to calculate the Order Total Sales Amount. This ability has been added to the Order Integrity Check utility program. It is available from Global Setup-> Utilities-> COP Utilities-> ...Item Quantity Allocated Is Not Updated
Release Date: 12/6/2019 Version: All Q - Dear Netcellent Support -- Upon entering an order the item file is not updating (in some instances) the quantity allocated field. We have run a reset but this does not resolve the issue. Can you advise? A - ...