Inventory Planning Tools: Reorder Levels and Economic Order Quantity

Learning objectives

By the end of this chapter, you should be able to:

• Calculate a reorder level using demand and lead-time assumptions so that replenishment arrives before stock is exhausted.
• Compute the Economic Order Quantity (EOQ) and explain how it balances ordering costs and holding costs.
• Assess inventory risks (stockouts and excess stock) and set a practical buffer using the information available.
• Present an inventory policy clearly, including assumptions and decision rules that can be updated when conditions change.

Overview & key concepts

Inventory ties up cash, space and management time. Too little inventory can stop production or lose sales; too much inventory increases storage costs and the risk of damage, obsolescence or shrinkage. Inventory planning tools help answer two operational questions:

1. When should we reorder?(reorder level)
2. How much should we order each time?(EOQ or another chosen order quantity)

These tools are management techniques. They do not change the accounting model for purchases, inventory and cost of sales, but they can strongly influence working capital and operating profit.

Demand rate and lead time

Demand rate (usage)

Demand (or usage) is the expected units consumed or sold per time period (for example, units per day). Planning data often distinguishes between:

• Average demand(typical conditions)
• Maximum demand(busy periods)
• Minimum demand(quiet periods)

Lead time

Lead time is the time between placing an order and inventory becoming available for use (for example, the number of days between ordering and delivery into stores). Lead time may also vary, so questions may provide:

• Average lead time
• Maximum lead time
• Minimum lead time

Expected usage during lead time

A useful starting point is the expected consumption while waiting for a delivery:

• Expected lead-time usage = Average demand × Average lead time

This gives a “typical” reorder trigger under stable conditions. When demand and lead time vary, a buffer is usually needed.

Reorder level (ROL)

The reorder level is the stock level at which a replenishment order should be placed. A commonly examined conservative method is:

• Reorder level = Maximum demand per day × Maximum lead time (days)

Examiner-style note: this method assumes the worst demand and the worst lead time occur together. It is intentionally cautious and may overstate the level of inventory held, but it provides strong protection against stockouts.

Safety stock and minimum level

Safety stock and the “minimum level” idea (single, consistent lens)

Start with the amount you expect to use while waiting for delivery:

• Expected lead-time usage = Average demand × Average lead time

If you then set a cautious reorder trigger using worst-case assumptions:

• Reorder level (ROL) = Maximum demand × Maximum lead time

the difference between these figures is the buffer built into the reorder decision:

• Safety stock (buffer) = ROL − expected lead-time usage

Many questions also ask for a minimum level. In this teaching approach, the minimum level is not a separate additional layer of stock. It is simply the stock you would expect to remain when the delivery arrives under average conditions, assuming you reorder exactly at the ROL. That expected remaining stock is the same buffer figure:

• Minimum level (expected remaining at delivery, under average conditions)
• = ROL − (Average demand × Average lead time)

Key exam skill: explain what the number represents and how it arises from the assumptions, rather than treating “minimum level” and “safety stock” as two unrelated controls.

Maximum level

A maximum level helps plan for space and cash constraints by estimating a likely peak inventory shortly after a delivery arrives.

A common planning convention is:

• Maximum level = ROL + Order quantity − (Minimum demand × Minimum lead time)

Timing note: this estimates stock immediately after replenishment under favourable conditions for inventory build-up (fastest delivery and slowest usage).

Ordering costs and holding costs

Ordering costs

Ordering costs are triggered each time an order is placed, such as purchasing administration, receiving and inspection, and any delivery charge that is incurred per order. They behave like a fixed cost per order, not per unit.

Holding costs

Holding costs are the costs of keeping inventory, such as warehousing, handling, insurance, security, and the opportunity cost of tying up funds. For EOQ purposes, holding cost must be stated as a cost per unit per year in money terms.

Economic Order Quantity (EOQ)

EOQ is the order size that minimises the combined annual cost of:

• ordering (high when you place many small orders), and
• holding (high when you carry large average inventories)

The EOQ formula is:

• EOQ = √[(2 × D × S) ÷ H]

Where:

• D= annual demand (units per year)
• S= ordering cost per order (£ per order)
• H= annual holding cost per unit (£ per unit per year)

Important nuance: if holding cost is given as a percentage (for example, “20% of unit cost per year”), convert it into money terms:
H = holding rate × unit cost.

Scope note: EOQ assumes the unit purchase price does not change with order size. If quantity discounts exist, EOQ is only a starting point—you extend the analysis by comparing total annual costs, including purchase cost, across the feasible order sizes.

Core theory and frameworks

1) Reorder decisions: setting the trigger point

A reorder level is designed to cover demand during lead time, with an allowance for uncertainty.

A robust exam approach is:

• ROL = Maximum demand × Maximum lead time
• Expected lead-time usage = Average demand × Average lead time
• Buffer (safety stock) = ROL − expected lead-time usage

Then interpret the buffer clearly: it is the protection built into the reorder trigger when demand and/or lead time can worsen.

2) Order quantity decisions: balancing two opposing costs

Total annual inventory-related cost (excluding purchase price) is commonly presented as two components:

• Annual ordering cost ≈ (D ÷ Q) × S
• Annual holding cost ≈ (Q ÷ 2) × H

Where Q is the order quantity. EOQ is the value of Q that minimises the combined total.

3) Practical adjustments

EOQ and reorder calculations often need modification in real settings. Typical reasons include:

• storage space limits (cap the maximum level)
• supplier constraints (minimum order sizes, delivery schedules)
• demand seasonality or trend
• service-level targets for critical items
• quantity discounts (requiring a total-cost comparison)

Impact on financial statements

Inventory planning does not change the accounting model, but it can change the amount of cash tied up and the likelihood of avoidable costs. Holding more stock typically increases working capital (inventory up, cash down—unless supplier credit rises). Holding too much also increases exposure to losses from slow-moving items, damage, or obsolescence, which can lead to write-downs when value cannot be recovered.

Day-to-day costs linked to ordering and storing stock (such as warehouse rent, handling and routine administration) usually flow through profit or loss as operating expenses. Some costs may be included in the cost of inventory where the business’s costing approach treats them as part of getting goods ready for sale or use, but general inefficiencies and avoidable waste should not be “buried” in inventory costs.

Used well, reorder points and order-size decisions reduce disruption (stockouts, rush orders, stoppages) and reduce unnecessary carrying costs—improving cash flow and operational performance.

Worked example

Narrative scenario

ABC Ltd manufactures electronic components and uses a specialised input in its production process. The following estimates have been prepared for this component:

• Average demand:50 units per day
• Maximum demand:70 units per day
• Minimum demand:30 units per day
• Average lead time:5 days
• Maximum lead time:8 days
• Minimum lead time:3 days
• Ordering cost:£40 per order
• Holding cost:£2.00 per unit per year
• Working year:250 days

ABC Ltd wants an inventory policy that supports uninterrupted production while keeping ordering and holding costs under control.

Required

1. Calculate thereorder leveland theminimum level.
2. Compute theEconomic Order Quantity (EOQ).
3. Determine themaximum inventory level.
4. Draft a conciseinventory policy statement.

Solution

Step 1: Reorder level (ROL)

Reorder level = Maximum demand × Maximum lead time
= 70 units/day × 8 days
= 560 units

Comment on judgement: this is deliberately conservative because it combines the highest usage with the longest lead time.

Step 2: Minimum level (and implied buffer)

Expected lead-time usage (average conditions)
= Average demand × Average lead time
= 50 × 5
= 250 units

Minimum level (expected remaining at delivery under average conditions)
= ROL − expected lead-time usage
= 560 − 250
= 310 units

In this approach, 310 units is also the buffer (safety stock) implied by using a worst-case reorder level.

Step 3: EOQ

Annual demand (D)
= Average demand × Working days
= 50 × 250
= 12,500 units

EOQ = √[(2 × D × S) ÷ H]
= √[(2 × 12,500 × 40) ÷ 2.00]
= √[(1,000,000) ÷ 2.00]
= √500,000
≈ 707 units

Step 4: Maximum level

Minimum lead-time usage (favourable conditions for a high peak)
= Minimum demand × Minimum lead time
= 30 × 3
= 90 units

Maximum level (estimated peak immediately after delivery)
= ROL + Order quantity − minimum lead-time usage
= 560 + 707 − 90
= 1,177 units

Step 5: Inventory policy statement

Policy:Place a replenishment order when inventory falls to 560 units. Order 707 units (or the nearest practical quantity). Under average conditions, stock is expected to be around 310 units when the delivery arrives, and stock is expected to peak at approximately 1,177 units immediately after replenishment. Review the assumptions if demand, lead times, costs, or capacity constraints change.

Interpretation of the results

• Reorder level (560 units):strong protection against stockouts, but potentially higher average inventory because it assumes worst demand and worst lead time coincide.
• Minimum level / buffer (310 units):the safety margin created by using a conservative reorder trigger; it represents the expected remaining stock when delivery arrives under average conditions.
• EOQ (707 units):balances ordering frequency against the cost of carrying inventory.
• Maximum level (1,177 units):estimates the likely peak immediately after delivery and helps test feasibility against storage and cash constraints.

Common pitfalls and misunderstandings

• Using average values for the reorder level without considering variability, leading to stockouts.
• Treating “minimum level” and “safety stock” as separate add-ons when, in some approaches, they are the same implied buffer.
• Forgetting the timing logic behind maximum level (peak occurs just after replenishment under favourable usage/lead-time conditions).
• Using the wrong time base when converting demand into annual units.
• Misstating holding cost (H): it must be an annual cost per unit in money terms (convert from a percentage where required).
• Treating EOQ as compulsory rather than a starting point that may need adjustment.
• Ignoring quantity discounts: if price changes with volume, compare total costs including purchase cost.

Summary and further reading

Reorder levels and EOQ are key planning tools:

• Reorder levelsets the reorder trigger using demand and lead-time assumptions.
• A conservative reorder rule can embed abuffer(safety stock) within the trigger point.
• EOQprovides a cost-efficient order size by balancing ordering costs against holding costs.
• Minimum and maximum levelshelp translate calculations into a workable policy and highlight space and cash implications.

Further study should link these tools to working capital management, operational risk, and the cost consequences of disruption and overstocking.

FAQ

How do reorder levels reduce the risk of stockouts?

A reorder level is set so that expected usage during lead time is covered, with a buffer if demand or lead time can worsen. When inventory reaches the trigger point, the order is placed early enough for delivery to arrive before stock is exhausted under the chosen assumptions.

Is “maximum demand × maximum lead time” always the best approach?

It is a strong protective approach, but it assumes the worst demand and the worst lead time happen at the same time. That caution reduces stockout risk but may increase average inventory. The most suitable approach depends on how variable demand and lead times are and how costly a stockout would be.

What does EOQ tell you, and what does it not tell you?

EOQ identifies an order size that minimises ordering and holding costs under simplified assumptions. It does not automatically incorporate capacity limits, supplier restrictions, seasonality, or quantity discounts—those factors may justify a different order size.

How do you handle holding cost given as a percentage?

Convert it into money terms: holding cost per unit per year = holding rate × unit cost. That figure is then used as H in the EOQ formula.

How does inventory planning affect reported performance?

Inventory planning influences working capital and avoidable costs. Holding too much stock increases cash tied up and raises the risk of write-downs on slow-moving, damaged or obsolete items. Well-chosen reorder points and order quantities reduce stoppages and rush ordering, which supports operating performance and cash flow.

Summary (Recap)

This chapter explained how reorder levels and EOQ support efficient inventory control. Reorder levels set the timing of replenishment based on demand and lead-time assumptions. A conservative reorder rule can embed a buffer, and the resulting “minimum level” figure can be interpreted as the expected remaining stock at delivery under average conditions. EOQ estimates a cost-efficient order size by balancing ordering and holding costs, while maximum level helps assess peak stock against practical constraints. A worked example showed how to calculate and explain these results clearly.

Glossary

Demand rate
Expected usage or sales volume per time period (for example, units per day), used in reorder and inventory-level calculations.

Lead time
Time between placing an order and inventory becoming available for use.

Reorder level (ROL)
Stock level at which a replenishment order is triggered.

Safety stock (buffer)
Extra inventory held (explicitly or implicitly through a cautious reorder level) to protect against demand spikes and delivery delays.

Minimum level
In this approach, the stock expected to remain when a delivery arrives under average demand and average lead time, assuming reordering occurs at the ROL.

Maximum level
An estimate of peak stock immediately after replenishment under favourable conditions for inventory build-up (fast delivery and slow usage).

Ordering cost
Cost incurred each time an order is placed (for example, administration and receiving), treated as a cost per order for EOQ.

Holding cost
Annual cost of carrying one unit of inventory, expressed in money terms per unit per year and used as H in EOQ.

Stockout cost
Cost of running out of inventory, which may include lost contribution, downtime, expediting costs and customer-service impacts.

Economic Order Quantity (EOQ)
Order quantity that minimises the combined annual ordering and holding costs under simplified assumptions.

Reorder cycle
Time between orders at a given demand rate and order quantity.

Buffer stock
Another term for safety stock (buffer).