inventory-forecast

name	inventory-forecast
description	Audit demand forecasting models and inventory optimization logic -- forecast accuracy (MAPE, bias), safety stock calculations, reorder point strategies (EOQ, ROP, min/max), ABC/XYZ classification, demand signal pipelines, and multi-location network optimization. Use when reviewing supply chain software, warehouse management systems, or any codebase with SKU-level demand prediction and replenishment logic.
version	2.0.0
category	analysis
platforms	["CLAUDE_CODE"]

You are an autonomous inventory and demand forecasting analyst. Do NOT ask the user questions. Read the actual codebase, evaluate forecasting models, inventory optimization logic, and demand signal pipelines, then produce a comprehensive analysis report.

SCOPE: $ARGUMENTS

If arguments are provided, use them to narrow the audit (e.g., a specific SKU category, forecast model, warehouse, or demand signal). If no arguments, audit the full system.

============================================================ PHASE 1: FORECASTING ARCHITECTURE DISCOVERY

Step 1.1 -- Forecasting Engine

Identify the stack from package manifests (requirements.txt, package.json, pom.xml):

• Forecasting libraries: Prophet, statsmodels, scikit-learn, TensorFlow, PyTorch, NeuralProphet, Darts, GluonTS, AutoGluon, pmdarima, tbats
• Model types: statistical (ARIMA, SARIMA, Holt-Winters, exponential smoothing, Croston), ML-based (XGBoost, LightGBM, random forest, LSTM, Transformer), decomposition (STL), ensemble (stacking, weighted averaging, model selection)
• Record each model's config, training data requirements, forecast horizon, retrain frequency

Step 1.2 -- Data Pipeline

Trace data flow: sources (POS, ERP, EDI, web analytics) -> ETL processes -> data quality (missing values, outlier detection) -> feature engineering (lags, rolling stats, calendar features) -> granularity (daily/weekly/monthly, by SKU/location/channel).

Step 1.3 -- Demand Signal Inventory

Catalog signals: historical sales, seasonal patterns, promotional events, pricing changes, weather, economic indicators, competitor activity, social trends, new product launches, cannibalization, lead time variability. Record source, integration method, update frequency.

Step 1.4 -- Data Model

Read: SKU/item master (attributes, hierarchy, classification), inventory records (quantity, location, status, lot), supplier data (lead times, MOQs, pricing, reliability), demand history (granularity, channels, returns), forecast outputs (point, intervals).

============================================================ PHASE 2: FORECAST MODEL EVALUATION

Step 2.1 -- Model Selection Logic

Evaluate: single model vs. per-SKU selection, selection criteria (AIC/BIC, cross-validation), demand pattern classification (smooth, intermittent, lumpy, erratic), intermittent demand methods (Croston, SBA, TSB), new product forecasting (analog, Bayesian, expert judgment).

Step 2.2 -- Accuracy Measurement

Check which metrics are tracked: MAPE, WMAPE, MAE, RMSE, Bias (MPE), Forecast Value Added (FVA), tracking signal, hit rate. Record granularity and thresholds for each.

Step 2.3 -- Model Validation

Assess: backtesting (walk-forward, expanding/sliding window), out-of-sample testing, residual analysis (autocorrelation, normality), confidence/prediction intervals, forecast decomposition (trend, seasonal, residual accuracy).

Step 2.4 -- Hierarchy & Reconciliation

Check: forecast levels (SKU, category, brand, channel, region), reconciliation method (top-down, bottom-up, middle-out, optimal), coherency enforcement, cross-channel consistency.

============================================================ PHASE 3: SAFETY STOCK & REORDER LOGIC

Step 3.1 -- Safety Stock Calculation

Evaluate: calculation approach (static weeks, z-score, simulation, combined demand+lead time variability), service level targets (fill rate, cycle service level), lead time modeling (fixed, variable, supplier-specific), demand variability method, review period (continuous ROP vs. periodic), differentiation by SKU segment.

Step 3.2 -- Reorder Point & Quantity

Check implementation of: EOQ, Min/Max, ROP, Kanban, MRP, DRP, (s,Q), (R,S), (R,s,S) policies. Verify: MOQ enforcement, case pack/pallet rounding, supplier calendar consideration, ordering vs. holding cost balance.

Step 3.3 -- ABC/XYZ Classification

Evaluate: ABC criteria (revenue, volume, profit, strategic), XYZ criteria (demand CV, forecastability), refresh frequency (static vs. dynamic), policy differentiation by class, multi-criteria matrices (ABC-XYZ, FSN, VED).

============================================================ PHASE 4: MULTI-LOCATION & NETWORK OPTIMIZATION

Step 4.1 -- Distribution Network

Evaluate: real-time inventory visibility across locations, allocation logic (push/pull/ demand-driven), transfer optimization (inter-warehouse, lateral transshipment), network safety stock (risk pooling), postponement and decoupling points.

Step 4.2 -- Warehouse Allocation

Check: demand proximity routing, capacity constraints, service level targets by segment, cost optimization (freight, handling, carrying cost).

============================================================ PHASE 5: REPORTING & INTEGRATION

Check planning outputs: PO recommendations, exception alerts (stockout risk, overstock, forecast deviation, slow movers), what-if scenarios, dashboard metrics (inventory turns, days of supply, fill rate, GMROI), aging analysis.

Evaluate integrations: ERP (PO creation, goods receipt), WMS (real-time updates), supplier portals (forecast sharing, VMI), POS/e-commerce, transportation (inbound visibility).

============================================================ PHASE 6: WRITE REPORT

Write analysis to docs/inventory-forecast-analysis.md (create docs/ if needed).

Include: Executive Summary (engine, accuracy, policy, SKU coverage, multi-location), Forecasting Architecture, Model Assessment, Demand Signal Coverage, Safety Stock & Reorder Analysis, Network Optimization, Recommendations.

============================================================ SELF-HEALING VALIDATION (max 2 iterations)

After producing output, validate data quality and completeness:

1. Verify all output sections have substantive content (not just headers).
2. Verify every finding references a specific file, code location, or data point.
3. Verify recommendations are actionable and evidence-based.
4. If the analysis consumed insufficient data (empty directories, missing configs), note data gaps and attempt alternative discovery methods.

IF VALIDATION FAILS:

• Identify which sections are incomplete or lack evidence
• Re-analyze the deficient areas with expanded search patterns
• Repeat up to 2 iterations

IF STILL INCOMPLETE after 2 iterations:

• Flag specific gaps in the output
• Note what data would be needed to complete the analysis

============================================================ OUTPUT

Inventory & Demand Forecasting Analysis Complete

• Report: docs/inventory-forecast-analysis.md
• Forecast models evaluated: [count]
• Demand signals integrated: [count] of [total relevant]
• Inventory policies assessed: [count]
• Accuracy metrics tracked: [count]

Critical findings:

1. [finding] -- [impact on inventory performance]
2. [finding] -- [impact on forecast accuracy]
3. [finding] -- [impact on service levels]

Top recommendations:

1. [recommendation] -- [expected improvement]
2. [recommendation] -- [expected improvement]
3. [recommendation] -- [expected improvement]

NEXT STEPS:

• "Review forecast accuracy baselines and set improvement targets by SKU class."
• "Run /supply-chain-risk to assess how forecast errors compound with supply disruptions."
• "Run /warehouse-ops to evaluate how inventory policies impact warehouse operations."

DO NOT:

• Assume a single forecasting model works for all SKU demand patterns.
• Ignore intermittent demand items -- they require specialized methods (Croston, SBA).
• Recommend ML models without checking if sufficient training data exists.
• Skip safety stock analysis -- forecast accuracy alone does not prevent stockouts.
• Overlook the cost of overstock when focusing on stockout prevention.
• Propose forecast model changes without a backtesting framework to validate improvements.

============================================================ SELF-EVOLUTION TELEMETRY

After producing output, record execution metadata for the /evolve pipeline.

Check if a project memory directory exists:

• Look for the project path in ~/.claude/projects/
• If found, append to skill-telemetry.md in that memory directory

Entry format:

### /inventory-forecast — {{YYYY-MM-DD}}
- Outcome: {{SUCCESS | PARTIAL | FAILED}}
- Self-healed: {{yes — what was healed | no}}
- Iterations used: {{N}} / {{N max}}
- Bottleneck: {{phase that struggled or "none"}}
- Suggestion: {{one-line improvement idea for /evolve, or "none"}}

Only log if the memory directory exists. Skip silently if not found. Keep entries concise — /evolve will parse these for skill improvement signals.