加工费售价甲原料A>=60%原料C<=20%0.053.4乙原料A>=15%原料C<=60%0.42.85丙原料C<=50%0.32.25成本每月限制用量A22000B1.52500C11200ABCtotal条件1条件2销售额成本甲00000>=00<=000乙00000>=00<=000丙00000<=000total00000<=<=<=200025001200总销售额总成本总利润0加工费售价甲原料A>=60%原料C<=20%0.53.4乙原料A>=15%原料C<=60%0.42.85丙原料C<=50%0.32.25成本每月限制用量A22000B1.52500C11200ABCtotal条件1条件2销售额成本甲1526.6666671017.77777802544.4444440>=0-508.8888889<=08651.1111115852.222222乙473.33333331482.22222212003155.5555560>=0-693.3333333<=08993.3333335632.222222丙00000<=000total20002500120017644.4444411484.44444<=<=<=200025001200总销售额总成本总利润6160MicrosoftExcel11.0敏感性
报告
软件系统测试报告下载sgs报告如何下载关于路面塌陷情况报告535n,sgs报告怎么下载竣工报告下载
工作表[线性规划图表.xls]Sheet3报告的建立:2012-11-1121:38:30可变单元格终递减目标式允许的允许的单元格名字值成本系数增量减量$C$3I22.53333333030.33333333341.454545455$D$3II23.2020.21428571430.7777777778$E$3III7.33333333302.91.60.15约束终阴影约束允许的允许的单元格名字值价格限制值增量减量$F$6A已用资源3000.03300165.714285736.66666667$F$7B已用资源4000.266666666740044122.9090909$F$8C已用资源4200.0466666667420397.6470588220MicrosoftExcel11.0敏感性报告工作表[线性规划图表.xls]Sheet3报告的建立:2012-11-1121:49:42可变单元格终递减目标式允许的允许的单元格名字值成本系数增量减量$C$21I26.75031.450.402173913$D$21II15.5020.19393203880.8295454546$E$21III0-0.231252.90.231251E+30$F$21IV0-0.4993752.10.4993751E+30$G$21V13.7501.870.730.1233333333约束终阴影约束允许的允许的单元格名字值价格限制值增量减量$H$24A已用资源3000.0762530044.2857142936.66666667$H$25B已用资源4000.2281254004456.36363636$H$26C已用资源4200.054375420713.3333333220MicrosoftExcel11.0敏感性报告工作表[线性规划图表.xls]Sheet3报告的建立:2012-11-1121:59:21可变单元格终递减目标式允许的允许的单元格名字值成本系数增量减量$C$40I22.7941176504.50.30.4555555555$D$40II25.294117650212.6250.125$E$40III0-0.18088235292.90.18088235291E+30约束终阴影约束允许的允许的单元格名字值价格限制值增量减量$F$43A已用资源255.735294103001E+3044.26470588$F$44B已用资源4000.371323529440055.2293578238.4615385$F$45C已用资源4200.0110294118420620286.666666776页2.10产品IIIIII22.5333333323.27.333333333设备已用资源可用资源A8210300<=300B1058400<=400C21310420<=420利润322.9总利润135.2666667产品IIIIIIIVV26.7515.50013.75设备已用资源可用资源A8210124300<=300B105854400<=400C213101012420<=420利润322.92.11.87总利润136.9625产品IIIIII22.7941176525.294117650设备已用资源可用资源A9210255.7352941<=300B1258400<=400C41310420<=420利润4.522.9总利润153.1617647