Electronics Inventory Velocity & Obsolescence Risk Analyzer
Analyze electronics SKU velocity and seasonal demand to optimize purchasing and reduce obsolescence
What You Can Do
You can analyze historical sales data, inventory metrics, and seasonal patterns across your electronics SKU portfolio to identify slow-moving items, forecast demand volatility, and calculate optimal buy quantities. This skill helps you make quantified purchasing recommendations that balance inventory investment with sell-through velocity, reducing both overstock markdowns and stockouts.
Features
Calculate inventory turnover rates and days inventory outstanding (DIO) to identify fast, moderate, and slow-moving SKUs
Analyze monthly sales trends to forecast demand spikes and lulls across holiday, back-to-school, and category-specific cycles
Evaluate product age, lifecycle stage, and sales momentum to flag candidates for discontinuation or clearance
Generate recommended purchase quantities based on velocity tiers, lead times, and working capital constraints
Compare performance metrics across product categories to reallocate budget toward higher-velocity segments
Estimate potential margin recovery from strategic price reductions on slow-moving inventory
Evaluate how lead time variability impacts inventory levels and demand fulfillment risk
Project next-quarter sales by SKU using historical seasonality indices and growth trends
Example Output
Example 1: Velocity Analysis Output
SKU: LED-Monitor-27-4K | Category: Displays
Current Inventory: 245 units | Age: 8 months
Annual Velocity: 432 units | Monthly Average: 36 units
Days Inventory Outstanding: 206 days
Status: SLOW-MOVING (Velocity Tier: 3 of 5)
Risk Level: MEDIUM — Recommend 25% markdown within 60 days
Example 2: Seasonal Forecast
Q4 Projection (Oct-Dec):
- Laptops: +45% vs baseline (holiday demand spike)
- Cables/Accessories: +28% vs baseline
- Monitors: +12% vs baseline
Recommended Q4 Order: 1,200 units (vs Q3: 850 units)
Example 3: Obsolescence Risk Flag
SKU: Older-GPU-Model-X | Lifecycle Stage: Legacy
Monthly Sales Trend: -18% YoY decline
Current Stock Age: 14 months | Turnover: 2.1x/year
- ⚠️ DISCONTINUATION CANDIDATE: Recommend phasing out within 90 days
Estimated Markdown Impact: $8,400 if cleared at 40% discount
What's Included
- SKILL.md instruction file with core analysis framework and workflow:
- Velocity Analysis Template: SKU-level metrics worksheet (unit sales, DIO, turnover tiers)
- Seasonality Worksheet: Monthly sales trend capture and seasonal index calculation
- Obsolescence Risk Scorecard: 6-factor risk assessment (age, velocity, trends, lifecycle, supplier lead time, category maturity)
- Buy Quantity Calculator: Spreadsheet-ready formulas for optimal purchase quantities by velocity tier
- Markdown Scenario Modeler: Tool to estimate margin recovery from strategic price reductions
Who It's For
- Electronics buyers — optimize SKU allocation and purchasing decisions across categories
- Inventory planners — balance stock levels with demand seasonality and supplier lead times
- Merchandising managers — identify candidates for markdown, clearance, or discontinuation
- Supply chain directors — justify inventory investment levels to finance and operations teams
- Product managers — evaluate product lifecycle and make new-item-vs-legacy decisions
Best For
- Quarterly inventory planning and seasonal demand forecasting
- Slow-moving SKU identification and obsolescence risk assessment
- Buy quantity optimization by product velocity tier and lead time
- Markdown and clearance strategy development to recover margin
- Portfolio rebalancing across distribution centers and supplier partners
You might also like
You can systematically analyze vendor quotes by deconstructing cost structures, identifying hidden costs and margin compression points, and modeling multiple pricing scenarios. The skill enables you to forecast margin impact across volume tiers, develop proactive negotiation strategies grounded in vendor financials, and build data-backed proposals that improve both your margins and vendor sustainability—transforming reactive price-pushing into strategic partnership analysis.
by cowork-os
You can process historical sales data and market signals to generate demand forecasts tailored to electronics SKUs, accounting for seasonality, product lifecycle stages, and supply chain lead times. The skill helps you identify optimal reorder points, calculate safety stock requirements, and flag slow-moving inventory or obsolescence risks—enabling you to make data-driven purchase order decisions that balance working capital efficiency with service level targets.
by cowork-os
You can rapidly assess current planogram performance against sales data, identify underperforming SKUs and space inefficiencies, and generate detailed shelf layout recommendations that balance profitability, velocity, and compliance. Claude processes your category mix, fixture dimensions, regulatory constraints, and competitive positioning to produce actionable planograms ready for retail operations review and store execution.
by cowork-os
Transform raw sales data into strategic insights by decomposing performance variance into specific drivers, benchmarking category health against targets, and quantifying the financial impact of merchandising decisions. You'll uncover hidden patterns in customer behavior, identify performance bottlenecks, and build executive-ready business cases backed by rigorous data analysis—moving beyond dashboards to actionable strategy.
by cowork-os
You can upload category sales data, market metrics, and competitive intelligence, then leverage Claude to apply a diagnostic framework that identifies performance drivers, quantifies gaps against benchmarks, and prioritizes improvement opportunities by revenue impact. The skill translates raw data into executive-ready strategies with ROI projections, cutting your quarterly diagnostic phase from weeks to hours.
by cowork-os
You develop strategic visual merchandising plans that integrate business objectives, customer behavior analysis, and brand guidelines into actionable retail presentations. This skill guides you through spatial psychology, color theory, product hierarchy, and sales velocity analysis to create zone-specific placement strategies, seasonal displays, and fixture specifications that drive conversion and average transaction value. You'll analyze competitor approaches, align visual hierarchy with margin targets, and build frameworks for multi-location consistency.
by cowork-os
This skill transforms raw sales, inventory, and market data into actionable assortment insights. You'll rank SKUs by velocity, margin, and trend trajectory to identify underperformers worth pruning. Discover whitespace gaps—missing size/color/price tier combinations that competitors stock but you don't. Model the financial impact of proposed assortment changes, projecting revenue and margin shifts before implementation.
by cowork-os
You can convert raw pricing data into defensible, actionable price recommendations by analyzing competitor behavior, demand elasticity, inventory health, and seasonal factors simultaneously. This skill helps you balance revenue maximization against competitive positioning and inventory velocity, enabling you to prioritize which SKUs to adjust first and justify price changes to stakeholders with quantitative rationale.
by cowork-os