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
Microsoft Excel 14.0 Sensitivity ReportWorksheet: [Chapter 3 Problem 15 Excel Answer With Sensitivity report - Amswer.xlsx]Sheet1Report Created: 10/27/2011 10:45:01 AMEngine: Gurobi SolverObjective Cell (Max)CellNameFinal Value$B$25Max total profit: X1215000Decision Variable CellsFinalReducedObjectiveCellNameValueCostCoefficient$B$23Units produced: X1500053$C$23Units produced: X21,000048$D$23Units produced: X31,500033$E$23Units produced: X42,250032$F$23Units produced: X5500038ConstraintsFinalShadowConstraintCellNameValuePriceR.H. Side$B$28PC board available Amount Used (LHS)60,500080000$B$29Resistors available Amount Used (LHS)100,0000100000$B$30Memory chips available Amount Used (LHS)30,000830000$B$31Assembly hours available Amount Used (LHS)3,68805000$B$32Required # of HyperLinks Amount Used (LHS)500-44500$B$33Required # of FastLinks Amount Used (LHS)1,0000500$B$34Required # of SpeedLinks Amount Used (LHS)1,5000500$B$35Required # of MicroLinks Amount Used (LHS)2,2500500$B$36Required # of EtherLinks Amount Used (LHS)500-10500$B$372 X # FastLinks as HyperLinks Amount Used (LHS)0-160
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)