Cycle Stock Calculator

How the number is derived

Cycle stock is the portion of inventory that is consumed and replenished in the normal course of ordering: order quantity ÷ 2 on average, since it runs from the full order quantity down to the reorder point and back.

Total inventory is cycle stock plus safety stock plus any pipeline stock in transit. Separating the three matters because each is controlled by a different lever: order quantity, service level, and lead time respectively.

An example

An order quantity of 280 gives average cycle stock of 140 units, $2,520 at $18 cost. Safety stock of 34 units adds $612. Average on-hand inventory is $3,132.

Now halve the order quantity to 140. Cycle stock falls to 70 units and average inventory to $1,872, a 40% reduction in capital. But orders double to 14.9 a year, adding $637 in ordering cost against a carrying saving of $315.

That is the EOQ trade-off seen from the stock side, and it shows why cycle stock is the wrong place to look for capital savings unless the ordering cost is genuinely low.

Where the figure deceives

The halving assumes demand is even across the cycle. Where it is lumpy, a few large orders rather than steady consumption, average cycle stock is higher than half the order quantity, and the calculation understates the capital committed.

It also assumes the order quantity is what was chosen rather than what the supplier imposed. Where a minimum order quantity or a container fill sets the number, cycle stock is a consequence rather than a decision.

What this changes

Split the inventory report into cycle, safety and pipeline stock. Each has a different owner and a different fix, and an aggregate inventory figure invites the unhelpful instruction to hold less of everything.

Where cycle stock is the largest component and ordering cost is low, smaller more frequent orders genuinely release capital. Where safety stock dominates, the lever is lead time and supplier reliability instead.

Cycle stock and the supplier minimum

Minimum order quantities are the most common reason cycle stock sits above where the arithmetic would put it. A supplier requiring 1,000 units on a product with an EOQ of 280 has fixed the cycle stock at 500 rather than 140, adding $6,480 of committed capital.

That is a negotiable cost with a number attached, which makes it a much better conversation than a general request for flexibility. Showing a supplier that their minimum costs $6,480 a year in carrying cost frequently produces a smaller minimum, a staged delivery against a single order, or a price concession that offsets it.

The staged delivery is usually the easiest win. The supplier gets the full order and the production run economics they wanted, and you take delivery in four instalments, which leaves the cycle stock where the arithmetic says it should be and costs the supplier almost nothing.

Cycle stock is the component most affected by consolidating orders across products. Ordering ten items together on one purchase order spreads a single ordering cost across all of them, which lowers the effective per-item ordering cost and therefore the economic order quantity for each.

Businesses that order item by item usually carry noticeably more cycle stock than the same business would ordering by supplier on a schedule, and the difference is available without any change in supplier terms.