Reorder at 224 units, not 120: in the worked example a supplier running 14 days instead of 10 while sales hit 16 a day leaves 104 units short — $1,612 of gross profit gone on one SKU.
Reorder at 224 units — you have 6.3 days. Ordering at 120 instead leaves 104 units short in a worst-case delivery: $1,612.00 of gross profit.
| Gross margin per unit | $15.50 |
| Units sold during a usual lead time (average × usual days) | 120 |
| Units sold during a worst-case lead time (busiest × slowest) | 224 |
| Safety stock (worst case minus usual) | 104 |
| Reorder point — order when stock falls to this | 224 |
| Days of stock left at average sales | 25 |
| Days until you reach the reorder point (0 = order today) | 6.3 |
| Order quantity if you order today (covers lead time + cycle + safety stock) | 284 |
| Cost of that order | $2,414.00 |
| Gross profit lost in a worst-case lead time without safety stock | $1,612.00 |
| Stock value at cost (for your year-end count) | $2,550.00 |
| Cash held in the safety buffer | $884.00 |
Everything updates as you type. Nothing is uploaded. This runs in your browser.
Full version — $21 once (Excel, 5 sheets: 100-row SKU Register that flags REORDER NOW across your catalogue + Schedule C Part III year-end count).
Safety stock = (busiest day × slowest lead time) − (average day × usual lead time). Reorder point = average day × usual lead time + safety stock. Example: 12 a day on average, 16 on the busiest day, 10 days usual delivery, 14 days slowest → 120 + 104 = reorder at 224 units. A plain “average × lead time” reorder level of 120 runs 104 units short when the busy week and the late delivery land together — 104 × $15.50 margin = $1,612.
Stock value at cost is the number the IRS asks for on Schedule C (Form 1040) Part III line 41, “Inventory at end of year”. Count on 31 December, multiply by unit cost, add up every SKU. Corporations and partnerships use Form 1125-A. Yardstick: the median US logistician earns $39.58 an hour (BLS OEWS 2025, SOC 13-1081).