homework 7 - Microsof Excel 14.4 Linearity Report Worksheet[Workbook3]Sheet1 Report Created 11:33:56 AM Objectve Cell(Max Cell Name Original Value Final

# homework 7 - Microsof Excel 14.4 Linearity Report...

This preview shows page 1 - 3 out of 9 pages.

Microsoft Excel 14.4 Linearity Report Worksheet: [Workbook3]Sheet1 Report Created: 10/17/2014 11:33:56 AM Objective Cell (Max) Cell Name Original Value Final Value Linear Function \$H\$11 rev country 6400 800 Yes Variable Cells Cell Name Original Value Final Value Occurs Linearly \$H\$8 Quantity country 8 1 Yes \$I\$8 Quantity contemporary 8 1 Yes Constraints Cell Name Cell Value Formula Linear Function \$H\$15 router LHS 3.5 \$H\$15<=\$J\$15 Yes \$H\$16 sander LHS 7.5 \$H\$16<=\$J\$16 Yes \$H\$17 polisher LHS 4 \$H\$17<=\$J\$17 Yes \$H\$18 %country LHS 1 \$H\$18>=\$J\$18 Yes \$H\$19 %contemp LHS 1 \$H\$19>=\$J\$19 Yes
Microsoft Excel 14.4 Answer Report Worksheet: [homework 7.xlsx]Sheet1 Report Created: 10/23/2014 8:44:15 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 13.024442 Seconds. Iterations: 4 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 (Max) Cell Name Original Value Final Value \$H\$11 rev country 220289.855072 220289.855072 Variable Cells

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

Want to read all 9 pages?

• Fall '13
• LHS