The purchasing manager at a $40 million service center makes 200 buying decisions per month. Each one involves the same mental calculation: "Do I have enough of this product? Should I order more? How much?" He does this from memory, gut feel, and occasional glances at inventory reports that are two days old. He is right about 80% of the time. The 20% he gets wrong costs the company $600,000 per year in stockouts (lost sales when customers call and the material is not available) and excess inventory (material that sits for months and eventually gets sold at a loss or scrapped).
The Basic Replenishment Formula
A replenishment model for steel inventory needs four inputs for each product: average daily demand (in pounds or tons), demand variability (how much daily demand fluctuates), lead time (how many days from order to receipt), and lead time variability (how much delivery timing fluctuates).
The reorder point is: (Average Daily Demand x Lead Time) + Safety Stock. Safety stock accounts for demand variability and lead time variability. The standard formula is: Safety Stock = Z x Square Root of (Lead Time x Demand Variance + Average Demand Squared x Lead Time Variance), where Z is the service level factor (1.65 for 95% fill rate, 2.33 for 99%).
For a practical example: you sell an average of 2,000 pounds per day of 14-gauge HRC in 48-inch width. Demand varies by plus or minus 500 pounds per day. Your mill lead time is 28 days, varying by plus or minus 5 days. For a 95% service level, the safety stock calculation yields approximately 14,000 pounds. Your reorder point is (2,000 x 28) + 14,000 = 70,000 pounds. When your inventory of that product hits 70,000 pounds, it is time to order.
Setting the Order Quantity
The Economic Order Quantity (EOQ) balances the cost of ordering (freight, receiving, paperwork) against the cost of holding inventory (capital, insurance, storage, obsolescence). For steel, the ordering cost per purchase order is typically $150 to $300 (including freight allocation). The holding cost is approximately 1.5% of inventory value per month.
At these economics, most steel products optimize at 60 to 90 days of supply per order. Ordering more frequently increases freight and administrative costs. Ordering less frequently ties up capital and increases obsolescence risk. Adjust the calculation for any volume discounts or freight breaks that the mill offers at specific tonnage levels.
Handling Steel-Specific Complications
Steel replenishment has wrinkles that the textbook formulas do not address. Coils come in fixed sizes, not variable quantities. You cannot order exactly 70,000 pounds of HRC. You order 2 or 3 coils at whatever weight the mill produces, which might total 65,000 or 85,000 pounds. Your replenishment model needs to think in coil counts, not pounds.
Mill minimums create another complication. If the mill requires a 40-ton minimum per order, you may need to combine products on a single purchase order to hit the minimum. Your replenishment model should flag products approaching reorder simultaneously so purchasing can consolidate orders efficiently.
Price volatility adds a strategic layer. In a rising market, ordering ahead of your calculated reorder point locks in lower prices. In a falling market, delaying orders (while managing stockout risk) lets you buy at lower prices later. The replenishment model sets the baseline. Market intelligence adjusts the timing.
Getting Started
You do not need software to start. Build a spreadsheet with your top 50 products by volume. Calculate the reorder point and order quantity for each using 6 months of sales history. Review the sheet weekly and compare your current inventory positions to the calculated reorder points. Within 90 days, you will see fewer stockouts on fast movers and less excess on slow movers. That is the foundation for a purchasing discipline that scales as your business grows.