Assignment 5a

Submission: this paper report and Spreadsheet with Solver.

A wine cooler that would be a blend of a white wine, a rose wine, and fruit juice will be produced. To meet taste specifications, the wine cooler must consist of at least 36% white wine, at least 20% and no more than 35% rose; fruit juice will be exactly 15% of white wine and rose wine. For the current production period, 8,000 gallons of white wine and 7000 gallons of rose wine are available; 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 rose; the fruit juice can be purchased for $0.50 per gallon. All of the wine cooler produced can be sold for $2.75 per gallon.

Please formulate an LP model to determine the blend of the three ingredients that will maximize the total profit contribution.

Step 1: Describe the objective.

Step 2: Describe each constraint.

Step 3: Define the decision variables.

Step 4: Write the objective in terms of the decision variables

Step 5: Write the constraints in terms of the decision variables. .---All constraints have to have a format of Right-Hand Side a number only.

2. Please make an LP model based on your step 4 and step5.

Please refer to your spreadsheet and write a brief conclusion to state the gallons of each ingredients will be used and the cost spent on each of the ingredients. Then state the maximized profits accordingly. (Minimum words: 30).

Must state the cells you used to cite the optimal solution and the maximized profits.