What is Lot Sizing Calculator?
▾
Lot sizing is the process of determining the optimal quantity to order or produce in a single batch — balancing the fixed cost of placing an order (setup cost, purchasing admin, minimum shipping fees) against the variable cost of holding inventory over time. The Economic Order Quantity (EOQ) is the most famous lot sizing formula, first derived by Ford Whitman Harris in 1913, and it remains one of the most widely applied formulas in supply chain management. An EOQ/lot sizing calculator helps buyers, planners, and production schedulers find the order quantity that minimizes total annual inventory cost — the sum of ordering cost and holding cost. Total cost is U-shaped as a function of order quantity: very small orders create frequent, high ordering costs; very large orders minimize ordering frequency but drive up holding costs. EOQ is the mathematical minimum of this curve. Beyond EOQ, the calculator also implements periodic-review lot sizing methods (POQ, Lot-for-Lot, Silver-Meal, Part Period Balancing) used in MRP systems for lumpy, time-phased demand. Key inputs are annual demand, ordering cost (cost to place one purchase order or setup one production run), and holding cost rate (annual cost of carrying one unit of inventory, typically 20–30% of unit cost). The calculator outputs optimal order quantity, optimal number of orders per year, optimal order interval, and total annual inventory cost. Sensitivity analysis shows how total cost changes if EOQ assumptions change.
DigiCalcs delivers precision-engineered tools for engineers and STEM professionals.
Formula
▾
EOQ = √(2 × D × S / H)
Where: D = Annual demand (units); S = Ordering/Setup cost per order; H = Holding cost per unit per year = Unit Cost × Holding Rate
Total Annual Cost = (D/Q) × S + (Q/2) × H
Optimal Orders per Year = D / EOQ
Optimal Order Interval = 365 / (D/EOQ) days
Reorder Point = (D/365) × Lead Time + Safety StockHow to Lot Sizing Calculator
▾
- 1Enter annual demand (D) in units — use 52-week trailing demand or forecast.
- 2Enter ordering cost (S) — cost to place one purchase order: purchasing staff time, system transaction cost, supplier minimum charges, receiving cost per order.
- 3Enter unit cost and holding cost rate (typically 20–30% annually including capital cost, storage, obsolescence, insurance).
- 4Calculate H = Unit Cost × Holding Rate — holding cost per unit per year.
- 5Apply EOQ formula: √(2DS/H) to get optimal order quantity.
- 6Divide annual demand by EOQ to get optimal orders per year; divide 365 by orders/year for order interval in days.
- 7Add reorder point = average demand during lead time + safety stock.
Worked Examples
▾
Optimal to order 303 units 8 times per year. Current practice of ordering 500 units 4.8×/year costs $118/year more in holding costs — switching to EOQ saves 7% on inventory costs.
Each production run should produce 6,742 units. With 7.4 runs per year, the production schedule spaces runs approximately every 7 weeks to minimize combined setup and inventory holding costs.
High unit cost (high H) drives EOQ down — it's cheaper to order frequently in small quantities than to carry expensive inventory. Order approximately monthly.
EOQ is the global minimum — but total cost is relatively flat near EOQ (the curve is shallow). Even 65% more than EOQ only costs 6% more — which is why EOQ is robust to small deviations.
Real-World Applications
▾
Professionals in finance and investment use Lot Sizing Calc as part of their standard analytical workflow to verify calculations, reduce arithmetic errors, and produce consistent results that can be documented, audited, and shared with colleagues, clients, or regulatory bodies for compliance purposes.
University professors and instructors incorporate Lot Sizing Calc into course materials, homework assignments, and exam preparation resources, allowing students to check manual calculations, build intuition about input-output relationships, and focus on conceptual understanding rather than arithmetic.
Consultants and advisors use Lot Sizing Calc to quickly model different scenarios during client meetings, enabling real-time exploration of what-if questions that would otherwise require returning to the office for detailed spreadsheet-based analysis and reporting.
Individual users rely on Lot Sizing Calc for personal planning decisions — comparing options, verifying quotes received from service providers, checking third-party calculations, and building confidence that the numbers behind an important decision have been computed correctly and consistently.
Special Cases
▾
Extreme input values
In practice, this edge case requires careful consideration because standard assumptions may not hold. When encountering this scenario in lot sizing calculator calculations, practitioners should verify boundary conditions, check for division-by-zero risks, and consider whether the model's assumptions remain valid under these extreme conditions.
Assumption violations
In practice, this edge case requires careful consideration because standard assumptions may not hold. When encountering this scenario in lot sizing calculator calculations, practitioners should verify boundary conditions, check for division-by-zero risks, and consider whether the model's assumptions remain valid under these extreme conditions.
Rounding and precision effects
In practice, this edge case requires careful consideration because standard assumptions may not hold. When encountering this scenario in lot sizing calculator calculations, practitioners should verify boundary conditions, check for division-by-zero risks, and consider whether the model's assumptions remain valid under these extreme conditions.
Lot Sizing Calc reference data
▾
| Annual Demand | Unit Cost | Order Cost | Typical EOQ | Order Frequency |
|---|---|---|---|---|
| 1,000 units | $10 | $50 | 100 units | 10× / year |
| 5,000 units | $25 | $100 | 200 units | 25× / year |
| 10,000 units | $5 | $200 | 1,265 units | 8× / year |
| 50,000 units | $50 | $500 | 1,000 units | 50× / year |
| 100,000 units | $2 | $150 | 3,873 units | 26× / year |
Frequently Asked Questions
▾
What is Economic Order Quantity (EOQ)?
EOQ is the optimal order quantity that minimizes total inventory costs (ordering costs + holding costs). Formula: EOQ = √(2DS/H), where D = annual demand, S = cost per order (shipping, receiving, paperwork), and H = annual holding cost per unit (storage, insurance, depreciation, opportunity cost — typically 20-30% of item value). For a product with 10,000 units annual demand, $50 per order cost, and $2 annual holding cost: EOQ = √(2 × 10,000 × 50 / 2) = 707 units per order, with about 14 orders per year. EOQ assumes constant demand and lead time — in practice, add safety stock for variability.
When should I not use EOQ?
EOQ is less useful when: demand is highly variable or seasonal (the constant demand assumption breaks), volume discounts significantly change unit cost at different order quantities (use quantity discount models instead), products are perishable with a limited shelf life, lead times are unreliable, you're in a just-in-time manufacturing environment, or storage space is the binding constraint rather than holding cost. For seasonal products, use seasonal ordering models. For perishables, use the newsvendor model. For items with quantity breaks, compare total cost at each price break against the EOQ cost. Many companies use EOQ as a starting point and then adjust for practical constraints like minimum order quantities, container sizes, and supplier schedules.
How is the Economic Order Quantity (EOQ) calculated?
The Economic Order Quantity (EOQ) is calculated using the formula: EOQ = √((2DS)/H), where D is the annual demand in units, S is the ordering or setup cost per order, and H is the annual holding cost per unit. For example, with an annual demand of 10,000 units, a setup cost of $50 per order, and a holding cost of $2 per unit per year, the EOQ would be √((2 * 10,000 * 50) / 2) = √500,000 ≈ 707 units. This formula minimizes the total cost of ordering and holding inventory by balancing these two cost components.
What factors constitute the annual holding cost per unit?
The annual holding cost per unit (H) encompasses all expenses related to storing inventory for one year. This typically includes capital costs (the opportunity cost of money tied up in inventory, often 10-20% of item value), storage space costs (rent, utilities, maintenance), and inventory service costs (insurance, taxes). It also factors in inventory risk costs such as obsolescence, damage, or spoilage, which can be significant for perishable or high-tech goods.
What are some alternative lot sizing methods besides EOQ?
While EOQ is widely used, other lot sizing methods exist, often employed when demand is lumpy or specific constraints apply. The Lot-for-Lot (LFL) method orders exactly what is needed for each period, minimizing holding costs but maximizing ordering costs. The Fixed Order Quantity (FOQ) method uses a predetermined, constant order size, regardless of demand fluctuations. Period Order Quantity (POQ) orders enough to satisfy demand for a specific number of periods, for instance, ordering every two weeks.
Common Mistakes to Avoid
▾
- !
- !
- !
Pro Tip
The 'EOQ insensitivity property' means total cost is within 1% of optimal for order quantities between 0.75× and 1.33× EOQ. Don't obsess over getting the exact EOQ — a reasonable approximation within 25% of EOQ gives nearly the same cost outcome.
Did you know?
The EOQ formula was independently derived at least 3 times before Harris published it in 1913 — by Andler in 1929 (called the 'Andler formula' in Germany), by Camp in 1922, and by Harris in 1913. It's often called the 'Wilson formula' in the UK after R.H. Wilson who popularized it in the 1920s — a historical attribution error that persists in British textbooks.
References
Have a question about this calculator? Get a detailed answer.
Get Weekly Math Tips
Join 12,000+ subscribers who get calculator tips every week.