社區(qū) 發(fā)現(xiàn) Amazon 亞馬遜IPI計(jì)算,說能不能做個(gè)公式去反推...
亞馬遜IPI計(jì)算,說能不能做個(gè)公式去反推Sell-through rate 跟 In-stock rate?或者有哪位大佬愿意分享類似表格?
1.Sell-through rate(動(dòng)銷率)
2.In-stock rate(現(xiàn)貨率)
3.Excess inventory percentage(積壓庫存比率過高)
4.Stranded inventory percentage(滯留產(chǎn)品庫存比例
?
那么我想說能不能做個(gè)公式去反推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)怎么計(jì)算?
?
或者有哪位大佬愿意分享類似表格?
4 個(gè)回復(fù)
匿名用戶
贊同來自: Amazon哈叔 、 荒原北望