What Is Economic Order Quantity (EOQ)?
Economic Order Quantity (EOQ) is the optimal order quantity that minimizes your total inventory costs, which include both ordering and holding expenses. It's a strategic calculation for Shopify merchants to find the sweet spot where the cost of placing new orders perfectly balances the cost of storing inventory. By optimizing order quantities, businesses can reduce unnecessary expenses, improve cash flow, and prevent excess stockouts or overstock situations.
Understanding EOQ helps you make data-driven decisions about purchasing inventory. Ordering too little leads to frequent orders, higher ordering costs, and potential stockouts. Ordering too much inflates holding costs, ties up capital, and increases risks of obsolescence. The EOQ model provides a precise quantity that achieves the lowest possible combined cost for managing your inventory over a year.
Economic Order Quantity (EOQ) Formulas
The core of EOQ lies in a straightforward formula that balances your demand with your fixed ordering and variable holding costs.
Economic Order Quantity (EOQ)
EOQ = √(2DS/H)
Where:
* **D** = Annual Demand (total units sold per year)
* **S** = Ordering Cost per Purchase Order (cost to place one order)
* **H** = Holding Cost per Unit per Year (annual cost to store one unit)
**Total Annual Inventory Cost (at any Order Quantity, Q)**
Total Annual Cost = (D/Q * S) + (Q/2 * H)
Where:
* **D/Q * S** = Total Annual Ordering Cost (number of orders * cost per order)
* **Q/2 * H** = Total Annual Holding Cost (average inventory * holding cost per unit)
At the EOQ, your total annual ordering costs will exactly equal your total annual holding costs, leading to the absolute lowest total annual inventory cost.
---
## How to Use This Calculator
This Economic Order Quantity (EOQ) calculator helps you pinpoint the most cost-effective order quantity for your Shopify products. Here's how to get the most accurate results:
1. **Enter Annual Demand:** Input the "Total units sold per year for this product." This should be your historical sales data or a reliable forecast.
2. **Enter Ordering Cost:** Provide the "Cost to place one purchase order — includes admin, communication, receiving, and QC time." Be realistic about the time and resources involved in managing a single order from your supplier.
3. **Enter Unit Cost:** Input the "Cost per unit (COGS from supplier)." This is the cost you pay your supplier for each individual item, not your selling price.
4. **Enter Holding Cost %:** Specify the "Annual holding cost as % of unit cost. Includes storage, insurance, capital cost, shrinkage. Typically 20-30%." If your unit cost is $10 and holding cost is 25%, the calculator uses $2.50 as the annual holding cost per unit.
5. **Enter Lead Time (Days):** Input the "Days from placing a PO to receiving inventory." This is crucial for calculating your reorder point, though it doesn't directly affect the EOQ formula.
6. **Enter Selling Price:** Input the "Selling price per unit — used for revenue projections." While not part of EOQ, it helps contextualize the financial impact and calculate potential revenue if you avoid stockouts.
7. **Enter Current Order Qty:** Input "Your current typical order quantity — used to compare vs EOQ." This allows the calculator to show you the direct savings you could achieve by switching to the EOQ.
> Hover over the **?** icon next to each field for a detailed explanation of what to enter. The calculator dynamically updates, showing your optimal EOQ, projected annual costs, and potential savings in real-time.
---
## Step-by-Step Example
Let's optimize inventory for a popular line of custom-printed t-shirts sold on a Shopify store.
Here are the key inputs:
* **Annual Demand (D):** 2,400 units (200 units/month)
* **Ordering Cost (S):** $75 per purchase order
* **Unit Cost (COGS):** $12.00 per t-shirt
* **Holding Cost %:** 25% of unit cost (which means $3.00 per unit per year for holding)
* **Lead Time Days:** 14 days
* **Selling Price:** $28.00 per t-shirt
* **Current Order Quantity:** 300 units
Using the EOQ formula:
`EOQ = √(2 * 2400 * 75 / 3.00)`
`EOQ = √(360,000 / 3.00)`
`EOQ = √(120,000)`
`EOQ ≈ 346.4 units`
Let's round this to **346 units** for practical ordering.
Now, let's compare the total annual inventory costs:
| Metric | Current Order Quantity (300 units) | EOQ (346 units) |
| :------------------------------ | :----------------------------------: | :-----------------------: |
| Annual Demand (D) | 2,400 units | 2,400 units |
| Orders per Year (D/Q) | 2,400 / 300 = 8 orders | 2,400 / 346 = 6.94 orders |
| Annual Ordering Cost (D/Q * S) | 8 * $75 = **$600.00** | 6.94 * $75 = **$520.50** |
| Average Inventory (Q/2) | 300 / 2 = 150 units | 346 / 2 = 173 units |
| Annual Holding Cost (Q/2 * H) | 150 * $3.00 = **$450.00** | 173 * $3.00 = **$519.00** |
| **Total Annual Inventory Cost** | **$1,050.00** | **$1,039.50** |
| **Annual Savings** | — | **$10.50** |
While the savings of $10.50 might seem small for a single SKU, consider a Shopify store with 50 such SKUs. This would translate to over $500 in annual savings on inventory management costs, directly impacting your net profit. This example clearly shows how slightly larger, less frequent orders (EOQ) can slightly increase holding costs but significantly reduce ordering costs, leading to a net saving.
---
## EOQ in the Real World: Beyond the Formula for Shopify Stores
While the EOQ formula provides a powerful theoretical baseline, real-world e-commerce, especially on Shopify, introduces variables that require practical adjustments.
**1. Demand Variability & Seasonality:** EOQ assumes constant demand, which is rarely true for e-commerce. Seasonal products (e.g., holiday decor, summer apparel) or those affected by marketing campaigns will see demand spikes and troughs. For these, use EOQ as a baseline, but strategically increase order quantities before peak seasons and reduce them during slow periods. Our [Inventory Turnover Calculator](/tools/inventory-turnover-calculator) can help you monitor how efficiently you're moving seasonal stock.
**2. Supplier Constraints:**
* **Minimum Order Quantities (MOQs):** Many suppliers impose MOQs. If your calculated EOQ is 163 units but the supplier's MOQ is 200 units, you'll need to order 200. As discussed in the FAQ, EOQ is robust, and ordering slightly above the optimum usually results in minimal cost increase.
* **Volume Discounts:** Suppliers often offer price breaks for larger orders. The basic EOQ model doesn't account for this. If a discount on a larger order significantly reduces your unit cost, it might be more profitable to order above EOQ. You'll need to calculate the total cost for each price break quantity to find the true optimum.
**3. Lead Times and Safety Stock:** EOQ tells you *how much* to order, but not *when*. Your lead time, combined with demand variability, dictates your [Reorder Point](/tools/reorder-point-calculator) and necessary [Safety Stock](/tools/safety-stock-calculator). Ignoring these can lead to costly stockouts, even if you're ordering the EOQ quantity. For fast-moving items or those with unpredictable supply, investing in safety stock might be more crucial than strictly adhering to EOQ for every order.
**4. Product Life Cycles:** For trendy or rapidly evolving products, a strict adherence to EOQ might lead to accumulating obsolete inventory. Prioritize smaller, more frequent orders for these items to reduce obsolescence risk, even if it means slightly higher ordering costs.
**5. Top SKUs vs. Long Tail:** Many Shopify brands apply EOQ rigorously to their top 20% of SKUs (the 80/20 rule), which drive the majority of revenue and profit. For less critical "long-tail" products, simpler inventory rules or even dropshipping might be more efficient, reducing the analytical overhead.
EOQ is a starting point for intelligent inventory management, not a rigid rule. Use its insights as a foundation, then adapt your strategy to the dynamic realities of your Shopify store and supply chain.
---
## Understanding Your Inventory Costs: Typical Ranges for Shopify
Accurately estimating your ordering and holding costs is critical for a meaningful EOQ calculation. Here's a deeper dive into what these costs typically entail for Shopify merchants.
**Ordering Cost (S): The Price of Replenishment**
This is not the cost of the goods themselves, but the administrative and logistical expenses incurred each time you place a purchase order.
* **Staff Time:** Processing a PO, communicating with suppliers, tracking shipments, and handling invoices can take 1-3 hours of staff time. At $25-$50/hour, this is **$25-$150** per PO.
* **Supplier Communication:** Emails, calls, and follow-ups.
* **Receiving & Inspection:** Unloading, counting, checking for damage, and moving stock to storage.
* **Quality Control (QC) Checks:** Time spent inspecting a sample of goods.
* **Payment Processing:** Bank fees for international transfers, credit card fees for large purchases.
* **Fixed Shipping Fees:** Any flat rate or base shipping charge per order, regardless of quantity.
Typical ordering costs for Shopify stores can range from **$25 to $150 per PO**. Higher ordering costs push your EOQ towards larger, less frequent orders to amortize that fixed cost over more units.
**Inventory Holding Cost (H): The Burden of Storage**
This is the annual cost of keeping one unit of inventory in your possession. It's often expressed as a percentage of the unit cost and can vary significantly.
* **Warehouse Rent/Space Allocation:** This is the physical cost of storing the item. For a small item, this might be negligible, but for bulky goods, it's substantial. (Typically **6-10%** of unit cost annually).
* **Insurance:** Protecting your inventory against damage, theft, or loss. (Typically **1-3%**).
* **Capital Cost/Opportunity Cost:** The money tied up in inventory could be earning interest elsewhere or invested in marketing. This is often the largest component. (Typically **8-15%**).
* **Shrinkage & Obsolescence:** Loss due to damage, theft, expiration, or becoming outdated. (Typically **2-5%**).
* **Handling Costs:** Moving inventory within the warehouse, basic maintenance. (Typically **1-3%**).
Overall, inventory holding costs typically fall between **20-30% of the unit cost per year**. So, a $20 unit with a 25% holding cost incurs $5.00 in annual holding expenses. Higher holding costs favor smaller, more frequent orders to reduce the amount of capital tied up and storage space consumed.
---
## 7 Practical Tips to Optimize Inventory for Shopify Merchants
Optimizing your inventory isn't just about calculations; it's about integrating smart practices into your Shopify operations.
1. **Negotiate Smartly with Suppliers:** Don't just accept MOQs. If your EOQ is slightly below an MOQ, try to negotiate a small deviation, or propose a bundled order for several SKUs to meet a higher minimum while still optimizing individual quantities. Request lead time transparency and explore volume discounts, which may justify ordering above your calculated EOQ.
2. **Automate PO Generation & Tracking:** Use Shopify apps like Katana MRP, Stocky (Shopify's own inventory app), or third-party inventory management systems to automate purchase order creation based on sales velocity and reorder points. This significantly reduces your "Ordering Cost (S)" by minimizing manual staff time.
3. **Optimize Warehouse Space:** Analyze your warehouse layout (or 3PL usage). Efficient shelving, clear labeling, and dedicated pick-and-pack stations can reduce handling costs and potentially lower your "Holding Cost (H)" by maximizing existing space rather than needing more expensive square footage.
4. **Implement Robust Forecasting Tools:** Leverage Shopify's analytics, Google Analytics, and specialized forecasting apps to predict demand spikes and dips. Tools that integrate with your sales data can refine your "Annual Demand (D)" input, making your EOQ more accurate for future planning.
5. **Batch Inbound Shipments:** If you order multiple products from the same supplier, try to batch them into a single, larger shipment. This amortizes the fixed shipping component of your "Ordering Cost (S)" across more units, reducing the per-order impact and increasing efficiency.
6. **Review Underperforming SKUs:** Regularly use your [Sell-Through Rate Calculator](/tools/sell-through-rate-calculator) to identify slow-moving or stagnant inventory. For these items, prioritize clearing existing stock rather than placing new EOQ orders, even if it means temporary markdowns. This frees up capital and reduces ongoing holding costs for products unlikely to sell at full price.
7. **Optimize Safety Stock Strategy:** EOQ ensures you have enough *average* stock, but doesn't protect against unexpected demand surges or supply delays. Pair your EOQ calculations with our [Safety Stock Calculator](/tools/safety-stock-calculator) to determine the right buffer for your top-selling items, balancing the cost of holding extra stock against the potential revenue loss from stockouts.
---
## Frequently Asked Questions
### What is Economic Order Quantity (EOQ)?
Economic Order Quantity (EOQ) is the optimal order quantity that minimizes total inventory costs, which is the combined sum of ordering costs and holding costs. The formula is EOQ = √(2DS/H), where D represents annual demand, S is the ordering cost per purchase order, and H is the holding cost per unit per year. When you order at the EOQ, your annual ordering costs are designed to exactly equal your annual holding costs, resulting in the lowest possible total inventory management cost for that product.
### What is ordering cost in the EOQ formula?
Ordering cost is the total cost incurred each time you place a single purchase order, distinct from the cost of the goods themselves. This includes expenses like staff time for processing the order ($15-$30 per hour), communication with your supplier, the labor involved in receiving and inspecting the inventory upon arrival, quality control checks, and any fixed fees associated with payment processing or initial shipping. Typical ordering costs for Shopify merchants generally range from $25 to $100 per purchase order. Products with higher ordering costs benefit from larger, less frequent orders to spread this fixed expense across more units.
### What is inventory holding cost?
Inventory holding cost is the annual expense of storing one unit of inventory. This cost typically falls between 20-30% of the unit's cost and encompasses several components. These include your allocated warehouse rent or space usage (6-10%), inventory insurance (1-3%), the capital cost or opportunity cost of money tied up in stock (8-15%), losses due to shrinkage (theft, damage) and obsolescence (2-5%), and handling costs for moving stock within the storage facility (1-3%). For example, a $15 unit with a 25% holding cost has an annual holding expense of $3.75. Products with higher holding costs are better managed with smaller, more frequent orders to reduce storage burden and capital lockup.
### Does EOQ work for e-commerce businesses?
Yes, EOQ can be a valuable tool for e-commerce businesses, but it comes with specific considerations. The classic EOQ model assumes consistent demand and immediate inventory availability, which doesn't perfectly reflect the realities of online sales with seasonal spikes, promotional events, and variable supplier lead times. Shopify merchants should use EOQ as a foundational baseline, adjusting quantities for known demand fluctuations like holiday seasons. It's also crucial to factor in supplier-specific constraints such as Minimum Order Quantities (MOQs) and the financial benefits of volume discounts, which the basic EOQ formula does not account for directly. Many successful brands find it most effective to apply EOQ principles to their top-selling or most critical SKUs, while managing other products with simpler rules.
### How sensitive is EOQ to changes in inputs?
EOQ is surprisingly robust and forgiving when it comes to minor inaccuracies in your input data. The total cost curve for inventory management is relatively flat around the optimal EOQ point, meaning that even if you order 20% more or 20% less than the exact EOQ, your total annual inventory costs typically only increase by a modest 1-2%. This flexibility means you don't need perfectly precise figures for annual demand, ordering cost, or holding cost to still achieve near-optimal results. For instance, if your calculated EOQ is 163 units but your supplier mandates a 200-unit minimum order, the resulting cost difference will be minimal. The sensitivity table available in this calculator provides a clear illustration of how total costs fluctuate at various order quantities around the EOQ.
---
## About This Calculator
This Economic Order Quantity (EOQ) calculator was developed by [Luis Dev Studio](/about-us) specifically to assist Shopify merchants in optimizing their inventory management. It provides real-time calculations to help you find the most cost-effective order quantities, ultimately aiming to reduce your inventory expenses and improve profitability.
Need expert assistance with your Shopify store's inventory strategy or supply chain optimization? [Get in touch](/contact) for a consultation tailored to your business needs.