warehouse-optimization

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Warehouse & Inventory Optimization 🏭

仓库与库存优化 🏭

Diagnose and optimize your warehouse operations: analyze inventory health, calculate safety stock, reduce costs, and improve efficiency. No API key required.

诊断并优化您的仓库运营：分析库存健康状况、计算安全库存、降低成本并提升效率。无需API密钥。

Installation

安装

bash

npx skills add nexscope-ai/eCommerce-Skills --skill warehouse-optimization -g

bash

npx skills add nexscope-ai/eCommerce-Skills --skill warehouse-optimization -g

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

模式	平台	优化重点
自发货	任意	仓库布局、人员配置、拣货/打包效率、存储成本
Amazon FBA	Amazon	IPI分数、存储费用、滞销库存、补货限制
Amazon FBM	Amazon	发货速度、Prime资格、成本对比FBA
Walmart WFS	Walmart	履约费用、存储限制、专业卖家资质
3PL	多渠道	服务商成本、服务水平协议（SLA）、合同优化、隐性费用
Shopify履约网络	Shopify	分布式库存、配送速度、成本分析
TikTok Shop履约	TikTok	TikTok专属要求、发货服务水平协议
代发货	任意	供应商可靠性、交付周期、缺货预防
混合模式	多渠道	库存分配、渠道平衡、拆分策略

Usage Examples

使用示例

Audit my warehouse operations. I'm self-fulfilling from a 2,000 sq ft warehouse.
500 SKUs, 3,000 orders/month. Main issues: frequent stockouts on top sellers, 
high storage costs on slow movers. Help me optimize.

I use FBA for my Amazon store. IPI score dropped to 350. I have excess inventory 
warnings on 40 SKUs. How do I fix this before I get storage limits?

Running FBM for my oversized products and FBA for standard. 200 orders/day total.
Which SKUs should I move to FBA vs keep FBM? Help me optimize the split.

Using ShipBob as my 3PL. Monthly bill is $8,500 for 2,000 orders. Is this competitive?
What should I negotiate or consider switching?

审核我的仓库运营。我使用自发货模式，仓库面积2000平方英尺。
有500个SKU，月度订单量3000单。主要问题：畅销品频繁缺货，滞销品存储成本高。请帮我优化。

我的亚马逊店铺使用FBA模式。IPI分数降至350，有40个SKU收到库存过剩警告。如何在被限制存储前解决这个问题？

大件商品使用FBM模式，标准商品使用FBA模式。日均订单总量200单。
哪些SKU应该转到FBA，哪些继续保留FBM？请帮我优化拆分策略。

使用ShipBob作为我的3PL服务商。2000单的月度账单为8500美元。这个价格有竞争力吗？
我应该协商哪些条款，或者是否考虑更换服务商？

First Interaction

首次交互

When user first asks about warehouse optimization, inventory management, or fulfillment efficiency, greet them with:

🏭 Warehouse Optimization ready!

I'll help you diagnose issues and optimize your inventory operations.

**Tell me about your setup:**
- Fulfillment model (FBA, FBM, 3PL, self-fulfill, hybrid?)
- Approximate SKU count
- Monthly order volume
- Main pain points (stockouts, high costs, slow shipping, IPI issues?)

Or just describe your situation and I'll guide you from there.

当用户首次询问仓库优化、库存管理或履约效率相关问题时，使用以下问候语：

🏭 仓库优化工具已就绪！

我将帮您诊断问题并优化库存运营。

**请告知您的运营设置：**
- 履约模式（FBA、FBM、3PL、自发货、混合模式？）
- 大致SKU数量
- 月度订单量
- 主要痛点（缺货、高成本、发货缓慢、IPI问题？）

或者直接描述您的情况，我会引导您完成后续流程。

Handling Incomplete Input

处理不完整输入

To optimize your warehouse operations, I need:

**Required:**
- Fulfillment model: Self / FBA / FBM / WFS / 3PL / Dropship / Hybrid
- Approximate SKU count
- Monthly order volume
- Main pain points (stockouts, high costs, slow shipping, etc.)

**Recommended (deeper analysis):**
- Top 10 SKUs by sales volume (or % of total sales)
- Current inventory turnover rate (if known)
- Average days of inventory on hand
- Monthly storage/fulfillment costs
- For FBA: Current IPI score, aged inventory alerts
- For 3PL: Current provider and monthly costs

要优化您的仓库运营，我需要以下信息：

**必填项：**
- 履约模式：自发货 / FBA / FBM / WFS / 3PL / 代发货 / 混合模式
- 大致SKU数量
- 月度订单量
- 主要痛点（缺货、高成本、发货缓慢等）

**推荐项（用于深度分析）：**
- 销量TOP10的SKU（或占总销售额的比例）
- 当前库存周转率（如已知）
- 平均库存持有天数
- 月度存储/履约成本
- 若使用FBA：当前IPI分数、滞销库存警报
- 若使用3PL：当前服务商及月度成本

Audit Workflow

审核流程

Step 1: Collect Current State Data

步骤1：收集当前状态数据

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

数据项	重要性
履约模式	决定优化方案
SKU数量	复杂度指标
月度订单量	运营规模
畅销SKU（占销售额比例）	用于ABC分析
当前库存周转率	库存健康指标
库存持有天数	库存过剩/不足信号
缺货频率	销售额损失指标
存储成本	成本优化潜力
拣货/打包准确率	服务质量指标

Step 2: Calculate Key Metrics

步骤2：计算关键指标

Inventory Turnover Rate:

Inventory Turnover = Cost of Goods Sold (COGS) / Average Inventory Value

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):

DOI = (Average Inventory / COGS) × 365

Target: 30-60 days for most products
Too high (>90 days): Overstock, storage cost drain
Too low (<14 days): Stockout risk

Stockout Rate:

Stockout Rate = (Days Out of Stock / Total Days) × 100

Target: <2%
Impact: Each 1% stockout ≈ 1% lost revenue

Perfect Order Rate:

Perfect Order Rate = (Orders Shipped Complete, On-Time, Undamaged / Total Orders) × 100

Target: >95%

库存周转率：

Inventory Turnover = Cost of Goods Sold (COGS) / Average Inventory Value

行业基准： 多数电商为4-6次/年（数值越高越好）
周转率低（<4）： 库存过剩，资金被占用
周转率高（>8）： 缺货风险高，供应链紧张

库存持有天数（DOI）：

DOI = (Average Inventory / COGS) × 365

目标值： 多数产品为30-60天
天数过高（>90）： 库存过剩，存储成本消耗大
天数过低（<14）： 缺货风险高

缺货率：

Stockout Rate = (Days Out of Stock / Total Days) × 100

目标值： <2%
影响： 每增加1%缺货率，约损失1%的销售额

完美订单率：

Perfect Order Rate = (Orders Shipped Complete, On-Time, Undamaged / Total Orders) × 100

目标值： >95%

Step 3: Perform ABC Analysis

步骤3：执行ABC分析

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

根据营收贡献对SKU分类：

类别	占SKU比例	占营收比例	库存策略
A	~20%	~80%	高优先级，绝不允许缺货，频繁补货
B	~30%	~15%	中等优先级，标准补货
C	~50%	~5%	低优先级，评估是否停产

分类别建议：

A类商品： 安全库存=2-4周，频繁补货，放置在仓库核心位置
B类商品： 安全库存=2-3周，放置在标准位置
C类商品： 最低安全库存，考虑代发货或停产滞销品

Step 4: Calculate Safety Stock & Reorder Points

步骤4：计算安全库存与再订货点

Safety Stock Formula:

Safety Stock = Z × σd × √L

Where:
- Z = Service level factor (1.65 for 95%, 2.33 for 99%)
- σd = Standard deviation of daily demand
- L = Lead time in days

Simplified Safety Stock (if limited data):

Safety Stock = (Max Daily Sales - Avg Daily Sales) × Lead Time

Reorder Point Formula:

Reorder Point = (Avg Daily Sales × Lead Time) + Safety Stock

Example calculation:

Product: Widget A
- Average daily sales: 10 units
- Max daily sales: 18 units
- Lead time: 14 days

Safety Stock = (18 - 10) × 14 = 112 units
Reorder Point = (10 × 14) + 112 = 252 units

→ Reorder when inventory hits 252 units
→ Keep 112 units as buffer

安全库存公式：

Safety Stock = Z × σd × √L

其中：
- Z = 服务水平系数（95%服务水平为1.65，99%服务水平为2.33）
- σd = 日均需求标准差
- L = 交付周期（天数）

简化版安全库存（数据有限时）：

Safety Stock = (Max Daily Sales - Avg Daily Sales) × Lead Time

再订货点公式：

Reorder Point = (Avg Daily Sales × Lead Time) + Safety Stock

计算示例：

产品：Widget A
- 日均销量：10件
- 最大日均销量：18件
- 交付周期：14天

安全库存 = (18 - 10) × 14 = 112件
再订货点 = (10 × 14) + 112 = 252件

→ 库存降至252件时补货
→ 保留112件作为缓冲库存

Step 5: Analyze Costs

步骤5：成本分析

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):

CPO = (Storage + Labor + Packaging + Shipping) / Total Orders

Inventory Carrying Cost:

Carrying Cost = Average Inventory Value × Carrying Rate (typically 20-30%/year)

Includes: Storage, insurance, obsolescence, opportunity cost

履约成本基准：

成本构成	自发货	3PL	FBA
存储	$0.30-0.50/立方英尺	$0.45-0.75/立方英尺	$0.87-2.40/立方英尺
拣货与打包	基于人力成本	$1.50-3.00/订单	包含在费用中
配送	承运人报价	折扣报价	Prime配送报价
退货	人力+空间成本	$3-8/退货	买家免运费

单均履约成本（CPO）：

CPO = (Storage + Labor + Packaging + Shipping) / Total Orders

库存持有成本：

Carrying Cost = Average Inventory Value × Carrying Rate（通常为20-30%/年）

包含：存储、保险、损耗、机会成本

Step 6: Platform-Specific Analysis

步骤6：平台专属分析

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

Amazon FBA：

IPI分数影响因素： 库存过剩比例、售罄率、滞留库存、现货率
存储费用触发条件： 滞销库存（181天以上）、低IPI分数（<400）
补货限制： 基于IPI分数和销售速度

Amazon FBM：

Prime资格： 卖家自发货Prime要求
配送绩效： 准时交付率、有效追踪率
成本对比： FBM优于FBA的场景（大件商品、滞销品）

Walmart WFS：

专业卖家徽章： 履约绩效要求
存储费用： 通常低于FBA
限制： 产品限制、地域覆盖范围

3PL服务商：

合同条款： 最低承诺量、旺季附加费
隐性成本： 收货费、特殊处理费、退货处理费
绩效SLA： 配送准确率、周转时间

Step 7: Generate Recommendations

步骤7：生成建议

Prioritize by impact and effort:

undefined

按影响程度和实施难度排序：

undefined

Recommendations

优化建议

🔴 Critical (Do Now)

🔴 紧急（立即执行）

Issue	Impact	Action	Expected Result

问题	影响	行动方案	预期结果

🟡 Important (This Month)

🟡 重要（本月完成）

Issue	Impact	Action	Expected Result

问题	影响	行动方案	预期结果

🟢 Optimization (This Quarter)

🟢 优化（本季度完成）

Issue	Impact	Action	Expected Result

---

问题	影响	行动方案	预期结果

---

FBA-Specific Optimization

FBA专属优化

IPI Score Improvement

IPI分数提升

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

影响因素	目标值	行动方案
库存过剩	<5%	创建移除订单、开展促销、清库存
售罄率	>4.5	优化listing、PPC广告、降价
滞留库存	0%	修复listing错误、匹配ASIN
现货率	>90%	提高补货频率

滞销库存预防：

每周监控库存时长
在181天（滞销费用触发点）前采取行动
可选方案：移除订单、奥特莱斯活动、清库存、捐赠

存储费用日历：

1-9月： 标准费率
10-12月： 旺季费率（为标准费率3倍）
滞销库存附加费： 181天以上库存

FBA Restock Calculation

FBA补货计算

Target FBA Inventory = (Avg Daily Units × Days of Cover) + Safety Buffer

Where:
- Days of Cover: 30-60 days (varies by IPI score)
- Safety Buffer: 1-2 weeks for top sellers

Example:
- Selling 10 units/day
- Target 45 days cover
- Safety: 10 days

Target = (10 × 45) + (10 × 10) = 550 units

目标FBA库存 = (日均销量 × 覆盖天数) + 安全缓冲库存

其中：
- 覆盖天数：30-60天（根据IPI分数调整）
- 安全缓冲库存：畅销品为1-2周销量

示例：
- 日均销量10件
- 目标覆盖45天
- 安全缓冲：10天销量

目标库存 = (10 × 45) + (10 × 10) = 550件

3PL Cost Optimization

3PL成本优化

Evaluate Your 3PL Costs

评估3PL成本

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

成本类型	检查要点
存储	每托盘 vs 每立方英尺计价，最低收费
拣货与打包	按订单 vs 按商品计价，套装费用
收货	按件、按箱或按 shipment 计价
特殊处理	易碎品、危险品、温控商品
旺季附加费	第四季度费率上涨
最低承诺量	月度最低订单量、长期合同

3PL Benchmark Costs (2025)

2025年3PL成本基准

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

服务	低价	均价	高价
存储（每托盘/月）	$8	$15	$25
拣货与打包（每订单）	$2.50	$4.00	$6.00
附加商品	$0.30	$0.75	$1.50
收货（每件）	$0.20	$0.40	$0.75

When to Switch 3PLs

何时更换3PL服务商

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)

单均成本高于基准20%
SLA履约失败率超过订单总量的5%
沟通不畅 / 问题解决缓慢
合作6个月以上仍无基于订单量的折扣
地域不匹配（配送区域过远）

Output Format

输出格式

undefined

undefined

🏭 Warehouse Optimization Report

🏭 仓库优化报告

Business: [Business Name/Type] Fulfillment Model: [Self / FBA / FBM / WFS / 3PL / Hybrid] Analysis Date: [Date]

业务： [业务名称/类型] 履约模式： [自发货 / FBA / FBM / WFS / 3PL / 混合模式] 分析日期： [日期]

1. Current State Summary

1. 当前状态总结

Metric	Current	Benchmark	Status
Monthly orders	X	—	—
SKU count	X	—	—
Inventory turnover	Xx/year	4-6x	🟢/🟡/🔴
Days of inventory	X days	30-60	🟢/🟡/🔴
Stockout rate	X%	<2%	🟢/🟡/🔴
Cost per order	$X	$3-8	🟢/🟡/🔴

指标	当前值	基准值	状态
月度订单量	X	—	—
SKU数量	X	—	—
库存周转率	X次/年	4-6次	🟢/🟡/🔴
库存持有天数	X天	30-60	🟢/🟡/🔴
缺货率	X%	<2%	🟢/🟡/🔴
单均成本	$X	$3-8	🟢/🟡/🔴

2. ABC Analysis

2. ABC分析

[SKU classification table]

[SKU分类表格]

3. Inventory Optimization

3. 库存优化

Safety Stock Recommendations

安全库存建议

SKU/Class	Current Stock	Recommended Safety Stock	Reorder Point

SKU/类别	当前库存	建议安全库存	再订货点

Overstock Alert

库存过剩警报

[SKUs with excess inventory]

[库存过剩的SKU列表]

Stockout Risk

缺货风险

[SKUs at risk of stockout]

[存在缺货风险的SKU列表]

4. Cost Analysis

4. 成本分析

[Cost breakdown and optimization opportunities]

[成本明细及优化机会]

5. Recommendations

5. 优化建议

🔴 Critical

🔴 紧急

[High-impact, do now]

[高影响，立即执行]

🟡 Important

🟡 重要

[Medium-impact, this month]

[中影响，本月完成]

🟢 Optimization

🟢 优化

[Lower priority improvements]

[低优先级改进]

6. Expected Results

6. 预期成果

Improvement Area	Current	Target	Timeline
Stockout rate	X%	X%	X weeks
Storage costs	$X	$X	X months
Turnover rate	Xx	Xx	X months

---

改进领域	当前值	目标值	时间线
缺货率	X%	X%	X周
存储成本	$X	$X	X月
库存周转率	X次	X次	X月

---

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

指标	公式
库存周转率	COGS / 平均库存
库存持有天数	(平均库存 / COGS) × 365
安全库存	Z × σd × √交付周期
再订货点	(日均销量 × 交付周期) + 安全库存
库存持有成本	平均库存 × 25%（典型费率）
单均成本	总履约成本 / 总订单量

Service Level Factors (Z)

服务水平系数（Z）

Service Level	Z Factor
90%	1.28
95%	1.65
97.5%	1.96
99%	2.33

服务水平	Z系数
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 — Your AI Assistant for smarter E-commerce decisions.

本工具基于行业基准和用户提供的数据提供战略分析与计算。无法访问实时库存系统、WMS数据或电商平台API。如需集成式库存管理，请查看 Nexscope —— 助力电商智能决策的AI助手。