- Home
- Skills
- Agents & Orchestration
- Inventory Supply Chain Risk Analyst
Works with the AI tools you already use
Inventory Supply Chain Risk Analyst
Analyze inventory risks, calculate safety stock, and model supply chain disruptions for your SKU list.
$11
Inventory Supply Chain Risk Analyst
Example session with this skill installed
Analyze this SKU: SKU-001, On-hand: 500 units, Avg Daily Demand: 20 units (StdDev 5), Lead Time: 14 days, Supplier: Acme Corp (Single Source), Unit Cost: $10. Service Level Target: 95%.
- Read your context and instructions
- Compiled the inventory supply chain
I have analyzed the inventory position for SKU-001. The current stock levels indicate a moderate risk of stockout if lead times extend beyond the current 14-day baseline.
Inventory & Risk Analysis: SKU-001
| Metric | Value | Status/Calculation |
|---|---|---|
| Current Days of Supply | 25.0 Days | On-hand / Avg Daily Demand |
| Demand during Lead Time | 280 Units | 20 units/day * 14 days |
| Safety Stock (95% SL) | 93 Units | 1.645 * (5 * sqrt(14)) |
| Reorder Point (ROP) | 373 Units | 280 + 93 |
| Net Excess / (Shortfall) | 127 Units | Above current ROP threshold |
| Supplier Concentration | 100% | Single-source dependency: Acme Corp |
Scenario Analysis
- Base Case: 25 days of cover. No immediate stockout.
Lead Time Shock (+7 days): If lead time increases to 21 days, Demand during Lead Time rises to 420. The current 500 units leave only 80 units of safety buffer, significantly increasing stockout probability.
- Demand Spike (+25%): Daily demand at 25 units reduces current coverage to 20 days.
Financial Exposure
- Carrying Cost: Estimated at $250.00 annually (assuming 5% holding cost on 500 units).
- Stockout Risk: Reaching the ROP in approx. 6 days.
Next steps
1.
Initiate Reorder: Current inventory is above ROP, but monitor closely as you are within 6 days of the reorder trigger.
2. Diversify Sourcing: Evaluate a secondary supplier for SKU-001 to mitigate the 100% Acme Corp concentration.
3. Buffer Review: If demand StdDev increases, safety stock must be recalculated to avoid stockouts.
Connects securely to your tools. The creator never sees your data.
What you get
About this skill
Supply chain disruptions and stockouts are often identified too late, leading to lost revenue or capital tied up in excess stock. This skill provides a quantitative framework to analyze your inventory data, calculate risk thresholds, and model lead-time shocks without the need for complex ERP modules.
What it does Inventory Health Analysis calculates days of supply, inventory turns, and identifies slow-moving or excess stock items. Safety Stock Modeling generates reorder points and safety stock levels based on your specific service-level targets and demand variability. Supply Chain Risk Mapping identifies single-supplier dependencies and regional concentration risks across your SKU list. Scenario Stress Testing simulates demand spikes and lead-time extensions to predict stockout windows before they happen. Financial Impact Assessment estimates the carrying costs of excess inventory versus the lost-sale exposure of stockouts. How it works Data Intake by providing your SKU list, on-hand quantities, lead times, and historical or forecast demand. Analysis Execution where the agent reconstructs demand patterns and calculates reorder parameters for each SKU. Stress Testing triggers scenario modeling for supply chain delays or sudden demand surges. Report Generation produces a risk comparison table, cost impact analysis, and specific action triggers for procurement. Frameworks & tools
This skill is framework-agnostic and processes data provided in CSV, Markdown tables, or plain text. It uses standard inventory management formulas including Reorder Point (ROP) and safety stock calculations based on lead-time demand distribution.
Why this beats prompting it yourself
Writing prompts to handle inventory math often results in inconsistent unit handling or hallucinated safety stock levels. This skill enforces strict logic gates for demand variability, mandates formula transparency, and ensures that illustrative assumptions are never confused with hard data.
Use cases Identify which products will stock out first during a 30-day port strike. Calculate how much capital is trapped in XYZ category slow-moving inventory. Determine the reorder point for a new SKU with high lead-time uncertainty. Audit supplier concentration to find single points of failure in your BOM. Known limitations
Does not integrate directly with live ERP APIs or provide real-time freight tracking. Requires user-provided demand and lead-time data to function.
How to install
Works the same in every agent - Claude, Cursor, Codex, Copilot and 20+ more.
- 1
Download the ZIP
Free skills download straight away. Paid skills unlock right after purchase.
- 2
Unzip into your skills folder
Every agent reads skills from one folder on your machine. Drop the unzipped folder in there.
- 3
Ask your agent to use it
Restart the agent if it was already running. It picks the skill up automatically - no config needed.
Skills folder by agent
Click the path to copy it. Create the folder if it does not exist yet.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
30-day refund
Not a fit? Get your money back
Trust & safety
Security scanned
Verified clean 5 days ago
- Passed all security checks, Safe to install