29. New Beverage Production. La Jolla Beverage Products is considering producing a new type of alcoholic beverage that would be a blend of a white wine, a rosé wine, and fruit juice. To meet taste specifications, the new beverage must consist of at least 50% white wine, at least 20% and no more than 30% rosé, and exactly 20% fruit juice. La Jolla purchases the wine from local wineries and the fruit juice from a processing plant in San Francisco. For the current production period, 10,000 gallons of white wine and 8000 gallons of rosé wine can be purchased; an unlimited amount of fruit juice can be ordered. The costs for the wine are $1.00 per gallon for the white and $1.50 per gallon for the rosé; the fruit juice can be purchased for $0.50 per gallon. La Jolla Beverage Products can sell all of the wine cooler they can produce for $2.50 per gallon. USE EXCEL SOLVER!!!