Agent skill · data analytics · davila7
safety-stock-review
Size or audit safety stock with assumption checks - the z*sigma*sqrt(LT) formula plus an empirical stress test of what it actually delivers (cycle service vs fill rate) per variability class. Use when the user mentions safety stock, emniyet stoku, emniyet stoğu, reorder point, service level, stok seviyesi belirleme. Differentiator - refuses to hand back a number without validating the demand-distribution assumptions behind it.
Why this skill is useful
Adds a comprehensive workflow for calculating and validating safety stock that includes empirical stress testing and specific recommendations based on demand variability.
What it needs
About 2k tokens when loaded. Last updated 2026-08-06. 30,138 stars on the source repository.
What this skill does
Safety Stock Review The textbook formula assumes roughly normal demand. Real portfolios contain SKUs where that assumption fails badly - the skill's job is to compute the number AND say where it can be trusted. Required data Per-SKU demand history (sku, period, qty, 12+ periods), lead time (with variability if available), and the service target. Clarify early which service the target means: cycle service (probability of no stockout per cycle) or fill rate (share of units served) - contracts usually mean fill rate, formulas usually compute cycle service. Workflow 1. Classify first. Compute CV and zero-period share per SKU. For CV >= 1.0 or intermittent demand, state up front that the normal-formula result will be optimistic. 2. Compute the formula result: SS = z sigmad sqrt(LT), ROP = mud LT + SS (demand-period units consistent with LT). If lead time varies, use the extended form with the sigmaLT term - ignoring lead-time variance is the most common silent understatement. 3. Stress-test empirically. Set stock at mu + SS and replay the actual history: report both achieved cycle service (share of periods fully covered) and achieved fill rate (units served / units demanded). Zero-demand periods pass cycle service for free - fill rate is the honest one on intermittent items. 4. Show the cost of nines. SS at 90/95/98/99% targets for the SKUs in question - service targets are pricing decisions, and the curve makes that visible. 5. Recommend per class, not globally: formula fine for X-class; formula + empirical check for Y; for Z-class recommend empirical/quantile-based sizing or a policy change (MTO, lead-time reduction) instead of a bigger z. 6. Validate. Reconcile the stress-test denominator (total units demanded) against the raw data sum before presenting. Pitfalls to check explicitly Cycle service quoted where the contract says fill rate - a penalty clause waiting to be found. Normal formula on lumpy demand understates risk precisely on the items that hurt most. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills davila7/safety-stock-review