Sample Exam1 Section1 - Microsoft Excel 15.30 Answer Report Worksheet[Workbook4]Sheet1 Report Created 10:30:19 AM Result Solver found a solution All

# Sample Exam1 Section1 - Microsoft Excel 15.30 Answer Report...

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

Microsoft Excel 15.30 Answer Report Worksheet: [Workbook4]Sheet1 Report Created: 2/25/17 10:30:19 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.13452 Seconds. Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 1E-06 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Solve Without Inte Objective Cell (Min) Cell Name Original Value Final Value \$D\$12Profit TOTAL 0 6.5 Variable Cells Cell Name Original Value Final Value Integer \$B\$11No.of Units X 0 1 Contin \$C\$11No.of Units Y 0 4.5 Contin Constraints Cell Name Cell Value Formula Status Slack \$D\$5 LHS 10 \$D\$5<=\$F\$5 Binding 0 \$D\$6 LHS 12 \$D\$6>=\$F\$6 Binding 0 \$D\$7 LHS 1 \$D\$7<=\$F\$7 Not Binding 5 \$D\$8 LHS 4.5 \$D\$8>=\$F\$8 Not Binding

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

Want to read all 4 pages?

• Spring '08
• drexel
• LHS