the second picture is an example

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 45% white wine, at least 15% and no more than 36% rose; fruit juice will be exactly 20% of white wine and rose wine. For the current production period, 11,000 gallons of white wine and 9500 gallons of rose wine are available; an unlimited amount of fruit juice can be ordered. The costs for the wine are $1.25 per gallon for the white and $1.40 per gallon for the rose; the fruit juice can be purchased for $0.60 per gallon. All of the wine cooler produced can be sold for $2.50 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. Chapter 4 Example Objective Function Objective Function Coefficients x1 x2 x3 Decision Variables Coefficients of LHS function LHS RHS Constraints #1 #2 #3 #4 #5 #6 #7 #8