Calculate target inventory, EOQ, or minimum and maximum stock levels from daily usage and lead-time ranges, with reorder levels and average stock.

Optional settings

Target (Order-Up-To / Maximum) Stock Level Formula

The target calculation estimates inventory position immediately after placing an order: order quantity plus expected lead-time demand plus safety stock. Inventory position includes on-hand stock, open orders and backorders. Under a simple steady-demand system, expected peak on-hand stock after arrival is order quantity plus safety stock; lead-time demand is consumed while waiting.

OSL = Q + Lead-time demand + SS
  • OSL = target inventory position immediately after ordering, not maximum on-hand stock
  • Q = order quantity
  • DLT = expected demand during lead time
  • SS = safety stock

This structure is useful when inventory is reviewed continuously and a new order is placed once stock falls to a defined trigger point. The reorder trigger is the lead-time demand plus the safety buffer.

R = Lead-time demand + SS

When inventory position reaches the reorder point, place the prescribed order quantity. Inventory position rises by that order quantity immediately; receipt later transfers inventory from on-order to on-hand without itself increasing inventory position.

How to Interpret the Inputs

Field What it Represents How to Estimate It Well
Order Quantity The amount purchased or produced each time you replenish. Use your normal batch size, supplier minimum, production lot size, or the quantity that best fits freight and handling economics.
Minimum / Working Stock The expected demand that occurs while waiting for replenishment to arrive. Base it on forecasted demand during the actual supplier lead time, not just a rough monthly average.
Safety Stock Extra inventory held to absorb uncertainty in demand, lead time, or both. Increase it when service level targets are high or when demand and supplier performance are inconsistent.
Target Stock Level The inventory position reached immediately after placing the replenishment order. Use it as a planning target for replenishment, storage capacity, and service-level control.

Stock definitions depend on the mode: In target-inventory mode, expected lead-time demand excludes safety stock, and the minimum-stock result is the supplied safety stock. In the range method, minimum stock is the reorder level less average lead-time demand. Do not add a buffer twice when transferring values from your own inventory policy.

Estimating Demand During Lead Time

If demand is fairly stable, lead-time demand can be approximated from average demand per period and average lead time.

Lead-time demand = d × L

Use this shortcut carefully. If demand is seasonal, highly promotional, or affected by project-based buying, a direct forecast for the replenishment window is usually better than a simple average.

Example Calculation

Suppose you order 500 units at a time, expect 180 units of demand during supplier lead time, and hold 70 units of safety stock.

OSL = 500 + 180 + 70 = 750

The target inventory position immediately after ordering is 750 units. Expected peak on hand after receipt is 500 + 70 = 570 units under the simple steady-demand assumptions.

R = 180 + 70 = 250

That means a new 500-unit order would typically be placed when inventory position reaches 250 units. Inventory position becomes 750 units immediately after ordering. During the lead time, 180 units of demand are expected; on-hand stock is expected to peak near 570 units on receipt.

Minimum and Maximum Stock Levels from Ranges

Select Min / max stock levels and enter an order quantity, minimum/average/maximum daily usage, and minimum/average/maximum lead times in days. Each average must lie within its minimum and maximum. Use the same stock unit throughout.

Reorder level = maximum daily usage × maximum lead time
Minimum stock = reorder level − average daily usage × average lead time
Maximum stock = reorder level + order quantity − minimum daily usage × minimum lead time
Average stock estimate = minimum stock + order quantity / 2

For daily usage of 10, 20 and 30 units; lead times of 2, 3 and 5 days; and an order quantity of 100 units, the reorder level is 150, minimum stock is 90, maximum stock is 230, and average stock estimate is 140 units. This average uses minimum plus half the order quantity, not the midpoint of the displayed extremes. These are textbook planning estimates, not a statistical service-level guarantee; the separate Safety Stock Calculator above uses demand variability and a chosen service level.

Economic Order Quantity (EOQ) Mode

EOQ = √(2 × annual demand × cost per order ÷ annual holding cost per stock unit). The simple model assumes steady demand, no shortages, instantaneous replenishment and constant costs. Average on-hand inventory = EOQ/2 + supplied safety stock. Ordering plus holding costs exclude purchasing costs. A planning year uses 365 days and a month uses 30.4375 days. Blank daily demand uses annual demand/365; blank safety stock and extra allowance mean zero. The optional percentage allowance is a heuristic on inventory position, not a service-level guarantee.

What Makes a Stock Level “Optimal”?

An optimal stock level is not one universal number. It depends on the tradeoff between service and cost. A higher target generally reduces stockout risk, but it also increases working capital, storage use, obsolescence exposure, shrinkage risk, and carrying cost. A lower target improves cash efficiency, but it raises the chance of missed sales, backorders, production interruptions, and emergency purchasing.

  • Demand variability: Greater demand swings usually require more safety stock.
  • Lead time variability: Unreliable suppliers increase the need for buffer inventory.
  • Service level goals: Faster fulfillment expectations usually push targets upward.
  • Order frequency: Larger, less frequent orders increase cycle stock.
  • Storage and cash constraints: Physical and financial limits may cap the practical target.
  • Shelf life and obsolescence: Perishable or rapidly changing items should be managed with tighter controls.

When This Calculator Is Most Useful

  • Setting a replenishment target for finished goods, spare parts, retail items, or consumables
  • Creating a simple min/max inventory policy
  • Comparing how changes in order quantity or safety stock affect inventory levels
  • Planning inventory position; use the separate expected peak on-hand result for a simple storage estimate
  • Supporting purchasing decisions where the replenishment quantity is relatively stable

Practical Tips for Better Results

  • Use the same unit of measure for every field. Do not mix units, cases, boxes, and pallets unless all inputs have been converted consistently.
  • Review supplier lead times regularly. Old lead-time assumptions are one of the fastest ways to understate required inventory.
  • Update safety stock whenever demand volatility, service goals, or supplier reliability changes.
  • For seasonal items, use current forecast data rather than long historical averages.
  • Base reorder decisions on inventory position when possible, not just on-hand stock. Open purchase orders and backorders materially affect the real trigger point.

Common Mistakes

  • Double-counting safety stock: Entering a minimum stock value that already includes buffer inventory and then adding safety stock again.
  • Using average demand from the wrong period: Weekly demand should not be combined with lead time measured in days unless converted correctly.
  • Ignoring pack-size assumptions: Convert all quantities to a consistent unit before planning replenishment. This calculator does not assume a box or pallet size.
  • Assuming one target fits every SKU: High-volume, unpredictable, and critical items often need different stocking rules than slow-moving items.
  • Treating the result as permanent: Inventory targets should move with demand, lead time, supplier performance, and service expectations.

Frequently Asked Questions

Is target stock level the same as reorder point?
No. The reorder point triggers an order based on inventory position. The target inventory position equals the reorder point plus the order quantity. Expected peak on hand after receipt is order quantity plus safety stock under steady demand without shortages or overlapping arrivals.
Can this calculator be used for manufacturing materials?
Yes. It works for raw materials, components, maintenance parts, retail items, and many other replenished inventories as long as the item follows a reasonably consistent reorder process.
Should safety stock always be increased to avoid stockouts?
Not automatically. More safety stock improves availability, but it also ties up cash and can increase waste or obsolescence. The right amount depends on variability, service goals, and cost tolerance.
What if demand changes every month?
Recalculate frequently using the newest demand forecast and current supplier lead time. A target level is only as good as the assumptions behind it.