Identify the problem in the Mexicana Case using the available information.
What are the key assumptions surrounding the business situation in this case?
Develop the LP model for this problem.
Solve the LP model to find the optimal solution.
Analyze the results by trying to point to the following:
What recommendations should Ron Garcia make, with what justification? Provide a detailed analysis with charges, graphs, and computer printouts included.
Discuss the need for temporary workers in the drawing department.
Discuss the plant layout.
Include the details of your analysis (using QM for Windows or Excel QM) as an
appendix to your report. Do not include any output in the body of the report.
Sample Solution