Use when inventory levels need threshold calculation, restock quantities need computing, or demand-based reorder recommendations are needed.
Computes reorder points, restock quantities, and safety stock for each SKU using velocity data, lead times, and seasonal demand signals. Produces recommendations only — never makes purchase commitments.
Invoke when:
Do NOT use for:
ts_inventoryexecute_sqldata/inventory-snapshot.jsonts_orders. Adjust for upcoming Buddhist calendar events (Losar, Saga Dawa, Vesak, Q4).references/formulas.md. Flag immediately if a top-20 SKU is below critical alert threshold.references/formulas.md.data/restock-recommendations.json with confidence labels and data source.| Rationalization | Reality |
|---|---|
| "Daily velocity is roughly known, I'll skip the label" | Every figure needs explicit confidence label — confirmed or estimated. |
| "The Nepal lead time is probably shorter this time" | Use 8–12 weeks conservative. Never assume a faster timeline. |
| "Low-margin SKU, I'll skip the safety stock calc" | If it serves a practitioner need, compute it regardless of margin. |
| "FBA fields aren't in the snapshot, I'll use on-hand only" | Note the missing fields explicitly; do not silently ignore them. |
ts_ordersfba_allocated, fba_in_transit, nepal_pipeline, nepal_eta checkeddata/restock-recommendations.json