Two alloys, A and B, are made from four metals, I, II, III, and IV, according to the follow- ing specifications: Alloy Specifications Selling price ($) At most 80% of I At most 30% of II A 200 At least 50% of IV Between 40% and 60% of II 300 At least 30% of II At most 70% of IV The four metals are extracted from three ores according to the following data: Constituents (%) Maximum quantity (tons) Ore II II IV Others Price/ton ($) 1 1000 20 10 30 30 10 30 2000 10 20 30 30 10 40 3000 70 20 50

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter9: Decision Making Under Uncertainty
Section: Chapter Questions
Problem 30P
icon
Related questions
Question

Develop an LP model to determine how much of each type of alloy should be produced, and find the solution using excel  Solver,  (Hint: Let x, be tons of ore i allocated to alloy k, and define wk as tons of alloy k produced.)

Two alloys, A and B, are made from four metals, I, II, III, and IV, according to the follow-
ing specifications:
Alloy
Specifications
Selling price ($)
At most 80% of I
At most 30% of II
A
200
At least 50% of IV
Between 40% and 60% of II
300
At least 30% of II
At most 70% of IV
The four metals are extracted from three ores according to the following data:
Constituents (%)
Maximum quantity
(tons)
Ore
II
II
IV
Others
Price/ton ($)
1
1000
20
10
30
30
10
30
2000
10
20
30
30
10
40
3000
70
20
50
Transcribed Image Text:Two alloys, A and B, are made from four metals, I, II, III, and IV, according to the follow- ing specifications: Alloy Specifications Selling price ($) At most 80% of I At most 30% of II A 200 At least 50% of IV Between 40% and 60% of II 300 At least 30% of II At most 70% of IV The four metals are extracted from three ores according to the following data: Constituents (%) Maximum quantity (tons) Ore II II IV Others Price/ton ($) 1 1000 20 10 30 30 10 30 2000 10 20 30 30 10 40 3000 70 20 50
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning