Managerial Report Perform an analysis to MEXICANA WIRE WORKS CASE, and prepare a report that summarizes your findings and recommendations. Include the following items in your report: 1. Identify the problem in the Mexicana Case using the available information. 2. What are the key assumptions surrounding the business situation in this case? 3. Develop the LP model for this problem. 4. Solve the LP model to find the optimal solution. 5. Analyze the results by trying to point to the following: i. 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. iii. Discuss the plant layout. 6. 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.In the following table, the costs of material, labor, and overhead in addition to the selling price are given. These should be used to determine how much PROFIT will be made for each unit of the product that is sold. Product Material Labor Overhead Selling Price W0075C $33.00 $ 9.90 $23.10 $100.00 W0033C 25.00 7.50 17.50 80.00 WOO05X 35.00 10.50 24.50 130.00 WOO07X 75.00 11.25 63.75 175.00 Selected Operating Data: Average output per month = 2,400 units Average machine utilization = 63% Average percentage of production set to rework department = 5% (mostly from Winding Department) Average no. of rejected units awaiting rework = 850 (mostly from Winding Department) Plant Capacity (Hours): Drawing=4,000; Extrusion=4,200; Winding=2,000; Packaging=2,300 Note: Inspection capacity is not a problem; workers can work overtime, as necessary, to accommodate any schedule. Bill of Labor (Hours/Unit) Product Drawing Extrusion Winding Packaging W0075C 1.0 1.0 1.0 1.0 W0033C 2.0 1.0 3.0 0.0 WOO05X 0.0 4.0 0.0 3.0 WOO07X 1.0 1.0 0.0 2.0MEXICANA WIRE WORKS CASE Ron Garcia felt good about his first week as a management trainee at Mexicana Wire Winding. Inc. He had not yet developed any technical knowledge about the manufacturing process, but he had toured the entire facility, located in the suburbs of Mexico City, and had met many people in various areas of the operation. Mexicana, a subsidiary of Westover Wire Works, a Texas firm, is a medium-sized producer of wire windings that are used in making electrical transformers. Jose Arroyo, the production control manager, described the windings to Garcia as being of standardized design. Garcia's tour of the plant followed the manufacturing sequence for the windings: drawing, extrusion, winding, inspection, and packaging. After inspection, good product is packaged and sent to finished product storage; a defective product is stored separately until it can be reworked. On March 8, Vivian Espania, Mexicana's general manager, stopped by Garcia's office and asked him to attend a staff meeting at 1:00 p.m. At the meeting: "Let's get started with the business at hand," Vivian said, opening the meeting. "You all have met Ron Garcia, our new management trainee. Ron studied operations management in his MBA program in northeastern Oklahoma so I think he is competent enough to help us with a problem we have been discussing for a long time that we have failed to resolve. I'm sure that each of you on my staff will give Ron your full cooperation." Vivian turned to Jose Arroyo, production manager. "Jose, why don't you describe the problem we are facing?" "Well," Jose said, "business is very good right now. We are booking more orders than we can fill. We will have some new equipment on line within the next several months, which will take care of our capacity problems, but that won't help us in April. I have located some retired employees who used to work in the drawing department, and I am planning to bring them in as temporary employees in April to increase capacity there. Because we are planning to refinance some of our long-term debt, Vivian wants our profits to look as good as possible in April. I'm having a hard time figuring out which orders to run and which to back order so that I can make the bottom line look as good as possible. Can you help me with this?" Ron was surprised and apprehensive to receive such an important, high-profile assignment so early in his career. Recovering quickly, he said, "Give me your data and let me work with it for a day or two.' Sometime shortly after the meeting, Ron was given the following information. April Orders Product W0075C 1,400 units Product W0033C 250 units Product WOO05X 1,510 units Product WOO07X 1,116 units Note: Vivian Espania has given her word to a key customer that MWW will manufacture 600 units of product WOO07X and 150 units of product W0075C for him during April