Kitap2.xlsx - Microsoft Excel 16.27 Answer Report Worksheet[Kitap2]Sayfa1 Report Created 19.11.2019 23:09:58 Result Solver found a solution All

# Kitap2.xlsx - Microsoft Excel 16.27 Answer Report...

• 9

This preview shows page 1 - 4 out of 9 pages.

Microsoft Excel 16.27 Answer Report Worksheet: [Kitap2]Sayfa1 Report Created: 19.11.2019 23:09:58 Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: GRG Nonlinear Solution Time: 30066680,207 Seconds. Iterations: 4 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 1E-06, Use Automatic Scaling Convergence 0,0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bou Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume No Objective Cell (Max) Cell Name Original Value Final Value \$B\$5 fx 297 286758.62069 Variable Cells Cell Name Original Value Final Value Integer \$B\$2 x1 10 26206.8965517 Contin \$B\$3 x2 20 6896.55172414 Contin Constraints Cell Name Cell Value Formula Status Slack \$B\$10 2000 \$B\$10<=\$D\$10 Binding 0 \$B\$11 5103.44827586 \$B\$11<=\$D\$11 Not Binding 896.55172414 \$B\$9 24000 \$B\$9<=\$D\$9 Binding 0
unds onNegative
Microsoft Excel 16.27 Sensitivity Report Worksheet: [Kitap2]Sayfa1 Report Created: 19.11.2019 23:09:58 Variable Cells Final Reduced Cell Name Value Gradient \$B\$2 x1 26206.896552 0 \$B\$3 x2 6896.5517241 0 Constraints Final Lagrange