[go: up one dir, main page]
Scribd
Upload
35 views4 pages

PG 49 Example Excel

The document contains a sensitivity report from Microsoft Excel detailing the results of an optimization problem with an objective function value of 92.4969492. It includes variable cells with their final values, reduced costs, and allowable increases and decreases, as well as constraints with their final values and shadow prices. The report also outlines the left-hand side (LHS) and right-hand side (RHS) values for the constraints.

Uploaded by

Study Account
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
35 views4 pages

PG 49 Example Excel

The document contains a sensitivity report from Microsoft Excel detailing the results of an optimization problem with an objective function value of 92.4969492. It includes variable cells with their final values, reduced costs, and allowable increases and decreases, as well as constraints with their final values and shadow prices. The report also outlines the left-hand side (LHS) and right-hand side (RHS) values for the constraints.

Uploaded by

Study Account
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
You are on page 1/ 4

Exercise 2.

22 Pg 45

Obj Fn 9.5

x1 2.5
x2 0
x3 0.5

constraints

1) 4 6
2) 9 9
3) 2 2
Microsoft Excel 16.41 Sensitivity Report
Worksheet: [Pg 45 Example Aishani.xlsx]Pg 49 example
Report Created: 04/02/25 4:57:45 PM

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$C$8 x_1 0 -0.0032138644 0 0.0032138644 1E+030
$C$9 x_2 0 -3.885781E-16 0 3.885781E-16 1E+030
$C$10 x_3 0 -0.0071186441 0 0.0071186441 1E+030
$C$11 x_4 0 -0.0031508475 0 0.0031508475 1E+030
$C$12 x_5 52 0 0 0.0031196509 3.809589E-16
$D$8 y_1 150 0 0 0.0039975356 0.0032138644
$D$9 y_2 100 0 0 0.003182044 3.885781E-16
$D$10 y_3 151.9441675 0 0 3.847308E-16 0.0031603
$E$8 z_1 0 -0.0039975356 0 0.0039975356 1E+030
$E$9 z_2 0 -0.00714 0 0.00714 1E+030
$E$10 z_3 351.9441675 0 0 0.00393091 0.0031603
$E$11 z_4 0 -0.0039191525 0 0.0039191525 1E+030
$E$12 z_5 0 -0.007 0 0.007 1E+030
$F$13 v 92.496949153 0 1 1E+030 1

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$C$16 LHS 150 -1.0372881356 150 89.171895425 149.41176471
$C$17 LHS 100 -1.0302 100 47.058823529 50.980392157
$C$18 LHS -200 -1.02 -200 90.683283483 151.9441675
$C$19 LHS 200 -1.0169491525 200 90.955333333 152.4
$C$20 LHS -50 -1.01 -50 48 52
$C$21 LHS -300 -1 -300 92.496949153 1E+030
Problem in 3.1.1 Pg 48 onwards

obj fn (v) 92.4969492

x_i y_i z_i VAR Constraint Value


JAN 0 150 0 150
FEB 0 100 0 100
MAR 0 151.944167 351.944167 -200
APR 0 0 200
MAY 52 0 -50
JUN 92.4969492 -300

LHS RHS
150 150
100 100
-200 -200
200 200
-50 -50
-300 -300
nstraint Value

You might also like