2021年大促活動庫存預算模型.xlsx
下載文檔
上傳人:正***
編號:774426
2023-10-19
2頁
26.49KB
1、雙十一單品當天庫存預測模型庫庫存存量量:10001000收收藏藏量量時時間間段段流流量量占占比比流流量量收收藏藏率率轉轉化化率率成成交交量量庫庫存存預預警警2002000-18%8%2000200010%7.65%1531538471501501-26%6%150010%7.65%11573275752-33%3%75010%7.65%5767513133-40.5%0.5%12510%7.65%106655 54-50.2%0.2%5010%7.65%46613 35-60.1%0.1%2510%7.65%266013136-70.5%0.5%12510%7.65%1065050507-822、.0%2.0%50010%7.65%386121001008-94.0%4.0%100010%7.65%775351751759-107.0%7.0%175010%7.65%13440115015010-116.0%6.0%150010%7.65%11528712512511-125.0%5.0%125010%7.65%96191959512-133.8%3.8%95010%7.65%73118757513-143.0%3.0%75010%7.65%576110010014-154.0%4.0%100010%7.65%77-1615015015-166.0%6.0%150010%7.65%113、5-13012512516-175.0%5.0%125010%7.65%96-22610010017-184.0%4.0%100010%7.65%77-30211311318-194.5%4.5%112510%7.65%86-38815015019-206.0%6.0%150010%7.65%115-50316316320-216.5%6.5%162510%7.65%124-62815015021-226.0%6.0%150010%7.65%115-74212512522-235.0%5.0%125010%7.65%96-83810010023-244.0%4.0%100010%7.65%774、-914此表格有一定參考下,商家可根據自己的經驗輸入相關數值(黃色背景色部分可自定義)使使用用步步驟驟第第一一步步:輸輸入入庫庫存存量量第第二二步步:雙雙十十一一當當天天0 0點點到到1 1點點統統計計產產品品收收藏藏量量,填填入入收收藏藏量量第第三三步步:輸輸入入0-10-1點點流流量量和和成成交交量量數數據據第第四四步步:如如果果想想要要庫庫存存預預測測更更加加精精準準,每每個個小小時時可可輸輸入入準準確確的的收收藏藏量量雙十一單品庫存備貨模型成成交交量量1515庫庫存存量量14001400流流量量30993099轉轉化化率率0.48%0.48%預預計計流流量量增增加加:1010倍倍成交量5、,流量是寶貝正常一天的數據值時時間間段段流流量量占占比比流流量量轉轉化化率率成成交交量量庫庫存存預預警警0-18%24794.84%12012801-26%18594.84%9011902-33%9304.84%4511453-40.5%1554.84%811384-50.2%624.84%311355-60.1%314.84%211336-70.5%1554.84%811267-82.0%6204.84%3010968-94.0%12404.84%6010369-107.0%21694.84%10593110-116.0%18594.84%9084111-125.0%15504.84%7576、6612-133.8%11784.84%5770913-143.0%9304.84%4566414-154.0%12404.84%6060415-166.0%18594.84%9051416-175.0%15504.84%7543917-184.0%12404.84%6037918-194.5%13954.84%6831119-206.0%18594.84%9022120-216.5%20144.84%9812421-226.0%18594.84%903422-235.0%15504.84%75-4223-244.0%12404.84%60-102此表格有一定參考下,商家此表格有一定參考下,商家可根據自己的經驗輸入相關數值(黃色背景色部分可自定義)根據自己的經驗輸入相關數值(黃色背景色部分可自定義)第一步:輸入寶貝正常一天的成交量和流量第二步輸入庫存量和預計計劃流量增加倍數第三步參考輸入的庫存量分析是否夠當天銷售,如果很快賣完或者一天賣不完,可進行庫存量調整
CAD圖紙
上傳時間:2022-06-30
20份