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

Microsoft Excel 16.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 2/7/2017 8:24:04 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0 Seconds.
Iterations: 8 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 NonNega
Objective Cell (Min)
Cell Name Original Value Final Value
$B$14 Min B1 0 550
Variable Cells
Cell Name Original Value Final Value Integer
$B$12 Lb B1 0 500 Contin
$C$12 Lb B2 0 300 Contin
$D$12 Lb B3 0 200 Contin
Constraints
Cell Name Cell Value Formula Status Slack
$B$17 Aroma LHS 0 $B$17>=$D$17 Binding 0
$B$18 Taste LHS 4400 $B$18>=$D$18 Not Binding 4400
$B$19 B1 LHS 500 $B$19<=$D$19 Binding 0
$B$20 B2 LHS 300 $B$20<=$D$20 Not Binding 300
$B$21 B3 LHS 200 $B$21<=$D$21 Not Binding 200
$B$22 Blend LHS 1000 $B$22=$D$22 Binding 0

ative

Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Book1]Sheet1
Report Created: 2/7/2017 8:24:04 AM
Variable Cells
Final Reduced