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
Microsoft Excel 16.0 Sensitivity Report

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