Economic Order Quantity Calculator

What is the Economic Order Quantity indicator?

Economic Order Quantity (EOQ) is the metric that tells you the best viable number of items you need to order to maintain sales most cost-effectively.

This indicator aims to find the balance between the stock value and the inventory management cost. 

Why is order quantity such a big deal?

For the companies that manage an extensive inventory of different items, it is costly to keep a high stock. It not only requires a lot of equity to be invested into the stock, but the high quantity of goods requires significant infrastructure in the form of the warehouse and the staff. 

Therefore most companies try to find optimal quantities of each particular item in order to maintain sales without driving costs too high.

Economic Order Quantities is a methodology for calculating the exact number of items the company needs to keep in stock in order to run the business with continuous product availability. 

How to calculate Economic Order Quantity?

EQQ takes into account the current sales performance in the form of annual demand for the product and costs related to transportation and warehouse management.

The economic order quantity formula

EQQ = (2 * Demand * Order_Cost / Holding_Cost)^(½)

Where:

• Demand - demand for this particular item for a given period.
• Order_costs - represents the total costs of bringing a single item to your warehouse
• Holding_costs - all the costs you need to cover while keeping items in stock

Take note that the actual purchase price of the products is not considered. The only costs that matter are transportation, product verification, and warehouse upkeep.

The demand is typically calculated for a year, but it could be calculated for a shorter period, for example, a quarter or even a month. 

This way, you will not only need to keep the stock for an entire year but will be able to consider the seasonality by calculating the demand using trends from the previous years. 

Orders costs comprise not only transportation costs but all the costs the company needs to cover in order to bring the goods and put them on the warehouse storage shelves. So apart from transportation, there are duty fees, transportation insurance, and even costs of delivery verification of your in-house staff. 

Holding costs should not only cover the warehouse rental but all the expenses required to keep the warehouse running, like electricity bills, staff, insurance, etc. 

Of course, tracking such costs per single item isn't easy. The common practice is to divide the total warehouse costs by available pallet spaces and then multiply the value by the number of pallets occupied by this particular item. For example:

Item_holding_cost = (Total_warehouse_costs / Total_pallets_spaces) * Used_Pallets

Depending on your accounting policy, you could calculate the costs of financing the stocks into the holding cost. 

Disadvantages of EOQ

Although EOQ is a simple and handy methodology, it has some limitations. 

1. For starters, it assumes that the demand will remain constant during the holding period. It is rarely the case due to seasonality, company growth, and market trends. You can address this by calculating Economic Order Quantity for shorter periods, but still, it is only an estimation.
2. The warehouse upkeep costs are also considered constant, but during times of high inflation, the costs may vary in time.
3. Since the purchase prices are not part of the EQQ formula, the wholesale discounts do not impact the calculation. It is crucial for some industries due to extensive discounts for high volumes. In many cases, discounts may strongly affect the viability of EOQ estimations. 

How to improve EOQ?

While the EOQ can be a useful indicator for inventory management, there are several ways to improve its accuracy and effectiveness:

1. Use accurate lead time data:
   The EOQ calculation requires accurate lead time data to ensure that the optimal order quantity is sufficient to cover demand during the lead time. Improving the accuracy of lead time data by tracking it over time and incorporating any changes or variations can improve the effectiveness of the EOQ.
2. Account for demand variability:
   The EOQ assumes that demand is constant and predictable, but in reality, demand can be volatile and unpredictable. To account for this, safety stock can be added to the EOQ calculation to ensure that the optimal order quantity is sufficient to cover unexpected spikes in demand.
3. Incorporate cost data:
   The EOQ formula accounts for the cost of holding inventory, but it does not take into account other costs associated with ordering, such as shipping or handling costs. Incorporating these costs into the EOQ calculation can provide a more accurate picture of the total cost of holding and ordering inventory.
4. Consider the batch size:
   The EOQ assumes that inventory is ordered and received in a single batch, but in reality, it may be more efficient to order inventory in smaller batches to reduce lead time and improve inventory turnover. Incorporating batch size into the EOQ calculation can provide a more accurate picture of the optimal order quantity.
5. Regularly preform the EOQ analysis:
   The optimal order quantity can change over time due to changes in demand, lead time, or other factors. Regularly reviewing and updating the EOQ calculation can ensure that inventory levels are optimized, and costs are minimized.

Summary

The right stock policy may enormously increase the company's profitability and net margin, which translates to a higher margin of safety. 

Authors

Created by Lucas Krysiak on 2022-06-11 12:57:31 | Last review by Mike Kozminsky on 2023-11-01 12:51:42