Scribd
Upload
11 views1 page

Excel Sensitivity Report Analysis

This document is a sensitivity report for an Excel worksheet containing an optimization model with variable cells and constraints. It lists the variable cells used in the model along with their names, coefficients, and allowable increases and decreases without affecting the optimal solution. It also lists the constraints in the model along with their final values, shadow prices, right-hand sides, and allowable increases and decreases. The report provides key information about the sensitivity of the optimal solution to changes in the variable cells and constraints.

Uploaded by

James4226c
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views1 page

Excel Sensitivity Report Analysis

This document is a sensitivity report for an Excel worksheet containing an optimization model with variable cells and constraints. It lists the variable cells used in the model along with their names, coefficients, and allowable increases and decreases without affecting the optimal solution. It also lists the constraints in the model along with their final values, shadow prices, right-hand sides, and allowable increases and decreases. The report provides key information about the sensitivity of the optimal solution to changes in the variable cells and constraints.

Uploaded by

James4226c
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Microsoft Excel 14.

0 Sensitivity Report
Worksheet: [[Link]]Sheet1
Report Created: 2/15/2012 11:15:29 PM

Variable Cells
Cell
$D$14
$E$14
$F$14
$G$14
$H$14

Name
Weights ROA
Weights New Loans
Weights Satisfation
Weights Labor Hours
Weights Op. Cost

Final
Reduced
Objective
Value
Cost
Coefficient
0.104753198
0
6.4
0 -18.93753991
910
0.00117428
0
98
0.044537503
0
0
0.078737526
0
0

Allowable
Increase
0.457370233
18.93753991
55.86283569
0.298290169
0.521657432

Allowable
Decrease
1.244431483
1E+30
2.231848356
0.425610034
0.365605299

Constraints
Cell
$D$19
$K$3
$K$4
$K$5
$K$6
$K$7
$K$8
$K$9
$K$10
$K$11
$K$12

Name
input ROA
Difference
Difference
Difference
Difference
Difference
Difference
Difference
Difference
Difference
Difference

Final
Value
1
3.21965E-15
-0.038747436
-0.135431659
-0.136399879
-0.214500061
2.9976E-15
-0.210447242
-7.21645E-15
-0.005779592
-0.096969404

Shadow
Constraint
Allowable
Allowable
Price
R.H. Side
Increase
Decrease
0.785499939
1
1E+30
1
0.219141963
0 0.009365913 0.086499217
0
0
1E+30 0.038747436
0
0
1E+30 0.135431659
0
0
1E+30 0.136399879
0
0
1E+30 0.214500061
0.113030837
0 0.050721647 0.067906478
0
0
1E+30 0.210447242
0.683496607
0 0.01539903 0.203069309
0
0
1E+30 0.005779592
0
0
1E+30 0.096969404

You might also like