EOQ & Inventory Ordering Planner
A lower unit price does not automatically mean a lower inventory cost. Compare up to four supplier offers for one SKU, including order fees, whole-pack quantities, minimum and maximum orders, quantity discounts, peak storage capacity and an optional per-order expenditure limit. The planner finds the exact lowest modeled annual cost among feasible lots, then shows purchasing, ordering, cycle-stock holding and buffer holding separately. Inspect the cost curve within each price tier, follow one stock-depletion cycle, compare your current lot without silently rounding it, and export the full analysis. Lead-time demand and the reorder inventory position remain separate from physical on-hand stock. This is a deterministic, steady-state EOQ comparison with authored demand and prices, not a first-year purchase schedule, stochastic safety-stock model, supplier recommendation or service-level guarantee.
Order less often—or tie up less stock?
Compare whole-pack order policies, price breaks and supplier constraints. See the annual cost alongside the cash and storage each order needs.
Best evaluated lot: 1008 units from Standard supplier.
Your supplier and order comparison
Annual purchase, ordering and holding costs under constant demand. Prices, demand and constraints are authored assumptions. Lowest modeled cost does not evaluate supplier reliability or service levels.
Standard supplier
Lowest evaluated annual cost
USD 118,409.47/year
- Order
- 1,008 units · tier 2
- Per-order expenditure
- USD 9,822.60
- Average on-hand
- 604 units
- Cycle length
- 30.24 operating days
Shorter lead time
Feasible alternative
USD 119,522.00/year
- Order
- 1,200 units · tier 2
- Per-order expenditure
- USD 11,780.00
- Average on-hand
- 700 units
- Cycle length
- 36 operating days
Bulk supplier
Feasible alternative
USD 121,230.67/year
- Order
- 900 units · tier 1
- Per-order expenditure
- USD 8,990.00
- Average on-hand
- 550 units
- Cycle length
- 27 operating days
Inspect Standard supplier
Entered comparison lot: 600 units. Annual cost USD 121,900.00; reduction at this supplier’s optimum USD 3,490.53 per year (exact difference rounded for display).
- Tier 1: USD 10/unit
- Tier 2: USD 9.7/unit
44 exact samples. Lines connect sampled lots within each tier; they are not continuous-price or fractional-pack offers. The optimizer examines every feasible lot mathematically, independently of these samples.
Buffer: 100 units. Average on-hand: 604 units.
One deterministic cycle, not a calendar forecast. The buffer is an entered assumption and is not consumed in this model.
Inspected lot: 1,008 units · 42 packs
Complete annual cost USD 118,409.47. Per-order expenditure USD 9,822.60 at USD 9.7/unit. Displayed components may differ by a cent when summed; the model rounds the complete total once.
- Annual purchase
- USD 116,400.00
- Annual ordering
- USD 535.71
- Annual cycle holding
- USD 1,229.76
- Annual buffer holding
- USD 244.00
- Orders/year (rate)
- 11.905
- Cycle length
- 30.24 operating days
- Average stock value
- USD 5,858.80
- Peak stock value
- USD 10,747.60
Reorder inventory position, including stock on order
Lead-time demand 466.667 + buffer 100 = 566.667 units. Lead time spans 0.463 replenishment cycles at this lot size.
This threshold uses on-hand plus on-order stock. It may exceed the physical on-hand peak and is not drawn as an on-hand trigger. The buffer is not a calculated service-level guarantee.
Price-tier feasibility and cost ledger
Bounds include supplier limits, stock capacity and the optional budget. A price threshold may be unreachable or fall between pack multiples. Every feasible tier is evaluated independently.
| Tier | All-units price | Price band (units) | Allowed unit bounds | Whole-pack bounds | Tier optimum | Annual cost |
|---|---|---|---|---|---|---|
| 1 | USD 10 | 1–999 | 48–999 | 2–41 | 648 units | USD 121,893.33 |
| 2 | USD 9.7 | 1,000–2,399 | 1,000–1,541 | 42–64 | 1,008 units | USD 118,409.47 |
| 3 | USD 9.4 | 2,400–no tier ceiling | 2,400–1,590 | 100–66 | Infeasible interval | Not calculated |
If lower exceeds upper, or no whole pack lies inside the bounds, that tier is infeasible. No partial optimum is shown.
Complete chart sample table
| Tier | Units | Purchase/year | Ordering/year | Cycle holding/year | Buffer holding/year | Total/year | Expenditure/order |
|---|---|---|---|---|---|---|---|
| 1 | 48 | USD 120,000.00 | USD 11,250.00 | USD 60.00 | USD 250.00 | USD 131,560.00 | USD 525.00 |
| 1 | 72 | USD 120,000.00 | USD 7,500.00 | USD 90.00 | USD 250.00 | USD 127,840.00 | USD 765.00 |
| 1 | 120 | USD 120,000.00 | USD 4,500.00 | USD 150.00 | USD 250.00 | USD 124,900.00 | USD 1,245.00 |
| 1 | 168 | USD 120,000.00 | USD 3,214.29 | USD 210.00 | USD 250.00 | USD 123,674.29 | USD 1,725.00 |
| 1 | 216 | USD 120,000.00 | USD 2,500.00 | USD 270.00 | USD 250.00 | USD 123,020.00 | USD 2,205.00 |
| 1 | 264 | USD 120,000.00 | USD 2,045.45 | USD 330.00 | USD 250.00 | USD 122,625.45 | USD 2,685.00 |
| 1 | 312 | USD 120,000.00 | USD 1,730.77 | USD 390.00 | USD 250.00 | USD 122,370.77 | USD 3,165.00 |
| 1 | 360 | USD 120,000.00 | USD 1,500.00 | USD 450.00 | USD 250.00 | USD 122,200.00 | USD 3,645.00 |
| 1 | 408 | USD 120,000.00 | USD 1,323.53 | USD 510.00 | USD 250.00 | USD 122,083.53 | USD 4,125.00 |
| 1 | 456 | USD 120,000.00 | USD 1,184.21 | USD 570.00 | USD 250.00 | USD 122,004.21 | USD 4,605.00 |
| 1 | 504 | USD 120,000.00 | USD 1,071.43 | USD 630.00 | USD 250.00 | USD 121,951.43 | USD 5,085.00 |
| 1 | 552 | USD 120,000.00 | USD 978.26 | USD 690.00 | USD 250.00 | USD 121,918.26 | USD 5,565.00 |
| 1 | 600 · comparison | USD 120,000.00 | USD 900.00 | USD 750.00 | USD 250.00 | USD 121,900.00 | USD 6,045.00 |
| 1 | 624 | USD 120,000.00 | USD 865.38 | USD 780.00 | USD 250.00 | USD 121,895.38 | USD 6,285.00 |
| 1 | 648 | USD 120,000.00 | USD 833.33 | USD 810.00 | USD 250.00 | USD 121,893.33 | USD 6,525.00 |
| 1 | 672 | USD 120,000.00 | USD 803.57 | USD 840.00 | USD 250.00 | USD 121,893.57 | USD 6,765.00 |
| 1 | 696 | USD 120,000.00 | USD 775.86 | USD 870.00 | USD 250.00 | USD 121,895.86 | USD 7,005.00 |
| 1 | 744 | USD 120,000.00 | USD 725.81 | USD 930.00 | USD 250.00 | USD 121,905.81 | USD 7,485.00 |
| 1 | 792 | USD 120,000.00 | USD 681.82 | USD 990.00 | USD 250.00 | USD 121,921.82 | USD 7,965.00 |
| 1 | 840 | USD 120,000.00 | USD 642.86 | USD 1,050.00 | USD 250.00 | USD 121,942.86 | USD 8,445.00 |
| 1 | 888 | USD 120,000.00 | USD 608.11 | USD 1,110.00 | USD 250.00 | USD 121,968.11 | USD 8,925.00 |
| 1 | 936 | USD 120,000.00 | USD 576.92 | USD 1,170.00 | USD 250.00 | USD 121,996.92 | USD 9,405.00 |
| 1 | 984 | USD 120,000.00 | USD 548.78 | USD 1,230.00 | USD 250.00 | USD 122,028.78 | USD 9,885.00 |
| 2 | 1,008 · optimum | USD 116,400.00 | USD 535.71 | USD 1,229.76 | USD 244.00 | USD 118,409.47 | USD 9,822.60 |
| 2 | 1,032 | USD 116,400.00 | USD 523.26 | USD 1,259.04 | USD 244.00 | USD 118,426.30 | USD 10,055.40 |
| 2 | 1,056 | USD 116,400.00 | USD 511.36 | USD 1,288.32 | USD 244.00 | USD 118,443.68 | USD 10,288.20 |
| 2 | 1,080 | USD 116,400.00 | USD 500.00 | USD 1,317.60 | USD 244.00 | USD 118,461.60 | USD 10,521.00 |
| 2 | 1,104 | USD 116,400.00 | USD 489.13 | USD 1,346.88 | USD 244.00 | USD 118,480.01 | USD 10,753.80 |
| 2 | 1,128 | USD 116,400.00 | USD 478.72 | USD 1,376.16 | USD 244.00 | USD 118,498.88 | USD 10,986.60 |
| 2 | 1,152 | USD 116,400.00 | USD 468.75 | USD 1,405.44 | USD 244.00 | USD 118,518.19 | USD 11,219.40 |
| 2 | 1,176 | USD 116,400.00 | USD 459.18 | USD 1,434.72 | USD 244.00 | USD 118,537.90 | USD 11,452.20 |
| 2 | 1,200 | USD 116,400.00 | USD 450.00 | USD 1,464.00 | USD 244.00 | USD 118,558.00 | USD 11,685.00 |
| 2 | 1,224 | USD 116,400.00 | USD 441.18 | USD 1,493.28 | USD 244.00 | USD 118,578.46 | USD 11,917.80 |
| 2 | 1,272 | USD 116,400.00 | USD 424.53 | USD 1,551.84 | USD 244.00 | USD 118,620.37 | USD 12,383.40 |
| 2 | 1,296 | USD 116,400.00 | USD 416.67 | USD 1,581.12 | USD 244.00 | USD 118,641.79 | USD 12,616.20 |
| 2 | 1,320 | USD 116,400.00 | USD 409.09 | USD 1,610.40 | USD 244.00 | USD 118,663.49 | USD 12,849.00 |
| 2 | 1,344 | USD 116,400.00 | USD 401.79 | USD 1,639.68 | USD 244.00 | USD 118,685.47 | USD 13,081.80 |
| 2 | 1,368 | USD 116,400.00 | USD 394.74 | USD 1,668.96 | USD 244.00 | USD 118,707.70 | USD 13,314.60 |
| 2 | 1,392 | USD 116,400.00 | USD 387.93 | USD 1,698.24 | USD 244.00 | USD 118,730.17 | USD 13,547.40 |
| 2 | 1,416 | USD 116,400.00 | USD 381.36 | USD 1,727.52 | USD 244.00 | USD 118,752.88 | USD 13,780.20 |
| 2 | 1,440 | USD 116,400.00 | USD 375.00 | USD 1,756.80 | USD 244.00 | USD 118,775.80 | USD 14,013.00 |
| 2 | 1,464 | USD 116,400.00 | USD 368.85 | USD 1,786.08 | USD 244.00 | USD 118,798.93 | USD 14,245.80 |
| 2 | 1,488 | USD 116,400.00 | USD 362.90 | USD 1,815.36 | USD 244.00 | USD 118,822.26 | USD 14,478.60 |
| 2 | 1,536 | USD 116,400.00 | USD 351.56 | USD 1,873.92 | USD 244.00 | USD 118,869.48 | USD 14,944.20 |
Exact inspected plan and stock-cycle values
Exact fractions preserve precision. Continuous EOQ is shown as its square and may be zero or not applicable; the constrained whole-pack optimum is calculated independently.
- Order quantity (units)
- 1008
- Whole packs
- 42
- All-units price (currency/unit)
- 97/10
- Combined holding cost (currency/unit/year)
- 61/25
- Annual purchase (currency/year)
- 116400
- Annual ordering (currency/year)
- 3750/7
- Annual cycle holding (currency/year)
- 30744/25
- Annual buffer holding (currency/year)
- 244
- Complete annual cost (currency/year)
- 20721658/175
- Orders per year (long-run rate)
- 250/21
- Cycle duration (operating days)
- 756/25
- Average on-hand (units)
- 604
- Peak on-hand (units)
- 1108
- Average stock value (currency)
- 29294/5
- Peak stock value (currency)
- 53738/5
- Per-order expenditure (currency)
- 49113/5
- Lead-time demand (units)
- 1400/3
- Reorder inventory position (units)
- 1700/3
- Lead time (replenishment cycles)
- 25/54
- Continuous EOQ squared (units²)
- 27000000/61
| Phase | Operating days | On-hand units |
|---|---|---|
| After receipt | 0 | 1108 |
| Mid-cycle | 378/25 | 604 |
| Before next receipt | 756/25 | 100 |
| After next receipt | 756/25 | 1108 |
Demand, storage and carrying costs
One SKU with constant demand and instantaneous receipts. Annual ordering frequency may be fractional; this is a long-run rate, not a first-year invoice schedule. Use consistent operating days for lead times and the year basis.
Three uppercase letters; no exchange-rate conversion.
Use inventory-proportional costs; avoid double counting costs already in the percentage.
Must fit the buffer plus the replenishment lot.
Evaluated as entered for every supplier; never rounded to a pack multiple.
Goods plus the fixed ordering cost; not an annual procurement budget.
Supplier offers and all-units price breaks
Compare up to four offers. A tier’s price applies to every unit in the order, not just units above the threshold. Thresholds must increase, prices must stay equal or decrease. Numeric assumptions accept up to six decimals; lot and pack quantities are whole units.
Standard supplier · 3 price tiers
Shorter lead time · 2 price tiers
Bulk supplier · 3 price tiers
How to use this calculator
- Choose Constrained supplier comparison or Larger-budget example, then enter annual demand, the operating-day year basis and your currency label. The label does not convert currencies.
- Enter annual carrying percentage, additional inventory-proportional holding cost per unit, buffer units and peak on-hand capacity. Set the current lot you want to compare; it is evaluated without pack rounding.
- Enable the optional per-order expenditure cap if needed. It includes goods plus fixed ordering cost. Disabling the cap preserves its draft text for later but removes it from active calculations.
- Expand each supplier and enter ordering cost, units per pack, supplier min/max quantities and lead time. Add price tiers with increasing thresholds and equal or decreasing all-units prices; keep the base tier starting at 1.
- Compare annual cost with per-order expenditure and average/peak inventory. Inspect a supplier, switch between full and ordering-plus-holding cost, and select a sampled feasible lot to see its cost components and stock cycle.
- Review price-tier feasibility, exact values and reorder inventory position. Download the full CSV or use its selectable fallback. Check real demand variability, supplier reliability and commercial terms separately before ordering.
The Formula
The mathematical logic powering this calculation is:
Let D be annual demand, Q a feasible whole-unit order, K fixed cost per order, c the all-units unit price at Q, r the annual carrying percentage and h the additional annual holding cost per unit. Combined annual holding cost H = c × r/100 + h. Average on-hand = Q/2 + entered buffer S; peak on-hand = Q + S. Annual purchasing = D × c; annual ordering = D × K/Q; annual cycle holding = Q × H/2; annual buffer holding = S × H. Complete annual cost is the sum of these four components. Do not omit purchasing when comparing different price tiers or suppliers.
The familiar unconstrained continuous EOQ is sqrt(2DK/H) when H>0. Here a feasible lot must also be a whole multiple of the supplier pack size P, meet minimum/maximum quantities, remain within its price band, fit Q+S within storage capacity and satisfy Qc+K ≤ the optional order budget. Threshold prices apply to all units in that lot; this is not incremental/block pricing.
For each price band, find the feasible integer pack interval. With Q=P×n, variable cost is A/n+B×n, where A=DK/P and B=PH/2. The exact adjacent difference is B−A/[n(n+1)]. Binary search its first nonnegative value inside the feasible interval, then compare all feasible tier optima and offers using exact arithmetic. Ties choose lower annual cost, then lower per-order expenditure, smaller quantity, lexicographically smaller supplier identifier and lower tier index. Zero ordering/holding costs and infeasible intervals are handled explicitly; no iteration cap is labeled an optimum.
Orders per year = D/Q is a long-run rate and may be fractional. Cycle duration = Q × entered operating days per year / D. The cycle depletes from Q+S to S, then replenishes instantaneously. Average stock value = (Q/2+S)c; peak stock value = (Q+S)c. Per-order expenditure = Qc+K includes the entered fixed order cost, and is not the annual procurement cost.
Lead-time demand = D × lead operating days / operating days per year. Reorder inventory position = lead-time demand + S. This position includes on-hand plus on-order inventory, with no backorders in this model; it may exceed physical peak on-hand when several replenishment orders overlap in the pipeline. Lead time does not change the cost-optimal Q under these fixed assumptions. The buffer is entered, not statistically sized.
Costs and constraints use exact rational arithmetic. Round the complete annual total once, half up to currency hundredths; displayed components round separately for readability and may not sum to the displayed total by a cent. Cost differences use exact annual amounts before display rounding. CSV keeps exact fractions, full constraint states and every plotted sample. The chart samples feasible lots and keeps each price tier separate; the optimizer does not rely on chart sampling.
Bounds: annual demand greater than zero through 1 billion units/year; year basis 1–366 operating days; carrying rate 0–100%; additional holding cost 0–1 million currency/unit/year; integer buffer 0–1 billion and capacity 1–1 billion units with buffer ≤ capacity. Optional order budget 0–999999999999 currency, or explicitly uncapped. Compare quantity 1–1 billion whole units. Use 1–4 offers, each with fixed order cost 0–1 billion, pack size 1–1 million whole units, supplier min/max 1–1 billion units and lead time 0–3660 operating days. Each offer has 1–8 ordered price tiers, starting at 1 with strictly increasing integer thresholds and nonincreasing prices from 0–1 million per unit. Decimal inputs allow six places and twelve significant digits; integer quantities use integer tokens. Blanks, signs, exponent notation and input fractions are invalid.
Assumptions: one SKU, known constant demand, fixed lead time, instantaneous complete receipts, an unconsumed buffer and inventory-proportional holding costs. Excludes random demand, stockouts, backorders, lost sales, service levels, production ramps, perishability, seasonality, shared multi-item constraints, inflation, taxes, financing terms and first-year cash timing. Do not double-count financing already included in the carrying rate or include fixed costs unaffected by inventory. Prices and constraints are editable assumptions, not market quotes.Worked Example
If you input:
- Demand: 12000 units/year over 360 operating days.
- Holding: 20% of unit cost per year plus 0.50/unit/year; 100-unit entered buffer.
- Constraints: Peak on-hand capacity 3000 units; per-order expenditure cap USD 15000; comparison lot 600 units.
- Offers: Three authored suppliers with 24-, 12- and 100-unit packs, different fixed order costs and all-units discounts.
- StandardSupplier: USD 45/order; price 10 below 1000 units, 9.70 from 1000 and 9.40 from 2400; min48/max5000 units; 14 operating-day lead time.
Result:
The Standard supplier’s lowest feasible annual cost uses 1008 units (42 packs) at USD 9.70/unit. Annual purchase is USD 116400, ordering is 3750/7, cycle holding is USD 1229.76 and buffer holding is USD 244: USD 118409.47 total after rounding. Per-order expenditure is USD 9822.60, average on-hand is 604 units and peak is 1108. The 600-unit comparison lot costs USD 121900/year, so the exact difference rounds to USD 3490.53/year. Raising only the order budget to USD 30000 unlocks the Bulk supplier’s 2000-unit lot at USD 113454/year, but requires USD 18480 per order and holds 1100 units on average. These are hypothetical steady-state comparisons, not forecasts or supplier quotes.
Frequently Asked Questions
Why not simply round the EOQ formula to the nearest pack?
The unconstrained square-root result ignores minimum orders, upper limits, price breaks, storage and order budgets. Rounding it can miss a cheaper discount tier or produce an infeasible lot. This planner finds the exact best whole-pack quantity inside every feasible tier, then compares the full annual costs.
What does an all-units discount mean?
Once the order reaches a price threshold, that tier’s price applies to every unit in the order. A threshold need not itself be a pack multiple; the first eligible whole pack may be larger. Incremental pricing, where only units above the threshold get a discount, is outside this model.
Which costs belong in carrying cost?
Use costs that change with the amount held: the entered percentage applies to unit price, and the additional amount is per unit per year. Avoid double-counting financing in both fields and do not add fixed warehouse or staff costs that remain unchanged by inventory quantity. Actual relevant costs depend on your operation.
Why can a cheaper annual policy require more cash?
A bulk discount may reduce annual purchasing cost while increasing the goods and fixed cost paid for each order, average inventory value and peak space required. The planner shows those quantities separately and can enforce a per-order expenditure cap. It does not model credit terms or first-year payment timing.
Why is the reorder position above peak on-hand stock?
Reorder position includes inventory already on order. If lead time spans more than one replenishment cycle, several orders can be in transit while on-hand stock stays within its capacity. The threshold is therefore displayed separately from the physical stock-cycle diagram.
Does the buffer guarantee a target service level?
No. The entered buffer remains unconsumed in this constant-demand model. Demand variation, lead-time uncertainty, stockout probabilities and service-level targets are not modeled. Use a separate uncertainty analysis before treating the buffer as adequate protection.
What does an infeasible tier or comparison lot mean?
No allowed whole-pack lot fits the applicable price band and all entered constraints, or your comparison quantity breaks one or more specific rules. An infeasible result has no fabricated cost-optimal quantity. A later lower-price tier can still be feasible even when an earlier tier is not.
Why are annual order counts fractional and exports sometimes fractions?
Orders per year is the steady-state rate D/Q, not an integer count of invoices in a particular year. Exact rational exports preserve cost and stock precision; import the exact-value column as text. Displayed money rounds to hundredths, and cost-curve samples are separate from the exact optimization.
Similar Calculators
Cash Conversion Cycle & Inventory Days Calculator
Calculate inventory, receivable and payable days together. Compare growth and timing scenarios, visualize operating-capital changes, weight balance snapshots and export the full analysis.
Profit Margin Calculator
Calculate gross, operating, and net profit margin percentages for your business or product.
Break-Even Calculator
Find the break-even point for your business — how many units you must sell to cover all costs.
Cost of Goods Sold & Inventory Ledger
Calculate COGS and ending inventory with FIFO, moving average and period-end weighted average. Trace inventory costs and compare gross profit on the same receipts and sales.
