Question: Question 3 . ( 5 0 points ) A winery produces three types of wine: Merlot, Chardonnay, and Cabernet. Each barrel of Merlot requires 0

Question 3.(50 points) A winery produces three types of wine: Merlot, Chardonnay, and Cabernet. Each
barrel of Merlot requires 0.5 units of grapes, 0.3 units of oak, and 0.1 units of yeast; each barrel of
Chardonnay requires 0.6 units of grapes, 0.4 units of oak, and 0.2 units of yeast; and each barrel of
Cabernet requires 0.7 units of grapes, 0.5 units of oak, and 0.3 units of yeast. The winery has 250 units of
grapes, 100 units of oak, and 60 units of yeast available each month.
According to a contract with a local distributor, the winery is required to supply at least 120 barrels of
Merlot, 90 barrels of Chardonnay, and 80 barrels of Cabernet each month. Due to storage limitations at
the distributor, the winery cannot send more than 180 barrels of Merlot, 110 barrels of Chardonnay, and
90 barrels of Cabernet per month.
The winery makes a profit of $15 per barrel of Merlot, $12 per barrel of Chardonnay, and $18 per barrel
of Cabernet.
You are asked to determine the optimal product mix that maximizes the monthly total profit. You will
formulate a linear programming model. You will NOT solve this problem by Excel Solver.
SHOW ALL YOUR WORK ONA PIECE OF PAPER.
a)(12 points) What are the decision variables? How many decision variables are there? Clearly explain
the decision variables in English and provide the mathematical notation used in the algebraic
formulation of the decision problem.
b)(8 points) What is the objective function? Clearly explain the objective function in English and provide
the mathematical formulation.
c)(25 points) What are the constraints of the problem? Clearly explain each constraint in English and
provide the mathematical formulation.
d)(5 point) Are there any sign or type restrictions in your formulation? Why or why not? Clearly explain
the sign and type restrictions (if any).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!