Scribd
Upload
25 views3 pages

OR Project

The WPS Office Sensitivity Report provides an analysis of variable cells and constraints for a linear programming model, detailing the final values, reduced costs, and allowable increases/decreases for each variable. It highlights the objective coefficients and the shadow prices for each constraint, indicating how much the objective function would improve if the constraint limits were relaxed. The report was created on May 6, 2025, and includes specific values for solutions and constraints.

Uploaded by

habibahsherif
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
25 views3 pages

OR Project

The WPS Office Sensitivity Report provides an analysis of variable cells and constraints for a linear programming model, detailing the final values, reduced costs, and allowable increases/decreases for each variable. It highlights the objective coefficients and the shadow prices for each constraint, indicating how much the objective function would improve if the constraint limits were relaxed. The report was created on May 6, 2025, and includes specific values for solutions and constraints.

Uploaded by

habibahsherif
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

WPS Office Sensitivity Report

Worksheet: [Book2]Sheet1
Report Created: 5/6/2025 [Link] AM

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$2 solution x1 2.0535386872 0 324 85.142857143 241.09473684
$C$2 solution x2 3.2086541988 0 358 1041.0909091 74.5
$D$2 solution x3 0 -175.739457279 177.5 175.73945728 1E+030
$E$2 solution x4 0 -146.235423542 148 146.23542354 1E+030
$F$2 solution x5 0 -111.70443711 182 111.70443711 1E+030
$G$2 solution x6 0 -108.141364136 123.5 108.14136414 1E+030

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$H$5 Constraint 1 LHS 48.193986065 0 60 1E+030 11.806013935
$H$6 Constraint 2 LHS 70 20.9974330766 70 15.803166033 23.578947368
$H$7 Constraint 3 LHS 35 9.83498349835 35 17.777777778 24.305555556
$H$8 Constraint 4 LHS 14.875320865 0 20 1E+030 5.1246791346
$H$9 Constraint 5 LHS 9.4976164283 0 15 1E+030 5.5023835717
x1 x2 x3 x4 x5
solution 2.0535386872 3.2086541988 0 0 0
object coeffecient 324 358 177.5 148 182

Constraint 1 10.5 8.3 10.2 7.2 12.3


Constraint 2 14.4 12.6 14.2 10.5 10.1
Constraint 3 2.2 9.5 5.6 7.5 8.3
Constraint 4 2.4 3.1 4.2 5.0 6.3
Constraint 5 1.5 2.0 1.8 1.2 2.5
x6 z
0 1814.045
123.5
LHS RHS
9.2 48.19399 <= 60
7.8 70 <= 70
6.9 35 <= 35
5.1 14.9 <= 20
1.0 9.5 <= 15

You might also like