1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

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

Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: Operations Research and Excel
  1. Excel question (Replies: 1)

  2. Excel Help (Replies: 3)

  3. Ploting graph in excel (Replies: 3)

Loading...