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.

Inventory • Ordering • Carrying cost

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.

Lowest evaluated annual cost
USD 118,409.47
Standard supplier
Order quantity
1,008 units
42 whole packs
Per-order expenditure
USD 9,822.60
Goods + fixed ordering cost
Average / peak stock
604 / 1,108
Units on hand, including buffer

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).

Annual cost by feasible order quantity
USD/year · vertical axis starts at 118,409.47Top: 131,560
Cost curve — Standard supplierEach price tier has a separate sampled curve. Dots are feasible pack multiples, larger outlined circles are the supplier optimum, and the filled square is the inspected quantity. Use the sample selector and table for exact results. No line crosses a price-tier gap.
48 units1,536 units
  • 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.

One replenishment cycle: on-hand stock
Units · starts at zeroPeak: 1,108
On-hand stock for 1008 units per orderConstant depletion from peak to the entered buffer, followed by an instantaneous receipt. Dashed line is the buffer. Reorder inventory position is shown separately because it includes on-order stock.
Day 0 · receiptDay 30.24 · next receipt

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.

Price bands and best feasible lots
TierAll-units pricePrice band (units)Allowed unit boundsWhole-pack boundsTier optimumAnnual cost
1USD 101–99948–9992–41648 unitsUSD 121,893.33
2USD 9.71,000–2,3991,000–1,54142–641,008 unitsUSD 118,409.47
3USD 9.42,400–no tier ceiling2,400–1,590100–66Infeasible intervalNot 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
Every plotted order quantity
TierUnitsPurchase/yearOrdering/yearCycle holding/yearBuffer holding/yearTotal/yearExpenditure/order
148USD 120,000.00USD 11,250.00USD 60.00USD 250.00USD 131,560.00USD 525.00
172USD 120,000.00USD 7,500.00USD 90.00USD 250.00USD 127,840.00USD 765.00
1120USD 120,000.00USD 4,500.00USD 150.00USD 250.00USD 124,900.00USD 1,245.00
1168USD 120,000.00USD 3,214.29USD 210.00USD 250.00USD 123,674.29USD 1,725.00
1216USD 120,000.00USD 2,500.00USD 270.00USD 250.00USD 123,020.00USD 2,205.00
1264USD 120,000.00USD 2,045.45USD 330.00USD 250.00USD 122,625.45USD 2,685.00
1312USD 120,000.00USD 1,730.77USD 390.00USD 250.00USD 122,370.77USD 3,165.00
1360USD 120,000.00USD 1,500.00USD 450.00USD 250.00USD 122,200.00USD 3,645.00
1408USD 120,000.00USD 1,323.53USD 510.00USD 250.00USD 122,083.53USD 4,125.00
1456USD 120,000.00USD 1,184.21USD 570.00USD 250.00USD 122,004.21USD 4,605.00
1504USD 120,000.00USD 1,071.43USD 630.00USD 250.00USD 121,951.43USD 5,085.00
1552USD 120,000.00USD 978.26USD 690.00USD 250.00USD 121,918.26USD 5,565.00
1600 · comparisonUSD 120,000.00USD 900.00USD 750.00USD 250.00USD 121,900.00USD 6,045.00
1624USD 120,000.00USD 865.38USD 780.00USD 250.00USD 121,895.38USD 6,285.00
1648USD 120,000.00USD 833.33USD 810.00USD 250.00USD 121,893.33USD 6,525.00
1672USD 120,000.00USD 803.57USD 840.00USD 250.00USD 121,893.57USD 6,765.00
1696USD 120,000.00USD 775.86USD 870.00USD 250.00USD 121,895.86USD 7,005.00
1744USD 120,000.00USD 725.81USD 930.00USD 250.00USD 121,905.81USD 7,485.00
1792USD 120,000.00USD 681.82USD 990.00USD 250.00USD 121,921.82USD 7,965.00
1840USD 120,000.00USD 642.86USD 1,050.00USD 250.00USD 121,942.86USD 8,445.00
1888USD 120,000.00USD 608.11USD 1,110.00USD 250.00USD 121,968.11USD 8,925.00
1936USD 120,000.00USD 576.92USD 1,170.00USD 250.00USD 121,996.92USD 9,405.00
1984USD 120,000.00USD 548.78USD 1,230.00USD 250.00USD 122,028.78USD 9,885.00
21,008 · optimumUSD 116,400.00USD 535.71USD 1,229.76USD 244.00USD 118,409.47USD 9,822.60
21,032USD 116,400.00USD 523.26USD 1,259.04USD 244.00USD 118,426.30USD 10,055.40
21,056USD 116,400.00USD 511.36USD 1,288.32USD 244.00USD 118,443.68USD 10,288.20
21,080USD 116,400.00USD 500.00USD 1,317.60USD 244.00USD 118,461.60USD 10,521.00
21,104USD 116,400.00USD 489.13USD 1,346.88USD 244.00USD 118,480.01USD 10,753.80
21,128USD 116,400.00USD 478.72USD 1,376.16USD 244.00USD 118,498.88USD 10,986.60
21,152USD 116,400.00USD 468.75USD 1,405.44USD 244.00USD 118,518.19USD 11,219.40
21,176USD 116,400.00USD 459.18USD 1,434.72USD 244.00USD 118,537.90USD 11,452.20
21,200USD 116,400.00USD 450.00USD 1,464.00USD 244.00USD 118,558.00USD 11,685.00
21,224USD 116,400.00USD 441.18USD 1,493.28USD 244.00USD 118,578.46USD 11,917.80
21,272USD 116,400.00USD 424.53USD 1,551.84USD 244.00USD 118,620.37USD 12,383.40
21,296USD 116,400.00USD 416.67USD 1,581.12USD 244.00USD 118,641.79USD 12,616.20
21,320USD 116,400.00USD 409.09USD 1,610.40USD 244.00USD 118,663.49USD 12,849.00
21,344USD 116,400.00USD 401.79USD 1,639.68USD 244.00USD 118,685.47USD 13,081.80
21,368USD 116,400.00USD 394.74USD 1,668.96USD 244.00USD 118,707.70USD 13,314.60
21,392USD 116,400.00USD 387.93USD 1,698.24USD 244.00USD 118,730.17USD 13,547.40
21,416USD 116,400.00USD 381.36USD 1,727.52USD 244.00USD 118,752.88USD 13,780.20
21,440USD 116,400.00USD 375.00USD 1,756.80USD 244.00USD 118,775.80USD 14,013.00
21,464USD 116,400.00USD 368.85USD 1,786.08USD 244.00USD 118,798.93USD 14,245.80
21,488USD 116,400.00USD 362.90USD 1,815.36USD 244.00USD 118,822.26USD 14,478.60
21,536USD 116,400.00USD 351.56USD 1,873.92USD 244.00USD 118,869.48USD 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
One-cycle exact values
PhaseOperating daysOn-hand units
After receipt01108
Mid-cycle378/25604
Before next receipt756/25100
After next receipt756/251108

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
Price tier 1

The base price tier must start at 1.

Price tier 2

Inclusive threshold; lots still need whole packs.

Price tier 3

Inclusive threshold; lots still need whole packs.

Shorter lead time · 2 price tiers
Price tier 1

The base price tier must start at 1.

Price tier 2

Inclusive threshold; lots still need whole packs.

Bulk supplier · 3 price tiers
Price tier 1

The base price tier must start at 1.

Price tier 2

Inclusive threshold; lots still need whole packs.

Price tier 3

Inclusive threshold; lots still need whole packs.

How to use this calculator

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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