- Home
- Skills
- Agents & Orchestration
- Inventory Supply Chain Risk Analyst
Works with the AI Agents 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.
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.
Requires manual input of SKU and demand data. Cannot execute purchase orders or integrate directly with live ERP databases. Leads to illustrative results if demand variability is not provided.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 1 month ago
Permissions
No special permissions declared or detected