库存上下限公式

需100天日均2店1400100096927444411107金辣子红油豆瓣酱500G240.240.0576 2401000076925638270059佳家嘉鸡精100G348 3.480.8352 3401000086925638230138金怡陈醋420ML378 3.780.9072 4401000106902487381402双桥味精338G213 2.130.5112 5401000116923942505201山西龙眼井陈醋420ML111 1.110.2664 6401000136925638210475金怡美味鲜原晒生抽王500ML301 3.010.7224 7401000146901377001000莲花味精100G267 2.670.6408 8401000156918272090381孔师傅蒸肉米粉（麻辣）150439 4.39 1.0536 9401000176925638210482金怡美味鲜原晒草菇老抽500181 1.810.4344 10401000186907212168211味丹100G168 1.680.4032 11401000196922125499986旺丰郫县豆瓣250G229 2.290.5496 12401000206922406898996蓬盛香港橄榄菜180G7057.05 1.692 13401000216917336403303家乐鸡精100G133 1.330.3192 14401000236921320200427郫县红油豆瓣500G284 2.840.6816 15401000246902487381471双桥味精(特小晶)100G297 2.970.7128 16401000256921480218287味事达味极鲜酱油380ML261 2.610.6264 1740100026693855030003同发料酒470ML155 1.550.372 18401000276919087958262加碘海精盐500G10979109.7926.3496 19401000286925792784164海马黄豆金标生抽王1.68L750.750.18 20401000336902265170501海天鲜味生抽王500ML338 3.380.8112 21401000366902150888900味嘉牌豆豉鲮鱼207G239 2.390.5736 22401000376902265120506海天金标生抽王500ML441 4.41 1.0584 23401000386902265180012海天威极生抽王500ML364 3.640.8736 24401000436906303999888新王守义十三香40G289 2.890.6936 25401000446918272090824孔师傅蒸肉米粉（五香）150359 3.590.8616 26401000456927119210028旺福白醋500ML208 2.080.4992 27401000476925638270011佳家嘉鸡精500G232 2.320.5568 28401000506922406898989蓬盛香港橄榄菜450G113 1.130.2712 29401000526921804700306陶老干妈牛肉味210G236 2.360.5664 30401000546902902004237美家草菇老抽500ML207 2.070.4968 31401000566902265120193海天金标生抽王1.9L790.790.1896 32401000576920502335902春盛香港橄榄菜160G116 1.160.2784 33401000586902265130505海天银标生抽王500ML531 5.31 1.2744 34401000606907212168082味丹400G125 1.250.3 35401000616902265280507海天老抽鼓油皇500ML209 2.090.5016 36401000626912336173355华盛白醋500ML850.850.204 37401000646923142690134典林野山椒300G213 2.130.5112 38401000656902265190509海天生抽鼓油皇500ML222 2.220.5328 39401000666902487381044双桥味精(晶体)227G104 1.040.2496 40401000756902265130192海天银标生抽王1.9L670.670.1608 41401000786924746200293燕山精制剁辣椒315G790.790.1896 42401000796904026219672黎红麻辣酱350G650.650.156 43401000826902902000017岐江桥美味鲜生抽王500ML135 1.350.324 44401000846905475350626三五火锅佐料300G151 1.510.3624 45401000866902902007382岐江桥上等生抽850ML610.610.1464 46401000876904026213458黎红花椒油50ML119 1.190.2856 47401000886902265210504海天草菇老抽500ML960.960.2304 48401000926921629213722自力小磨香油160ML106 1.060.2544 49401000976921804700054陶老干妈油辣子210G920.920.2208 50401000986910384989850绍兴圣塔料酒（干黄酒）500480.480.1152
51401000996904026078460黎红鲜花椒油360ML270.270.0648 52401001026928513120081红油郫县豆瓣500G980.980.2352 53401001036924747264683家家香香辣腐乳300G880.880.2112 54401001046921804700795陶老干妈风味鸡油辣椒280G139 1.390.3336 55401001056902265170198海天鲜味生抽王1.9L620.620.1488 56401001086902265240501海天老抽王500ML147 1.470.3528 57401001156914789018825一级保宁醋430ML660.660.1584 58401001166921629214859自力小磨香油300ML560.560.1344 59401001186902487381341双桥味精50G280 2.80.672 60401001196923194701888康的白醋王500ML105 1.050.252 61401001236928497900020天府醪糟380G320.320.0768 62401001306920818366157美和居东湖白醋420ML116 1.160.2784 63401001346921480218300味事达760ML720.720.1728 64401001406907212168112味丹200G119 1.190.2856 65401001536902265360018海天上等蚝油700G630.630.1512 66401001566902902007474美家特级金标生抽王500ML860.860.2064 67401001586921804700788陶老干妈辣三丁油辣椒280G950.950.228 68401001616914789018856保宁醋B430ML149 1.490.3576 69401001636920673703593三A辣腐乳300G960.960.2304 70401001686902902006439美味鲜小南乳360G490.490.1176 71401001696902902004381岐江桥原晒生抽王1.68L710.710.1704 72401001746920226900059香山牌桂林辣椒酱230G240.240.0576 73401001796902265360100海天上等蚝油260ML990.990.2376 74401001806902902005159美味鲜胡椒粉25G340.340.0816 75401001826910384989188东湖花雕酒600ML640.640.1536 76401001836901377291005莲花袁宫高纯味精100G103 1.030.2472 77401001856902902007122厨邦酱油500ML162 1.620.3888 78401001896921804700207陶老干妈鲜肉丝豆豉210G115 1.150.276 79401001916922824055063李锦记锦珍生抽500ML132 1.320.3168 80401001926902902008006岐江桥金标生抽王800ML490.490.1176 81401001996921180881903珠江桥精酿生抽王500ML400.40.096 82401002296920673709168三A白腐乳300G960.960.2304 83401002306902902004398岐江桥原晒草菇老抽1.68L260.260.0624 84401002346925638261057怡宝西红茄汁630G220.220.0528 85401002456920233023338安记香酥炸鸡粉45G670.670.1608 86401002546920818398691东湖陈醋420ML194 1.940.4656 87401002666925792783488海马草菇老抽1.68L180.180.0432 88401002686913102120221家乐新一品鲜鸡精180G630.630.1512 89401002776936168886887老兵剁辣椒2200G590.590.1416 90401002796913102210618家乐香菇鸡茸汤41G150.150.036 91401002866920233026926安记八角粉40G410.410.0984 92401002916920003400529陶味园黑胡椒粉25G270.270.0648 93401002986924747203682家家鲜小南乳300G240.240.0576 94401003056920003400352陶味园五香粉30G360.360.0864 95401003066918678600016李锦记卤水汁410ML160.160.0384 96401003106902902003063美味鲜添灯甜醋620ML180.180.0432 97401003186920818366300美和居东湖老陈醋420ML148 1.480.3552 98401003266920233026780安记鱼香肉丝40G120.120.0288 99401003326920233023321安记麻辣炸鸡粉45G570.570.1368 100401003356913102210113家乐鸡茸玉米羹38G280.280.0672 101401003666920233026759安记咖喱粉40G270.270.0648
102401003706902265440291海天海鲜酱250G130.130.0312 103401004546921804700757陶老干妈风味豆豉280G8758.75 2.1 104401004566902902004220岐江桥原晒生抽王500ML239 2.390.5736 105401004596924830328858涪渝牌榨菜55G114311.43 2.7432 106401004686923909921396杨江白醋500ML187 1.870.4488 107401004806926775488925恒丰和郫县豆瓣1.1KG480.480.1152 108401005246930331020054双楼四厂陈醋420ML740.740.1776 109401005296927444410223金辣子红油豆瓣酱500G190.190.0456 110401005426942487600011佳味橄榄菜178G176 1.760.4224 111401005446901754071107乌江牌榨菜100G361236.128.6688 112401005466935672818889恒冠镇江香醋500ML160.160.0384 113401005536936168867954洪波老兵朵辣椒260G480.480.1152 114401005546933928259936华多牌天府醪糟350G940.940.2256 115401005586942978600063合山桥阳江姜豉190G270.270.0648 116402000246921282917777华品生粉165G500.50.12 117422000086901434393789 绵竹大曲500ML294 2.940.7056 118422000096921414712256泸通高粱王4500ML170.170.0408 119422000126921674700017正通小烧42度430ML645 6.45 1.548 120422000146901435017783沱牌酒45度480ML473 4.73 1.1352 121422000196916333000072蛤蚧药酒182 1.820.4368 122422000216904406383283九江双蒸酒610ML147 1.470.3528 123422000256926130920336古绵纯33%500ML260.260.0624 12442200035690678500501552度红星二锅头500ML123 1.230.2952 125422000376912398335388红荔蛤蚧酒500ML206 2.060.4944 12642200041690179810016052度泸州二曲500ML540.540.1296 12742200051690678523085155度大红星锅头500ML990.990.2376 128422000696904406383290九江双蒸酒305ML730.730.1752 12942200071690138200036439%尖庄白酒475ML250.250.06 130422001416904406680016杯装九江双蒸米酒156ML370.370.0888 131422002386935856209281强将蛤蚧药酒500ML106 1.060.2544 132422002406930649916834仙人洞黑糯米650ML310.310.0744 13342200241693591290005340度名娘小烧酒450ML920.920.2208 134502000256922111222413露晶洗洁精900ML281 2.810.6744 135502000876922111222420露晶洗洁精500ML105 1.050.252 136502001656922111222437露晶洗洁精2KG106 1.060.2544
保险系数采购天下限初值下限上限初值上限340.1728335
34 2.5056366
34 2.7216377
34 1.5336355
340.7992345
34 2.1672366
34 1.9224366
34 3.1608377
34 1.3032355
34 1.2096467
34 1.6488356
34 5.07651212
340.9576345
34 2.0448366
34 2.1384366
34 1.8792366
34 1.116345
3479.048879184184
340.54234
34 2.4336368
34 1.7208355
34 3.1752488
34 2.6208478
34 2.0808366
34 2.5848478
34 1.4976468
34 1.6704468
340.8136458
34 1.6992468
34 1.4904357
340.5688234
340.8352458
34 3.82324910
340.9345
34 1.5048355
340.612346
34 1.5336355
34 1.5984355
340.7488345
340.4824234
340.5688346
340.468346
340.972345
34 1.08724510
340.4392346
340.8568346
340.6912458
340.7632345
340.6624458
340.3456335
340.7056346 340.6336345 34 1.0008345 340.4464234 34 1.0584345 340.4752458 340.4032345 34 2.016478 340.756345 340.2304335 340.8352345 340.5184345 340.8568345 340.4536345 340.6192345 340.684345 34 1.0728347 340.6912345 340.3528335 340.5112345 340.1728335 340.7128345 340.2448336 340.4608345 340.7416345 34 1.1664356 340.828345 340.9504345 340.3528335 340.288335 340.6912345 340.1872335 340.1584335 340.4824345 34 1.3968355 340.1296224 340.4536458 340.4248234 340.108335 340.2952335 340.1944336 340.1728336 340.2592336 340.1152336 340.1296335 34 1.0656346 340.0864335 340.4104345 340.2016335 340.1944335
34 6.361515 34 1.7208355 348.229681919 34 1.3464355 340.3456224 340.5328458 340.1368335 34 1.2672355 3426.0064266161 340.1152335 340.3456335 340.6768345 340.1944335 340.36335 34 2.11686912 340.1224224 34 4.64451111 34 3.40564910 34 1.3104468 34 1.0584457 340.1872224 340.8856345 34 1.4832355 340.3888345 340.7128345 340.5256345 340.18335 340.2664335 340.7632345 340.2232335 340.6624345 34 2.0232478 340.756458 340.7632234。