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

Recognize the limitations and security concerns associated with electronic communication.

Identify and employ correct sentence structures in written communication.

Implement effective strategies for managing and annotating incoming mail.

Apply proofreading techniques to ensure accuracy in written documents.

---

Definitions:

Undo Button

A feature in software applications that allows users to reverse their last action or a series of actions.

Redo Button

A feature in software applications that reverses the last undo action, restoring any changes that were previously undone.

Mini Toolbar

A small, context-sensitive toolbar that appears near a selected item or text in certain software to provide quick access to common functions.

File Tab

A component of the Microsoft Office Ribbon interface that gives access to file-related commands, such as open, save, close, and print.