BA1.xlsx - Microsoft Excel 16.0 Answer Report Worksheet[Book1]Sheet1 Report Created 4:40:33 PM Result Solver found a solution All Constraints and

BA1.xlsx - Microsoft Excel 16.0 Answer Report...

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

Microsoft Excel 16.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 2019-09-29 4:40:33 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 6 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$6 Revenue from farming Total 5800 5800 Variable Cells Cell Name Original Value Final Value Integer $B$5 Hector of Oats 50 50 Contin $C$5 Hector of Wheat 150 150 Contin $D$5 Hector of Barley 100 100 Contin Constraints Cell Name Cell Value Formula Status Slack $E$10 Hector of Wheat LHS 150 $E$10<=$G$10 Binding 0 $E$10 Hector of Wheat LHS 150 $E$10<=$G$10 Binding 0 $E$11 Hector of Barley LHS 50 $E$11>=$G$11 Binding 0 $E$12 oats constraint (x1-x3)>=0 LHS 0 $E$12<=$G$12 Binding 0 $E$13 Land constraint LHS 300 $E$13=$G$13 Binding 0 $E$14 None zero constrsint LHS 300 $E$14>=$G$14 Not Binding 300 $E$9 Hector of Oats LHS 50 $E$9>=$G$9 Binding 0
Image of page 1
Microsoft Excel 16.0 Sensitivity Report
Image of page 2
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Winter '18
  • jonathan li
  • Harshad number, Poaceae, Fodder, Hector of Oats

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture