Final Project 1 - Microsoft Excel 16.0 Sensitivity Report...

Microsoft Excel 16.0 Sensitivity Report
Worksheet: [Assignment 5.xlsx]Sheet1
Report Created: 4/8/2016 5:35:53 PM
Variable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$B$5 Number of pounds Powder A 0.125 0 1.33 0.23 1.00E+030
$C$5 Number of pounds Powder B 0 0.23 1.56 1.0000E+030 0.23
$D$5 Number of pounds Powder C 0 0.85 2.18 1.0000E+030 0.85
$E$5 Number of pounds Powder D 0 1.22 2.55 1.0000E+030 1.22
Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$F$12 Total Mix 0.125 1.33 0.125 0.219827586 0.125
$F$8 Sodium 0.5 0 2.3 1.0000E+030 1.8
$F$9 Potassium 1.2625 0 4.7 1.0000E+030 3.4375
$F$10 Riboflavin 1.45 0 4 1.0000E+030 2.55
$F$11 Sugars 2.375 0 37.5 1.0000E+030 35.125

Microsoft Excel 16.0 Answer Report
Worksheet: [Assignment 5.xlsx]Sheet1
Report Created: 4/8/2016 5:47:02 PM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.062 Seconds.
Iterations: 2 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling