Can you use Solver in excel to answer. That is what i am having issues with.

Problem 1) La Jolla Beverage Company produces and sells two wine coolers (Wine Coolers A & B). Both wine coolers are a blend of white wine, rose wine, and fruit juice. Wine Cooler A: Sells for $15.20 per gallon. To meet customer taste specifications, the wine cooler must contain the following amounts: At least 42% white wine, at most 55% white wine, at most 45% rose wine, and no more than 12% fruit juice. Wine Cooler B: Sells for $17.55 per gallon. To meet customer taste specifications, the wine cooler must contain the following amounts: At least 25% white wine, at least 37% rose wine, at most 49% rose wine, and at most 39% fruit juice. ABC purchases the white wine at $4.90 per gallon, rose wine at $4.20 per gallon, and fruit juice at $3.80 per gallon. The supplier for the white wine can supply a maximum of 7,250 gallons. The supplier for the rose wine can supply a maximum of 11,510 gallons. The supplier for the fruit juice can supply a maximum of 14,520 gallons. ABC Beverage Company wants to purchase ingredients to sell as many gallons of the two wine coolers as possible to maximize profits. Hint: You will need 6 variables. Use the headings listed below in your model formulation: Decision Variables: Objective Function: Constraints: Additional Work for Objective Function & Constraints