Question: A winemaker in California's Napa Valley must decide how much of two types of wine she will produce from a particular variety of grapes. Each liter of table wine yields $8 profit, whereas each liter of dessert wine produces $3 profit. The labor hours and bottling process time used for type of wine are given in the table below. Resources available include 200 labor hours and 80 hours of bottling process time. Assume the winemaker has more than enough grapes available to supply any feasible production plan.
|
Table
|
Desert
|
|
Labor (Hours)
|
0.20
|
0.60
|
|
Process Time (Hours)
|
0.30
|
0.10
|
Formulate a linear programming model that will enable the winemaker to determine the number of liters of each type of wine to produce in order to maximize her profit.
Refer to the scenario. Find an optimal solution to the model in 6 and determine the maximum profit.?
Refer to the scenario. Implement the model of 6 in Excel Solver and obtain an answer report. Which constraint(s) are binding on the optimal solution?
Refer to the scenario. Obtain a sensitivity report for the model in 6. How much should the winemaker be willing to pay for an additional labor hour?