Irish Calculators
Business

Maximum Stock Level Calculator

Calculate the stock ceiling implied by the reorder and consumption assumptions you enter. Keep the item, quantity unit and consumption time basis consistent; demand and supplier reliability are not forecast.

Runs privately in your browserMethod reviewed

Your numbers

Your figures stay on this device.

How the calculation works

Estimate a maximum stock level under a specified replenishment scenario. The formula starts with stock at the reorder trigger, adds an order quantity and subtracts usage during the assumed minimum lead time.

Maximum stock = reorder level + reorder quantity − minimum consumption rate × minimum lead time.

  1. Identify the replenishment starting point

    Use the reorder level as stock when the order is placed. The scenario assumes that trigger represents the relevant starting stock rather than an unrelated current count.

  2. Allow for usage before arrival

    Multiply minimum consumption by minimum lead time. This calculates the stock used during the entered replenishment interval under those assumptions.

  3. Calculate stock after replenishment

    Add order quantity to reorder level, then subtract the usage allowance. The result is the modelled maximum level at receipt, not a recommended new order quantity.

Worked example: Reorder policy

Sample inputs demonstrate the method. They are not a forecast or product offer.

A reorder level of 500 units and an order of 300 provide 800 units before allowing for consumption. Minimum use of 20 units per day over five days removes 100, giving the example maximum level of 700 units.

Reorder level
500
Reorder quantity
300
Minimum consumption per time unit
20
Minimum lead time in the same time unit
5

Expected result

Maximum stock level
700
Worked example: No lead-time consumption

Sample inputs demonstrate the method. They are not a forecast or product offer.

Reorder level
100
Reorder quantity
50
Minimum consumption per time unit
0
Minimum lead time in the same time unit
3

Expected result

Maximum stock level
150

Understanding your result

The result depends on the minimum-usage and minimum-lead-time scenario. It is not a statistical inventory limit or a guarantee that stock will never exceed that amount.

A negative implied stock level is rejected, so review units and replenishment assumptions if that occurs. The tool does not optimise an order policy, calculate economic order quantity or set safety stock automatically.

Questions you might have

Can I enter daily consumption and lead time in weeks?

Convert one of them first. Multiplying values with different time bases would produce the wrong stock consumption.

Choosing the right inputs

Reorder level
Enter the stock level at which the order is triggered, expressed in the same item unit as the order quantity. This is not the amount purchased.
Minimum consumption per time unit
Enter minimum consumption per lead-time unit, such as units per day when lead time is in days. The model does not infer demand from sales history.
Minimum lead time in the same time unit
Use the minimum replenishment lead time matching the consumption unit. A smaller usage allowance during replenishment leaves more stock on arrival.

Common mistakes to avoid

  • Do not mix weekly consumption with lead time entered in days without converting one of them.
  • Do not replace reorder level with order quantity; they play different roles in the stock balance.

Assumptions to check

  • Stock quantities must describe the same item and unit. Consumption rate and lead time must share a time basis.

Sources and method

Read our calculation and testing approach.