Scribd
Upload
98 views10 pages

Cell Name Original Value Final Value

The solver found an optimal solution that satisfies all constraints. It maximized the objective function value of 700*U1+300*U2 to 1. The optimal values of the variables are: U1 = 0.0012727273, U2 = 0.0003636364, V1 = 0, V2 = 0.002. All constraints are satisfied without slack or are non-binding with positive slack.

Uploaded by

Abhishek Srivastava
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
98 views10 pages

Cell Name Original Value Final Value

The solver found an optimal solution that satisfies all constraints. It maximized the objective function value of 700*U1+300*U2 to 1. The optimal values of the variables are: U1 = 0.0012727273, U2 = 0.0003636364, V1 = 0, V2 = 0.002. All constraints are satisfied without slack or are non-binding with positive slack.

Uploaded by

Abhishek Srivastava
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 Answer Report
Worksheet: [Exercise Solver.xlsx]Sheet1
Report Created: 23-04-2018 17:11:26
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.016 Seconds.
Iterations: 7 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Max)


Cell Name Original Value Final Value
$E$5 E(S1)=100*U1= 0 1

Variable Cells
Cell Name Original Value Final Value Integer
$B$3 Value U1 0 0.01 Contin
$C$3 Value V1 0 0.1666666667 Contin
$D$3 Value V2 0 0.0033333333 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$F$10 #NAME? 1.110223E-16 $F$10<=$H$10 Binding 0
$F$11 #NAME? -0.3333333333 $F$11<=$H$11 Not Binding 0.333333333
$F$12 #NAME? -0.6 $F$12<=$H$12 Not Binding 0.6
$F$13 #NAME? -0.8333333333 $F$13<=$H$13 Not Binding 0.833333333
$F$14 #NAME? 1 $F$14=$H$14 Binding 0
$F$15 #NAME? 0.01 $F$15>=$H$15 Not Binding 0.01
$F$16 #NAME? 0.1666666667 $F$16>=$H$16 Not Binding 0.166666667
$F$17 #NAME? 0.0033333333 $F$17>=$H$17 Not Binding 0.003333333
$F$8 #NAME? 0 $F$8<=$H$8 Binding 0
$F$9 #NAME? -0.1666666667 $F$9<=$H$9 Not Binding 0.166666667
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Exercise Solver.xlsx]Sheet1
Report Created: 23-04-2018 17:11:27

Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$3 Value U1 0.01 0 100 1E+030 100
$C$3 Value V1 0.1666666667 0 0 0 3
$D$3 Value V2 0.0033333333 0 0 300 0

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$F$10 #NAME? 1.110223E-16 0 0 0.2 1
$F$11 #NAME? -0.333333333 0 0 1E+030 0.333333333
$F$12 #NAME? -0.6 0 0 1E+030 0.6
$F$13 #NAME? -0.833333333 0 0 1E+030 0.833333333
$F$14 #NAME? 1 1 1 1E+030 1
$F$15 #NAME? 0.01 0 0 0.01 1E+030
$F$16 #NAME? 0.1666666667 0 0 0.166666667 1E+030
$F$17 #NAME? 0.0033333333 0 0 0.003333333 1E+030
$F$8 #NAME? 0 1 0 1 0.384615385
$F$9 #NAME? -0.166666667 0 0 1E+030 0.166666667
Microsoft Excel 16.0 Limits Report
Worksheet: [Exercise Solver.xlsx]Sheet1
Report Created: 23-04-2018 17:11:27

Objective
Cell Name Value
$E$5 E(S1)=100*U1= 1

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$B$3 Value U1 0.01 0 0 0.01 1
$C$3 Value V1 0.166666667 0.166666667 1 0.166666667 1
$D$3 Value V2 0.003333333 0.003333333 1 0.003333333 1
Variable U1 V1 V2
Value 0.01 0.166667 0.003333

Obj Fn E(S1)=100*U1= 1

Constraints Value RHS


Unit 1 100 -2 -200 = 0 <= 0
Unit 2 100 -4 -150 = -0.16667 <= 0
Unit 3 100 -4 -100 = 0 <= 0
Unit 4 100 -6 -100 = -0.33333 <= 0
Unit 5 100 -8 -80 = -0.6 <= 0
Unit 6 100 -10 -50 = -0.83333 <= 0
Inputs 0 2 200 = 1 = 1
Non Negative 1 0 0 = 0.01 >= 0
Non Negative 0 1 0 = 0.166667 >= 0
Non Negative 0 0 1 = 0.003333 >= 0
Variable U1 U2 V1 V2
Value 0 0 0 0

Objevtive fn 700*U1+300*U2= 0

Constraints Value RHS


Unit 1 700 -2 -200 = 0 <= 0
Unit 2 300 -4 -150 = 0 <= 0
Unit 3 200 -4 -100 = 0 <= 0
Unit 4 400 -6 -100 = 0 <= 0
Unit 5 500 -8 -80 = 0 <= 0
Unit 6 500 -10 -50 = 0 <= 0
Inputs 0 2 200 = 0 = 1
Non Negative 1 0 0 = 0 >= 0
Non Negative 0 1 0 = 0 >= 0
Non Negative 0 0 1 = 0 >= 0
Non Negative
q1aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
Microsoft Excel 16.0 Answer Report
Worksheet: [Exercise Solver.xlsx]Sheet5
Report Created: 23-04-2018 17:25:20
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: GRG Nonlinear
Solution Time: 0.031 Seconds.
Iterations: 3 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative

Objective Cell (Max)


Cell Name Original Value Final Value
$H$6 700*U1+300*U2= 0 1

Variable Cells
Cell Name Original Value Final Value Integer
$D$4 Value U1 0 0.0012727273 Contin
$E$4 Value U2 0 0.0003636364 Contin
$F$4 Value V1 0 0 Contin
$G$4 Value V2 0 0.002 Contin

Constraints
Cell Name Cell Value Formula Status Slack
$H$10 #NAME? -0.4 $H$10<=$J$10 Not Binding 0.4
$H$11 #NAME? -0.2909090909 $H$11<=$J$11 Not Binding 0.290909091
$H$12 #NAME? -0.2727272727 $H$12<=$J$12 Not Binding 0.272727273
$H$13 #NAME? -0.0181818182 $H$13<=$J$13 Not Binding 0.018181818
$H$14 #NAME? -0.1818181818 $H$14<=$J$14 Not Binding 0.181818182
$H$15 #NAME? 2.220446E-16 $H$15<=$J$15 Binding 0
$H$16 #NAME? -0.3454545455 $H$16<=$J$16 Not Binding 0.345454545
$H$17 #NAME? 1 $H$17=$J$17 Binding 0
$H$18 #NAME? 0.0012727273 $H$18>=$J$18 Not Binding 0.001272727
$H$19 #NAME? 0.0003636364 $H$19>=$J$19 Not Binding 0.000363636
$H$20 #NAME? 0 $H$20>=$J$20 Binding 0
$H$21 #NAME? 0.002 $H$21>=$J$21 Not Binding 0.002
$H$9 #NAME? 2.220446E-16 $H$9<=$J$9 Binding 0
Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Exercise Solver.xlsx]Sheet5
Report Created: 23-04-2018 17:25:21

Variable Cells
Final Reduced
Cell Name Value Gradient
$D$4 Value U1 0.0012727273 0
$E$4 Value U2 0.0003636364 0
$F$4 Value V1 0 0
$G$4 Value V2 0.002 0

Constraints
Final Lagrange
Cell Name Value Multiplier
$H$10 #NAME? -0.4 0
$H$11 #NAME? -0.290909091 0
$H$12 #NAME? -0.272727273 0
$H$13 #NAME? -0.018181818 0
$H$14 #NAME? -0.181818182 0
$H$15 #NAME? 2.220446E-16 0
$H$16 #NAME? -0.345454545 0
$H$17 #NAME? 1 1
$H$18 #NAME? 0.0012727273 0
$H$19 #NAME? 0.0003636364 0
$H$20 #NAME? 0 5.329071E-15
$H$21 #NAME? 0.002 0
$H$9 #NAME? 2.220446E-16 1
Microsoft Excel 16.0 Limits Report
Worksheet: [Exercise Solver.xlsx]Sheet5
Report Created: 23-04-2018 17:25:21

Objective
Cell Name Value
$H$6 700*U1+300*U2= 1

Variable Lower Objective Upper Objective


Cell Name Value Limit Result Limit Result
$D$4 Value U1 0.001272727 0 0.109090909 0.001272727 1
$E$4 Value U2 0.000363636 0 0.890909091 0.000363636 1
$F$4 Value V1 0 0 1 0 1
$G$4 Value V2 0.002 0.002 1 0.002 1
Variable U1 U2 V1 V2
Value 0.001273 0 0 0.002

Objevtive fn 700*U1+300*U2= 1

Constraints Value RHS


Unit 1 700 300 -40 -500 = 2.22E-16 <= 0
Unit 2 300 600 -50 -500 = -0.4 <= 0
Unit 3 200 700 -50 -400 = -0.29091 <= 0
Unit 4 400 600 -50 -500 = -0.27273 <= 0
Unit 5 500 400 -40 -400 = -0.01818 <= 0
Unit 6 500 500 -50 -500 = -0.18182 <= 0
Unit 7 800 500 -40 -600 = 2.22E-16 <= 0
Unit 8 300 200 -30 -400 = -0.34545 <= 0
Inputs 0 0 40 500 = 1 = 1
Non Negati 1 0 0 0 = 0.001273 >= 0
Non Negati 0 1 0 0 = 0.000364 >= 0
Non Negati 0 0 1 0 = 0 >= 0
Non Negati 0 0 0 1 = 0.002 >= 0

You might also like