Problem 17 - x1 of lbs of raisins x2 of lbs of grain x3 of lbs of chocolate chips x4 of lbs of peanuts x5 of lbs of almonds Minimize z 0.75 0.1 0.1 0.95

# Problem 17 - x1 of lbs of raisins x2 of lbs of grain x3 of...

This preview shows page 1 - 3 out of 3 pages.

x1 (# of lbs of raisins) 0.75 x2 (# of lbs of grain) 0.1 x3 (# of lbs of chocolate chips) 0.1 x4 (# of lbs of peanuts) 0.95 x5 (# of lbs of almonds) 0.1 Minimize z 5.85 LHS SIGN RHS 2 equals 2 (wt. of pkg.) 47.5 >= 40 (vitamins) 15 >= 15 (minerals) 12.9 >= 10 (protien) 738.5 >= 600 (calories) 0.75 >= 0.1 0.1 >= 0.1 0.1 >= 0.1 0.95 >= 0.1 0.1 >= 0.1 0.75 <= 1 0.1 <= 1 0.1 <= 1 0.95 <= 1 0.1 <= 1 #VALUE! >= 0
Microsoft Excel 14.5 Answer Report Worksheet: [Problem 17.xlsx]Sheet1 Report Created: 2/8/2016 7:20:20 PM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 1.070267 Seconds. Iterations: 13 Subproblems: 0 Solver Options Max Time Unlimited , Iterations Unlimited , Precision 1e-06, Use Automatic Scaling Max Subproblems Unlimited , Max Integer Sols Unlimited , Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value \$B\$9 Minimize z 0 5.85 Variable Cells Cell Name Original Value Final Value Integer \$D\$1 x1 (# of lbs of raisins) 0 0.75 Contin \$D\$2 x2 (# of lbs of grain) 0 0.1 Contin \$D\$3 x3 (# of lbs of chocolate chips) 0 0.1 Contin \$D\$4 x4 (# of lbs of peanuts) 0 0.95 Contin \$D\$5

#### You've reached the end of your free preview.

Want to read all 3 pages?