Note: This Problem Requires the Use of a Linear Programming $$y _ { i } = \left\{ \begin{array} { l } 1 , \text { if product } j \text { is produced } \\0 , \text { otherwise }\end{array} \right.$$

question 11

Multiple Choice

Note: This problem requires the use of a linear programming application such as Solver or Analytic Solver.
A manufacturer has the capability to produce both chairs and tables. Both products use the same materials (wood, nails and paint) and both have a setup cost ($100 for chairs, $200 for tables) . The firm earns a profit of $20 per chair and $65 per table and can sell as many of each as it can produce. The daily supply of wood, nails and paint is limited. To manage the decision-making process, an analyst has formulated the following linear programming model:
Max 20x1 + 65x2 - 100y1 - 200y2
s.t. 5x1 + 10x2 ? 100 {Constraint 1}
20x1 + 50x2 ? 250 {Constraint 2}
1x1 + 1.5x2 ? 10 {Constraint 3}
My1 ? x1 {Constraint 4}
My2 ? x2 {Constraint 5} $$y _ { i } = \left\{ \begin{array} { l } 1 , \text { if product } j \text { is produced } \\0 , \text { otherwise }\end{array} \right.$$
Set up the problem in Excel and find the optimal solution. What is the optimal production schedule?

• A) 10 chairs, 0 tables
• B) 0 chairs, 5 tables
• C) 10 chairs, 5 tables
• D) 5 chairs, 10 tables
• E) 15 chairs, 5 tables

---

Definitions:

Antitussive

A medication used to suppress or relieve coughing.

Cough Reflex

A protective reflex that helps clear the airways of mucus, irritants, and pathogens through a sudden, often repetitive, expulsion of air from the lungs.

Peripheral Nervous Systems

The portion of the nervous system that consists of nerves and ganglia outside of the brain and spinal cord, facilitating communication to the central nervous system.

Sedative/Tranquilizer

These are drugs or agents that induce a calming effect, reducing excitement, irritability, or anxiety, and often used to facilitate sleep.