- #1
tom.young84
- 23
- 0
Introduction to Operations Research, Hiller, 3.4-12 I believe
1 2 3 4 5 New Alloy
tin 60 25 45 20 50 =40
zinc 10 15 45 50 45 =35
lead 30 60 10 30 10 =25
total 1 1 1 1 1 =1
Cost 22 20 25 24 27
Goal: minimize cost function 22x1+20x2+25x3+24x4+27x5
Basically there is this metal company trying to make a new alloy through a linear combination of the other five alloys. At the bottom is the "cost function" which I am suppose to minimize. I actually understand how to do it, but not in Excel, which is what I am suppose to use. I'm completely unfamiliar with how to use solver.
1 2 3 4 5 New Alloy
tin 60 25 45 20 50 =40
zinc 10 15 45 50 45 =35
lead 30 60 10 30 10 =25
total 1 1 1 1 1 =1
Cost 22 20 25 24 27
Goal: minimize cost function 22x1+20x2+25x3+24x4+27x5
Basically there is this metal company trying to make a new alloy through a linear combination of the other five alloys. At the bottom is the "cost function" which I am suppose to minimize. I actually understand how to do it, but not in Excel, which is what I am suppose to use. I'm completely unfamiliar with how to use solver.