模型4-04办公设备最优供货运输方案

123456789101112131415161718192021ABCDEFGHIJKLMNOinH5:=SUM(E5:G5)inE8:运输数量矩阵甲乙丙运出量生产能力A111385B111390C111340运入量333需求量6010040单位运费矩阵A381426B342317总运费C53321211211=MIN($H$13)9=COUNT($E$5:$G$7)FALSE{=$E$8:$G$8=$E$9:$G$9}TRUE{=$E$5:$G$7=INT($E$5:$G$7)}TRUE{=$H$5:$H$7=$I$5:$I$7}100={100,100,0.000001,0.05,TRUE,FALSE,FALSE,1,1,1,0.001,TRUE}工厂工厂客户123456789101112131415161718192021PQRS=SUM(E5:E7)inH14:{=SUM(E5:G7*E11:G13)}