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

question 15

Essay

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

---

Definitions:

Syphilis

A sexually transmitted infection caused by the bacterium Treponema pallidum, presenting in various stages from sores to serious systemic symptoms.

Lyme Disease

An infectious disease caused by the Borrelia bacteria, transmitted to humans through the bite of infected black-legged ticks.

Spirilla

A genus of spiral-shaped bacteria, some of which are known to cause diseases in humans.

Viruses

Infectious agents that replicate only inside the living cells of an organism, which can cause a variety of diseases in humans, animals, and plants.