1、基于多因素变动库存管理模型注:提前期的单位可能是周、月,根据不同的情况要做相应调整,如用此表请务必留意和修改以下的提前期频段数请务必留意或修改此处:提前期单位为(周、月52周或月产品周需求均值周需求方差单价提前期(周)demademsprice at1 18637.932.12 9285.062.13113301.322.142052.411.95725.192.164901010.511.9744112.362868231.32948157.38210 719.69211 621.38212 413.2521390227.791.914515.483.38153119.043.3816722.033.38176268.972.6183121.653.381914456.282.2820 5119.85221 1043535.512.622 3092.192.1238214.242.12415612.162.2825624.043.38264166.133.38277268.13.38285111.183.382920526.412.283014440.862小计2、简单库存管理模型请依据提前期单位变动一下数值一年有52天、周、月产品序号年需求量D订货提前期T(周)年订货次数N 订货间隔期T01100502.136.606010441.420531748212000341331400044.73665466710.978212194200002 5.2440442419.9160109285150001.5 3.81881307913.616796356130002.5 3.33809184215.5777619371100033.3166247915.678589928125003.5 3.64109540614.28141659164004 4.84030695610.7431203210155002 4.45379720311.6754305711145003.5 3.80788655313.6558690212124002.5 3.27247473815.8901150313180004 4.65247994311.1768348614168001.5 4.42359376711.7551481315178004 4.87168690810.67392075必留意和修改以下的提前期频段数据!!!!只要修改蓝色部分的数据,即可得到结果(红色、绿色都是结果输出)再订货点订货期间内的平均需求年库存持有成本 平均库存量订货批量rodrohcaiq50.14837.8 375.096014639.5566585454.4173170723.01618.9 360.730235616.9635662225.69513243299.04237.3140.968976427.1787152730.877430347.313874.16217428123.0907457227.561491418.81614.7 64.8566842749.9858838391.739767661119.062931180.07162681412.3264852448.52897109.5688113.3404775192.1025043341.0850085181.08136107.4895696330.7371371571.3142743125.496240.0880968130.1290497201.458099515.961486.0710672435.5298523267.1397046315.921229.7654251886.27659473164.71318959.96837.1944662445.777804687.6356092211.964171341.2295845175.214164268.500328120.212416.9 56.2245433141.0398126475.4548252713.452410.14 90.3940968418.9903564831.3559129...