《管理运筹学》实验作业第三次

《《管理运筹学》实验作业第三次》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、习题3-1Excel模型习题3-1利润（1o力•元）A4.5B3.8C9.5D-2E-1.5资源限制应投资金（百力'元）46120120应投人力（人）54123015应投设备（套）111002解0.000.001.000.000.00最人利润9.50应投资金12.00应投人力12.00应投设备1.00设贾目标单云格（X）:最大利S3等于:◎最大值＜WO最小值型）值対QD叵MicrosoftExcel11.0运算结果报告工作表[Bookl]Sheetl报告的建立:2014-06-1120:34:25目标单元格就值）单元格名宇终佰$8$11最天利用131515789282

2、9490000000.009.50可娈单元格单元格名宇终（1$B$10解A47368421052631600000.000.00$C$10簡B39999999498066100000.000.00$D$10解C100000000000000000000.001.00$E$10簡D0.000.00$F$10輻E0.000.00约束$B$13人力12.00$B$13<=$G$6未到限制3$B$12资金12.00$B$12<=$G$58$B$14设备1.00$B$14<=$G$7未到限制1$B$10常A0.00$B$10=整数至1限制0.00$C$10询B0.00$C$10

3、=整数51达限制限吊1S0.00$D$10南c1.00$D$10=整数甲0.00$E$10韶D0.00$E$10=整裁甲10.00$F$10解E0.00$F$10遅藪限制I0.00$B$10解A0.00$B$10>=0限用g0.00$C$10解B0.00$C$10口至1限制0.00$D$10解C1.00$D$10>=0未到限制1.00$E$10解D0.00$E$10>=0毛1

4、诙限制0.00$F$10解E0.00$F$10>=00.00公衣GIod&IOE>cxxnalsoxu^xonxovundOb^eu匸丄vmvailue:Otojectivebound:Infc

5、aisXtoXXXeXejs:Ex匸■ridecisolver:Totalsolver:9•5000009•500000O•OOOOOOXXXXX12345(((((XXXXXValueO•OOOOOOO・OOOOOOX•OOOOOOO•OOOOOOO•OOOOOOO.OOOOOOO•OOOOOOO・OOOOOOO•OOOOOOO•OOOOOOSlaicJcox*Surplus9・5000008.OOOOOO3•OOOOOOX•OOOOOOO•OOOOOOO.OOOOOOO•OOOOOOO・OOOOOOO.OOOOOORedLuuuclCom匸一唆■500000-3•

6、800000一9•5000002•OOOOOO1•500000O.OOOOOOO•OOOOOOO•OOOOOOO•OOOOOOO•OOOOOO1.OOOOOOO.OOOOOO•OOOOOO•OOOOOO•OOOOOO•OOOOOO•OOOOOO•OOOOOO•OOOOOOlingo模型:secs:city/1^2r3r4^5/;linkl(city):x;endsecsmax=4•5*xl+3.8*x2+9.5*x3-2*x4-l•5*x5;4*xl+6*x2+12*x3+0*x4+l*x5<=20;5*xl+4*x2+12*x3+3*x4+0*x5<=15;I*xl

7、+I*x2+I*x3+O*x4+O*x5<=2;@for(city(1):x(1)>=0);©gin(xl>;@gin(x2);@gin(x3);@gln(x4);@gin(x5);习题3-5Excel模型典优解▼R二SUMP叫DUCT（工佯时间,最坤解）ABCDEF甲乙丙丁1L012甲乙丙丁最少时间71ABcD20192028182427J20J2616151817J20J24n190J1Jod0J11J0J0Jon10□0Jij01100J0111111MicrosoftExcel11.0运算结果报告作表[Bookl]Sheet1报告的建立：2014-06-112

8、2:14:35目单元格名字初值终值$B$12最少氏071•变单元格单元格名字初值终値$B$7甲A00$C$7甲B01$D$7甲c00$E$7甲D00$B$8乙A01$C$8乙B00$D$8乙c00$E$8乙D00$B$9丙A00$C$9丙B00$D$9丙c01$E$9丙D00$B$10TA00$C$10TB00$D$10丁c00$E$10丁D01单兀格名主单元格借公式状态型数值和8乙1fF$8=l未到限制値0啊7甲1$F$7=1未到限制値0們9丙1$F$9=131:到限制値0$F$10T1$F$10=l7":到限制值0}B

9、11A1$B$11二1未到