Question: Question 3 . ( 5 0 points ) A winery produces three types of wine: Merlot, Chardonnay, and Cabernet. Each barrel of Merlot requires 0
Question points A winery produces three types of wine: Merlot, Chardonnay, and Cabernet. Each barrel of Merlot requires units of grapes, units of oak, and units of yeast; each barrel of Chardonnay requires units of grapes, units of oak, and units of yeast; and each barrel of Cabernet requires units of grapes, units of oak, and units of yeast. The winery has units of grapes, units of oak, and units of yeast available each month.
According to a contract with a local distributor, the winery is required to supply at least barrels of Merlot, barrels of Chardonnay, and barrels of Cabernet each month. Due to storage limitations at the distributor, the winery cannot send more than barrels of Merlot, barrels of Chardonnay, and barrels of Cabernet per month.
The winery makes a profit of $ per barrel of Merlot, $ per barrel of Chardonnay, and $ 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 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 points What is the objective function? Clearly explain the objective function in English and provide the mathematical formulation.
c points What are the constraints of the problem? Clearly explain each constraint in English and provide the mathematical formulation.
d 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
