Most inventory spreadsheets record what you have. That is the easy half. The half that prevents stockouts is knowing, for every SKU, the stock level at which you must place the next order — and seeing it without doing the arithmetic yourself.
This template holds 100 SKUs and calculates safety stock, reorder point, days of cover, and a plain-language status for each one. It counts stock already on order, so a SKU with a container in transit does not keep shouting at you.
| Field | What goes in it |
|---|---|
| SKU / Product / Warehouse | What it is and where it sits. Works across multiple locations. |
| Unit cost | Landed cost per unit, ideally, not just the supplier price. |
| On hand / On order | Current stock and units already in transit or in production. |
| Daily demand | Average units sold per day. The number everything else keys off. |
| Lead time (days) | Production plus transit plus customs — the full replenishment cycle. |
| Safety buffer (days) | Your cushion for late shipments and demand spikes. |
| Safety stockauto | Daily demand × buffer days. |
| Reorder pointauto | (Daily demand × lead time) + safety stock. |
| Days of coverauto | On hand ÷ daily demand. |
| Statusauto | OK, REORDER NOW, or CRITICAL — below safety stock. |
| Stock valueauto | On hand × unit cost. |
The factory quoting 30 days means 30 days to produce. Add transit and customs clearance or your reorder point will be short by weeks.
Comparing on-hand against the reorder point alone triggers duplicate orders for SKUs with a container already at sea. This template adds on-order before it decides.
A reliable supplier on a short lane needs less cushion than a new factory on a congested one. The buffer is per SKU in this sheet for exactly that reason.
Standardised PO with automatic line totals, HS code fields, Incoterms, and payment terms.
Carton-level packing list that calculates total units, net and gross weight, CBM, and chargeable weight.
Customs-ready invoice with per-line HS codes, country of origin, Incoterms, and a declaration block.
Weighted scorecard comparing up to four suppliers across eight criteria, with automatic ranking.
Month-by-month P&L that turns orders, product cost, ad spend, and fees into net profit and margin automatically.
A spreadsheet works until there are eleven versions of it and nobody knows which one the supplier filled in. SupplyAutomate keeps purchase orders, supplier documents, shipments, and landed costs in one workspace that updates as the order moves.