HW 3 final.xlsx - Drug Space Weight Manpower Alphadox Biolight Solostock Doubletech Hattex Air-Dox Aptech Scotdox 2.4 5.43 3.31 3.79 8.09 9.83 6.78

HW 3 final.xlsx - Drug Space Weight Manpower Alphadox...

This preview shows page 1 - 2 out of 2 pages.

Drug Space Weight Manpower Profit Alphadox 2.4 22.6 0.18 132 5.1 Biolight 5.43 55.1 0.4 149 4.87 Solostock 3.31 28.6 0.21 156 4.8 Doubletech 3.79 29.2 0.25 126 5.06 Hattex 8.09 80.5 0.42 190 7.18 Air-Dox 9.83 97.7 0.28 168 7.25 Aptech 6.78 64.5 0.28 197 7.08 Scotdox 14.57 143.4 0.39 116 6.9 Decision Variables: 132 Alphadox 0 Biolight 156 Solostock 126 Doubletech 147 Hattex 161 Air-Dox 197 Aptech 0 Scotdox Objective Funtion $5,678.02 Constraints L.H. Side Type R.H. Side 5420 <= 5420 51411 <= 52160 250 <= 250 132 <= 132 0 <= 149 156 <= 156 126 <= 126 147 <= 190 161 <= 168 197 <= 197 0 <= 116 Max Storage
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Excel HW 3.xlsx final.xlsx]HW3 Report Created: 3/26/2020 6:16:17 PM Engine: Gurobi Solver Objective Cell (Max) Cell Name Final Value $A$27 Objective Funtion 5678.0182945 Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $A$16 Decision Variables: 132 0 5.1 1E+100 2.6153579478 $A$17 Decision Variables: 0 -0.7050982076 4.87 0.7050982076 1E+100 $A$18 Decision Variables: 156 0 4.8 1E+100 1.6180879038 $A$19 Decision Variables: 126 0 5.06 1E+100 1.3555570463 $A$20 Decision Variables: 146.73253193 0 7.18 1.8090274296 0.5448167192 $A$21 Decision Variables: 161.4012021

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture