安全庫(kù)存樣本

安全庫(kù)存物資初設(shè)統(tǒng)計(jì)報(bào)表（定期測(cè)算）,,,,,,,,,,,,,,,,,,,,,,,,

制表部門：計(jì)劃統(tǒng)計(jì)室,,,,,,,,,,,,,,,,,,制表日期：2005.9.6,,,,,,

序號(hào),物資編碼,更換備品備件名稱,規(guī)格及型號(hào),單位,消耗量,,,,,,,,采購(gòu)單位,最小采購(gòu)量,采購(gòu)周期（天）,采購(gòu)周期耗用量,試算訂貨周期（月）,訂貨周期（月）,訂貨周期耗用量,最小庫(kù)存量,安全庫(kù)存量,預(yù)計(jì)采購(gòu)單價(jià)（元）,預(yù)計(jì)采購(gòu)費(fèi)用（元）,需求專業(yè)

,,,,,1月份,2月份,3月份,4月份,5月份,6月份,累計(jì),月耗用最大值,,,,,,,,,,,,

1,17010241,彈簧墊圈,DIN127-B-6,個(gè),385098,85650,8662,127985,141151,39600,"788,146.00",385098.00,個(gè),800000,15,192549,2.08,2,770196,211803.9,800000,2.50,2000000,車輛運(yùn)用室

2,17010278,彈簧墊圈,DIN127-B-8,個(gè),1555,2720,5422,49058,33174,34000,"125,929.00",49058.00,個(gè),100000,15,24529,2.04,2,98116,26981.9,122708,2.50,306770,車輛運(yùn)用室

3,20180016,開(kāi)口銷,GB91-86-2.5x40,個(gè),,18,15,83,176,73,365.00,176.00,個(gè),400,15,88,2.27,2,352,96.8,450,0.08,36,車輛運(yùn)用室

4,20180014,開(kāi)口銷,GB91-86-3.2x40,個(gè),,69,15,13,8,,105.00,69.00,個(gè),200,15,34.5,2.90,2,138,37.95,200,0.06,12,車輛運(yùn)用室

5,20180013,開(kāi)口銷,GB91-86-3.2x65,個(gè),,33,16,17,,18,84.00,33.00,個(gè),200,15,16.5,6.06,5,165,18.15,200,0.10,20,車輛運(yùn)用室

6,17020026,六角螺母,GB6170-86-M10x1,個(gè),,,1,,40,3,44.00,40.00,個(gè),200,15,20,5.00,4,160,22,200,0.12,24,車輛運(yùn)用室

7,17020014,六角螺母,GB6170-86-M4,個(gè),,,4,1,4,1,10.00,4.00,個(gè),200,15,2,50.00,48,192,2.2,200,0.06,12,車輛運(yùn)用室

8,17020011,六角螺母,GB6170-86-M5,個(gè),,2,32,,11,3,48.00,32.00,個(gè),200,15,16,6.25,6,192,17.6,210,0.10,21,車輛運(yùn)用室

9,17010019,平墊圈,DIN125-A-6,個(gè),,7,14,23,8,6,58.00,23.00,個(gè),200,15,11.5,8.70,8,184,12.65,200,0.72,144,車輛運(yùn)用室

10,40130022,日光燈管,20W,支,5,9,5,,4,,23.00,9.00,個(gè),25,15,4.5,2.78,2,18,4.95,25,4.80,120,車輛運(yùn)用室

11,20180488,砂紙,80#,張,,,4,31,6,1,42.00,31.00,張,100,15,15.5,3.23,3,93,17.05,110,0.80,88,車輛運(yùn)用室

12,20010262,尼龍?jiān)鷰?100mm,根,100,150,210,20,30,60,570.00,210.00,根,500,15,105,2.38,2,420,115.5,530,0.02,10.6,維修通信室

13,20170031,水晶頭,RJ11,個(gè),14,25,40,36,29,36,180.00,40.00,個(gè),100,15,20,2.50,2,80,22,100,0.09,9,維修通信室

,,,,,,,,,,,,,,,,,,,,,,,,,

,因?yàn)橐陨衔镔Y最小采購(gòu)量是月消耗量得若干倍，所以采用定期補(bǔ)足安全庫(kù)存的方式管理：,,,,,,,,,,,,,,,,,,,,,,,

,1、訂貨周期<=最小采購(gòu)量÷月耗用最大值（為便于計(jì)算取正整數(shù)）,,,,,,,,,,,,,,,,,,,,,,,

,2、采購(gòu)周期耗用量>=月耗用最大值÷30*采購(gòu)周期,,,,,,,,,,,,,,,,,,,,,,,

,3、最小庫(kù)存量>＝采購(gòu)周期耗用量*（1+采購(gòu)保險(xiǎn)比例）,,,,,,,,,,,,,,,,,,,,,,,

,4、安全庫(kù)存量>=訂貨周期*月耗用最大值+最小庫(kù)存量,,,,,,,,,,,,,,,,,,,,,,,

,所以上述物資按照訂貨周期管理，