Metals, Steel, Aluminum & Coil Processing worked example

Coil Inventory Days with daily coil consumption of 20 tons / day: a worked example

This worked example runs the coil inventory days numbers for a tougher week than the baseline: daily coil consumption of 20 tons / day instead of the typical 40 tons / day. 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.

The inputs for this scenario

  • Daily coil consumption: 20 tons / day (the input this scenario stresses; the baseline uses 40)
  • Supplier lead time: 21 days (held at the documented default)
  • Safety stock: 120 tons (held at the documented default)

Working through the calculation

  • The calculation starts from the formula this tool documents: Cycle stock = daily coil consumption × supplier lead time.
  • Protected days of supply works out to 0.01 days at these inputs, and this is the headline figure for the scenario.
  • Unprotected days works out to 0.95 days at these inputs.
  • Inventory works out to 20 pieces at these inputs.
  • Daily usage works out to 21 pieces / day at these inputs.

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 50% below the baseline at 0.01 days.
  • Use it when setting reorder points, negotiating delivery frequency with a mill, or reviewing whether coil on hand matches consumption and lead time. A result at this level usually justifies acting on the stressed input before touching anything else, because every other figure in the table is downstream of it.

Results at a glance

  • Protected days of supply: 0.01 days (headline result)
  • Unprotected days: 0.95 days
  • Inventory: 20 pieces
  • Daily usage: 21 pieces / day

Run it with your numbers

  • To rerun this with your own numbers, open the live Coil Inventory Days calculator, set daily coil consumption to your actual value, and adjust the remaining inputs to match your operation.

Last reviewed 2026-05-12.