# How to Best Use the Economic Order Quantity Calculator

## Executive Summary

• This is an introduction to EOQ calculator or EOQ formula calculator.
• We cover how to calculate Economic Order Quantity.
• We cover the Economic Order Quantity Calculator, EOQ Formula Calculator, and a Quantity Discount Model. ## Introduction to the EOQ Calculator or EOQ Formula Calculator

• Economic order quantity (EOQ) is one of the oldest formulas in inventory management.
• It was first developed by Ford W. Harris in 1913 (interestingly, as with the development of MRP, the originator of EOQ was not an academic).
• This EOQ calculator or EOQ formula calculator will allow anyone to calculate EOQ quickly. One can calculate EOQ in a spreadsheet for a large number of product location combinations.

## Reorder Quantity Formula

EOQ is one type of reordering quantity formula. Any reorder quantity formula can be used. All that has to occur is that the assumptions of the reorder quantity formula must be agreed to by the entity that intends to use it. Most software has a rather small number of options for its reorder quantity formula. However, when calculated externally, an entity can use any reorder quantity formula that it wants. It can then upload the results of the reorder quantity formula to their ERP or other supply planning system.

## EOQ for the Production Order Quantity or the Purchase Order Quantity

EOQ can drive production order quantity as well as procurement order quantity. The production order quantity then drives the purchase order for the finished good. But once the finished good production order quantity is determined, the bill of material can be explored to determine the purchase order quantity. One of the criticisms of EOQ is that the bill of materials is not exploded.

That is untrue as what are called requirements strategies can be set differently for every part of the bill of material. This is covered in my book on reorder point planning which is shown at the bottom of this article.

When companies search for a purchase order system or purchase order software

EOQ is not an adjustable formula; unlike the dynamic safety stock calculation, it cannot account for variability. Some have proposed that this means it cannot be used for more product location combinations (PLCs) with more variable demand history — and this is true — if the data provided to the EOQ is not periodically changed. Therefore, it must be periodically recomputed for the entire database.

This is the standard relationship between cycle stock and safety stock with a stable order quantity. The inventory is reduced by orders — hopefully only occasionally dipping into safety stock.

## Economic Order Quantity Calculator, EOQ Formula Calculator, and the Forecast Error

The higher the forecast error, the less use the EOQ value is. This is because was the forecast error increases, the likelihood that the quantity will be consumed declines.

However, this is not different from any other supply planning parameter. Supply planning parameters have the highest value when the forecast is most accurate.

## EOQ Calculator with Quantity Discount Model

If there are quantity discounts, the calculation below will not be accurate. For instance, the formula below may propose an EOQ of 184 units. If the price per each at this level is \$50, then this is a total cost of (184 * \$50) + 45 or \$9245.

If the quantity discount kicks it at 200 units and this discount is 15%, then 16 more units could be obtained for \$8538. This would be a missed opportunity. This can easily calculate EOQ for an individual item, but this cannot be systematized because supply planning applications do not have EOQ functionality or even step function min lot sizes.

This means that when you purchase a system, it will in almost all cases not have a quantity discount model as part of its EOQ functionality. It is easy to create a quantity discount model as part of your EOQ externally and then import the hard-coded EOQ values into the system. But normally calculating an EOQ with quantity discount model is not done. This is often seen as too much “work.” And rather than calculating things like EOQ with quantity discount model outside the system, there is a strong preference for many companies to use the software as is.

Rather than calculate EOQ, batching typically is handled by procurement as they are up to date on the volume discounts and will up the orders to meet the discount.

## How the EOQ Calculator Form Works

This form requires input to provide output for the Economic Order Quantity Calculator. However, it also has default values. You can change any input value and the rest of the formula — the output will change immediately. You can continue making changes, and the form will always update without having to press any button or refresh.

This calculator assumes that the location receives the entire order at one time. However, this assumption does not always hold. For the noninstantaneous receipt, EOQ calculator see this article.

Also, learn about the limitations of EOQ at this article.

## Conclusion

This is a way to calculate EOQ easily. The best way to calculate economic order quantity is normally in a system or a spreadsheet. One can calculate economic order quantity as one wishes and then upload the result to any supply planning system. There are many EOQ formulas and many ways to calculate EOQ that are different from the standard model. To calculate economic order quantity in a way that is different from the standard EOQ formula in ERP or other supply planning systems, to calculate economic order quantity is the way to go.

This page is provided to have a fast way to calculate economic order quantity and EOQ formula calculator online.

• ## Interested in Our Supply Planning Research?

The software space is controlled by vendors, consulting firms and IT analysts who often provide self-serving and incorrect advice at the top rates.

• We have a better track record of being correct than any of the well-known brands.
• If this type of accuracy interests you, contact us and we will be in touch.

## Order Sizing and Optimization

Order optimization is necessary in order to get the predicted value from ERP and other supply planning applications. The Brightwork MRP & S&OP Explorer does exactly this, and it is free to use in the beginning until it sees “serious usage.” It is permanently free to academics and students. See by clicking the image below: 