Helen Keplinger must choose the amount of two wine types shewill produce. Each liter of Red wine returns $7 profit, while eachliter of White wine returns $2 profit. The labor hours and bottlingtime used for each type of wine are given in the table below.Resources available include 169 labor hours and 74.25 hours ofbottling process time. Assume the Helen Keplinger has more thanenough grapes available to supply any feasible production plan.
| Red | White |
Labor (Hours) | 0.15 | 0.50 |
Bottling Time (Hours) | 0.20 | 0.05 |
a) Formulate a linear programming model that will enable HelenKeplinger to determine the number of liters of each type of wine toproduce in order to maximize her profit. (15 pts)
b) Suppose Helen Keplinger labor hours varies from 150 to 250with 10-unit increments. Use SolverTable to determine her expectedprofit? Would her bottling plan change? Explain your answer. (5pts)
