MEXICANA 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 ProductW0075C 1,400 units ProductW0033C 250 units ProductW0005X 1,510 units Product W0007X 1,116 units Note: Vivian Espania has given her word to a key customer that MWW will manufacture 600 units of product W0007X and 150 units of product W0075C for him during April. 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 W0005X 35.00 10.50 24.50 130.00 W0007X 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 W0005X 0.0 4.0 0.0 3.0 W0007X 1.0 1.0 0.0 2.0 Managerial Report Perform an analysis to MEXICANA WIRE WORKS CASE, and prepare a report that summarizes your ndings 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. 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.

Download - + MEXICANA WIRE WORKS CASE Romance che i finst what MW descopy who was post hadith all wwwdot www.cadou Are the good.com detech bemanden der erste plet de corte de dapat List WA We Ryby Apels PC 500 produ HOC 21 7:30 DE CE XS 10 X 115.00 D Botobehen DI 1 33 00 30 WTX 1 OE + Alth pret Download - + MEXICANA WIRE WORKS CASE Romance che i finst what MW descopy who was post hadith all wwwdot www.cadou Are the good.com detech bemanden der erste plet de corte de dapat List WA We Ryby Apels PC 500 produ HOC 21 7:30 DE CE XS 10 X 115.00 D Botobehen DI 1 33 00 30 WTX 1 OE + Alth pret