ABC Manufacturing Company has seen the demand for two new types of metal alloys explode in...

Transcribed Image Text:

ABC Manufacturing Company has seen the demand for two new types of metal alloys explode in recent months. The alloys, which are made by mixing copper, nickel, and aluminum, do not require an exact formulation of components but must satisfy the following general specifications: Alloy A At least 40% copper At least 10% nickel Alloy B No more than 35% copper At least 40% nickel No more than 25% nickel Aluminum content must be exactly twice that of nickel No more than 30% aluminum Copper costs $2 per pound, nickel $3 per pound, and aluminum $1.50 per pound. ABC has a limit of 2000 pounds of copper, 3000 pounds of nickel, and 4000 pounds of aluminum available each day. Assume that the company can sell as much of each alloy as it makes at a price of $6 per pound for alloy A and $6.5 per pound for alloy B. Assume that one pound of an alloy is obtained from one pound of a mixture, that is, there is no loss in the process. (a) (15 points) Formulate the company's problem a linear program to maximize profit. Define your decision variables clearly. (b) (10 points) Solve the model you developed in part (a) using OpenSolver and report the optimal solution. Upload the excel file as well when uploading your solutions. (Hint: Optimal objective function value is $31,286) ABC Manufacturing Company has seen the demand for two new types of metal alloys explode in recent months. The alloys, which are made by mixing copper, nickel, and aluminum, do not require an exact formulation of components but must satisfy the following general specifications: Alloy A At least 40% copper At least 10% nickel Alloy B No more than 35% copper At least 40% nickel No more than 25% nickel Aluminum content must be exactly twice that of nickel No more than 30% aluminum Copper costs $2 per pound, nickel $3 per pound, and aluminum $1.50 per pound. ABC has a limit of 2000 pounds of copper, 3000 pounds of nickel, and 4000 pounds of aluminum available each day. Assume that the company can sell as much of each alloy as it makes at a price of $6 per pound for alloy A and $6.5 per pound for alloy B. Assume that one pound of an alloy is obtained from one pound of a mixture, that is, there is no loss in the process. (a) (15 points) Formulate the company's problem a linear program to maximize profit. Define your decision variables clearly. (b) (10 points) Solve the model you developed in part (a) using OpenSolver and report the optimal solution. Upload the excel file as well when uploading your solutions. (Hint: Optimal objective function value is $31,286)

Answer rating: 100% (QA)

a To formulate the companys problem as a linear program to maximize profit we need to define decisio... View the full answer