leehengyu/mediator-coevo/inventory-manager

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

Optimizes inventory levels, predicts demand, and manages stock across warehouses. Use when analyzing inventory, planning reorders, or optimizing supply chain.

Install

npx vskill@latest install leehengyu/mediator-coevo/inventory-manager

SKILL.md

Inventory Management System

Overview

This skill provides systematic approaches to inventory optimization, demand forecasting, and supply chain management for e-commerce and retail businesses.

Key Metrics

Stock Level Metrics
MetricFormulaTarget
Days of SupplyCurrent Inventory / Daily Sales Rate14-45 days
Stock TurnCOGS / Average Inventory4-12x annually
Fill RateOrders Fulfilled / Total Orders> 95%
Stockout RateStockout Days / Total Days< 2%

Calculations:

Days of Supply = Current Inventory Units / Average Daily Sales
Stock Turn = Annual COGS / Average Inventory Value
Fill Rate = (Orders Shipped Complete) / (Total Orders) × 100
Stockout Rate = (Days with Zero Stock) / (Total Days) × 100
Reorder Calculations

Reorder Point Formula:

Reorder Point = (Lead Time × Daily Sales) + Safety Stock
 
Example:
- Lead time: 14 days
- Daily sales: 50 units
- Safety stock: 200 units
- Reorder Point = (14 × 50) + 200 = 900 units

Safety Stock Formula:

Safety Stock = Z × σd × √L
 
Where:
Z = Service level factor (1.65 for 95%, 2.33 for 99%)
σd = Standard deviation of daily demand
L = Lead time in days

Economic Order Quantity (EOQ):

EOQ = √[(2 × D × S) / H]
 
Where:
D = Annual demand
S = Order cost per order
H = Holding cost per unit per year

Alert Thresholds

StatusDays of SupplyAction Required
Critical< 7 daysImmediate reorder, expedite
Low7-14 daysPlace reorder now
Normal14-45 daysMonitor, scheduled reorder
Excess> 45 daysEvaluate markdown/transfer
Dead Stock> 90 days, zero salesLiquidate or dispose

Inventory Actions

Low Stock Response

Immediate Actions:

  1. Check supplier lead times and capacity
  2. Evaluate expedited shipping costs vs. stockout cost
  3. Identify substitute products to recommend
  4. Update availability display on storefront
  5. Pause marketing campaigns driving demand

Reorder Decision Matrix:

ScenarioStandard OrderExpedited Order
Lead time < stockoutYesNo
Lead time > stockoutNoEvaluate cost
High margin productConsiderYes
Low margin productYesNo
Excess Stock Response

Evaluation Steps:

  1. Analyze why stock became excess
  • Demand drop
  • Forecast error
  • Cancelled orders
  • Seasonal mismatch
  1. Markdown Strategy:
Markdown % = (Holding Cost × Projected Days) / Unit Cost
 
If Markdown % > 30%: Consider liquidation
If Markdown % 10-30%: Promotional pricing
If Markdown % < 10%: Price optimization
  1. Alternative Actions:
  • Warehouse transfer to higher-demand location
  • Bundle with fast-moving items
  • B2B wholesale channel
  • Donation (tax benefit calculation)
Dead Stock Management
Dead Stock Cost = Units × (Holding Cost + Opportunity Cost)
Liquidation Value = Units × (Salvage Price - Liquidation Cost)
 
Decision: Liquidate if Liquidation Value > 0 or Dead Stock Cost/month > Liquidation Cost

Demand Forecasting

Methods
MethodBest ForAccuracy
Moving AverageStable demandMedium
Exponential SmoothingTrending demandMedium-High
ARIMASeasonal patternsHigh
ML/AIComplex patternsHighest
Simple Forecasting Formula
Forecast = (α × Recent Sales) + ((1-α) × Previous Forecast)
 
Where α = 0.2 to 0.5 (smoothing factor)
Higher α = More responsive to recent changes
Seasonality Adjustment
Seasonal Index = Period Sales / Average Period Sales
 
Adjusted Forecast = Base Forecast × Seasonal Index
 
Example (Q4 Holiday Season):
- Base forecast: 1,000 units
- Q4 Index: 1.8
- Adjusted forecast: 1,800 units

Multi-Warehouse Management

Allocation Strategy
FactorWeightConsideration
Regional demand40%Historical sales by region
Lead time to customers25%Shipping speed goals
Warehouse capacity20%Available space
Cost15%Storage and shipping costs
Transfer Decision
Transfer if:
1. Source warehouse: Days of Supply > 60
2. Destination warehouse: Days of Supply < 14
3. Transfer cost < (Stockout cost × Stockout probability)

Reporting Templates

Daily Inventory Report
SKUCurrent StockDays SupplyStatusAction
Weekly Performance Report
MetricThis WeekLast WeekTrend
Fill Rate
Stockout %
Avg Days Supply
Inventory Value
Stock Turn (Ann.)
Monthly Analysis
  • Top 10 fast-moving SKUs
  • Top 10 slow-moving SKUs
  • Forecast vs. actual variance analysis
  • Supplier performance scorecard
  • Dead stock report
  • Inventory valuation changes

Integration Points

  • ERP: Real-time stock levels
  • POS: Sales velocity data
  • WMS: Warehouse capacity
  • TMS: Lead time updates
  • Supplier Portal: Order status
  • E-commerce Platform: Availability sync

Security

  • Security scanPassed, 95 of 100Pattern checks on the skill's files.
  • Model reviewPassed

See the full security report

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

See evaluation results

Source

Popularity

Repository forks
1
7-day trend score
0

Stars and forks are for the whole GitHub repository, not this skill alone. Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/leehengyu/mediator-coevo/inventory-manager/badge)](https://verified-skill.com/skills/leehengyu/mediator-coevo/inventory-manager)

Something wrong with this skill or its page? Tell us.