Problem 10 on Midterm 2 - Fall 2016 - Microsoft Excel 14.0 Answer Report Worksheet[Book3]Sheet1 Report Created 1:56:35 PM Result Solver found a solution

Problem 10 on Midterm 2 - Fall 2016 - Microsoft Excel 14.0...

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

Microsoft Excel 14.0 Answer Report Worksheet: [Book3]Sheet1 Report Created: 11/15/2016 1:56:35 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 3 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 NonNegativ Objective Cell (Min) Cell Name Original Value Final Value $C$10 Minimize: X1 0 350 Variable Cells Cell Name Original Value Final Value Integer $C$7 X1 0 250 Contin $D$7 X2 0 50 Contin Constraints Cell Name Cell Value Formula Status Slack $C$14 LHS 300 $C$14>=$E$14 Binding 0 $C$15 LHS 550 $C$15>=$E$15 Not Binding 150 $C$16 LHS 750 $C$16>=$E$16 Binding 0
Image of page 1
ve
Image of page 2
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Book3]Sheet1 Report Created: 11/15/2016 1:56:36 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$7 X1 250 0 1 1 0.2 $D$7 X2 50 0 2 0.5 1 Constraints Final Shadow
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '16
  • Reginald Murra
  • LHS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture