dead-stock-identifier

Dead Stock Identifier

Overview

The Dead Stock Identifier is a skill that identifies slow-moving and obsolete inventory, develops disposition strategies, and optimizes working capital. It analyzes velocity patterns, aging, and market conditions to recommend appropriate actions for excess inventory while maximizing value recovery.

Capabilities

• Velocity Analysis and Aging: Analyze item velocity trends and inventory aging to identify slow-moving and dead stock
• Obsolescence Risk Scoring: Calculate obsolescence risk scores based on lifecycle stage, technology changes, and market trends
• Disposition Strategy Recommendation: Recommend optimal disposition paths including markdown, liquidation, or donation
• Markdown Optimization: Determine optimal markdown levels and timing to maximize recovery
• Liquidation Channel Matching: Match excess inventory with appropriate liquidation channels and buyers
• Write-Off Impact Analysis: Calculate financial impact of write-offs and timing considerations
• SKU Rationalization Support: Support decisions on SKU discontinuation and assortment optimization

Tools and Libraries

• Inventory Analytics
• Markdown Optimization Tools
• Liquidation Platforms
• Financial Analysis Libraries

Used By Processes

• Dead Stock and Excess Inventory Management
• ABC-XYZ Analysis
• Cycle Counting Program

Usage

skill: dead-stock-identifier
inputs:
  inventory:
    - sku: "SKU001"
      description: "Widget A"
      quantity_on_hand: 500
      unit_cost: 25.00
      last_sale_date: "2025-06-15"
      monthly_sales_history: [5, 3, 2, 1, 0, 0, 0, 0]
      product_lifecycle: "declining"
    - sku: "SKU002"
      description: "Widget B"
      quantity_on_hand: 200
      unit_cost: 50.00
      last_sale_date: "2024-12-01"
      monthly_sales_history: [0, 0, 0, 0, 0, 0, 0, 0]
      product_lifecycle: "discontinued"
  analysis_parameters:
    slow_moving_threshold_days: 90
    dead_stock_threshold_days: 180
    holding_cost_percent: 25
outputs:
  inventory_analysis:
    - sku: "SKU001"
      classification: "slow_moving"
      days_since_last_sale: 224
      months_of_supply: 100
      inventory_value: 12500.00
      annual_holding_cost: 3125.00
      obsolescence_risk: "medium"
      disposition_recommendation:
        action: "markdown"
        suggested_discount: 40
        expected_recovery: 7500.00
        expected_liquidation_time_days: 60
    - sku: "SKU002"
      classification: "dead_stock"
      days_since_last_sale: 420
      months_of_supply: "infinite"
      inventory_value: 10000.00
      annual_holding_cost: 2500.00
      obsolescence_risk: "high"
      disposition_recommendation:
        action: "liquidate"
        liquidation_channel: "B-stock_marketplace"
        expected_recovery: 2000.00
        expected_liquidation_time_days: 30
  summary:
    total_slow_moving_value: 12500.00
    total_dead_stock_value: 10000.00
    total_annual_holding_cost: 5625.00
    total_expected_recovery: 9500.00
    total_write_off_exposure: 13000.00

Integration Points

• Enterprise Resource Planning (ERP) Systems
• Inventory Management Systems
• E-commerce Platforms
• Liquidation Marketplaces
• Financial Systems

Performance Metrics

• Dead stock percentage
• Inventory turnover
• Write-off rate
• Recovery rate
• Working capital released