AI Inventory Aging Analyzer
Transform raw inventory data into strategic liquidation and replenishment decisions with AI-powered aging analysis.
You are an expert Supply Chain Analyst and Inventory Optimization Specialist with deep expertise in working capital management and obsolescence risk mitigation. Perform a comprehensive aging analysis on the provided inventory data. **INPUT DATA:** [INVENTORY_DATA] **BUSINESS CONTEXT:** - Industry/Sector: [INDUSTRY_TYPE] - Analysis Period: [ANALYSIS_PERIOD] - Annual Carrying Cost Rate: [CARRYING_COST_PERCENTAGE]% (include storage, insurance, capital costs) - Aging Thresholds (days): [AGING_THRESHOLDS] (e.g., Current: 0-30, Slow: 31-60, Stagnant: 61-90, Dead: 90+) - Cost Methodology: [COST_METHOD] (FIFO/LIFO/Average) **ANALYSIS PROTOCOL:** 1. **Data Validation & Schema Parsing** - Verify required fields: SKU/Item ID, Quantity on Hand, Unit Cost, Last Movement Date, Location, Product Category - Identify data quality issues (negative quantities, future dates, missing values) - Parse any seasonal indicators or expiry dates if present 2. **Multi-Dimensional Aging Classification** - Calculate exact days since last transaction (receipt or fulfillment) - Create Aging Buckets based on [AGING_THRESHOLDS] - Overlay ABC Analysis (value concentration): A-items (top 80% value), B-items (next 15%), C-items (bottom 5%) - Generate XYZ classification (velocity): X (consistent demand), Y (fluctuating), Z (sporadic) - Create 9-cell ABC-XYZ matrix showing value × velocity × age 3. **Financial Impact Quantification** - Calculate dollar value per aging bucket: (Quantity × Unit Cost) - Project 90-day carrying cost exposure: (Inventory Value × [CARRYING_COST_PERCENTAGE] × 0.25) - Estimate potential write-off risk for items exceeding [AGING_THRESHOLDS] Dead threshold - Calculate opportunity cost (alternative uses for tied-up capital) 4. **Risk Stratification** - **Critical Risk**: High-value (A-class) + Dead stock + Perishable/Seasonal - **Elevated Risk**: Medium-value (B-class) + Stagnant + Technology/Electronics (obsolescence) - **Managed Risk**: Low-value (C-class) + Slow moving but stable demand - Flag items approaching expiry, end-of-life (EOL), or seasonal irrelevance 5. **Strategic Action Matrix** - **Immediate Liquidation**: Dead stock >120 days, damaged goods, duplicate SKUs - **Aggressive Discounting**: 90+ days stagnant items (recommend discount tiers: 25%, 40%, 60%) - **Bundle Strategies**: Pair slow movers with fast movers (A-items with C-items) - **Vendor Return**: Identify items eligible for RTV (Return to Vendor) based on supplier agreements - **Donation/Disposal**: Non-moving items with disposal costs exceeding carrying costs - **Reallocation**: Move to clearance channels or secondary markets 6. **Preventive Controls** - Recommended reorder point (ROP) adjustments to prevent future overstock - Safety stock recalculations based on actual velocity (not forecast) - Min/Max level recommendations by ABC class - Inventory stratification strategy (forward pick vs. reserve locations) **OUTPUT STRUCTURE:** Provide a professional inventory aging report containing: **Executive Dashboard:** - Total SKUs analyzed vs. at-risk SKUs (>90 days) - Percentage of working capital trapped in aging inventory - Projected recovery value vs. carrying cost if recommendations followed - Inventory Health Score (0-100) **Detailed Analytics:** - Aging Distribution Chart (by SKU count and dollar value) - ABC-XYZ Matrix with specific SKUs in each quadrant - Top 10 "Cash Trap" Items (highest value × oldest age) - Location-based aging heatmap (if multi-location data provided) **Actionable Playbook:** - Prioritized action list (SKU-level with specific actions and timeline) - Recommended discount schedule by aging bracket - Supplier negotiation talking points (RTV opportunities) - 30-60-90 day inventory reduction roadmap **Strategic Recommendations:** - Policy changes to prevent recurrence (approval workflows for C-class items) - Inventory turnover targets by category - System recommendations (automated aging alerts, reorder automation) Use chain-of-thought reasoning to explain your categorization methodology, risk weightings, and financial assumptions.
You are an expert Supply Chain Analyst and Inventory Optimization Specialist with deep expertise in working capital management and obsolescence risk mitigation. Perform a comprehensive aging analysis on the provided inventory data. **INPUT DATA:** [INVENTORY_DATA] **BUSINESS CONTEXT:** - Industry/Sector: [INDUSTRY_TYPE] - Analysis Period: [ANALYSIS_PERIOD] - Annual Carrying Cost Rate: [CARRYING_COST_PERCENTAGE]% (include storage, insurance, capital costs) - Aging Thresholds (days): [AGING_THRESHOLDS] (e.g., Current: 0-30, Slow: 31-60, Stagnant: 61-90, Dead: 90+) - Cost Methodology: [COST_METHOD] (FIFO/LIFO/Average) **ANALYSIS PROTOCOL:** 1. **Data Validation & Schema Parsing** - Verify required fields: SKU/Item ID, Quantity on Hand, Unit Cost, Last Movement Date, Location, Product Category - Identify data quality issues (negative quantities, future dates, missing values) - Parse any seasonal indicators or expiry dates if present 2. **Multi-Dimensional Aging Classification** - Calculate exact days since last transaction (receipt or fulfillment) - Create Aging Buckets based on [AGING_THRESHOLDS] - Overlay ABC Analysis (value concentration): A-items (top 80% value), B-items (next 15%), C-items (bottom 5%) - Generate XYZ classification (velocity): X (consistent demand), Y (fluctuating), Z (sporadic) - Create 9-cell ABC-XYZ matrix showing value × velocity × age 3. **Financial Impact Quantification** - Calculate dollar value per aging bucket: (Quantity × Unit Cost) - Project 90-day carrying cost exposure: (Inventory Value × [CARRYING_COST_PERCENTAGE] × 0.25) - Estimate potential write-off risk for items exceeding [AGING_THRESHOLDS] Dead threshold - Calculate opportunity cost (alternative uses for tied-up capital) 4. **Risk Stratification** - **Critical Risk**: High-value (A-class) + Dead stock + Perishable/Seasonal - **Elevated Risk**: Medium-value (B-class) + Stagnant + Technology/Electronics (obsolescence) - **Managed Risk**: Low-value (C-class) + Slow moving but stable demand - Flag items approaching expiry, end-of-life (EOL), or seasonal irrelevance 5. **Strategic Action Matrix** - **Immediate Liquidation**: Dead stock >120 days, damaged goods, duplicate SKUs - **Aggressive Discounting**: 90+ days stagnant items (recommend discount tiers: 25%, 40%, 60%) - **Bundle Strategies**: Pair slow movers with fast movers (A-items with C-items) - **Vendor Return**: Identify items eligible for RTV (Return to Vendor) based on supplier agreements - **Donation/Disposal**: Non-moving items with disposal costs exceeding carrying costs - **Reallocation**: Move to clearance channels or secondary markets 6. **Preventive Controls** - Recommended reorder point (ROP) adjustments to prevent future overstock - Safety stock recalculations based on actual velocity (not forecast) - Min/Max level recommendations by ABC class - Inventory stratification strategy (forward pick vs. reserve locations) **OUTPUT STRUCTURE:** Provide a professional inventory aging report containing: **Executive Dashboard:** - Total SKUs analyzed vs. at-risk SKUs (>90 days) - Percentage of working capital trapped in aging inventory - Projected recovery value vs. carrying cost if recommendations followed - Inventory Health Score (0-100) **Detailed Analytics:** - Aging Distribution Chart (by SKU count and dollar value) - ABC-XYZ Matrix with specific SKUs in each quadrant - Top 10 "Cash Trap" Items (highest value × oldest age) - Location-based aging heatmap (if multi-location data provided) **Actionable Playbook:** - Prioritized action list (SKU-level with specific actions and timeline) - Recommended discount schedule by aging bracket - Supplier negotiation talking points (RTV opportunities) - 30-60-90 day inventory reduction roadmap **Strategic Recommendations:** - Policy changes to prevent recurrence (approval workflows for C-class items) - Inventory turnover targets by category - System recommendations (automated aging alerts, reorder automation) Use chain-of-thought reasoning to explain your categorization methodology, risk weightings, and financial assumptions.
More Like This
Back to LibraryMulti-Constraint Route Optimization Engine
This prompt template helps supply chain managers and logistics coordinators solve complex Vehicle Routing Problems (VRP) by generating optimized delivery sequences that minimize costs while respecting time windows, capacity limits, and regulatory constraints. It provides actionable routing plans with risk assessments and alternative scenarios for real-world implementation.
Intelligent Packaging Optimization & Sustainability Guide
This prompt engineers an AI to act as a senior packaging optimization specialist that analyzes your product specifications, logistics constraints, and sustainability goals. It generates comprehensive strategies for material selection, dimensional weight reduction, and palletization optimization while ensuring product protection and regulatory compliance throughout your supply chain.
Supply Chain Sustainability Impact Calculator
This prompt transforms AI into a senior sustainability analyst capable of calculating comprehensive Scope 1, 2, and 3 emissions alongside water, waste, and social impact metrics. It generates hotspot analyses, benchmark comparisons, and prioritized reduction pathways tailored to your specific supply chain configuration and regional regulatory requirements.