Examlex
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}
Set up the problem in Excel and find the optimal solution. What is the optimal production schedule?
Plain Text Document
A file that contains only text and has no special formatting, fonts, or images.
Documents Library
A centralized location on a computer or network where documents are stored, organized, and accessed.
Files And Folders
Digital containers used on computers to organize and store documents, images, videos, and other data types.
Address Bar
The part of a web browser that displays the URL of the current page and allows the user to enter website addresses.
Q6: When you explore new websites, TV shows,
Q7: At the lowest level of media literacy,
Q13: Managers who oversee queueing systems are usually
Q35: An example of maximax decision making is
Q47: You have decided to start a vending
Q51: <span class="ql-formula" data-value="\begin{array}{l}\begin{array}{|l|l|}\hline \text { Priority }&\text
Q56: When dealing with relatively complex systems, computer
Q56: Linear programming problems may have multiple goals
Q67: If the optimal solution will remain the
Q81: The best feasible solution is called the