Order Quantity Calculator: How to Find EOQ

An order quantity calculator works out the optimal amount of inventory to purchase at one time, typically using the Economic Order Quantity (EOQ) formula. You enter your annual demand, ordering cost per order, and holding cost per unit per year, and the calculator returns the order size that minimizes total inventory costs. This article explains the formula, how to use it, and its real-world limitations.

Formula

The Economic Order Quantity (EOQ) is the order size that minimizes the sum of ordering costs and holding costs. The formula is:

EOQ = √(2DS / H)

• D = annual demand (units per year)
• S = ordering cost per order (dollars per order)
• H = holding cost per unit per year (dollars per unit per year)

The total annual inventory cost (TC) is the sum of ordering and holding costs:

TC = (D / EOQ) × S + (EOQ / 2) × H

At the EOQ, ordering cost equals holding cost, so TC = D × S / EOQ + EOQ × H / 2.

Worked Example

Using the calculator defaults (D = 1200 units/year, S = $50/order, H = $2/unit/year):

1. Multiply D and S: 1200 × 50 = 60,000
2. Multiply by 2: 2 × 60,000 = 120,000
3. Divide by H: 120,000 / 2 = 60,000
4. Take the square root: √60,000 ≈ 244.9 units

So the EOQ is about 244.9 units per order. The total annual cost is (1200 / 244.9) × 50 + (244.9 / 2) × 2 = 245.0 + 244.9 = $489.9 per year.

Why Use an Order Quantity Calculator?

Businesses face a trade-off: ordering too often increases ordering costs (paperwork, shipping, receiving), while ordering too much increases holding costs (storage, insurance, obsolescence). The EOQ model finds the sweet spot. It is widely used in retail, manufacturing, and wholesale operations to guide purchase decisions.

For example, a small hardware store selling 1,200 bags of cement per year, with a $50 cost to place an order and a $2 holding cost per bag per year, would order about 245 bags at a time. That means roughly five orders per year (1200 / 245 ≈ 4.9).

How to Choose Input Values

Accurate inputs are critical. Here are guidelines for each:

• Annual demand (D): Use historical sales data or forecasted demand. For seasonal products, use annual totals, not peak months.
• Ordering cost (S): Include all costs to place and receive an order: administrative time, delivery charges, inspection, and setup. Exclude the cost of the goods themselves.
• Holding cost (H): Include storage space, insurance, taxes, shrinkage, and the cost of capital tied up in inventory. Often expressed as a percentage of unit cost (e.g., 20–30% per year).

If you don’t know exact costs, start with estimates and refine over time. Many companies use a holding cost percentage of 20–30% of the unit value.

Common Mistakes and Misconceptions

One frequent error is mixing units: demand is annual, but ordering cost might be per month. Convert everything to the same time period (usually a year). Another mistake is using the purchase price of the item in the holding cost without multiplying by the holding percentage.

A common misconception is that EOQ is the “minimum order quantity� or that it must be a whole number. In practice, you round to a convenient number (e.g., 245 units) or adjust to a full case or pallet. The EOQ is a target, not a rigid rule.

Also, the EOQ formula assumes constant demand and instantaneous replenishment. If demand is highly variable or lead times are long, you may need a different model, such as the reorder point with safety stock.

Limitations of the EOQ Model

The basic EOQ formula relies on several simplifying assumptions:

• Demand is constant and known
• Ordering cost is fixed per order
• Holding cost is linear per unit
• No quantity discounts (price breaks)
• No stockouts or backorders
• Lead time is zero (or known and constant)

In reality, these assumptions often fail. For example, if a supplier offers a 5% discount for ordering 500 units instead of 245, the EOQ may not be optimal. You would need to compare total costs at the discount quantity. Similarly, if demand spikes seasonally, a fixed order quantity may lead to stockouts or excess inventory.

Alternatives to the Basic EOQ

When the basic model isn’t enough, consider these variations:

• Quantity discount model: Compares total costs at different price breaks to find the cheapest order size.
• Periodic review system: Orders a variable quantity at fixed intervals (e.g., every month).
• Reorder point with safety stock: Determines when to order, not just how much, by considering lead time and demand variability.
• ABC analysis: Classifies items by value to focus on the most important ones.

For most small to medium businesses, the basic EOQ is a good starting point. For complex supply chains, simulation or specialized inventory software may be needed.

Frequently Asked Questions

How do I calculate order quantity without a calculator?

Use the EOQ formula: EOQ = √(2DS/H). Plug in your annual demand (D), ordering cost per order (S), and holding cost per unit per year (H). For example, if D=1200, S=$50, H=$2, then EOQ = √(2×1200×50/2) = √60,000 ≈ 245 units.

What is the difference between EOQ and reorder point?

EOQ tells you how much to order each time, while the reorder point tells you when to place the order. The reorder point is typically calculated as (daily demand × lead time in days) + safety stock. Both are used together in inventory management.

Can EOQ be used for perishable goods?

Yes, but with caution. The basic EOQ assumes holding costs are linear and goods don’t spoil. For perishables, you may need to adjust holding costs to include spoilage or use a shorter planning period. In extreme cases, a just-in-time approach may be better.

What if my demand is not constant?

If demand varies, the basic EOQ may not be optimal. You can use an average annual demand, but consider adding safety stock. For highly variable demand, use a periodic review system or a dynamic lot-sizing technique like the Silver-Meal heuristic.

How do quantity discounts affect the EOQ?

Quantity discounts lower the unit price for larger orders, which can make a larger order size more economical. To evaluate, calculate the total cost (ordering + holding + purchase cost) at each discount level and choose the one with the lowest total. The basic EOQ ignores discounts, so it may suggest a smaller order than optimal.

Is EOQ the same as minimum order quantity?

No. EOQ is the cost-minimizing order size based on your costs. Minimum order quantity (MOQ) is the smallest amount a supplier will sell. If the supplier’s MOQ is larger than your EOQ, you must order at least the MOQ, which may increase costs.

Related

• Great Circle Calculator: Distance & Formula
• Great Circle Route Calculator: How It Works
• Gradient Slope Calculator: Find Slope & Angle

in d | Annual demand | units/year | 1200 | 0
in s | Ordering cost | $/order | 50 | 0
in h | Holding cost | $/unit/year | 2 | 0
out eoq | Economic Order Quantity | units | sqrt((2 * d * s) / h) | 1
out tc | Total annual cost | $/year | (d / eoq) * s + (eoq / 2) * h | 2