Introduction to Operations Research, Hiller, 3.4-12 I believe(adsbygoogle = window.adsbygoogle || []).push({});

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 22x_{1}+20x_{2}+25x_{3}+24x_{4}+27x_{5}

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.

**Physics Forums | Science Articles, Homework Help, Discussion**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Homework Help: Operations Research and Excel

**Physics Forums | Science Articles, Homework Help, Discussion**