每日库存量监控表（可视化存量出入库警示累计计算）

仓储物流管理工具——物品库存控制管理,,,,,,,,,,,,,,,,,,,,,,,

每日库存量监控表（可视化预警提示）,,,,,,,,,,,,,,,今天是,,2016年6月11日,,,,,,

说明：本工具主要用来跟踪、监控各产品每日的出入库及结存数据。特点1：自动显示每日库存状态：低于最低库存为“及时补货”，高于最高库存为“存货太多”，其余则为正常状态。特点2：有效监控本月出入库累计数据，高于月均入库则自动显示浅红色，低于月均出库量者显示黄色。其中，这里的入库主要针对的是采购数量，其目的是为了有效控制成本；出库主要指销售数量，其目的是为了有效监控销量情况。注：截止昨日结存、入库合计、出库合计、累计入库、累计出库、本日结存为自动生成数据。,,,,,,,,,,,,,,,,,,,,,,,

单位：仓管负责人：制表人：文件编号No：,,,,,,,,,,,,,,,,,,,,,,,

编号,品名,规格,单位,月均入库量,月均出库量,最低库存量,最高库存量,截止昨日出入库及结存,,,,本日入库,,,本日出库,,,,,本月当前累计出入库,,本日结存,

,,,,,,,,本月期初结存数量,累计入库数量,累计出库数量,截至昨日结存数量,自产数量,采购数量,本日入库合计,销售数量,赠品数量,内部领用,调拨数量,本日出库合计,累计入库,累计出库,数量,库存状态

,,,,590,900,100,500,400,400,300,500,50,150,200,380,50,40,100,570,600,870,130,正常

,,,,620,840,101,501,400,400,300,500,51,151,202,381,51,41,101,574,602,874,128,正常

,,,,630,900,102,502,400,400,300,500,52,152,204,382,52,42,102,678,604,978,26,及时补货

,,,,560,880,103,503,400,400,300,500,53,153,206,383,53,43,103,582,606,882,124,正常

,,,,630,900,104,504,1400,400,300,1500,54,154,208,384,54,44,104,586,608,886,1122,存货太多

,,,,630,900,105,505,400,400,300,500,55,155,210,385,55,45,105,590,610,890,120,正常

,,,,630,900,106,506,400,400,300,500,56,156,212,386,56,46,106,594,612,894,118,正常

,,,,630,900,107,507,1200,400,300,1300,57,157,214,387,57,47,107,598,614,898,916,存货太多

,,,,630,900,108,508,400,400,300,500,58,158,216,388,58,48,108,602,616,902,114,正常

,,,,630,900,109,509,400,400,300,500,59,159,218,389,59,49,109,606,618,906,112,正常

,,,,630,900,110,510,400,400,300,500,60,160,220,390,60,50,110,610,620,910,110,正常

,,,,630,900,111,511,400,400,300,500,61,161,222,391,61,51,111,614,622,914,108,及时补货

,,,,630,900,112,512,400,400,300,500,62,162,224,392,62,52,112,618,624,918,106,及时补货

,,,,630,900,113,513,400,400,300,500,63,163,226,393,63,53,113,622,626,922,104,及时补货

,,,,630,900,114,514,400,400,300,500,64,164,228,394,64,54,114,626,628,926,102,及时补货

,,,,630,900,115,515,400,400,300,500,65,165,230,395,65,55,115,630,630,930,100,及时补货

,,,,630,900,116,516,400,400,300,500,66,166,232,396,66,56,116,634,632,934,98,及时补货

,,,,630,900,117,517,400,400,300,500,67,167,234,397,67,57,117,436,634,736,298,正常

,,,,630,900,118,518,400,400,300,500,68,168,236,398,68,58,118,642,636,942,94,及时补货

,,,,630,900,119,519,400,400,300,500,69,169,238,399,69,59,119,646,638,946,92,及时补货

,,,,630,900,120,520,400,400,300,500,70,170,240,400,70,60,120,650,640,950,90,及时补货

,,,,630,900,121,521,400,400,300,500,71,171,242,401,71,61,121,654,642,954,88,及时补货

,,,,630,900,122,522,400,400,300,500,72,172,244,402,72,62,122,658,644,958,86,及时补货

,,,,630,900,123,523,400,400,300,500,73,173,246,403,73,63,123,662,646,962,84,及时补货

,,,,630,900,124,524,400,400,300,500,74,174,248,404,74,64,124,666,648,966,82,及时补货

合计,,,,15630,22420,2800,12800,11800,10000,7500,14300,1550,4050,5600,9800,1550,1300,2800,15348,15600,22848,4552,

核准人：审批人：制表人：,,,,,,,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,版权所有：