An important part of running a business effectively is ensuring that you are getting the most value out of your storage and logistics costs. With so many micro-costs and variables involved in the supply chain, it can be difficult to know where to begin optimising the efficiency of your processes.
Thankfully, the Economic Order Quantity formula (EOQ) can help you find the ideal amount of inventory to send to and store inside a warehouse at any given time. Today, we’re taking a look at why eCommerce businesses should use this formula, how to calculate it, and how to optimise inventory levels in general.
In this article
Economic Order Quantity explained
Using the Economic Order Quantity formula can help you make data-lead decisions on how much inventory you have in the warehouse at any given time. The calculation is designed to help you reduce storage, buying, and shipping costs by only storing the ideal amount of stock over a specific period.
EOQ helps ensure you keep up with demand without paying for storage costs you don’t need.
The benefits of Economic Order Quantity
There are numerous ways the EOQ calculation can benefit your business. It helps you to find the ideal balance between having enough stock in place while keeping costs as low as possible. It’s particularly useful for businesses that shift large amounts of products, or those businesses that sell products with a fluctuating demand.
Here are some of the benefits of the Economic Order Quantity formula in more detail:
Reduce average cost of inventory
The more inventory you have inside a warehouse, the higher your costs will be. It’s far more than just the cost of storage though; with bigger inventory comes more variables, and a higher risk that stock gets damaged during transit, or sits on the shelf for too long.
How to achieve operational excellence in your eCommerce business
Operational excellence is a process that involves continuous improvement, ambitious goal setting, evidenced-based decision making, and clear accountability. Learn more in our latest guide.
An EOQ calculation can help reduce overall inventory costs by aiding you in preventing overstocking situations, while helping you to eliminate unnecessary risks.
Prevents items from going out of stock
Every time a product goes out of stock, your business loses money. It can be devastating if this happens to a popular product. By using the EOQ formula, you’re able to have a better grasp of how much inventory you need at all times to prevent stockouts, while not paying for unnecessary storage costs.
Helps you make better decisions
Running an eCommerce business is all about making those tough decisions. Using the EOQ can help you make better decisions based on a tried-and-tested method, rather than guesswork. The EOQ calculation makes good use of existing data to help you improve your operational efficiency and make better use of your resources.
Frees up cash
As an eCommerce business, much of your assets are held within your products. If you overorder products, you’ve spent cash unnecessarily and are missing out on the advantages of using it elsewhere. By only ordering and storing the optimal amount of goods, you can free up cash to spend on other areas of your business, such as marketing or customer service.
Data you’ll require to calculate your Economic Order Quantity
To calculate your EOQ, there’s a few bits of data you’ll need. Much of it is historical data, so the formula works best if you’ve been trading for at least a year. The longer you’ve been trading, the more accurate your calculations will be. Here’s the three bits of data you’ll need:
- Holding costs – your holding costs, or carrying costs, are made up of each cost associated with holding inventory. This includes storage costs, labour costs, fulfilment costs, total cost of inventory, insurances, and depreciation costs.
- Demand – the annual demand of your goods. To find this, look at your sales over the past year.
- Order cost – The typical cost associated with making an order. This will usually include any shipping, handling, and administration costs you incur when ordering goods.
With accurate data in your arsenal, you’ll be ready to calculate the formula.
The Economic Order Quantity formula
To calculate your EOQ, take your:
order cost (O)
holdings costs (H),
and place them into the following formula:
EOQ = square root of [2OD] / H
EOQ in practice
Let’s have a look at the EOQ formula using real numbers. Imagine that you’ve got an order cost of £300, a demand of 6,000 products per yet, and a holding cost of £0.45 per product. The formula would look like this:
EOQ = square root of (2 x 300 x 6000) / 0.45
Therefore, EOQ = 2828 units.
Factors that affect EOQ
It’s important to remember that the EOQ formula isn’t perfect, and results will vary depending on a number of factors. The EOQ formula has several assumptions, and its accuracy will diminish if these assumptions aren’t met.
Here are some factors that affect the EOQ formula:
The EOQ formula assumes that demand stays constant. If you have various peaks and troughs of demand throughout the year, you may find the calculation to be unreliable. Therefore, EOQ is more suitable for product lines that have steady, predictable demand throughout the course of the year. It isn’t particularly useful for seasonal products.
Some suppliers may offer discounts if you purchase in bulk quantities. The EOQ formula won’t account for this, so it may end up to be more cost-effective if you order more products than the EOQ recommends.
Continuing from the point above, one disadvantage of the EOQ formula is that it assumes that all costs are steady. Once again, it won’t take into account seasonal variations on inventory costs, shipping costs, geopolitical situations, and other events outside of your control.
While the formula itself isn’t particularly difficult, you will need to have a good understanding of data to use the EOQ formula effectively. Data calculations can be complex, and without a good competency in maths it may be difficult to work out sums accurately. There is, however, software to assist with these kinds of calculations.
Make EOQ a breeze with James and James Fulfilment
James and James Fulfilment are a 3pl provider specialising in eCommerce fulfilment. We store, pick, pack, and ship orders on your behalf, using state-of-the-art fulfilment technology to achieve industry-leading accuracy and speed. With an international network of fulfilment centres, we’re helping hundreds of eCommerce businesses reach new markets in an efficient, cost-effective way.
We also provide you with the tools you need to make accurate EOQ calculations. Our in-house software, ControlPort, presents you with all the data you’ll need to make accurate decisions, and all of your product lines can be managed directly through our software. We make it easy for you to ensure you have the right amount of stock in storage at the right time, and give you the power to make smarter decisions every day.
EOQ vs EPQ
Economic Production Quantity (EPQ) takes a similar concept to EOQ, however the calculation is made at the production stage, rather than the ordering stage. It is applied earlier in the supply chain to determine the optimal amount of products to be created on the production line.
EOQ vs MOQ
Minimum order quantity is a calculation that some businesses use to determine the minimum number of orders to be purchased at one time. This is required in order for businesses to remain profitable. It’s often used when businesses operate on small margins and require large order volumes to generate enough revenue to maintain their business.
What is the reorder point in relation to EOQ?
The reorder point is the time at which a new order is placed with the supplier. It’s often made automatically when the stock level of a particular product drops to a specified amount.