Inventory Management Template — Reorder Point & Safety Stock for US Small Sellers

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.

Your numbers

Your result

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 this224
Days of stock left at average sales25
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).

The rule behind the numbers

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).

Get the full calculatorFull version: all tabs, your own file, works offline.

Open full tool → getreadystack.com · Put this on your site with your logo