INVENTORY PLANNING

When to order, and how much?

Balance ordering and holding costs. See stock coverage and the reorder threshold.

WHAT WILL THIS CALCULATE?

I know demand and lead time → when and how much should I order?

1. Check the example2. Enter your values3. See the result

Reorder point is the stock level for considering a new order. EOQ balances the costs you enter.

Starting values are examples. Replace dimensions and prices with your product or quote.

Enter your values

Assumes constant demand and lead time. Use the same type of day throughout.

A VISUAL RESULT FROM YOUR INPUTSINVENTORY PLANNING
Preparing result

—

Calculating…

REUSE YOUR WORK

Save a scenario. Continue later.

Use Save to keep up to 10 scenarios for this tool in this browser. They are not uploaded or synced across devices. Avoid saving on shared devices.

Back up / open on another device

The JSON file contains inputs only. Opening a scenario recalculates the result with the current engine. You can transfer the file yourself.

The method behind the calculation

EOQ = √(2 × annual demand × order cost / annual holding cost per unit). Reorder threshold = daily demand × (lead time + safety days).

Assumptions and limits

The pack multiples immediately below and above EOQ are compared and the lower-cost quantity is selected. Holding cost includes safety stock. Purchase cost, volume discounts, capacity, outstanding orders and demand variability are excluded. Available stock should be net of reservations.

WORKED EXAMPLE

Follow the example calculation.

With annual demand of 12,000, ordering cost of 150 and annual holding cost of 6 per unit, continuous EOQ is about 774.60 units. At a pack multiple of 50, this example selects 750. With 365 demand days, a 20-day lead time and 7 safety days, the reorder threshold is 888 units.

Frequently asked questions

What do EOQ and the reorder threshold tell me?

EOQ balances costs to suggest how much to order. The threshold is the stock level indicating when to reorder. They answer different questions.

Why not round EOQ to the nearest pack multiple?

The annual ordering plus holding costs of the adjacent pack multiples are compared. The lower-cost quantity is selected; the numerically closest quantity is not always cheaper.

Does this include outstanding orders or variable demand?

No. The model assumes constant demand and lead time. Enter available stock net of reservations. Consider open purchase orders, seasonality and service-level targets separately.

Related sources

Oracle · EOQ ↗

Inputs are processed on this device. Example figures are not quotes or live market prices.