模型3-4 在采用EOQ与EPQ的前提下对购买与自制的比较

A B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 C D E F G H I J K L M N O 6427.506623.006396.006335.676317.006315.006321.336332.436346.506362.566380.006398.456417.676437.466457.716478.336585.006695.00P Q R S 年需求量 (D)一件产品保存一年储存成本10002.3#6.11025046100.0040.00287.506427.5093.256314.48购买单位采购成本每批订货成本每批订货数量每年订货批数年采购成本年订货成本年储存成本购买年总成本经济订货量最小年总成本制造年生产速率 (P)1-D/P单位生产成本每批设置成本每批生产数量每年生产批数年生产成本年设置成本年储存成本制造年总成本经济生产量最小年总成本60000.835.95020055900.00250.00191.676341.67228.426337.80经济订货量参考线最优方案最优方案下的最小年总成本购买6314.48h=2.393.2593.25228.42228.4261006600610066002040608010012014016018020022024026028030040050020406080100120140160180200220240260280300400500最小制造成本参考线经济生产量参考线最小购买成本参考线最优方案为购买05006314.486314.480500T 1 2 6341.673 8419.1674 7188.3335 6790.8336 6601.6677 6495.8338 6431.6679 6391.3110 6365.83311 6350.27812 6341.66713 6338.10614 6338.33315 6341.47416 6346.90517 6354.16718 6408.33319 6479.16720 最小制造成本参考线21 22 6337.8023 6337.80U V W in D9:=D3/D8in D10:=D3*D6X Y Z AA AB AC in J5:in J9:in J10:in D11:=D7*D9in D12:=D4*D8/2in D13:=D10+D11+D12in D15:=SQRT(2*D7*D3/D4)in J16:=SQRT(2*J7*D4*D3*J5)+D3*J6in D16:=SQRT(2*D7*D4*D3)+D3*D6in D19:=IF(D20=D16,C5,H2)in J15:=SQRT(2*J7*D3/D4/J5)in D20:=MIN(D16,J16)AD 1 2 =1-D3/J43 =D3/J84 =D3*J65 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 AE AF AG in J11:=J7*J9in J12:=D4*J8/2*J5in J13:=J10+J11+J12