產(chǎn)品進(jìn)銷存表單_第1頁
產(chǎn)品進(jìn)銷存表單_第2頁
產(chǎn)品進(jìn)銷存表單_第3頁
產(chǎn)品進(jìn)銷存表單_第4頁
全文預(yù)覽已結(jié)束

下載本文檔

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請進(jìn)行舉報或認(rèn)領(lǐng)

文檔簡介

序號,商家編碼,貨品名稱,創(chuàng)建時間,級別分類,系列,尺寸,顏色,建議下市產(chǎn)品,規(guī)格名稱,波動提醒,滯銷提醒,低庫存提醒,分類,品牌,跟單,裝箱數(shù),倉庫,供應(yīng)周期/天,,,,,可審核庫存情況,,,,,,可周轉(zhuǎn)天數(shù),,,,,,過往銷售情況,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,倉庫上下限數(shù)據(jù),,,,采購情況,,,,,,,,,,,,,,,,,,,,,,,,1個月以內(nèi)可消耗完,,,,,,,,,,,,,,24年1-6月,24年1-12月

,,,,,,,,,,,,,,,,,,最短,最長,材料周期,備貨標(biāo)準(zhǔn)（天）,覆蓋天數(shù),佛山倉,"工廠

代發(fā)倉",新鄭倉,"剩余

訂單",訂單+庫存,總庫存,總倉（最近30天）,總倉（最近7天）,安全天數(shù),中山倉,"工廠

代發(fā)倉",新鄭倉,2020年12月,1月,2月,3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,"2025年

1月","2025年

2月",2025年3月,4月,5月,6月,7月,8月,9月,10月,11月,12月,1月,2月,3月,4月,5月,6月,7月,8月,近6個月平均銷量,中山倉,,新鄭倉,,最近7天銷售,,,,,昨天銷售,,,,最近14天銷售,,,,,最近30天銷售,,,,,需求,計劃采購數(shù)量,訂單+庫存可周轉(zhuǎn)天數(shù),備注,建議補單量,,,,,,,,,,,,,,,25年1-8月,25年1-8月

,,,,,,,,,規(guī)格名稱,,,,分類,品牌,,裝箱數(shù),,,,,,,,,,采購在途,合計庫存,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,下限,上限,下限,上限,佛山倉,"工廠

代發(fā)倉",新鄭倉,總倉,天/件,佛山倉,"工廠

代發(fā)倉",新鄭倉,總倉,佛山倉,"工廠

代發(fā)倉",新鄭倉,總倉,天/件,佛山倉,"工廠

代發(fā)倉",新鄭倉,總倉,天/件,,,,,,品類,佛山金額,新鄭金額,最后單價,總金額,一個月預(yù)估,70%,兩個月銷量,30%,預(yù)計出庫數(shù)量,取整,可銷天數(shù),健康情況,一年總,一年半,兩年

1,,,2025/5/8,水槽-D類-新品,P01,7642,不銹鋼色,,納米201-單槽黑色,,,,納米水槽,優(yōu)質(zhì),嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,0,0,0,#VALUE!,#VALUE!,0,0,#VALUE!,#VALUE!,#VALUE!,兩年以上未消耗的庫存,0,0,0

2,,,2025/5/8,水槽-D類-新品,P01,6842,不銹鋼色,,納米201-單槽黑色,,,,納米水槽,優(yōu)質(zhì),嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,93.59,93.59,4585.91,0,0,0,0,0,0,#DIV/0!,兩年以上未消耗的庫存,0,0,0

3,,,2025/5/8,水槽-D類-新品,P01,6042,不銹鋼色,,納米201-單槽黑色,,,,納米水槽,優(yōu)質(zhì),嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,90.6,90.6,4439.4,0,0,0,0,0,0,#DIV/0!,兩年以上未消耗的庫存,0,0,0

4,,,2025/4/17,水槽-E類-滯銷,P01,7545,不銹鋼色,,不銹鋼201-單槽,,滯銷,,不銹鋼水槽,優(yōu)質(zhì),嘉文,1,新鄭,7,10,14,10,34,0,0,0,#REF!,#REF!,0,0,0,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,3,7,5,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,82.32,82.32,2222.64,7,4.9,10,3,7.9,8,0,1個月以內(nèi)可消耗完,,,

5,,,2025/4/17,水槽-E類-滯銷,P01,6045,不銹鋼色,,不銹鋼201-單槽,,滯銷,,不銹鋼水槽,優(yōu)質(zhì),嘉文,1,新鄭,7,10,14,10,34,0,0,0,#REF!,#REF!,0,0,0,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,0,2,1,1,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,67.62,67.62,2840.04,1,0.7,3,0.9,1.6,2,0,1個月以內(nèi)可消耗完,,,

6,,,2025/8/15,水槽-D類-新品,P01,8045,銀色,,納米201-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,0,0,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,0,109,1635,0,0,0,0,0,0,#DIV/0!,兩年以上未消耗的庫存,0,0,0

7,,,2025/5/11,水槽-D類-新品,P01,7545,銀色,,納米201-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,14,6,12,11,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,103.686154,103.686154,1140.547694,4,2.8,18,5.4,8.2,8,0,1個月以內(nèi)可消耗完,,,

8,,,2025/5/11,水槽-D類-新品,P01,7245,銀色,,納米201-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,"佛山,新鄭",14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6,11,9,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,96.825333,103.8,4567.2,0,0,17,5.1,5.1,5,0,1個月以內(nèi)可消耗完,,,

9,,,2025/5/11,水槽-D類-新品,P01,6845,銀色,,納米201-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,"佛山,新鄭",14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,42,25,32,33,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,91.887333,91.89,2021.58,3,2.1,57,17.1,19.2,19,0,1個月以內(nèi)可消耗完,,,

10,,,2025/8/15,水槽-D類-新品,P01,6545,銀色,,納米201-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,0,0,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,0,92,3772,0,0,0,0,0,0,#DIV/0!,兩年以上未消耗的庫存,0,0,0

11,,,2025/5/11,水槽-D類-新品,P01,6045,銀色,,納米201-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,"佛山,新鄭",14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8,23,24,18,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,86.484348,88.98,1067.76,3,2.1,47,14.1,16.2,16,0,1個月以內(nèi)可消耗完,,,

12,,,2025/5/11,水槽-D類-新品,P01,5545,銀色,,納米201-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,13,17,15,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,94.661944,94.661944,2745.196376,25.42857143,17.8,30,9,26.8,27,0,1個月以內(nèi)可消耗完,,,

13,,,2025/5/11,水槽-D類-新品,P01,5045,銀色,,納米201-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,"佛山,新鄭",14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,46,26,25,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,83.983111,90.8,3541.2,0,0,72,21.6,21.6,22,0,1個月以內(nèi)可消耗完,,,

14,,,2025/8/15,水槽-D類-新品,P01,8045,銀色,,納米304-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,0,0,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,0,163,7498,0,0,0,0,0,0,#DIV/0!,兩年以上未消耗的庫存,0,0,0

15,,,2025/7/11,水槽-D類-新品,P01,7545,銀色,,納米304-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,15,15,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,157.754179,157.754179,18614.99312,22.42857143,15.7,15,4.5,20.2,20,0,1個月以內(nèi)可消耗完,,,

16,,,2025/7/11,水槽-D類-新品,P01,7245,銀色,,納米304-單槽銀色,,滯銷,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,"佛山,新鄭",14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,9,9,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,152.800096,152.800096,21392.01344,1,0.7,9,2.7,3.4,3,0,1個月以內(nèi)可消耗完,,,

17,,,2025/7/11,水槽-D類-新品,P01,6845,銀色,,納米304-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,"佛山,新鄭",14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,,,,,,,,,,,,,0,30,109,70,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,136.441046,147.8,13449.8,93,65.1,139,41.7,106.8,107,0,1個月以內(nèi)可消耗完,,,

18,,,2025/8/15,水槽-D類-新品,P01,6045,銀色,,納米304-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,,,,,,,,,,,,,,,,,,,0,0,0,0,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,0,144,2592,0,0,0,0,0,0,#DIV/0!,兩年以上未消耗的庫存,0,0,0

19,,,2025/7/11,水槽-D類-新品,P01,7245,銀色,,納米304-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,"佛山,新鄭",14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,0,0,0,0,27,27,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,139.43,139.8,9226.8,4,2.8,27,8.1,10.9,11,0,1個月以內(nèi)可消耗完,,,

20,,,2025/7/11,水槽-D類-新品,P01,7245,銀色,,納米304-單槽銀色,,滯銷,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,"佛山,新鄭",14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,0,0,0,0,10,10,,,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,#REF!,0,,,水槽,0,135.8,135.8,9370.2,0,0,10,3,3,3,0,1個月以內(nèi)可消耗完,,,

21,,,2025/7/11,水槽-D類-新品,P01,7245,銀色,,納米304-單槽銀色,,,,納米水槽,衛(wèi)達(dá)斯,嘉文,1,新鄭,14,18,14,14,46,0,0,0,#REF!,#REF!,0,0,0,18,0,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,0,0,0,0,0,5,5,,,,,0,0

溫馨提示

  • 1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲空間，僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理，對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容，請與我們聯(lián)系，我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論