HW DUE FE 21.xlsx - Microsoft Excel 15.16 Sensitivity Report Worksheet[Workbook5]Sheet1 Report Created 10:38:22 PM Variable Cells Final Reduced

# HW DUE FE 21.xlsx - Microsoft Excel 15.16 Sensitivity...

This preview shows page 1 - 5 out of 5 pages.

Microsoft Excel 15.16 Sensitivity Report Worksheet: [Workbook5.xlsx]Sheet1 Report Created: 2/20/2019 10:38:22 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$C\$2 X1 200 0 2 2 2 \$D\$2 X2 300 0 3 2 1.00E+030 \$E\$2 X3 0 2 5 1.00E+030 2 \$F\$2 Y1 100 0 9 2 2 \$G\$2 Y2 0 2 12 1.00E+030 2 \$H\$2 Y3 300 0 10 2 1.00E+030 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$D\$12 LHS 500 -7 500 100 0 \$D\$13 LHS 400 0 400 1.00E+030 0 \$D\$14 LHS 300 9 300 0 100 \$D\$15 LHS 300 10 300 0 100 \$D\$16 LHS 300 10 300 0 300
Microsoft Excel 15.16 Answer Report Worksheet: [Workbook5.xlsx]Sheet1 Report Created: 2/20/2019 10:38:38 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.367974 Seconds. Iterations: 6 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name

#### You've reached the end of your free preview.

Want to read all 5 pages?

• Spring '14
• Management, Variable Cells, Max Integer Sols Unlimited, Iterations Unlimited