Obsolete / Slow-Moving Stock
Identify inventory at risk of obsolescence and quantify tied-up capital to support clearance and planning decisions.
Inputs
Provide a CSV with columns: SKU,OnHand,UnitCost,LastMovementDate(YYYY-MM-DD),AvgDemand(optional) or paste data below.
Summary KPIs
Aging & Risk Table
How it works
This tool analyses each SKU row using the following steps and formulas to identify slow-moving and obsolete stock and estimate value at risk.
Key calculations
- Age (days) = Days since LastMovementDate. Items with invalid or missing dates are shown as Unknown.
- Item value = OnHand × UnitCost.
- Category rules:
- If Age > Obsolete threshold → Category = Obsolete.
- Else if Age > Slow-moving threshold → Category = Slow-moving.
- Else → Category = Active.
- Risk score (0–100) = round( Age_norm × 0.65 + (1 − Demand_norm) × 0.35 ) × 100
Where:- Age_norm = min(Age / ObsoleteThreshold, 1)
- Demand_norm = small-scale normalization of average demand (if provided); higher demand reduces risk (see source code for the simple scaling used).
Summary statistics
- Total inventory value: sum of Item value for all SKUs.
- Slow-moving inventory value: sum of Item value for SKUs categorized as Slow-moving.
- Obsolete inventory value: sum of Item value for SKUs categorized as Obsolete.
- % of value at risk: (Slow-moving value + Obsolete value) ÷ Total inventory value.
- Risk score: numeric priority (High/Medium/Low) used to sort and highlight SKUs for review. Higher = higher priority for clearance.
Notes and limitations
- This is a heuristic tool intended to help prioritize investigation — adjust thresholds to match your business rules.
- Accuracy depends on the quality of LastMovementDate and AvgDemand data; missing demand will bias items toward higher risk unless you provide demand data.
- To extend: link with turnover/coverage tools, add warehouse-level grouping, or compute days-of-supply using forecasted demand.
Frequently Asked Questions
The CSV should include columns: SKU, OnHand, UnitCost, LastMovementDate (YYYY-MM-DD). Optionally include AvgDemand as the fifth column. The tool accepts comma- or tab-separated values.
By default, slow-moving items are those with no movement for more than 90 days and obsolete items are those with no movement for more than 365 days. You can change these thresholds using the inputs above.
The risk score combines normalized age (relative to the obsolete threshold) and inverse demand to produce a 0–100 priority score. Higher scores indicate higher urgency for review or clearance.
Currently the tool only displays results in the table and KPIs.
No. All processing happens locally in your browser. Nothing is sent to remote servers unless you explicitly use an export or copy feature that saves data locally.
Other Free Supply Chain Tools
- ABC-XYZ Inventory AnalysisClassify inventory by value and variability.
- Carrying Cost Impact CalculatorQuantify the financial impact of holding inventory.
- EOQ & Reorder Point SuiteOptimize order quantities, reorder points, and safety stock.
- Inventory Turnover CalculatorMeasure inventory turnover ratio and efficiency.
- Lead Time CalculatorCalculate procurement and supply chain lead times.
- Obsolete & Slow-Moving Stock ToolIdentify and analyze slow-moving or obsolete inventory.
- Procurement Savings CalculatorCalculate cost savings and ROI on procurement decisions.
- Safety Stock CalculatorEstimate safety stock and stockout risk.
- Supplier Reliability CalculatorEvaluate supplier performance, lead times, and defect rates.