Exhibit 3-1
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, while 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.
$$\begin{array} { | l l l | }
\hline & \text { Table } & \text { Dessert } \
\hline \text { Labor (Hours) } & 0.20 & 0.60 \
\text { Process Time (Hours) } & 0.30 & 0.10 \
\hline
\end{array}$$
-[Part 3] Refer to Exhibit 3-1.Implement the model in Part 1 in Excel Solver and obtain an answer report.Which constraint(s)are binding on the optimal solution

Question

Exhibit 3-1
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, while 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.
 $$\begin{array} { | l l l | } 
\hline & \text { Table } & \text { Dessert } \
\hline \text { Labor (Hours) } & 0.20 & 0.60 \
\text { Process Time (Hours) } & 0.30 & 0.10 \
\hline
\end{array}$$ ​
-[Part 3] Refer to Exhibit 3-1.Implement the model in Part 1 in Excel Solver and obtain an answer report.Which constraint(s)are binding on the optimal solution

Quizplus · Accepted Answer

The Answer of Exhibit 3-1
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, while 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.
 $$\begin{array} { | l l l | } 
\hline & \text { Table } & \text { Dessert } \
\hline \text { Labor (Hours) } & 0.20 & 0.60 \
\text { Process Time (Hours) } & 0.30 & 0.10 \
\hline
\end{array}$$ ​
-[Part 3] Refer to Exhibit 3-1.Implement the model in Part 1 in Excel Solver and obtain an answer report.Which constraint(s)are binding on the optimal solution

Exhibit 3-1 a Winemaker in California's Napa Valley Must Decide

Exhibit 3-1
a Winemaker in California's Napa Valley Must Decide