Common Mistakes

Why Your Safety Stock and Inventory Numbers Are Wrong: Costly Mistakes to Catch

The specific data, unit, and assumption errors that make safety stock, turnover, and landed cost numbers wrong, plus how to catch each one before it costs you.

The most expensive safety stock mistake is mixing time units. The formula needs lead time and demand in the same period, yet teams pull demand as weekly and lead time as days, then wonder why coverage is off by a factor of seven. Symptom: your Safety Stock Calculator output looks 5 to 8 times too high or too low. Root cause: lead time entered as 21 days against weekly sigma. Fix: convert both to days. If daily demand sigma is 12 units and lead time is 21 days, safety stock at 95 percent service (z=1.65) is 1.65 times 12 times sqrt(21), roughly 91 units, not 640.

Averaging away demand variability is the second killer. Teams feed a smooth 12-month average into planning and set safety stock near zero because the mean looks stable. Symptom: chronic stockouts despite healthy average inventory. Root cause: standard deviation ignored. Run the Demand Variability tool on raw daily or weekly buckets. A SKU averaging 100 units per week with a sigma of 45 has a coefficient of variation of 0.45, which is lumpy. Plan that item with statistical reorder points, not a flat two-week supply, or expect fill rates below 90 percent.

Landed cost gets understated because buyers quote only the unit price and freight. Symptom: gross margin comes in 6 to 14 points under the quote sheet. Root cause: duty, brokerage, insurance, demurrage, and currency spread left out. A part quoted at 4.20 dollars FOB can land at 5.35 after a 6.5 percent duty, 0.28 freight, 0.09 insurance, and a 3 percent FX buffer. Run every offshore quote through the Landed Cost Calculator and the Tariff Impact Calculator before comparing to a domestic source, or the offshore win is imaginary.

Inventory turnover gets flattered by the wrong denominator. Symptom: turns look strong at 9 but cash is always tight. Root cause: turnover computed on ending inventory during a low-stock month instead of average inventory, or COGS swapped for revenue. Turnover is COGS divided by average inventory at cost. Using revenue inflates the ratio by your full margin, so a real 5.2 reads as 8.4. Feed the Inventory Turnover tool trailing 12-month COGS and a 13-point average of month-end balances to kill the seasonality distortion.

Carrying cost gets set to a lazy 10 percent and never revisited. Symptom: nobody can justify holding decisions and slow movers pile up. Root cause: the rate ignores current capital cost, obsolescence, insurance, shrink, and warehouse space. In a higher-rate environment the true figure is often 22 to 28 percent annually: 9 percent capital, 6 percent obsolescence, 4 percent storage, 2 percent shrink, 3 percent insurance and taxes. Rebuild it in the Inventory Carrying Cost tool. At 26 percent, a 400,000 dollar average inventory costs 104,000 per year to hold, which reframes every reorder quantity.

Supplier performance gets scored on price alone. Symptom: your cheapest vendor causes your worst stockouts. Root cause: on-time delivery and quality never enter the decision. A supplier 4 percent cheaper but at 82 percent on-time forces buffer stock and expedites that erase the saving. Track it with the Supplier On-Time Delivery tool and weight the Supplier Scorecard so price is 40 percent, delivery 30 percent, quality 20 percent, responsiveness 10 percent. Measure OTD against the confirmed date, not the revised date, or you are grading the supplier on its own excuses.

Purchase price variance gets read without context and triggers bad reactions. Symptom: a favorable PPV celebrated while inventory swells. Root cause: buyers hit a volume price break by overbuying, booking a 0.15 per unit favorable PPV while adding 60 days of stock at 26 percent carrying cost. On a 3-dollar part that 0.15 saving is dwarfed by 0.13 in extra holding cost over the excess period. Pair the Purchase Price Variance tool with carrying cost before rewarding a variance, and split price PPV from mix and FX so you know what actually moved.

Stockout cost is treated as just the lost margin, so service targets get set too low. Symptom: leadership sets a 90 percent fill rate to save inventory, then loses accounts. Root cause: the true stockout cost includes lost margin plus expedite freight, substitution loss, and customer churn. If a stockout on a 40-dollar item costs 18 in margin plus 12 expedite plus a 4 percent churn probability worth 90 in lifetime value, the real hit is near 30 to 35 per event. Model it in the Stockout Cost Calculator, then let that number, not a gut feel, set the service level.

Published 2026-07-01.