Metals, Steel, Aluminum & Coil Processing worked example
Coil Inventory Days with daily coil consumption of 100 tons / day: a worked example
Push daily coil consumption up to 100 tons / day and the picture changes. This example computes every intermediate figure at that operating point. Use it when a planner is setting coil reorder points and wants days of supply that reflect real usage and mill lead times.
The inputs for this scenario
- Daily coil consumption: 100 tons / day (raised for this scenario; the documented default is 40)
- Supplier lead time: 21 days (unchanged)
- Safety stock: 120 tons (unchanged)
Working through the calculation
- Applying the documented formula (Cycle stock = daily coil consumption × supplier lead time) to the inputs above produces each figure below.
- At this operating point the engine returns 0.04 days for protected days of supply, the number this scenario is built around.
- At this operating point the engine returns 4.76 days for unprotected days.
- At this operating point the engine returns 100 pieces for inventory.
- At this operating point the engine returns 21 pieces / day for daily usage.
How this compares with the baseline
- Against the tool's baseline example, where daily coil consumption sits at 40 tons / day and the headline result is 0.02 days, this scenario comes in 150% above the baseline at 0.04 days.
- It computes required coil inventory as cycle stock, which is daily consumption times supplier lead time, plus your safety stock. The value of this scenario is the size of the gap it exposes: that gap, priced out over a year, is the budget you can justify spending to close it.
Results at a glance
- Protected days of supply: 0.04 days (headline result)
- Unprotected days: 4.76 days
- Inventory: 100 pieces
- Daily usage: 21 pieces / day
Run it with your numbers
- Every input above is editable in the live Coil Inventory Days calculator, which recalculates instantly and can be shared with the inputs intact.
Last reviewed 2026-05-12.