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
Image of page 1
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
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 9 pages?

  • Fall '13
  • LHS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes