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:AlloySpecificationsSelling price ($)At most 80% of IAt most 30% of IIA200At least 50% of IVBetween 40% and 60% of II300At least 30% of IIAt most 70% of IVThe four metals are extracted from three ores according to the following data:Constituents (%)Maximum quantity(tons)OreIIIIIVOthersPrice/ton ($)1100020103030103020001020303010403000702050

Let, xij be tons of ore i allocated to j where i = 1,2,3,4 j = A, B wj is the tons of alloy j…

Answered: Two alloys, A and B, are made from four…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Concept explainers

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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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