Question: use excel solver and lp model to solve. please show work! thanks 2) (6 points) A beverage maker wants to blend grape juice and blueberry

use excel solver and lp model to solve. please show work! thanks
2) (6 points) A beverage maker wants to blend grape juice and blueberry juice to make a new breakfast drink. The drink blend should contain at least 36 units of vitamin C and at least 27 units of vitamin A. Grape juice costs $0.05 per ounce and contains 2 units of vitamin C and 4 units of vitamin A; blueberry juice costs $0.08 per ounce and contains 3 units of vitamin C and 1 unit of vitamin A. The final blend should contain at least 3 ounces of blueberry juice (so that it can legally be called a blueberry juice cocktail). How many ounces of each kind of juice should be blended together to make new drink at minimum cost? a) Set up the LP Model and write it down below or include your Excel work. b) Write your final answer simply. c) Which constraint has an excess? Interpret what the excess means. = d) What is the new solution if the cost for grape juice goes up to $0.06 per ounceStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
