Scribd
Upload
12 views4 pages

LPP Simplex

The Microsoft Excel Sensitivity Report provides a summary of variable cells and constraints for a linear programming problem. It includes final values, reduced costs, objective coefficients, and allowable increases and decreases for each variable and constraint. The objective function aims to maximize profit, but the current solution yields a profit of zero.

Uploaded by

Chitralekha Madhusudhanan
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
12 views4 pages

LPP Simplex

The Microsoft Excel Sensitivity Report provides a summary of variable cells and constraints for a linear programming problem. It includes final values, reduced costs, objective coefficients, and allowable increases and decreases for each variable and constraint. The objective function aims to maximize profit, but the current solution yields a profit of zero.

Uploaded by

Chitralekha Madhusudhanan
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 16.

0 Sensitivity Report
Worksheet: [LPP [Link]]Sheet1
Report Created: 21-11-2024 2.34.58 PM

Variable Cells
Final Reduced Objective Allowable Allowable Upper limit
Cell Name Value Cost Coefficient Increase Decrease
$B$3 X1 Values 0 0 4 3.3333333333 1E+030 7.333333
$B$4 X2 Values 42.222222222 0 3 6 3 9
$B$5 X3 Values 156.66666667 0 6 1E+030 2.5 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$B$13 Eq1 LHS 440 1 440 131.33333333 126.66666667
$B$14 Eq2 LHS 470 1.3333333333 470 190 197
$B$15 Eq3 LHS 211.11111111 0 430 1E+030 218.88888889
$B$16 Eq4 LHS 0 -3.3333333333 0 70.357142857 0
$B$17 Eq5 LHS 42.222222222 0 0 42.222222222 1E+030
$B$18 Eq6 LHS 156.66666667 0 0 156.66666667 1E+030
Lower Limit

-1E+030
0
3.5
Variables Values Profit per unit

X1 0.00 4
X2 0.00 8
X3 0.00 6

Objective Function
Maximize Z 0.00

Constraints
LHS Inequality RHS
Eq1 0.00 <= 440
Eq2 0.00 <= 470
Eq3 0.00 <= 430
Eq4 0.00 >= 0
Eq5 0.00 >= 0
Eq6 0.00 >= 0
Variables Values Profit per unit

X1 0 4
X2 0 3
X3 0 6

Objective Function
Maximize Z

Constraints
LHS Inequality RHS
Eq1
Eq2
Eq3
Eq4
Eq5
Eq6

You might also like