• Author / Uploaded
• JD_04

• Categories
• Optimización Matemática
• Business
• Matemáticas

Citation preview

Case Study: Mexicana Wire Works Inc.

Name of the group members

ID Number

Chusak Deetrakunwattanapoen Gopi Krishna Pamula Mohammed Faruk Ahmed Nam Doc Tran Sukana Sasiwachiranggool Varavut Nitistaporn

7472100374 7462100509 7472100333 7472100382 7472100291 7472100127

Headings: •

Scenario in brief

•

Problem identification

•

Objective function and constraints

•

Developing the model based on acquired data

•

Plot the model in spread sheet to obtain solution

•

Focus on discussion questions

Scenario in brief: •

Mexicana Wire Winding Inc. is a producer of wire winding used in making electrical transformer.

•

Production process involves drawing, extrusion, winding, inspection and packaging

•

This company is booking more orders than they can fill

•

They will expand the plant capacity later but it will not help them in April

•

The company wants the optimum profit for the month of April using their limited capacity and resources

•

April orders:

----------------------------------------Product W0075C 1400 units Product W0033C 250 units Product W0005X 1510 units Product W0007X 1116 units -----------------------------------------

Identified Problem: •

Booking orders > production using present capacity

Objective function and constraints: Objective Function: Maximum Profit We assume – To make the optimum profit by satisfying the limitations, total units of Product W0075C = X1 Product W0033C = X2 Product W0005X = X3 Product W0007X = X4 Assume that X1, X2, X3, X4 >=0 Constraints: • Meet key customers demand: Product W0075C >= 150 units Product W0007X >= 600 units • Hours Hours Hours Hours

Plant capacity: for Drawing