Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Homework Help: Operations Research and Excel

  1. Jan 27, 2010 #1
    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.
     
  2. jcsd
  3. Jan 28, 2010 #2

    berkeman

    User Avatar

    Staff: Mentor

    Excel's help on the Solver is generally pretty good. Have you read through it?
     
  4. Jan 28, 2010 #3
    I've tried using solver...I get something that isn't the answer. Is there a good tutorial?
     
  5. Jan 29, 2010 #4

    berkeman

    User Avatar

    Staff: Mentor

Share this great discussion with others via Reddit, Google+, Twitter, or Facebook