In: Advanced Math
Creatine and protein are common supplements in most bodybuilding products. Bodyworks, a nutrition health store, makes a powder supplement that combines creatine and protein from two ingredients (X1 and X2). Ingredient X1 provides 20 grams of protein and 5 grams of creatine per pound. Ingredient X2 provides 15 grams of protein and 3 grams of creatine per pound. Ingredients X1 and X2 cost Bodyworks $5 and $7 per pound, respectively. Bodyworks wants its supplement to contain at least 30 grams of protein and 10 grams of creatine per pound and be produced at the least cost.
Determine what combination will maximize profits.
Use Excel Solve to determine the solution:
a. |
Decision variables yield, = (5, 0) and objective function value is 9 |
|
b. |
Decision variables yield = (3, 1) and objective function value is 10 |
|
c. |
Decision variable yield = (2,0) and objective function value =10 |
|
d. |
Decision variable yield = (2,2) and objective function value = 12 |