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...

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
Image of page 1
unds onNegative
Image of page 2
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
Image of page 3
Image of page 4

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture