4. From previous LP hwk #2 - Set up in Excel and Solve using Excel Solver 1. Army REM drink A = ounces of liquid A to pu

[answerhappygod]

4. From previous LP hwk #2 - Set up in Excel and Solve using
Excel Solver
1. Army REM drink
A = ounces of liquid A to put in each can
B = ounces of liquid B to put in each can
C = ounces of liquid C to put in each can
Minimize total cost per can = 0.10A + 0.15B + 0.82C
St
Protein .18A + .25B + 6.8C >= 15
Fat .25A + .35B + .06C <= 3
Carb 4.5A + 3.0B + 0.70C <= 38
Sodium 50A + 20B + 10C <= 310
Total oz A + B + C =12 (or >=12)