物品出入庫(kù)管理1

倉(cāng)儲(chǔ)物流管理工具——物品出入庫(kù)管理,,,,,,,,,,,,,,,,,,,,,

物料出入庫(kù)日?qǐng)?bào)表（含明細(xì)、自動(dòng)顯示庫(kù)存狀態(tài)、適合固定成本價(jià)產(chǎn)品）,,,,,,,,,,,,,,,,,,今天是,2024年6月18日,,

說(shuō)明：本工具特點(diǎn)是：記錄每日各編號(hào)物料出入庫(kù)數(shù)據(jù)明細(xì)，包括采購(gòu)、調(diào)撥、退倉(cāng)、使用、報(bào)廢等數(shù)據(jù)明細(xì)；自動(dòng)顯示每日庫(kù)存狀態(tài)：低于最低庫(kù)存為“及時(shí)補(bǔ)貨”，高于最高庫(kù)存為“存貨太多”，其余則為正常狀態(tài)。表格中金額、累計(jì)出入庫(kù)及本日結(jié)存為自動(dòng)計(jì)算。注：本工具適合對(duì)固定成本價(jià)、使用相對(duì)頻繁的產(chǎn)品進(jìn)行匯總、統(tǒng)計(jì)。,,,,,,,,,,,,,,,,,,,,,

單位：倉(cāng)管負(fù)責(zé)人：制表人：,,,,,,,,,,,,,,,,,文件編號(hào)No：,,,,

編號(hào),品名,規(guī)格,單位,單價(jià),最低庫(kù)存量,最高庫(kù)存量,昨日結(jié)存,,本日入庫(kù),,,,本日出庫(kù),,,,,本日?qǐng)?bào)廢,本日結(jié)存,,

,,,,,,,數(shù)量,金額,采購(gòu)數(shù)量,調(diào)撥數(shù)量,退倉(cāng)數(shù)量,累計(jì)入庫(kù),生產(chǎn)一部,生產(chǎn)二部,生產(chǎn)三部,調(diào)撥數(shù)量,累計(jì)出庫(kù),數(shù)量,數(shù)量,金額,庫(kù)存狀態(tài)

1,,,,￥18.00,100,500,400,"￥7,200.00",150,50,10,210,380,50,40,100,570,20,20,￥360.00,及時(shí)補(bǔ)貨

2,,,,￥20.00,101,501,600,"￥12,000.00",151,51,11,213,381,51,41,101,574,21,218,"￥4,360.00",正常

3,,,,,102,502,800,￥0.00,152,52,12,216,382,52,42,102,578,22,416,￥0.00,正常

4,,,,,103,503,1000,￥0.00,153,53,13,219,383,53,43,103,582,23,614,￥0.00,存貨太多

5,,,,,104,504,1200,￥0.00,154,54,14,222,384,54,44,104,586,24,812,￥0.00,存貨太多

6,,,,,105,505,400,￥0.00,155,55,15,225,385,55,45,105,590,25,10,￥0.00,及時(shí)補(bǔ)貨

7,,,,,106,506,600,￥0.00,156,56,16,228,386,56,46,106,594,26,208,￥0.00,正常

8,,,,,107,507,1800,￥0.00,157,57,17,231,387,57,47,107,598,27,1406,￥0.00,存貨太多

9,,,,,109,509,700,￥0.00,159,59,19,237,389,59,49,109,606,29,302,￥0.00,正常

10,,,,,110,510,900,￥0.00,160,60,20,240,390,60,50,110,610,30,500,￥0.00,正常

11,,,,,111,511,600,￥0.00,161,61,21,243,391,61,51,111,614,31,198,￥0.00,正常

12,,,,,112,512,500,￥0.00,162,62,22,246,392,62,52,112,618,32,96,￥0.00,及時(shí)補(bǔ)貨

13,,,,,113,513,400,￥0.00,163,63,23,249,393,63,53,113,622,33,-6,￥0.00,及時(shí)補(bǔ)貨

14,,,,,114,514,700,￥0.00,164,64,24,252,394,64,54,114,626,34,292,￥0.00,正常

15,,,,,115,515,500,￥0.00,165,65,25,255,395,65,55,115,630,35,90,￥0.00,及時(shí)補(bǔ)貨

16,,,,,116,516,800,￥0.00,166,66,26,258,396,66,56,116,634,36,388,￥0.00,正常

17,,,,,117,517,1800,￥0.00,167,67,27,261,397,67,57,117,638,37,1386,￥0.00,存貨太多

18,,,,,118,518,700,￥0.00,168,68,28,264,398,68,58,118,642,38,284,￥0.00,正常

19,,,,,119,519,1000,￥0.00,169,69,29,267,399,69,59,119,646,39,582,￥0.00,存貨太多

20,,,,,120,520,700,￥0.00,170,70,30,270,400,70,60,120,650,40,280,￥0.00,正常

21,,,,,121,521,800,￥0.00,171,71,31,273,401,71,61,121,654,41,378,￥0.00,正常

22,,,,,122,522,500,￥0.00,172,72,32,276,402,72,62,122,658,42,76,￥0.00,及時(shí)補(bǔ)貨

23,,,,,123,523,600,￥0.00,173,73,33,279,403,73,63,123,662,43,174,￥0.00,正常

24,,,,,124,524,800,￥0.00,174,74,34,282,404,74,64,124,666,44,372,￥0.00,正常

25,,,,,108,508,600,￥0.00,158,58,18,234,388,58,48,108,602,28,204,￥0.00,正常

26,,,,,109,509,700,￥0.00,159,59,19,237,389,59,49,109,606,29,302,￥0.00,正常

27,,,,,110,510,900,￥0.00,160,60,20,240,390,60,50,110,610,30,500,￥0.00,正常

28,,,,,111,511,600,￥0.00,161,61,21,243,391,61,51,111,614,31,198,￥0.00,正常

29,,,,,112,512,500,￥0.00,162,62,22,246,392,62,52,112,618,32,96,￥0.00,及時(shí)補(bǔ)貨

30,,,,,113,513,400,￥0.00,163,63,23,249,393,63,53,113,622,33,-6,￥0.00,及時(shí)補(bǔ)貨

31,,,,,115,515,500,￥0.00,165,65,25,255,395,65,55,115,630,35,90,￥0.00,及時(shí)補(bǔ)貨

32,,,,,116,516,800,￥0.00,166,66,26,258,396,66,56,116,634,36,388,￥0.00,正常

33,,,,,117,517,1800,￥0.00,167,67,27,261,397,67,57,117,638,37,1386,￥0.00,存貨太多

34,,,,,118,518,700,￥0.00,168,68,28,264,398,68,58,118,642,38,284,￥0.00,正常

35,,,,,119,519,1000,￥0.00,169,69,29,267,399,69,59,119,646,39,582,￥0.00,存貨太多

36,,,,,120,520,700,￥0.00,170,70,30,270,400,70,60,120,650,40,280,￥0.00,正常

37,,,,,121,521,800,￥0.00,171,71,31,273,401,71,61,121,654,41,378,￥0.00,正常

38,,,,,114,514,700,￥0.00,164,64,24,252,394,64,54,114,626,34,292,￥0.00,正常

39,,,,,115,515,500,￥0.00,165,65,25,255,395,65,55,115,630,35,90,￥0.00,及時(shí)補(bǔ)貨

40,,,,,116,516,800,￥0.00,166,66,26,258,396,66,56,116,634,36,388,￥0.00,正常

41,,,,,117,517,1800,￥0.00,167,67,27,261,397,67,57,117,638,37,1386,￥0.00,存貨太多

42,,,,,118,518,700,￥0.00,168,68,28,264,398,68,58,118,642,38,284,￥0.00,正常

43,,,,,119,519,1000,￥0.00,169,69,29,267,399,69,59,119,646,39,582,￥0.00,存貨太多

44,,,,,120,520,700,￥0.00,170,70,30,270,400,70,60,120,650,40,280,￥0.00,正常

45,,,,,121,521,800,￥0.00,171,71,31,273,401,71,61,121,654,41,378,￥0.00,正常

46,,,,,122,522,500,￥0.00,172,72,32,276,402,72,62,122,658,42,76,￥0.00,及時(shí)補(bǔ)貨

47,,,,,123,523,600,￥0.00,173,73,33,279,403,73,63,123,662,43,174,￥0.00,正常

48,,,,,124,524,800,￥0.00,174,74,34,282,404,74,64,124,666,44,372,￥0.00,正常

合計(jì),,,,,,,37700,"￥19,20