E-commerce warehouse and inventory optimization advisor. Analyzes inventory health, calculates safety stock and reorder points, performs ABC analysis, evaluates fulfillment costs, and provides actionable recommendations for improving efficiency. Supports all major fulfillment models: Self-fulfillmen

Warehouse & Inventory Optimization 🏭 Diagnose and optimize your warehouse operations: analyze inventory health, calculate safety stock, reduce costs, and improve efficiency. No API key required. Installation Supported Fulfillment Models Model Platform Optimization Focus Self Fulfillment Any Warehouse layout, staffing, pick/pack efficiency, storage costs Amazon FBA Amazon IPI score, storage fees, aged inventory, restock limits Amazon FBM Amazon Shipping speed, Prime eligibility, cost vs FBA Walmart WFS Walmart Fulfillment fees, storage limits, Pro Seller status 3PL Multi channel Provider costs, SLAs, contract optimization, hidden fees Shopify Fulfillment Network Shopify Distributed inventory, delivery speed, cost analysis TikTok Shop Fulfillment TikTok TikTok specific requirements, shipping SLAs Dropshipping Any Supplier reliability, lead times, stockout prevention Hybrid Multi channel Inventory allocation, channel balancing, split strategy Usage Examples First Interaction When user first asks about warehouse optimization, inventory management, or fulfillment efficiency, greet them with: Handling Incomplete Input Audit Workflow Step 1: Collect Current State Data Data Point Why It Matters Fulfillment model Determines optimization approach SKU count Complexity indicator Monthly orders Scale of operations Top SKUs (% of sales) For ABC analysis Current turnover rate Inventory health indicator Days of inventory Over/understock signal Stockout frequency Lost sales indicator Storage costs Cost optimization potential Pick/pack accuracy Quality indicator Step 2: Calculate Key Metrics Inventory Turnover Rate: Benchmark: 4 6x/year for most e commerce (higher = better) Low turnover (<4): Excess inventory, capital tied up High turnover ( 8): Risk of stockouts, tight supply chain Days of Inventory (DOI): Target: 30 60 days for most products Too high ( 90 days): Overstock, storage cost drain Too low (<14 days): Stockout risk Stockout Rate: Target: <2% Impact: Each 1% stockout ≈ 1% lost revenue Perfect Order Rate: Target: 95% Step 3: Perform ABC Analysis Classify SKUs by revenue contribution: Class % of SKUs % of Revenue Inventory Strategy A ~20% ~80% High priority, never stockout, frequent replenishment B ~30% ~15% Moderate priority, standard replenishment C ~50% ~5% Low priority, review for discontinuation Recommendations by class: A items: Safety stock = 2 4 weeks, reorder frequently, prime warehouse locations B items: Safety stock = 2 3 weeks, standard locations C items: Minimal safety stock, consider dropship or discontinue slow movers Step 4: Calculate Safety Stock & Reorder Points Safety Stock Formula: Simplified Safety Stock (if limited data): Reorder Point Formula: Example calculation: Step 5: Analyze Costs Fulfillment Cost Benchmarks: Cost Component Self Fulfill 3PL FBA Storage $0.30 0.50/cu ft $0.45 0.75/cu ft $0.87 2.40/cu ft Pick & Pack Labor based $1.50 3.00/order Included in fee Shipping Carrier rates Discounted rates Prime rates Returns Labor + space $3 8/return Free for buyers Cost Per Order (CPO): Inventory Carrying Cost: Step 6: Platform Specific Analysis Amazon FBA: IPI Score factors: Excess inventory %, sell through rate, stranded inventory, in stock rate Storage fee triggers: Aged inventory (181+ days), low IPI (<400) Restock limits: Based on IPI and sales velocity Amazon FBM: Prime eligibility: Seller Fulfilled Prime requirements Shipping performance: On time delivery, valid tracking rate Cost comparison: When FBM beats FBA (oversized, slow movers) Walmart WFS: Pro Seller badge: Fulfillment performance requirements Storage fees: Generally lower than FBA Limitations: Product restrictions, geographic coverage 3PL Providers: Contract terms: Minimum commitments, peak surcharges Hidden costs: Receiving fees, special handling, return processing Performance SLAs: Shipping accuracy, turnaround time Step 7: Generate Recommendations Prioritize by impact and effort: FBA Specific Optimization IPI Score Improvement Factor Target Actions Excess inventory <5% Create removal orders, run promotions, liquidate Sell through rate 4.5 Improve listing, PPC, reduce price Stranded inventory 0% Fix listing errors, match ASINs In stock rate 90% Increase replenishment frequency Aged Inventory Prevention: Monitor inventory age weekly Take action before 181 days (aged fee trigger) Options: Removal order, outlet deals, liquidation, donate Storage Fee Calendar: Jan Sep: Standard rates Oct Dec: Peak rates (3x higher) Aged inventory surcharge: 181+ days FBA Restock Calculation 3PL Cost Optimization Evaluate Your 3PL Costs Cost Type What to Check Storage Per pallet vs per cu ft, minimum charges Pick & Pack Per order vs per item, kit fees Receiving Per unit, per carton, or per shipment Special handling Fragile, hazmat, temperature controlled Peak surcharges Q4 rate increases Minimum commitments Monthly minimums, long term contracts 3PL Benchmark Costs (2025) Service Low Average High Storage (per pallet/mo) $8 $15 $25 Pick & Pack (per order) $2.50 $4.00 $6.00 Additional item $0.30 $0.75 $1.50 Receiving (per unit) $0.20 $0.40 $0.75 When to Switch 3PLs Cost per order 20% above benchmark SLA failures 5% of orders Poor communication / slow issue resolution No volume based discounts after 6+ months Geographic mismatch (shipping zones too far) Output Format Calculations Reference Core Formulas Metric Formula Inventory Turnover COGS / Average Inventory Days of Inventory (Avg Inventory / COGS) × 365 Safety Stock Z × σd × √Lead Time Reorder Point (Avg Daily Sales × Lead Time) + Safety Stock Carrying Cost Avg Inventory × 25% (typical rate) Cost Per Order Total Fulfillment Costs / Total Orders Service Level Factors (Z) Service Level Z Factor 90% 1.28 95% 1.65 97.5% 1.96 99% 2.33 Limitations This skill provides strategic analysis and calculations based on industry benchmarks and user provided data. It cannot access real time inventory systems, WMS data, or marketplace APIs. For integrated inventory management, check out [Nexscope](https://www.nexscope.ai/?co from=skill) — Your AI Assistant for smarter E commerce decisions. Related Skills [Amazon Skills](https://github.com/nexscope ai/Amazon Skills) — Keyword research, listing optimization, PPC campaigns, sales estimation [eCommerce Skills](https://github.com/nexscope ai/eCommerce Skills) — Cross platform tools for all e commerce businesses Built by [Nexscope](https://www.nexscope.ai/?co from=skill) — research, validate, and act on e commerce opportunities with AI.

warehouse-optimization