Ecom Inventory Health Agent Skill
Analyze inventory health using turnover ratios, ABC classification, safety stock calculations, and stockout vs overstock diagnostics. Use this skill when the user needs to optimize inventory levels, reduce carrying costs, prevent stockouts, or classify products by inventory priority — even if they say 'we have too much stock', 'we keep running out of bestsellers', 'how much safety stock do we need', or 'which products should we focus on'.
Install
one command, takes just this skill from the repositorynpx skills add https://github.com/asgard-ai-platform/skills --skill ecom-inventory-healthWhat comes with it
25 495 bytes besides the instructionThe instruction itself
11 sections, as written by the authorInventory Health Analysis
Overview
Inventory health balances two risks: stockouts (lost sales, unhappy customers) and overstock (carrying costs, obsolescence). This skill provides tools to measure, classify, and optimize inventory levels.
Framework
IRON LAW: Not All SKUs Deserve Equal Attention
ABC classification shows that ~20% of SKUs drive ~80% of revenue.
Treat A-items (top 20% revenue) with tight control and frequent review.
C-items (bottom 50% revenue) get simple rules and less attention.
Equal treatment of all SKUs wastes resources on low-impact items.
Key Metrics
| Metric | Formula | Healthy Range |
|--------|---------|--------------|
| Inventory Turnover | COGS / Avg Inventory | 4-12x/year (industry-dependent) |
| Days of Inventory (DOI) | 365 / Inventory Turnover | 30-90 days |
| Stockout Rate | Stockout incidents / Total demand occasions | < 2-5% |
| Fill Rate | Orders filled completely / Total orders | > 95% |
| Carrying Cost | Avg Inventory × Carrying Cost % (typically 20-30%/year) | Minimize |
| Dead Stock % | Items with zero sales in 6+ months / Total SKUs | < 10% |
ABC Classification
| Class | Revenue % | SKU % | Strategy |
|-------|----------|-------|----------|
| A | ~80% | ~20% | Tight control, frequent review, safety stock optimized |
| B | ~15% | ~30% | Moderate control, periodic review |
| C | ~5% | ~50% | Simple rules, min/max levels, consider dropping |
Safety Stock Calculation
Safety Stock = Z × σ_d × √(Lead Time)
Where:
- Z = service level factor (1.65 for 95%, 2.33 for 99%)
- σ_d = standard deviation of daily demand
- Lead Time = supplier lead time in days
Reorder Point
Reorder Point = (Average Daily Demand × Lead Time) + Safety Stock
Diagnosis Steps
Phase 1: Overall Health Check
- Calculate turnover and DOI for total inventory
- Compare to industry benchmarks
- Identify trend: improving or deteriorating?
Phase 2: ABC Classification
- Rank all SKUs by revenue contribution
- Classify into A/B/C
- Check: are A-items well-stocked? Are C-items over-stocked?
Phase 3: Problem Identification
- Overstock: DOI > 90 days, dead stock > 10%, carrying costs rising
- Stockout: Fill rate < 95%, lost sales reports, customer complaints
- Imbalance: A-items understocked while C-items overstocked
Phase 4: Optimization
- Set safety stock by ABC class
- Implement reorder points for A-items
- Liquidate dead stock (discount, bundle, donate)
- Reduce lead times through supplier negotiation
Output Format
# Inventory Health Report: {Business}
## Summary
| Metric | Current | Target | Status |
|--------|---------|--------|--------|
| Turnover | {X}x | {X}x | 🟢/🟡/🔴 |
| DOI | {X} days | {X} days | 🟢/🟡/🔴 |
| Fill Rate | {X%} | >95% | 🟢/🟡/🔴 |
| Dead Stock | {X%} | <10% | 🟢/🟡/🔴 |
## ABC Distribution
| Class | SKUs | Revenue % | Avg DOI | Issue |
|-------|------|----------|---------|-------|
| A | {N} | {%} | {days} | {stockout risk?} |
| B | {N} | {%} | {days} | ... |
| C | {N} | {%} | {days} | {overstock?} |
## Top Issues
1. {issue with specific SKUs and data}
## Recommendations
1. {action with expected impact}
Gotchas
- Seasonal products need separate treatment: Swimsuits in January will show as "dead stock" but shouldn't be liquidated. Use seasonal adjustment or analyze by season.
- Inventory turnover varies hugely by industry: Grocery: 20-50x/year. Fashion: 4-6x. Electronics: 6-12x. Always benchmark within industry.
- Low turnover ≠ bad if intentional: Strategic inventory (buying ahead of price increases, securing supply) may justify lower turnover.
- ABC classifications shift: A product that was A-class last year may be C-class this year. Reclassify quarterly.
- Carrying cost is often underestimated: Include: warehouse rent, insurance, obsolescence, capital cost (opportunity cost of money tied up), handling labor. Total is typically 20-30% of inventory value per year.
References
- For EOQ (Economic Order Quantity) model, see
references/eoq-model.md - For seasonal demand forecasting, see
references/seasonal-forecasting.md
Other skills for the same job
different authors, same section of the catalogue
Automatically organizes invoices and receipts for tax preparation by reading messy files, extracting key information, renaming them consistently, and sorting them into logical folders. Turns hours of manual bookkeeping into minutes of automated organization.
Expert guidance for systematic backtesting of trading strategies. Use when developing, testing, stress-testing, or validating quantitative trading strategies. Covers "beating ideas to death" methodology, parameter robustness testing, slippage modeling, bias prevention, and interpreting backtest results. Applicable when user asks about backtesting, strategy validation, robustness testing, avoiding overfitting, or systematic trading development.
This skill calculates key financial ratios and metrics from financial statement data for investment analysis
This skill provides an advanced financial modeling suite with DCF analysis, sensitivity testing, Monte Carlo simulations, and scenario planning for investment decisions
This skill retrieves upcoming earnings announcements for US stocks using the Financial Modeling Prep (FMP) API. Use this when the user requests earnings calendar data, wants to know which companies are reporting earnings in the upcoming week, or needs a weekly earnings review. The skill focuses on mid-cap and above companies (over $2B market cap) that have significant market impact, organizing the data by date and timing in a clean markdown table format. Supports multiple environments (CLI, Desktop, Web) with flexible API key management.
Crypto wallet operations via the awal CLI — sign in, check balances, send USDC/ETH/POL/SOL, trade tokens, fund the wallet, and use the x402 payment protocol to discover paid services, pay for API calls, monetize an API, or query onchain data. Use whenever the user mentions signing in, login, authentication, wallet status, balance, address, sending money, paying someone, transferring tokens, ENS names, swapping/trading/converting tokens, funding/topping up/onramp, USDC, ETH, POL, SOL, the x402 bazaar, paid APIs, monetizing an endpoint, or querying onchain data on Base.
Access real-time and historical stock market data, forex rates, cryptocurrency prices, commodities, economic indicators, and 50+ technical indicators via the Alpha Vantage API. Use when fetching stock prices (OHLCV), company fundamentals (income statement, balance sheet, cash flow), earnings, options data, market news/sentiment, insider transactions, GDP, CPI, treasury yields, gold/silver/oil prices, Bitcoin/crypto prices, forex exchange rates, or calculating technical indicators (SMA, EMA, MACD, RSI, Bollinger Bands). Requires a free API key from alphavantage.co.
Braintree Automation: manage payment processing via Stripe-compatible tools for customers, subscriptions, payment methods, and transactions
How to use it
Take asgard-ai-platform/ecom-inventory-health from the repository into ~/.claude/skills for personal
use, or into .claude/skills inside a project.
The agent identifies a skill by the name field in its header. Two skills with the
same name cannot sit side by side — one of them will be ignored.