單品每日庫存量監(jiān)控表（整月可視化預(yù)警）

倉儲(chǔ)物流管理工具——物品庫存控制管理,,,,,,,,,,,,,,

單品每日庫存量監(jiān)控表（整月，可視化預(yù)警提示）,,,,,,,,,,,,今天是,2016年6月11日,

說明：本工具特點(diǎn)是：1.記錄某產(chǎn)品每日出入庫及庫存數(shù)據(jù)明細(xì)；2.自動(dòng)跟蹤監(jiān)控每日庫存狀態(tài)；3.自動(dòng)提示最低、最高庫存量警示；4.自動(dòng)提示每日出入庫量是否異常（高于日均入庫顯示淺紅色；低于日均出庫量顯示黃色）；5.可靈活設(shè)置月份、無需錄入整月日期（通過右上角滑條選擇即可，日期將自動(dòng)顯示）；6.首行動(dòng)態(tài)顯示每天的庫存情況；7.今日庫存量、累計(jì)入庫、累計(jì)出庫、結(jié)存、庫存狀態(tài)皆為自動(dòng)生成，請(qǐng)勿錄入數(shù)據(jù)。,,,,,,,,,,,,,,

倉庫：倉管負(fù)責(zé)人：制表人：文件編號(hào)No：,,,,,,,,,,,,,,

編號(hào),品名,規(guī)格,單位,單價(jià),期初庫存數(shù)量,日均入庫量,日均出庫量,最低庫存量,最高庫存量,今日庫存量,今日庫存狀態(tài),當(dāng)前月份,2016,6

,,,,￥18.00,500,290,300,100,500,139,正常,,,

日期,入庫,,,,,出庫,,,,,損耗,,結(jié)存,

,自產(chǎn)數(shù)量,采購數(shù)量,退倉數(shù)量,調(diào)撥數(shù)量,累計(jì)入庫,銷售數(shù)量,贈(zèng)品數(shù)量,內(nèi)部領(lǐng)用,調(diào)撥數(shù)量,累計(jì)出庫,報(bào)廢數(shù)量,損壞數(shù)量,數(shù)量,庫存狀態(tài)

2016/6/1,50,150,20,50,270,380,50,40,100,570,20,10,170,正常

2016/6/2,151,51,50,100,352,81,51,41,101,274,21,8,219,正常

2016/6/3,52,152,,,204,82,52,42,20,196,22,6,199,正常

2016/6/4,53,1000,,,1053,383,53,43,103,582,23,4,643,存貨太多

2016/6/5,54,154,,,208,384,54,44,104,586,24,0,241,正常

2016/6/6,55,155,,,210,285,20,0,0,305,25,0,121,正常

2016/6/7,56,156,,,212,286,10,0,0,296,26,0,11,及時(shí)補(bǔ)貨

2016/6/8,57,800,,,857,387,0,0,0,387,27,0,454,正常

2016/6/9,58,200,,,258,90,0,0,0,90,28,0,594,存貨太多

2016/6/10,59,159,,,218,389,0,0,0,389,29,0,394,正常

2016/6/11,60,160,,,220,390,5,50,0,445,30,0,139,正常

2016/6/12,61,161,,,222,80,20,0,0,100,31,0,230,正常

2016/6/13,62,60,,,122,50,10,0,0,60,32,0,260,正常

2016/6/14,63,163,,,226,200,0,0,0,200,33,0,253,正常

2016/6/15,64,164,,,228,394,0,0,0,394,34,0,53,及時(shí)補(bǔ)貨

2016/6/16,65,265,,,330,50,0,0,0,50,35,0,298,正常

2016/6/17,66,166,,,232,270,5,50,0,325,36,0,169,正常

2016/6/18,67,167,,,234,70,20,0,0,90,37,0,276,正常

2016/6/19,68,168,,,236,350,10,0,0,360,38,0,114,正常

2016/6/20,69,169,,,238,250,0,0,0,250,39,0,63,及時(shí)補(bǔ)貨

2016/6/21,70,270,,,340,240,0,0,0,240,40,0,123,正常

2016/6/22,71,171,,,242,70,0,0,0,70,41,0,254,正常

2016/6/23,72,172,,,244,202,5,50,0,257,42,0,199,正常

2016/6/24,73,175,,,248,,,,,0,,0,447,正常

2016/6/25,,,,,0,,,,,0,,0,447,正常

2016/6/26,,,,,0,,,,,0,,0,447,正常

2016/6/27,,,,,0,,,,,0,,0,447,正常

2016/6/28,,,,,0,,,,,0,,0,447,正常

2016/6/29,,,,,0,,,,,0,,0,447,正常

2016/6/30,,,,,0,,,,,0,,0,447,正常

,,,,,0,,,,,0,,0,447,正常

合計(jì),1576,5408,70,150,7204,5363,365,360,428,6516,713,28,,

核準(zhǔn)人：審批人：倉管負(fù)責(zé)人：制表人：,,,,,,,,,,,,,,

,,,,,,,,,,版權(quán)所有：