HW-4 Hilltop Coffee SOLVED IN CLASS - Microsoft Excel 16.0 Answer Report Worksheet[Book1]Sheet1 Report Created 8:24:04 AM Result Solver found a solution

HW-4 Hilltop Coffee SOLVED IN CLASS - Microsoft Excel 16.0...

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

Microsoft Excel 16.0 Answer ReportWorksheet: [Book1]Sheet1Report Created: 2/7/2017 8:24:04 AMResult: Solver found a solution. All Constraints and optimality conditions are satisfied.Solver EngineEngine: Simplex LPSolution Time: 0 Seconds.Iterations: 8 Subproblems: 0Solver OptionsMax Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic ScalingMax Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegaObjective Cell (Min)CellNameOriginal ValueFinal Value$B$14Min B10550Variable CellsCellNameOriginal ValueFinal ValueInteger$B$12Lb B10500 Contin$C$12Lb B20300 Contin$D$12Lb B30200 ContinConstraintsCellNameCell ValueFormulaStatusSlack$B$17Aroma LHS0 $B$17>=$D$17 Binding0$B$18Taste LHS4400 $B$18>=$D$18Not Binding4400$B$19B1 LHS500 $B$19<=$D$19 Binding0$B$20B2 LHS300 $B$20<=$D$20Not Binding300$B$21B3 LHS200 $B$21<=$D$21Not Binding200$B$22Blend LHS1000 $B$22=$D$22Binding0
Background image
ative
Background image
Microsoft Excel 16.0 Sensitivity ReportWorksheet: [Book1]Sheet1Report Created: 2/7/2017 8:24:04 AMVariable CellsFinalReduced
Background image
Image of page 4

You've reached the end of your free preview.

Want to read all 8 pages?

  • Fall '08
  • STAFF
  • LHS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture