How do you calculate required coil inventory?

Multiply daily coil consumption by supplier lead time to get cycle stock, then add safety stock. At 40 tons/day with a 21-day lead time, cycle stock is 840 tons; adding 120 tons of safety stock gives 960 tons required.

What is cycle stock versus safety stock?

Cycle stock is the inventory consumed between replenishments, sized to cover the lead time. Safety stock is an extra buffer held against demand spikes and late deliveries. Cycle stock follows the math; safety stock reflects how much risk you will tolerate.

How many days of coil inventory should I carry?

Enough to cover supplier lead time plus a safety margin. With a 21-day lead time you need at least 21 days of cycle coverage, and most processors add several days of safety stock on top, more for unreliable mills or volatile demand.

How does lead time affect coil inventory?

Directly. Longer mill lead times require proportionally more cycle stock. Doubling lead time from 21 to 42 days at 40 tons/day doubles cycle stock from 840 to 1,680 tons, which is a large jump in tonnage and cash.

How do I set coil safety stock?

Base it on the variability of both demand and delivery. If usage swings or the mill is frequently late, raise safety stock; if both are steady, you can run leaner. Many planners size it to cover a few days of consumption or a typical delivery slip.

What happens if coil inventory runs too low?

You risk a line-down event where presses or the CTL line starve, which is far more costly than the carrying cost of extra coil. The reorder point should trigger replenishment before stock falls into the safety buffer.

Metals, Steel, Aluminum & Coil Processing calculator

Coil Inventory Days Calculator

Coil inventory days expresses how much steel coil a processor needs on hand, both as cycle stock to cover the supplier's replenishment lead time and as safety stock to buffer demand and delivery swings. Materials planners and buyers in service centers and stamping plants use it to set reorder points, avoid line-down events, and keep working capital from piling up in the rack. Coil is heavy, expensive, and slow to replace, so the balance between stockout risk and tied-up cash is real money. This calculator sizes the required inventory from your usage rate, lead time, and chosen safety buffer.

What this calculator does

Size coil inventory from daily coil consumption, supplier lead time, and a safety stock buffer, so you can see the days of supply you are carrying.
Use it when a planner is setting coil reorder points and wants days of supply that reflect real usage and mill lead times.
It computes required coil inventory as cycle stock, which is daily consumption times supplier lead time, plus your safety stock.

Formula used

Cycle stock = daily coil consumption × supplier lead time
Required coil inventory = cycle stock + safety stock

Inputs explained

Daily coil consumption:
Supplier lead time:
Safety stock:

How to use the result

Use it when setting reorder points, negotiating delivery frequency with a mill, or reviewing whether coil on hand matches consumption and lead time.
It assumes steady daily consumption and a fixed lead time, so demand spikes or unreliable deliveries require a larger safety stock than a single average suggests.

Current U.S. benchmarks

The producer price index for steel mill products stands at 348.53 (BLS, May 2026), up 6.7% from a year earlier. Quotes priced off last quarter's material cost miss this move.
The producer price index for aluminum mill shapes stands at 404.859 (BLS, May 2026), up 36.8% from a year earlier. Quotes priced off last quarter's material cost miss this move.
The producer price index for copper and brass mill shapes stands at 559.593 (BLS, May 2026), up 76.8% from a year earlier. Quotes priced off last quarter's material cost miss this move. Global copper trades at $13,484 per tonne (IMF via FRED, May 2026).

Common questions

How do you calculate required coil inventory? Multiply daily coil consumption by supplier lead time to get cycle stock, then add safety stock. At 40 tons/day with a 21-day lead time, cycle stock is 840 tons; adding 120 tons of safety stock gives 960 tons required.
What is cycle stock versus safety stock? Cycle stock is the inventory consumed between replenishments, sized to cover the lead time. Safety stock is an extra buffer held against demand spikes and late deliveries. Cycle stock follows the math; safety stock reflects how much risk you will tolerate.
How many days of coil inventory should I carry? Enough to cover supplier lead time plus a safety margin. With a 21-day lead time you need at least 21 days of cycle coverage, and most processors add several days of safety stock on top, more for unreliable mills or volatile demand.
How does lead time affect coil inventory? Directly. Longer mill lead times require proportionally more cycle stock. Doubling lead time from 21 to 42 days at 40 tons/day doubles cycle stock from 840 to 1,680 tons, which is a large jump in tonnage and cash.
How do I set coil safety stock? Base it on the variability of both demand and delivery. If usage swings or the mill is frequently late, raise safety stock; if both are steady, you can run leaner. Many planners size it to cover a few days of consumption or a typical delivery slip.

Last reviewed 2026-05-12.