Scribd
Upload
31 views7 pages

Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease

This sensitivity report summarizes two optimization models with variable cells and constraints. The first model has variables X1 and X2 with allowable increases and decreases. It aims to maximize costs subject to constraints on FH LHS, CH LHS, and DD LHS. The second model has more variables and aims to meet minimum production levels subject to constraints on MIN while minimizing total costs. It provides details on variable values, coefficients, and allowable changes for both models.

Uploaded by

HariSharanPanjwani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
31 views7 pages

Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease

This sensitivity report summarizes two optimization models with variable cells and constraints. The first model has variables X1 and X2 with allowable increases and decreases. It aims to maximize costs subject to constraints on FH LHS, CH LHS, and DD LHS. The second model has more variables and aims to meet minimum production levels subject to constraints on MIN while minimizing total costs. It provides details on variable values, coefficients, and allowable changes for both models.

Uploaded by

HariSharanPanjwani
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Microsoft Excel 15.

0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 27-09-2019 12.12.47 PM

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$C$5 X1 20 0 3 1 1
$D$5 X2 60 0 2 1 0.5

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$F$7 FH LHS 100 1 100 20 20
$F$8 CH LHS 80 1 80 20 20
$F$9 DD LHS 20 0 40 1E+030 20
Max
X1 X2
3 2 180
20 60
LHS
FH 2 1 100 <= 100
CH 1 1 80 <= 80
DD 1 0 20 <= 40
1 0 20 >= 0
X1 X2
2 -1
2.333333 1.333333 3.333333

1 -1 1 <= 1
2 1 6 >= 6
Microsoft Excel 15.0 Sensitivity Report
Worksheet: [Book1]Sheet6
Report Created: 27-09-2019 12.33.33 PM

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$C$3 X11 0 15 464 1E+030 15
$D$3 X12 20 0 513 15 21
$E$3 X13 0 84 654 1E+030 84
$F$3 X14 55 0 867 21 351
$G$3 X21 80 0 352 15 1E+030
$H$3 X22 45 0 416 21 15
$I$3 X23 0 217 690 1E+030 217
$J$3 X24 0 21 791 1E+030 21
$K$3 X31 0 728 995 1E+030 728
$L$3 X32 0 351 682 1E+030 351
$M$3 X33 70 0 388 84 1E+030
$N$3 X34 30 0 685 351 84

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$P$6 MIN 75 570 75 0 55
$P$7 MIN 125 473 125 0 45
$P$8 MIN 100 388 100 0 70
$P$9 MIN 80 -121 80 45 0
$P$10 MIN 65 -57 65 55 0
$P$11 MIN 70 0 70 0 1E+030
$P$12 MIN 85 297 85 70 0
X11 X12 X13 X14 X21 X22 X23 X24
0 20 0 55 80 45 0 0
464 513 654 867 352 416 690 791

1 1 1 1
1 1 1 1

1 1
1 1
1 1
1 1
X31 X32 X33 X34 MIN
0 0 70 30
995 682 388 685 152535

75 = 75
125 = 125
1 1 1 1 100 = 100
1 80 = 80
1 65 = 65
1 70 = 70
1 85 = 85
W1 W2 W3 W4
Plant 1 464 513 654 867
Plant 2 352 416 690 791
Plant 3 995 682 388 685
Allocation 80 65 70 85

You might also like