社区 发现 Amazon 亚马逊IPI计算,说能不能做个公式去反推...
亚马逊IPI计算,说能不能做个公式去反推Sell-through rate 跟 In-stock rate?或者有哪位大佬愿意分享类似表格?
1.Sell-through rate(动销率)
2.In-stock rate(现货率)
3.Excess inventory percentage(积压库存比率过高)
4.Stranded inventory percentage(滞留产品库存比例
那么我想说能不能做个公式去反推Sell-through rate 跟 In-stock rate?
1. Sell-through rate = Total units sold (cumulative) in past 90 days / Average available inventory
2.In-stock rate= (60-day sales velocity (units sold/days in stock) * % of days in stock in the past 30 days)/((60-day sales velocity (units sold/days in stock))
求问% of days in stock in the past 30 days)怎么计算?
或者有哪位大佬愿意分享类似表格?
4 个回复
匿名用户
赞同来自: Amazon哈叔 、 荒原北望