Chapter 4 Problem 17 in 7th ed - Problem 15 in 6th ed Excel Answer With Sensitivity report - Microsoft Excel 14.0 Sensitivity Report Worksheet[Chapter 3

Chapter 4 Problem 17 in 7th ed - Problem 15 in 6th ed Excel Answer With Sensitivity report

This preview shows page 1 - 2 out of 8 pages.

Microsoft Excel 14.0 Sensitivity Report Worksheet: [Chapter 3 Problem 15 Excel Answer With Sensitivity report - Amswer.xlsx]Sheet1 Report Created: 10/27/2011 10:45:01 AM Engine: Gurobi Solver Objective Cell (Max) Cell Name Final Value $B$25 Max total profit: X1 215000 Decision Variable Cells Final Reduced Objective Cell Name Value Cost Coefficient $B$23 Units produced: X1 500 0 53 $C$23 Units produced: X2 1,000 0 48 $D$23 Units produced: X3 1,500 0 33 $E$23 Units produced: X4 2,250 0 32 $F$23 Units produced: X5 500 0 38 Constraints Final Shadow Constraint Cell Name Value Price R.H. Side $B$28 PC board available Amount Used (LHS) 60,500 0 80000 $B$29 Resistors available Amount Used (LHS) 100,000 0 100000 $B$30 Memory chips available Amount Used (LHS) 30,000 8 30000 $B$31 Assembly hours available Amount Used (LHS) 3,688 0 5000 $B$32 Required # of HyperLinks Amount Used (LHS) 500 -44 500 $B$33 Required # of FastLinks Amount Used (LHS) 1,000 0 500 $B$34 Required # of SpeedLinks Amount Used (LHS) 1,500 0 500 $B$35 Required # of MicroLinks Amount Used (LHS) 2,250 0 500 $B$36 Required # of EtherLinks Amount Used (LHS) 500 -10 500 $B$37 2 X # FastLinks as HyperLinks Amount Used (LHS) 0 -16 0
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '08
  • STAFF
  • BMW Sports Activity Series, memory chips, Max Guevara, LHS)

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture